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 NOT NULL,
8 KEY `i1` (`c1`) USING BTREE
9 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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);
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` int NOT NULL,
20 KEY `i1` (`c1`) USING BTREE
21 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 NOT NULL,
31 UNIQUE KEY `i1` (`c1`) USING BTREE
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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);
39 SHOW CREATE TABLE t1;
40 Table Create Table
41 t1 CREATE TABLE `t1` (
42 `c1` int NOT NULL,
43 UNIQUE KEY `i1` (`c1`) USING BTREE
44 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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);
51 Warnings:
52 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
53 SHOW CREATE TABLE t1;
54 Table Create Table
55 t1 CREATE TABLE `t1` (
56 `c1` int NOT NULL,
57 KEY `i1` (`c1`)
58 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
59 DROP INDEX i1 ON t1;
60 DROP TABLE t1;
61 SHOW TABLES;
62 Tables_in_test
63 CREATE TABLE t1(c1 INTEGER NOT NULL);
64 CREATE INDEX i1 USING HASH ON t1(c1);
65 Warnings:
66 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
67 SHOW CREATE TABLE t1;
68 Table Create Table
69 t1 CREATE TABLE `t1` (
70 `c1` int NOT NULL,
71 KEY `i1` (`c1`)
72 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
73 DROP INDEX i1 ON t1;
74 DROP TABLE t1;
75 SHOW TABLES;
76 Tables_in_test
77 CREATE TABLE t1(c1 INTEGER NOT NULL);
78 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1);
79 Warnings:
80 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` int NOT NULL,
85 UNIQUE KEY `i1` (`c1`)
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP INDEX i1 ON t1;
88 DROP TABLE t1;
89 SHOW TABLES;
90 Tables_in_test
91 CREATE TABLE t1(c1 INTEGER NOT NULL);
92 CREATE UNIQUE INDEX i1 USING HASH ON t1(c1);
93 Warnings:
94 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
95 SHOW CREATE TABLE t1;
96 Table Create Table
97 t1 CREATE TABLE `t1` (
98 `c1` int NOT NULL,
99 UNIQUE KEY `i1` (`c1`)
100 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
101 DROP INDEX i1 ON t1;
102 DROP TABLE t1;
103 SHOW TABLES;
104 Tables_in_test