Bug #28109 add sql mode to error out when doing DDL inside a transaction
Submitted: 26 Apr 2007 0:05 Modified: 26 Apr 2007 14:25
Reporter: Lukas Smith Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Triage: D5 (Feature request)

[26 Apr 2007 0:05] Lukas Smith
Description:
Currently when doing DDL within a transaction an implicit commit is done.

How to repeat:
http://dev.mysql.com/doc/refman/5.0/en/implicit-commit.html

Suggested fix:
It would be nice to have an SQL mode to instead generate an error that aborts the transaction when executing a DDL statement.
[26 Apr 2007 4:04] Valeriy Kravchuk
Thank you for a feature request. Do you know any other RDBMS that works like you requested?
[26 Apr 2007 14:25] Lukas Smith
Admittedly no. As far as I know Oracle behaves just like MySQL does now. Obviously PostgreSQL supports DDL fully inside transactions. I could try and see how other RDBMS behave.

However I have a hard time believing that this is actually what the user wants. As a matter of fact many many users of MySQL actually believe they could rollback DDL.