Bug #16091 'create table' statement cannot be rollbacked successfully
Submitted: 30 Dec 2005 3:45 Modified: 30 Dec 2005 14:29
Reporter: ming lu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.12 OS:Microsoft Windows (windows2000 server)
Assigned to: Miguel Solorzano CPU Architecture:Any

[30 Dec 2005 3:45] ming lu
Description:
Some sql commands like 'create table' cannot be rollbacked successfully.

How to repeat:
test one:
create schema db1;
start transaction;
create table t1(id int);
show tables;         (the table t1 exists)
rollback;
show tables;         (the table t1 still exists)

test two:
create schema db1;
create table t1(id int);
select * from t1;        (the table is empty)
start transaction;
insert into t1 values(1);
select * from t1;        (one record exists)
rollback;
select * from t1;        (the table t1 becomes empty again)

The test two succeeds, but the test one fails.
[30 Dec 2005 14:29] Miguel Solorzano
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Please read:

http://dev.mysql.com/doc/refman/5.0/en/cannot-roll-back.html