2 ms·
True, however transactional DDL doesn't seem to be a problem after MySQL 5.5 https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_An
by raverbashing 13y ago
True, however transactional DDL doesn't seem to be a problem after MySQL 5.5
https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis#MySQL https://wiki.postgresql.org/wiki/Transactional_DDL_in_Postgr...
- masklinn 13y agoThis 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 http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html