3 ms·
MySQL isn't the only engine that does this. http://docs.oracle.com/cd/E17952_01/refman-5.1-en/implicit-commit.html http://docs.oracle.com/cd/E17952_01/refman-5
by jpitz 13y ago
MySQL isn't the only engine that does this.
http://docs.oracle.com/cd/E17952_01/refman-5.1-en/implicit-commit.html http://docs.oracle.com/cd/E17952_01/refman-5.1-en/implicit-c...
Edit - I was wrong!
Not only did I link to the wrong docs, but Oracle fixed what I considered to be a longstanding bug.
Thanks to those who pointed it out.
For a very, very long time, Oracle has enforced implicit transaction boundaries around DDL, and it is about time that finally changed.
- lcampbell 13y agoThose docs look like they're MySQL docs, not Oracle Database docs. Stackoverflow suggests[1] that as-of Oracle Database 11g Release 2, DDL changes are isolated within the current transaction. -- [1] http://stackoverflow.com/questions/4692690/is-it-possible-to-roll-back-create-table-and-alter-table-statements-in-major-sql http://stackoverflow.com/questions/4692690/is-it-possible-to...
- bunderbunder 13y agoThat link is to a page from the MySQL 5.1 reference manual. As of about 4 years ago Oracle's been the owners of MySQL, so that's the reason why you're seeing it hosted at docs.oracle.com.