Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

True, however transactional DDL doesn't seem to be a problem after MySQL 5.5

https://wiki.postgresql.org/wiki/Transactional_DDL_in_Postgr...



This only demonstrates that rollbacking an insertion after creating a table within a transaction now works. That is, it shows DDL does not completely break a transaction it's performed in.

According to the documentation DDL remains non-transactional in MySQL 5.5[0]

> The CREATE TABLE statement in InnoDB is processed as a single transaction. This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction.

[0] http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: