34 lines
575 B
Plaintext
34 lines
575 B
Plaintext
SET GLOBAL innodb_file_per_table=ON;
|
|
#
|
|
# Tablespace rename
|
|
#
|
|
CREATE TABLE t1 (c1 int KEY) ENGINE=Innodb;
|
|
INSERT INTO t1 VALUES (1);
|
|
SELECT * FROM t1;
|
|
c1
|
|
1
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t1
|
|
#
|
|
# Test crash before writing MLOG_FILE_RENAME t2.
|
|
# On recovery the rename never happened.
|
|
#
|
|
SET SESSION debug="+d,ib_crash_rename_log_1";
|
|
RENAME TABLE t1 TO t2;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
SET SESSION debug="-d,ib_crash_rename_log_1";
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t1
|
|
INSERT INTO t1 VALUES (2);
|
|
SELECT * FROM t1;
|
|
c1
|
|
1
|
|
2
|
|
#
|
|
# Cleanup
|
|
#
|
|
DROP TABLE t1;
|