Debian Codegraph @

mysql-test/suite/engines/funcs/t/ix_using_order.test

raw
1 if (`select @@default_storage_engine = "aria"`)
2 {
3 skip "Aria is not supported for this test (Index on virtual columns)";
4 }
5
6
7 --disable_warnings
8 DROP TABLE IF EXISTS t1;
9 --enable_warnings
10 CREATE TABLE t1(c1 INTEGER NOT NULL);
11 CREATE INDEX i1 USING BTREE ON t1(c1 ASC);
12 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
13 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
14 SHOW CREATE TABLE t1;
15 DROP INDEX i1 ON t1;
16 DROP TABLE t1; SHOW TABLES;
17 CREATE TABLE t1(c1 INTEGER NOT NULL);
18 CREATE INDEX i1 USING BTREE ON t1(c1 DESC);
19 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
21 SHOW CREATE TABLE t1;
22 DROP TABLE t1; SHOW TABLES;
23 CREATE TABLE t1(c1 INTEGER NOT NULL);
24 CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC);
25 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
27 SHOW CREATE TABLE t1;
28
29 DROP INDEX i1 ON t1;
30 DROP TABLE t1; SHOW TABLES;
31 CREATE TABLE t1(c1 INTEGER NOT NULL);
32 CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 DESC);
33 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
35 SHOW CREATE TABLE t1;
36
37 DROP INDEX i1 ON t1;
38 DROP TABLE t1; SHOW TABLES;
39 CREATE TABLE t1(c1 INTEGER NOT NULL);
40 CREATE INDEX i1 USING HASH ON t1(c1 ASC);
41 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
42 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
43 SHOW CREATE TABLE t1;
44 DROP INDEX i1 ON t1;
45 DROP TABLE t1; SHOW TABLES;
46 CREATE TABLE t1(c1 INTEGER NOT NULL);
47 CREATE INDEX i1 USING HASH ON t1(c1 DESC);
48 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
49 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
50 SHOW CREATE TABLE t1;
51 DROP INDEX i1 ON t1;
52 DROP TABLE t1; SHOW TABLES;
53 CREATE TABLE t1(c1 INTEGER NOT NULL);
54 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 ASC);
55 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
57 SHOW CREATE TABLE t1;
58
59 DROP INDEX i1 ON t1;
60 DROP TABLE t1; SHOW TABLES;
61 CREATE TABLE t1(c1 INTEGER NOT NULL);
62 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 DESC);
63 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
64 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
65 SHOW CREATE TABLE t1;
66
67 DROP INDEX i1 ON t1;
68 DROP TABLE t1; SHOW TABLES;
69