diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/ta_drop_pk_string.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/ta_drop_pk_string.test | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/t/ta_drop_pk_string.test b/mysql-test/suite/engines/funcs/t/ta_drop_pk_string.test index 4074d028a02..22611b96de2 100644 --- a/mysql-test/suite/engines/funcs/t/ta_drop_pk_string.test +++ b/mysql-test/suite/engines/funcs/t/ta_drop_pk_string.test @@ -4,41 +4,41 @@ DROP TABLE IF EXISTS t9; CREATE TABLE t9(c1 CHAR(20) NOT NULL PRIMARY KEY); 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 t9; ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; CREATE TABLE t9(c1 VARCHAR(20) NOT NULL PRIMARY KEY); 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 t9; ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; CREATE TABLE t9(c1 BINARY(20) NOT NULL PRIMARY KEY); 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 t9; ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; CREATE TABLE t9(c1 VARBINARY(20) NOT NULL PRIMARY KEY); 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 t9; ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; |