Bug #16091 'create table' statement cannot be rollbacked successfully

• Submitted: 30 Dec 2005 3:45
• Modified: 30 Dec 2005 14:29
• Reporter: ming lu
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.12
• OS: Windows (windows2000 server)
• Assigned to: MySQL Verification Team
• 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] MySQL Verification Team

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