Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t4;
2 CREATE TABLE t4(c1 TINYBLOB NULL);
3 CREATE UNIQUE INDEX i1 ON t4(c1(100));
4 SHOW TABLES;
5 Tables_in_test
6 t4
7 SHOW CREATE TABLE t4;
8 Table Create Table
9 t4 CREATE TABLE `t4` (
10 `c1` tinyblob,
11 UNIQUE KEY `i1` (`c1`(100))
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 DROP TABLE t4;
14 SHOW TABLES;
15 Tables_in_test
16 CREATE TABLE t4(c1 BLOB NULL);
17 CREATE UNIQUE INDEX i1 ON t4(c1(100));
18 SHOW TABLES;
19 Tables_in_test
20 t4
21 SHOW CREATE TABLE t4;
22 Table Create Table
23 t4 CREATE TABLE `t4` (
24 `c1` blob,
25 UNIQUE KEY `i1` (`c1`(100))
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t4;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t4(c1 MEDIUMBLOB NULL);
31 CREATE UNIQUE INDEX i1 ON t4(c1(100));
32 SHOW TABLES;
33 Tables_in_test
34 t4
35 SHOW CREATE TABLE t4;
36 Table Create Table
37 t4 CREATE TABLE `t4` (
38 `c1` mediumblob,
39 UNIQUE KEY `i1` (`c1`(100))
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t4;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t4(c1 LONGBLOB NULL);
45 CREATE UNIQUE INDEX i1 ON t4(c1(100));
46 SHOW TABLES;
47 Tables_in_test
48 t4
49 SHOW CREATE TABLE t4;
50 Table Create Table
51 t4 CREATE TABLE `t4` (
52 `c1` longblob,
53 UNIQUE KEY `i1` (`c1`(100))
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t4;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t4(c1 TINYTEXT NULL) charset latin1;
59 CREATE UNIQUE INDEX i1 ON t4(c1(100));
60 SHOW TABLES;
61 Tables_in_test
62 t4
63 SHOW CREATE TABLE t4;
64 Table Create Table
65 t4 CREATE TABLE `t4` (
66 `c1` tinytext,
67 UNIQUE KEY `i1` (`c1`(100))
68 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
69 DROP TABLE t4;
70 SHOW TABLES;
71 Tables_in_test
72 CREATE TABLE t4(c1 TEXT NULL);
73 CREATE UNIQUE INDEX i1 ON t4(c1(100));
74 SHOW TABLES;
75 Tables_in_test
76 t4
77 SHOW CREATE TABLE t4;
78 Table Create Table
79 t4 CREATE TABLE `t4` (
80 `c1` text,
81 UNIQUE KEY `i1` (`c1`(100))
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t4;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t4(c1 MEDIUMTEXT NULL);
87 CREATE UNIQUE INDEX i1 ON t4(c1(100));
88 SHOW TABLES;
89 Tables_in_test
90 t4
91 SHOW CREATE TABLE t4;
92 Table Create Table
93 t4 CREATE TABLE `t4` (
94 `c1` mediumtext,
95 UNIQUE KEY `i1` (`c1`(100))
96 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
97 DROP TABLE t4;
98 SHOW TABLES;
99 Tables_in_test
100 CREATE TABLE t4(c1 LONGTEXT NULL);
101 CREATE UNIQUE INDEX i1 ON t4(c1(100));
102 SHOW TABLES;
103 Tables_in_test
104 t4
105 SHOW CREATE TABLE t4;
106 Table Create Table
107 t4 CREATE TABLE `t4` (
108 `c1` longtext,
109 UNIQUE KEY `i1` (`c1`(100))
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t4;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t4(c1 TINYBLOB NOT NULL);
115 CREATE UNIQUE INDEX i1 ON t4(c1(100));
116 SHOW TABLES;
117 Tables_in_test
118 t4
119 SHOW CREATE TABLE t4;
120 Table Create Table
121 t4 CREATE TABLE `t4` (
122 `c1` tinyblob NOT NULL,
123 UNIQUE KEY `i1` (`c1`(100))
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t4;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t4(c1 BLOB NOT NULL);
129 CREATE UNIQUE INDEX i1 ON t4(c1(100));
130 SHOW TABLES;
131 Tables_in_test
132 t4
133 SHOW CREATE TABLE t4;
134 Table Create Table
135 t4 CREATE TABLE `t4` (
136 `c1` blob NOT NULL,
137 UNIQUE KEY `i1` (`c1`(100))
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t4;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t4(c1 MEDIUMBLOB NOT NULL);
143 CREATE UNIQUE INDEX i1 ON t4(c1(100));
144 SHOW TABLES;
145 Tables_in_test
146 t4
147 SHOW CREATE TABLE t4;
148 Table Create Table
149 t4 CREATE TABLE `t4` (
150 `c1` mediumblob NOT NULL,
151 UNIQUE KEY `i1` (`c1`(100))
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t4;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t4(c1 LONGBLOB NOT NULL);
157 CREATE UNIQUE INDEX i1 ON t4(c1(100));
158 SHOW TABLES;
159 Tables_in_test
160 t4
161 SHOW CREATE TABLE t4;
162 Table Create Table
163 t4 CREATE TABLE `t4` (
164 `c1` longblob NOT NULL,
165 UNIQUE KEY `i1` (`c1`(100))
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t4;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t4(c1 TINYTEXT NOT NULL) charset latin1;
171 CREATE UNIQUE INDEX i1 ON t4(c1(100));
172 SHOW TABLES;
173 Tables_in_test
174 t4
175 SHOW CREATE TABLE t4;
176 Table Create Table
177 t4 CREATE TABLE `t4` (
178 `c1` tinytext NOT NULL,
179 UNIQUE KEY `i1` (`c1`(100))
180 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
181 DROP TABLE t4;
182 SHOW TABLES;
183 Tables_in_test
184 CREATE TABLE t4(c1 TEXT NOT NULL);
185 CREATE UNIQUE INDEX i1 ON t4(c1(100));
186 SHOW TABLES;
187 Tables_in_test
188 t4
189 SHOW CREATE TABLE t4;
190 Table Create Table
191 t4 CREATE TABLE `t4` (
192 `c1` text NOT NULL,
193 UNIQUE KEY `i1` (`c1`(100))
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t4;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t4(c1 MEDIUMTEXT NOT NULL);
199 CREATE UNIQUE INDEX i1 ON t4(c1(100));
200 SHOW TABLES;
201 Tables_in_test
202 t4
203 SHOW CREATE TABLE t4;
204 Table Create Table
205 t4 CREATE TABLE `t4` (
206 `c1` mediumtext NOT NULL,
207 UNIQUE KEY `i1` (`c1`(100))
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 DROP TABLE t4;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t4(c1 LONGTEXT NOT NULL);
213 CREATE UNIQUE INDEX i1 ON t4(c1(100));
214 SHOW TABLES;
215 Tables_in_test
216 t4
217 SHOW CREATE TABLE t4;
218 Table Create Table
219 t4 CREATE TABLE `t4` (
220 `c1` longtext NOT NULL,
221 UNIQUE KEY `i1` (`c1`(100))
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t4;
224 SHOW TABLES;
225 Tables_in_test