release/src/router/mysql/mysql-test/suite/engines/funcs/t/tc_rename_across_database.test

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