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