diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/tc_structure_create_like_string.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/tc_structure_create_like_string.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/engines/funcs/t/tc_structure_create_like_string.test b/mysql-test/suite/engines/funcs/t/tc_structure_create_like_string.test index 551a87f12ab..96951a2d5ce 100644 --- a/mysql-test/suite/engines/funcs/t/tc_structure_create_like_string.test +++ b/mysql-test/suite/engines/funcs/t/tc_structure_create_like_string.test @@ -5,28 +5,28 @@ CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 CHAR(10) NULL, PRIMARY KEY( CREATE TABLE dst LIKE src; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES; DROP TABLE src; CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) NULL, PRIMARY KEY(c1)); CREATE TABLE dst LIKE src; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES; DROP TABLE src; CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BINARY(10) NULL, PRIMARY KEY(c1)); CREATE TABLE dst LIKE src; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES; DROP TABLE src; CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARBINARY(10) NULL, PRIMARY KEY(c1)); CREATE TABLE dst LIKE src; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES; DROP TABLE src; |