diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/tc_rename.test')
| -rw-r--r-- | mysql-test/suite/engines/funcs/t/tc_rename.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/t/tc_rename.test b/mysql-test/suite/engines/funcs/t/tc_rename.test new file mode 100644 index 00000000..c4e1ca4f --- /dev/null +++ b/mysql-test/suite/engines/funcs/t/tc_rename.test @@ -0,0 +1,14 @@ +--disable_warnings +DROP TABLE IF EXISTS t1,t2; +--enable_warnings +CREATE TABLE t1(c1 INTEGER NULL); +SHOW TABLES; +let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" + SHOW CREATE TABLE t1; +RENAME TABLE t1 TO t2; +SHOW TABLES; +let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" + SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; + |