Debian Codegraph @

mysql-test/suite/innodb/r/tablespace_rename.result

raw
1 SET GLOBAL innodb_file_per_table=ON;
2 #
3 # Tablespace rename
4 #
5 CREATE TABLE t1 (c1 int KEY) ENGINE=Innodb;
6 INSERT INTO t1 VALUES (1);
7 SELECT * FROM t1;
8 c1
9 1
10 SHOW TABLES;
11 Tables_in_test
12 t1
13 #
14 # Test crash before writing MLOG_FILE_RENAME t2.
15 # On recovery the rename never happened.
16 #
17 SET SESSION debug="+d,ib_crash_rename_log_1";
18 RENAME TABLE t1 TO t2;
19 ERROR HY000: Lost connection to MySQL server during query
20 # restart
21 SET SESSION debug="-d,ib_crash_rename_log_1";
22 SHOW TABLES;
23 Tables_in_test
24 t1
25 INSERT INTO t1 VALUES (2);
26 SELECT * FROM t1;
27 c1
28 1
29 2
30 #
31 # Cleanup
32 #
33 DROP TABLE t1;