Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t3;
2 CREATE TABLE t3(c1 CHAR(50) NULL);
3 CREATE INDEX i1 ON t3(c1(10));
4 SHOW TABLES;
5 Tables_in_test
6 t3
7 SHOW CREATE TABLE t3;
8 Table Create Table
9 t3 CREATE TABLE `t3` (
10 `c1` char(50) DEFAULT NULL,
11 KEY `i1` (`c1`(10))
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 DROP TABLE t3;
14 SHOW TABLES;
15 Tables_in_test
16 CREATE TABLE t3(c1 VARCHAR(50) NULL);
17 CREATE INDEX i1 ON t3(c1(10));
18 SHOW TABLES;
19 Tables_in_test
20 t3
21 SHOW CREATE TABLE t3;
22 Table Create Table
23 t3 CREATE TABLE `t3` (
24 `c1` varchar(50) DEFAULT NULL,
25 KEY `i1` (`c1`(10))
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t3;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t3(c1 BINARY(50) NULL);
31 CREATE INDEX i1 ON t3(c1(10));
32 SHOW TABLES;
33 Tables_in_test
34 t3
35 SHOW CREATE TABLE t3;
36 Table Create Table
37 t3 CREATE TABLE `t3` (
38 `c1` binary(50) DEFAULT NULL,
39 KEY `i1` (`c1`(10))
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t3;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t3(c1 VARBINARY(50) NULL);
45 CREATE INDEX i1 ON t3(c1(10));
46 SHOW TABLES;
47 Tables_in_test
48 t3
49 SHOW CREATE TABLE t3;
50 Table Create Table
51 t3 CREATE TABLE `t3` (
52 `c1` varbinary(50) DEFAULT NULL,
53 KEY `i1` (`c1`(10))
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t3;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t3(c1 CHAR(50) NOT NULL);
59 CREATE INDEX i1 ON t3(c1(10));
60 SHOW TABLES;
61 Tables_in_test
62 t3
63 SHOW CREATE TABLE t3;
64 Table Create Table
65 t3 CREATE TABLE `t3` (
66 `c1` char(50) NOT NULL,
67 KEY `i1` (`c1`(10))
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 DROP TABLE t3;
70 SHOW TABLES;
71 Tables_in_test
72 CREATE TABLE t3(c1 VARCHAR(50) NOT NULL);
73 CREATE INDEX i1 ON t3(c1(10));
74 SHOW TABLES;
75 Tables_in_test
76 t3
77 SHOW CREATE TABLE t3;
78 Table Create Table
79 t3 CREATE TABLE `t3` (
80 `c1` varchar(50) NOT NULL,
81 KEY `i1` (`c1`(10))
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t3;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t3(c1 BINARY(50) NOT NULL);
87 CREATE INDEX i1 ON t3(c1(10));
88 SHOW TABLES;
89 Tables_in_test
90 t3
91 SHOW CREATE TABLE t3;
92 Table Create Table
93 t3 CREATE TABLE `t3` (
94 `c1` binary(50) NOT NULL,
95 KEY `i1` (`c1`(10))
96 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
97 DROP TABLE t3;
98 SHOW TABLES;
99 Tables_in_test
100 CREATE TABLE t3(c1 VARBINARY(50) NOT NULL);
101 CREATE INDEX i1 ON t3(c1(10));
102 SHOW TABLES;
103 Tables_in_test
104 t3
105 SHOW CREATE TABLE t3;
106 Table Create Table
107 t3 CREATE TABLE `t3` (
108 `c1` varbinary(50) NOT NULL,
109 KEY `i1` (`c1`(10))
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t3;
112 SHOW TABLES;
113 Tables_in_test