diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/ix_unique_lob.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/ix_unique_lob.test | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/suite/engines/funcs/t/ix_unique_lob.test b/mysql-test/suite/engines/funcs/t/ix_unique_lob.test index 9d635dc5c07..32a6b1bfd5c 100644 --- a/mysql-test/suite/engines/funcs/t/ix_unique_lob.test +++ b/mysql-test/suite/engines/funcs/t/ix_unique_lob.test @@ -5,96 +5,96 @@ CREATE TABLE t4(c1 TINYBLOB NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 BLOB NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 MEDIUMBLOB NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 LONGBLOB NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 TINYTEXT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 TEXT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 MEDIUMTEXT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 LONGTEXT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 TINYBLOB NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 BLOB NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 MEDIUMBLOB NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 LONGBLOB NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 TINYTEXT NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 TEXT NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 MEDIUMTEXT NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; CREATE TABLE t4(c1 LONGTEXT NOT NULL); CREATE UNIQUE INDEX i1 ON t4(c1(100)); 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 t4; DROP TABLE t4; SHOW TABLES; |