Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NULL);
3 CREATE UNIQUE INDEX i1 ON t1(c1);
4 SHOW TABLES;
5 Tables_in_test
6 t1
7 SHOW CREATE TABLE t1;
8 Table Create Table
9 t1 CREATE TABLE `t1` (
10 `c1` bit(1) DEFAULT NULL,
11 UNIQUE KEY `i1` (`c1`)
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 DROP TABLE t1;
14 SHOW TABLES;
15 Tables_in_test
16 CREATE TABLE t1(c1 TINYINT NULL);
17 CREATE UNIQUE INDEX i1 ON t1(c1);
18 SHOW TABLES;
19 Tables_in_test
20 t1
21 SHOW CREATE TABLE t1;
22 Table Create Table
23 t1 CREATE TABLE `t1` (
24 `c1` tinyint DEFAULT NULL,
25 UNIQUE KEY `i1` (`c1`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t1;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t1(c1 SMALLINT NULL);
31 CREATE UNIQUE INDEX i1 ON t1(c1);
32 SHOW TABLES;
33 Tables_in_test
34 t1
35 SHOW CREATE TABLE t1;
36 Table Create Table
37 t1 CREATE TABLE `t1` (
38 `c1` smallint DEFAULT NULL,
39 UNIQUE KEY `i1` (`c1`)
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t1;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t1(c1 MEDIUMINT NULL);
45 CREATE UNIQUE INDEX i1 ON t1(c1);
46 SHOW TABLES;
47 Tables_in_test
48 t1
49 SHOW CREATE TABLE t1;
50 Table Create Table
51 t1 CREATE TABLE `t1` (
52 `c1` mediumint DEFAULT NULL,
53 UNIQUE KEY `i1` (`c1`)
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t1;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t1(c1 INT NULL);
59 CREATE UNIQUE INDEX i1 ON t1(c1);
60 SHOW TABLES;
61 Tables_in_test
62 t1
63 SHOW CREATE TABLE t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `c1` int DEFAULT NULL,
67 UNIQUE KEY `i1` (`c1`)
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 DROP TABLE t1;
70 SHOW TABLES;
71 Tables_in_test
72 CREATE TABLE t1(c1 INTEGER NULL);
73 CREATE UNIQUE INDEX i1 ON t1(c1);
74 SHOW TABLES;
75 Tables_in_test
76 t1
77 SHOW CREATE TABLE t1;
78 Table Create Table
79 t1 CREATE TABLE `t1` (
80 `c1` int DEFAULT NULL,
81 UNIQUE KEY `i1` (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t1;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t1(c1 BIGINT NULL);
87 CREATE UNIQUE INDEX i1 ON t1(c1);
88 SHOW TABLES;
89 Tables_in_test
90 t1
91 SHOW CREATE TABLE t1;
92 Table Create Table
93 t1 CREATE TABLE `t1` (
94 `c1` bigint DEFAULT NULL,
95 UNIQUE KEY `i1` (`c1`)
96 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
97 DROP TABLE t1;
98 SHOW TABLES;
99 Tables_in_test
100 CREATE TABLE t1(c1 REAL NULL);
101 CREATE UNIQUE INDEX i1 ON t1(c1);
102 SHOW TABLES;
103 Tables_in_test
104 t1
105 SHOW CREATE TABLE t1;
106 Table Create Table
107 t1 CREATE TABLE `t1` (
108 `c1` double DEFAULT NULL,
109 UNIQUE KEY `i1` (`c1`)
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t1;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t1(c1 DOUBLE NULL);
115 CREATE UNIQUE INDEX i1 ON t1(c1);
116 SHOW TABLES;
117 Tables_in_test
118 t1
119 SHOW CREATE TABLE t1;
120 Table Create Table
121 t1 CREATE TABLE `t1` (
122 `c1` double DEFAULT NULL,
123 UNIQUE KEY `i1` (`c1`)
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t1;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t1(c1 FLOAT NULL);
129 CREATE UNIQUE INDEX i1 ON t1(c1);
130 SHOW TABLES;
131 Tables_in_test
132 t1
133 SHOW CREATE TABLE t1;
134 Table Create Table
135 t1 CREATE TABLE `t1` (
136 `c1` float DEFAULT NULL,
137 UNIQUE KEY `i1` (`c1`)
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t1;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t1(c1 DECIMAL NULL);
143 CREATE UNIQUE INDEX i1 ON t1(c1);
144 SHOW TABLES;
145 Tables_in_test
146 t1
147 SHOW CREATE TABLE t1;
148 Table Create Table
149 t1 CREATE TABLE `t1` (
150 `c1` decimal(10,0) DEFAULT NULL,
151 UNIQUE KEY `i1` (`c1`)
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t1;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t1(c1 NUMERIC NULL);
157 CREATE UNIQUE INDEX i1 ON t1(c1);
158 SHOW TABLES;
159 Tables_in_test
160 t1
161 SHOW CREATE TABLE t1;
162 Table Create Table
163 t1 CREATE TABLE `t1` (
164 `c1` decimal(10,0) DEFAULT NULL,
165 UNIQUE KEY `i1` (`c1`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t1;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t1(c1 DATE NULL);
171 CREATE UNIQUE INDEX i1 ON t1(c1);
172 SHOW TABLES;
173 Tables_in_test
174 t1
175 SHOW CREATE TABLE t1;
176 Table Create Table
177 t1 CREATE TABLE `t1` (
178 `c1` date DEFAULT NULL,
179 UNIQUE KEY `i1` (`c1`)
180 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
181 DROP TABLE t1;
182 SHOW TABLES;
183 Tables_in_test
184 CREATE TABLE t1(c1 TIME NULL);
185 CREATE UNIQUE INDEX i1 ON t1(c1);
186 SHOW TABLES;
187 Tables_in_test
188 t1
189 SHOW CREATE TABLE t1;
190 Table Create Table
191 t1 CREATE TABLE `t1` (
192 `c1` time DEFAULT NULL,
193 UNIQUE KEY `i1` (`c1`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t1;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t1(c1 TIMESTAMP NULL);
199 CREATE UNIQUE INDEX i1 ON t1(c1);
200 SHOW TABLES;
201 Tables_in_test
202 t1
203 SHOW CREATE TABLE t1;
204 Table Create Table
205 t1 CREATE TABLE `t1` (
206 `c1` timestamp NULL DEFAULT NULL,
207 UNIQUE KEY `i1` (`c1`)
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 DROP TABLE t1;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t1(c1 YEAR NULL);
213 CREATE UNIQUE INDEX i1 ON t1(c1);
214 SHOW TABLES;
215 Tables_in_test
216 t1
217 SHOW CREATE TABLE t1;
218 Table Create Table
219 t1 CREATE TABLE `t1` (
220 `c1` year DEFAULT NULL,
221 UNIQUE KEY `i1` (`c1`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t1;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t1(c1 BIT NOT NULL);
227 CREATE UNIQUE INDEX i1 ON t1(c1);
228 SHOW TABLES;
229 Tables_in_test
230 t1
231 SHOW CREATE TABLE t1;
232 Table Create Table
233 t1 CREATE TABLE `t1` (
234 `c1` bit(1) NOT NULL,
235 UNIQUE KEY `i1` (`c1`)
236 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
237 DROP TABLE t1;
238 SHOW TABLES;
239 Tables_in_test
240 CREATE TABLE t1(c1 TINYINT NOT NULL);
241 CREATE UNIQUE INDEX i1 ON t1(c1);
242 SHOW TABLES;
243 Tables_in_test
244 t1
245 SHOW CREATE TABLE t1;
246 Table Create Table
247 t1 CREATE TABLE `t1` (
248 `c1` tinyint NOT NULL,
249 UNIQUE KEY `i1` (`c1`)
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
251 DROP TABLE t1;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t1(c1 SMALLINT NOT NULL);
255 CREATE UNIQUE INDEX i1 ON t1(c1);
256 SHOW TABLES;
257 Tables_in_test
258 t1
259 SHOW CREATE TABLE t1;
260 Table Create Table
261 t1 CREATE TABLE `t1` (
262 `c1` smallint NOT NULL,
263 UNIQUE KEY `i1` (`c1`)
264 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
265 DROP TABLE t1;
266 SHOW TABLES;
267 Tables_in_test
268 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
269 CREATE UNIQUE INDEX i1 ON t1(c1);
270 SHOW TABLES;
271 Tables_in_test
272 t1
273 SHOW CREATE TABLE t1;
274 Table Create Table
275 t1 CREATE TABLE `t1` (
276 `c1` mediumint NOT NULL,
277 UNIQUE KEY `i1` (`c1`)
278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 DROP TABLE t1;
280 SHOW TABLES;
281 Tables_in_test
282 CREATE TABLE t1(c1 INT NOT NULL);
283 CREATE UNIQUE INDEX i1 ON t1(c1);
284 SHOW TABLES;
285 Tables_in_test
286 t1
287 SHOW CREATE TABLE t1;
288 Table Create Table
289 t1 CREATE TABLE `t1` (
290 `c1` int NOT NULL,
291 UNIQUE KEY `i1` (`c1`)
292 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
293 DROP TABLE t1;
294 SHOW TABLES;
295 Tables_in_test
296 CREATE TABLE t1(c1 INTEGER NOT NULL);
297 CREATE UNIQUE INDEX i1 ON t1(c1);
298 SHOW TABLES;
299 Tables_in_test
300 t1
301 SHOW CREATE TABLE t1;
302 Table Create Table
303 t1 CREATE TABLE `t1` (
304 `c1` int NOT NULL,
305 UNIQUE KEY `i1` (`c1`)
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t1(c1 BIGINT NOT NULL);
311 CREATE UNIQUE INDEX i1 ON t1(c1);
312 SHOW TABLES;
313 Tables_in_test
314 t1
315 SHOW CREATE TABLE t1;
316 Table Create Table
317 t1 CREATE TABLE `t1` (
318 `c1` bigint NOT NULL,
319 UNIQUE KEY `i1` (`c1`)
320 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
321 DROP TABLE t1;
322 SHOW TABLES;
323 Tables_in_test
324 CREATE TABLE t1(c1 REAL NOT NULL);
325 CREATE UNIQUE INDEX i1 ON t1(c1);
326 SHOW TABLES;
327 Tables_in_test
328 t1
329 SHOW CREATE TABLE t1;
330 Table Create Table
331 t1 CREATE TABLE `t1` (
332 `c1` double NOT NULL,
333 UNIQUE KEY `i1` (`c1`)
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
335 DROP TABLE t1;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t1(c1 DOUBLE NOT NULL);
339 CREATE UNIQUE INDEX i1 ON t1(c1);
340 SHOW TABLES;
341 Tables_in_test
342 t1
343 SHOW CREATE TABLE t1;
344 Table Create Table
345 t1 CREATE TABLE `t1` (
346 `c1` double NOT NULL,
347 UNIQUE KEY `i1` (`c1`)
348 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
349 DROP TABLE t1;
350 SHOW TABLES;
351 Tables_in_test
352 CREATE TABLE t1(c1 FLOAT NOT NULL);
353 CREATE UNIQUE INDEX i1 ON t1(c1);
354 SHOW TABLES;
355 Tables_in_test
356 t1
357 SHOW CREATE TABLE t1;
358 Table Create Table
359 t1 CREATE TABLE `t1` (
360 `c1` float NOT NULL,
361 UNIQUE KEY `i1` (`c1`)
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 DROP TABLE t1;
364 SHOW TABLES;
365 Tables_in_test
366 CREATE TABLE t1(c1 DECIMAL NOT NULL);
367 CREATE UNIQUE INDEX i1 ON t1(c1);
368 SHOW TABLES;
369 Tables_in_test
370 t1
371 SHOW CREATE TABLE t1;
372 Table Create Table
373 t1 CREATE TABLE `t1` (
374 `c1` decimal(10,0) NOT NULL,
375 UNIQUE KEY `i1` (`c1`)
376 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
377 DROP TABLE t1;
378 SHOW TABLES;
379 Tables_in_test
380 CREATE TABLE t1(c1 NUMERIC NOT NULL);
381 CREATE UNIQUE INDEX i1 ON t1(c1);
382 SHOW TABLES;
383 Tables_in_test
384 t1
385 SHOW CREATE TABLE t1;
386 Table Create Table
387 t1 CREATE TABLE `t1` (
388 `c1` decimal(10,0) NOT NULL,
389 UNIQUE KEY `i1` (`c1`)
390 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
391 DROP TABLE t1;
392 SHOW TABLES;
393 Tables_in_test
394 CREATE TABLE t1(c1 DATE NOT NULL);
395 CREATE UNIQUE INDEX i1 ON t1(c1);
396 SHOW TABLES;
397 Tables_in_test
398 t1
399 SHOW CREATE TABLE t1;
400 Table Create Table
401 t1 CREATE TABLE `t1` (
402 `c1` date NOT NULL,
403 UNIQUE KEY `i1` (`c1`)
404 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
405 DROP TABLE t1;
406 SHOW TABLES;
407 Tables_in_test
408 CREATE TABLE t1(c1 TIME NOT NULL);
409 CREATE UNIQUE INDEX i1 ON t1(c1);
410 SHOW TABLES;
411 Tables_in_test
412 t1
413 SHOW CREATE TABLE t1;
414 Table Create Table
415 t1 CREATE TABLE `t1` (
416 `c1` time NOT NULL,
417 UNIQUE KEY `i1` (`c1`)
418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
419 DROP TABLE t1;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
423 CREATE UNIQUE INDEX i1 ON t1(c1);
424 SHOW TABLES;
425 Tables_in_test
426 t1
427 SHOW CREATE TABLE t1;
428 Table Create Table
429 t1 CREATE TABLE `t1` (
430 `c1` timestamp NOT NULL,
431 UNIQUE KEY `i1` (`c1`)
432 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
433 DROP TABLE t1;
434 SHOW TABLES;
435 Tables_in_test
436 CREATE TABLE t1(c1 YEAR NOT NULL);
437 CREATE UNIQUE INDEX i1 ON t1(c1);
438 SHOW TABLES;
439 Tables_in_test
440 t1
441 SHOW CREATE TABLE t1;
442 Table Create Table
443 t1 CREATE TABLE `t1` (
444 `c1` year NOT NULL,
445 UNIQUE KEY `i1` (`c1`)
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 DROP TABLE t1;
448 SHOW TABLES;
449 Tables_in_test