diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/ix_using_order.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/ix_using_order.test | 22 |
1 files changed, 14 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/t/ix_using_order.test b/mysql-test/suite/engines/funcs/t/ix_using_order.test index 0d0560f8e4d..6508066ab94 100644 --- a/mysql-test/suite/engines/funcs/t/ix_using_order.test +++ b/mysql-test/suite/engines/funcs/t/ix_using_order.test @@ -1,23 +1,29 @@ +if (`select @@default_storage_engine = "aria"`) +{ + skip "Aria is not supported for this test (Index on virtual columns)"; +} + + --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING BTREE ON t1(c1 ASC); 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 t1; DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING BTREE ON t1(c1 DESC); 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 t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC); 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 t1; DROP INDEX i1 ON t1; @@ -25,7 +31,7 @@ DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 DESC); 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 t1; DROP INDEX i1 ON t1; @@ -33,21 +39,21 @@ DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING HASH ON t1(c1 ASC); 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 t1; DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING HASH ON t1(c1 DESC); 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 t1; DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 ASC); 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 t1; DROP INDEX i1 ON t1; @@ -55,7 +61,7 @@ DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 DESC); 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 t1; DROP INDEX i1 ON t1; |