1--disable_warnings
2let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3--enable_warnings
4
5--disable_warnings
6DROP TABLE IF EXISTS t1,t2;
7--enable_warnings
8CREATE TABLE t1(c1 INTEGER NULL);
9CREATE TABLE t2(c1 INTEGER NULL);
10SHOW TABLES;
11--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE t1;
13--error 1050
14RENAME TABLE t2 TO t1;
15--error 1050
16RENAME TABLE t3 TO t1;
17--error 1017
18RENAME TABLE t3 TO doesnotexist.t1;
19SHOW TABLES;
20--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21 SHOW CREATE TABLE t1;
22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23SHOW CREATE TABLE t2;
24DROP TABLE t2;
25SHOW TABLES;
26
27DROP TABLE t1;
28