Question: InnoDB transaction and table changes

2005-02-04 Thread Ville Karjalainen
Greetings, I created a table during transaction and was surprised to find out it still existed after I did a ROLLBACK. The same seems to apply to changes made using ALTER TABLE statements. Is there a simple logical explanation to this behaviour? Any help would be appreciated. Demonstration

RE: Question: InnoDB transaction and table changes

2005-02-04 Thread Mark Leith
: http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- From: Ville Karjalainen [mailto:[EMAIL PROTECTED] Sent: 04 February 2005 13:59 To: mysql@lists.mysql.com Subject: Question: InnoDB transaction

Re: Question: InnoDB transaction and table changes

2005-02-04 Thread Philippe Poelvoorde
DDL cannot be rollback http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html It also apply to many DB like Sybase for example... Ville Karjalainen wrote: Greetings, I created a table during transaction and was surprised to find out it still existed after I did a ROLLBACK. The same seems to apply