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

[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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.