diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/ix_index_string.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/ix_index_string.test | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/t/ix_index_string.test b/mysql-test/suite/engines/funcs/t/ix_index_string.test index fe58185c01e..32a73b39c4e 100644 --- a/mysql-test/suite/engines/funcs/t/ix_index_string.test +++ b/mysql-test/suite/engines/funcs/t/ix_index_string.test @@ -5,48 +5,48 @@ CREATE TABLE t2(c1 CHAR(50) NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 VARCHAR(50) NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 BINARY(50) NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 VARBINARY(50) NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 CHAR(50) NOT NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 VARCHAR(50) NOT NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 BINARY(50) NOT NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; CREATE TABLE t2(c1 VARBINARY(50) NOT NULL); CREATE INDEX i1 ON t2(c1); 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 t2; DROP TABLE t2; SHOW TABLES; |