Debian Codegraph @

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

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t1;
7 --enable_warnings
8 CREATE TABLE t1(c1 INTEGER NOT NULL);
9 CREATE INDEX i1 USING BTREE ON t1(c1 ASC);
10 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
11 SHOW CREATE TABLE t1;
12 DROP INDEX i1 ON t1;
13 DROP TABLE t1; SHOW TABLES;
14 CREATE TABLE t1(c1 INTEGER NOT NULL);
15 CREATE INDEX i1 USING BTREE ON t1(c1);
16 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
17 SHOW CREATE TABLE t1;
18 DROP TABLE t1; SHOW TABLES;
19 CREATE TABLE t1(c1 INTEGER NOT NULL);
20 CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC);
21 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
22 SHOW CREATE TABLE t1;
23
24 DROP INDEX i1 ON t1;
25 DROP TABLE t1; SHOW TABLES;
26 CREATE TABLE t1(c1 INTEGER NOT NULL);
27 CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1);
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29 SHOW CREATE TABLE t1;
30
31 DROP INDEX i1 ON t1;
32 DROP TABLE t1; SHOW TABLES;
33 CREATE TABLE t1(c1 INTEGER NOT NULL);
34 CREATE INDEX i1 USING HASH ON t1(c1);
35 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
36 SHOW CREATE TABLE t1;
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);
41 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
42 SHOW CREATE TABLE t1;
43 DROP INDEX i1 ON t1;
44 DROP TABLE t1; SHOW TABLES;
45 CREATE TABLE t1(c1 INTEGER NOT NULL);
46 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1);
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t1;
49
50 DROP INDEX i1 ON t1;
51 DROP TABLE t1; SHOW TABLES;
52 CREATE TABLE t1(c1 INTEGER NOT NULL);
53 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1);
54 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
55 SHOW CREATE TABLE t1;
56
57 DROP INDEX i1 ON t1;
58 DROP TABLE t1; SHOW TABLES;