blob: d13fc84aa43d489ef33b9bfc491d018fd14692ad (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
FLUSH TABLES;
CREATE TABLE t1 (a SERIAL, b INT, c INT, d INT) ENGINE=InnoDB;
INSERT INTO t1 () VALUES ();
connect con1,localhost,root,,test;
SET DEBUG_SYNC='before_rename_table_commit SIGNAL renamed WAIT_FOR ever';
RENAME TABLE t1 TO t2;
connection default;
SET DEBUG_SYNC='now WAIT_FOR renamed';
# restart
disconnect con1;
SELECT * FROM t1;
a b c d
1 NULL NULL NULL
DROP TABLE t1;
|
