Debian Codegraph @

mysql-test/suite/engines/funcs/r/ix_using_order.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 INTEGER NOT NULL);
3 CREATE INDEX i1 USING BTREE ON t1(c1 ASC);
4 SHOW CREATE TABLE t1;
5 Table Create Table
6 t1 CREATE TABLE `t1` (
7 `c1` int(11) NOT NULL,
8 KEY `i1` (`c1`) USING BTREE
9 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
10 DROP INDEX i1 ON t1;
11 DROP TABLE t1;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t1(c1 INTEGER NOT NULL);
15 CREATE INDEX i1 USING BTREE ON t1(c1 DESC);
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` int(11) NOT NULL,
20 KEY `i1` (`c1` DESC) USING BTREE
21 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
22 DROP TABLE t1;
23 SHOW TABLES;
24 Tables_in_test
25 CREATE TABLE t1(c1 INTEGER NOT NULL);
26 CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC);
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `c1` int(11) NOT NULL,
31 UNIQUE KEY `i1` (`c1`) USING BTREE
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
33 DROP INDEX i1 ON t1;
34 DROP TABLE t1;
35 SHOW TABLES;
36 Tables_in_test
37 CREATE TABLE t1(c1 INTEGER NOT NULL);
38 CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 DESC);
39 SHOW CREATE TABLE t1;
40 Table Create Table
41 t1 CREATE TABLE `t1` (
42 `c1` int(11) NOT NULL,
43 UNIQUE KEY `i1` (`c1` DESC) USING BTREE
44 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
45 DROP INDEX i1 ON t1;
46 DROP TABLE t1;
47 SHOW TABLES;
48 Tables_in_test
49 CREATE TABLE t1(c1 INTEGER NOT NULL);
50 CREATE INDEX i1 USING HASH ON t1(c1 ASC);
51 SHOW CREATE TABLE t1;
52 Table Create Table
53 t1 CREATE TABLE `t1` (
54 `c1` int(11) NOT NULL,
55 KEY `i1` (`c1`) USING HASH
56 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
57 DROP INDEX i1 ON t1;
58 DROP TABLE t1;
59 SHOW TABLES;
60 Tables_in_test
61 CREATE TABLE t1(c1 INTEGER NOT NULL);
62 CREATE INDEX i1 USING HASH ON t1(c1 DESC);
63 SHOW CREATE TABLE t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `c1` int(11) NOT NULL,
67 KEY `i1` (`c1`) USING HASH
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
69 DROP INDEX i1 ON t1;
70 DROP TABLE t1;
71 SHOW TABLES;
72 Tables_in_test
73 CREATE TABLE t1(c1 INTEGER NOT NULL);
74 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 ASC);
75 SHOW CREATE TABLE t1;
76 Table Create Table
77 t1 CREATE TABLE `t1` (
78 `c1` int(11) NOT NULL,
79 UNIQUE KEY `i1` (`c1`) USING HASH
80 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
81 DROP INDEX i1 ON t1;
82 DROP TABLE t1;
83 SHOW TABLES;
84 Tables_in_test
85 CREATE TABLE t1(c1 INTEGER NOT NULL);
86 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 DESC);
87 SHOW CREATE TABLE t1;
88 Table Create Table
89 t1 CREATE TABLE `t1` (
90 `c1` int(11) NOT NULL,
91 UNIQUE KEY `i1` (`c1`) USING HASH
92 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
93 DROP INDEX i1 ON t1;
94 DROP TABLE t1;
95 SHOW TABLES;
96 Tables_in_test