Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TEMPORARY TABLE t1(c1 BIT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 SHOW CREATE TABLE t1;
6 Table Create Table
7 t1 CREATE TEMPORARY TABLE `t1` (
8 `c1` bit(1) DEFAULT NULL
9 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
10 DROP TABLE t1;
11 SHOW TABLES;
12 Tables_in_test
13 CREATE TEMPORARY TABLE t1(c1 TINYINT NULL);
14 SHOW TABLES;
15 Tables_in_test
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TEMPORARY TABLE `t1` (
19 `c1` tinyint DEFAULT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TEMPORARY TABLE t1(c1 SMALLINT NULL);
25 SHOW TABLES;
26 Tables_in_test
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TEMPORARY TABLE `t1` (
30 `c1` smallint DEFAULT NULL
31 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
32 DROP TABLE t1;
33 SHOW TABLES;
34 Tables_in_test
35 CREATE TEMPORARY TABLE t1(c1 MEDIUMINT NULL);
36 SHOW TABLES;
37 Tables_in_test
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TEMPORARY TABLE `t1` (
41 `c1` mediumint DEFAULT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TEMPORARY TABLE t1(c1 INT NULL);
47 SHOW TABLES;
48 Tables_in_test
49 SHOW CREATE TABLE t1;
50 Table Create Table
51 t1 CREATE TEMPORARY TABLE `t1` (
52 `c1` int DEFAULT NULL
53 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
54 DROP TABLE t1;
55 SHOW TABLES;
56 Tables_in_test
57 CREATE TEMPORARY TABLE t1(c1 INTEGER NULL);
58 SHOW TABLES;
59 Tables_in_test
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TEMPORARY TABLE `t1` (
63 `c1` int DEFAULT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t1;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TEMPORARY TABLE t1(c1 BIGINT NULL);
69 SHOW TABLES;
70 Tables_in_test
71 SHOW CREATE TABLE t1;
72 Table Create Table
73 t1 CREATE TEMPORARY TABLE `t1` (
74 `c1` bigint DEFAULT NULL
75 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
76 DROP TABLE t1;
77 SHOW TABLES;
78 Tables_in_test
79 CREATE TEMPORARY TABLE t1(c1 DECIMAL NULL);
80 SHOW TABLES;
81 Tables_in_test
82 SHOW CREATE TABLE t1;
83 Table Create Table
84 t1 CREATE TEMPORARY TABLE `t1` (
85 `c1` decimal(10,0) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t1;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TEMPORARY TABLE t1(c1 DEC NULL);
91 SHOW TABLES;
92 Tables_in_test
93 SHOW CREATE TABLE t1;
94 Table Create Table
95 t1 CREATE TEMPORARY TABLE `t1` (
96 `c1` decimal(10,0) DEFAULT NULL
97 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
98 DROP TABLE t1;
99 SHOW TABLES;
100 Tables_in_test
101 CREATE TEMPORARY TABLE t1(c1 FIXED NULL);
102 SHOW TABLES;
103 Tables_in_test
104 SHOW CREATE TABLE t1;
105 Table Create Table
106 t1 CREATE TEMPORARY TABLE `t1` (
107 `c1` decimal(10,0) DEFAULT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t1;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TEMPORARY TABLE t1(c1 NUMERIC NULL);
113 SHOW TABLES;
114 Tables_in_test
115 SHOW CREATE TABLE t1;
116 Table Create Table
117 t1 CREATE TEMPORARY TABLE `t1` (
118 `c1` decimal(10,0) DEFAULT NULL
119 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
120 DROP TABLE t1;
121 SHOW TABLES;
122 Tables_in_test
123 CREATE TEMPORARY TABLE t1(c1 DOUBLE NULL);
124 SHOW TABLES;
125 Tables_in_test
126 SHOW CREATE TABLE t1;
127 Table Create Table
128 t1 CREATE TEMPORARY TABLE `t1` (
129 `c1` double DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t1;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TEMPORARY TABLE t1(c1 REAL NULL);
135 SHOW TABLES;
136 Tables_in_test
137 SHOW CREATE TABLE t1;
138 Table Create Table
139 t1 CREATE TEMPORARY TABLE `t1` (
140 `c1` double DEFAULT NULL
141 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
142 DROP TABLE t1;
143 SHOW TABLES;
144 Tables_in_test
145 CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION NULL);
146 SHOW TABLES;
147 Tables_in_test
148 SHOW CREATE TABLE t1;
149 Table Create Table
150 t1 CREATE TEMPORARY TABLE `t1` (
151 `c1` double DEFAULT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t1;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TEMPORARY TABLE t1(c1 FLOAT NULL);
157 SHOW TABLES;
158 Tables_in_test
159 SHOW CREATE TABLE t1;
160 Table Create Table
161 t1 CREATE TEMPORARY TABLE `t1` (
162 `c1` float DEFAULT NULL
163 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
164 DROP TABLE t1;
165 SHOW TABLES;
166 Tables_in_test
167 CREATE TEMPORARY TABLE t1(c1 DATE NULL);
168 SHOW TABLES;
169 Tables_in_test
170 SHOW CREATE TABLE t1;
171 Table Create Table
172 t1 CREATE TEMPORARY TABLE `t1` (
173 `c1` date DEFAULT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t1;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TEMPORARY TABLE t1(c1 TIME NULL);
179 SHOW TABLES;
180 Tables_in_test
181 SHOW CREATE TABLE t1;
182 Table Create Table
183 t1 CREATE TEMPORARY TABLE `t1` (
184 `c1` time DEFAULT NULL
185 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
186 DROP TABLE t1;
187 SHOW TABLES;
188 Tables_in_test
189 CREATE TEMPORARY TABLE t1(c1 TIMESTAMP NULL);
190 SHOW TABLES;
191 Tables_in_test
192 SHOW CREATE TABLE t1;
193 Table Create Table
194 t1 CREATE TEMPORARY TABLE `t1` (
195 `c1` timestamp NULL DEFAULT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t1;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TEMPORARY TABLE t1(c1 DATETIME NULL);
201 SHOW TABLES;
202 Tables_in_test
203 SHOW CREATE TABLE t1;
204 Table Create Table
205 t1 CREATE TEMPORARY TABLE `t1` (
206 `c1` datetime DEFAULT NULL
207 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
208 DROP TABLE t1;
209 SHOW TABLES;
210 Tables_in_test
211 CREATE TEMPORARY TABLE t1(c1 YEAR NULL);
212 SHOW TABLES;
213 Tables_in_test
214 SHOW CREATE TABLE t1;
215 Table Create Table
216 t1 CREATE TEMPORARY TABLE `t1` (
217 `c1` year DEFAULT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t1;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TEMPORARY TABLE t1(c1 TINYBLOB NULL);
223 SHOW TABLES;
224 Tables_in_test
225 SHOW CREATE TABLE t1;
226 Table Create Table
227 t1 CREATE TEMPORARY TABLE `t1` (
228 `c1` tinyblob
229 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
230 DROP TABLE t1;
231 SHOW TABLES;
232 Tables_in_test
233 CREATE TEMPORARY TABLE t1(c1 BLOB NULL);
234 SHOW TABLES;
235 Tables_in_test
236 SHOW CREATE TABLE t1;
237 Table Create Table
238 t1 CREATE TEMPORARY TABLE `t1` (
239 `c1` blob
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t1;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB NULL);
245 SHOW TABLES;
246 Tables_in_test
247 SHOW CREATE TABLE t1;
248 Table Create Table
249 t1 CREATE TEMPORARY TABLE `t1` (
250 `c1` mediumblob
251 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
252 DROP TABLE t1;
253 SHOW TABLES;
254 Tables_in_test
255 CREATE TEMPORARY TABLE t1(c1 LONGBLOB NULL);
256 SHOW TABLES;
257 Tables_in_test
258 SHOW CREATE TABLE t1;
259 Table Create Table
260 t1 CREATE TEMPORARY TABLE `t1` (
261 `c1` longblob
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t1;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TEMPORARY TABLE t1(c1 TINYTEXT NULL);
267 SHOW TABLES;
268 Tables_in_test
269 SHOW CREATE TABLE t1;
270 Table Create Table
271 t1 CREATE TEMPORARY TABLE `t1` (
272 `c1` tinytext
273 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
274 DROP TABLE t1;
275 SHOW TABLES;
276 Tables_in_test
277 CREATE TEMPORARY TABLE t1(c1 TEXT NULL);
278 SHOW TABLES;
279 Tables_in_test
280 SHOW CREATE TABLE t1;
281 Table Create Table
282 t1 CREATE TEMPORARY TABLE `t1` (
283 `c1` text
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t1;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT NULL);
289 SHOW TABLES;
290 Tables_in_test
291 SHOW CREATE TABLE t1;
292 Table Create Table
293 t1 CREATE TEMPORARY TABLE `t1` (
294 `c1` mediumtext
295 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
296 DROP TABLE t1;
297 SHOW TABLES;
298 Tables_in_test
299 CREATE TEMPORARY TABLE t1(c1 LONGTEXT NULL);
300 SHOW TABLES;
301 Tables_in_test
302 SHOW CREATE TABLE t1;
303 Table Create Table
304 t1 CREATE TEMPORARY TABLE `t1` (
305 `c1` longtext
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TEMPORARY TABLE t1(c1 BIT NOT NULL);
311 SHOW TABLES;
312 Tables_in_test
313 SHOW CREATE TABLE t1;
314 Table Create Table
315 t1 CREATE TEMPORARY TABLE `t1` (
316 `c1` bit(1) NOT NULL
317 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
318 DROP TABLE t1;
319 SHOW TABLES;
320 Tables_in_test
321 CREATE TEMPORARY TABLE t1(c1 TINYINT NOT NULL);
322 SHOW TABLES;
323 Tables_in_test
324 SHOW CREATE TABLE t1;
325 Table Create Table
326 t1 CREATE TEMPORARY TABLE `t1` (
327 `c1` tinyint NOT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t1;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TEMPORARY TABLE t1(c1 SMALLINT NOT NULL);
333 SHOW TABLES;
334 Tables_in_test
335 SHOW CREATE TABLE t1;
336 Table Create Table
337 t1 CREATE TEMPORARY TABLE `t1` (
338 `c1` smallint NOT NULL
339 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
340 DROP TABLE t1;
341 SHOW TABLES;
342 Tables_in_test
343 CREATE TEMPORARY TABLE t1(c1 MEDIUMINT NOT NULL);
344 SHOW TABLES;
345 Tables_in_test
346 SHOW CREATE TABLE t1;
347 Table Create Table
348 t1 CREATE TEMPORARY TABLE `t1` (
349 `c1` mediumint NOT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t1;
352 SHOW TABLES;
353 Tables_in_test
354 CREATE TEMPORARY TABLE t1(c1 INT NOT NULL);
355 SHOW TABLES;
356 Tables_in_test
357 SHOW CREATE TABLE t1;
358 Table Create Table
359 t1 CREATE TEMPORARY TABLE `t1` (
360 `c1` int NOT NULL
361 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
362 DROP TABLE t1;
363 SHOW TABLES;
364 Tables_in_test
365 CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL);
366 SHOW TABLES;
367 Tables_in_test
368 SHOW CREATE TABLE t1;
369 Table Create Table
370 t1 CREATE TEMPORARY TABLE `t1` (
371 `c1` int NOT NULL
372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
373 DROP TABLE t1;
374 SHOW TABLES;
375 Tables_in_test
376 CREATE TEMPORARY TABLE t1(c1 BIGINT NOT NULL);
377 SHOW TABLES;
378 Tables_in_test
379 SHOW CREATE TABLE t1;
380 Table Create Table
381 t1 CREATE TEMPORARY TABLE `t1` (
382 `c1` bigint NOT NULL
383 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
384 DROP TABLE t1;
385 SHOW TABLES;
386 Tables_in_test
387 CREATE TEMPORARY TABLE t1(c1 DECIMAL NOT NULL);
388 SHOW TABLES;
389 Tables_in_test
390 SHOW CREATE TABLE t1;
391 Table Create Table
392 t1 CREATE TEMPORARY TABLE `t1` (
393 `c1` decimal(10,0) NOT NULL
394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
395 DROP TABLE t1;
396 SHOW TABLES;
397 Tables_in_test
398 CREATE TEMPORARY TABLE t1(c1 DEC NOT NULL);
399 SHOW TABLES;
400 Tables_in_test
401 SHOW CREATE TABLE t1;
402 Table Create Table
403 t1 CREATE TEMPORARY TABLE `t1` (
404 `c1` decimal(10,0) NOT NULL
405 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
406 DROP TABLE t1;
407 SHOW TABLES;
408 Tables_in_test
409 CREATE TEMPORARY TABLE t1(c1 FIXED NOT NULL);
410 SHOW TABLES;
411 Tables_in_test
412 SHOW CREATE TABLE t1;
413 Table Create Table
414 t1 CREATE TEMPORARY TABLE `t1` (
415 `c1` decimal(10,0) NOT NULL
416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
417 DROP TABLE t1;
418 SHOW TABLES;
419 Tables_in_test
420 CREATE TEMPORARY TABLE t1(c1 NUMERIC NOT NULL);
421 SHOW TABLES;
422 Tables_in_test
423 SHOW CREATE TABLE t1;
424 Table Create Table
425 t1 CREATE TEMPORARY TABLE `t1` (
426 `c1` decimal(10,0) NOT NULL
427 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
428 DROP TABLE t1;
429 SHOW TABLES;
430 Tables_in_test
431 CREATE TEMPORARY TABLE t1(c1 DOUBLE NOT NULL);
432 SHOW TABLES;
433 Tables_in_test
434 SHOW CREATE TABLE t1;
435 Table Create Table
436 t1 CREATE TEMPORARY TABLE `t1` (
437 `c1` double NOT NULL
438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 DROP TABLE t1;
440 SHOW TABLES;
441 Tables_in_test
442 CREATE TEMPORARY TABLE t1(c1 REAL NOT NULL);
443 SHOW TABLES;
444 Tables_in_test
445 SHOW CREATE TABLE t1;
446 Table Create Table
447 t1 CREATE TEMPORARY TABLE `t1` (
448 `c1` double NOT NULL
449 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
450 DROP TABLE t1;
451 SHOW TABLES;
452 Tables_in_test
453 CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION NOT NULL);
454 SHOW TABLES;
455 Tables_in_test
456 SHOW CREATE TABLE t1;
457 Table Create Table
458 t1 CREATE TEMPORARY TABLE `t1` (
459 `c1` double NOT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
461 DROP TABLE t1;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TEMPORARY TABLE t1(c1 FLOAT NOT NULL);
465 SHOW TABLES;
466 Tables_in_test
467 SHOW CREATE TABLE t1;
468 Table Create Table
469 t1 CREATE TEMPORARY TABLE `t1` (
470 `c1` float NOT NULL
471 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
472 DROP TABLE t1;
473 SHOW TABLES;
474 Tables_in_test
475 CREATE TEMPORARY TABLE t1(c1 DATE NOT NULL);
476 SHOW TABLES;
477 Tables_in_test
478 SHOW CREATE TABLE t1;
479 Table Create Table
480 t1 CREATE TEMPORARY TABLE `t1` (
481 `c1` date NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t1;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TEMPORARY TABLE t1(c1 TIME NOT NULL);
487 SHOW TABLES;
488 Tables_in_test
489 SHOW CREATE TABLE t1;
490 Table Create Table
491 t1 CREATE TEMPORARY TABLE `t1` (
492 `c1` time NOT NULL
493 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
494 DROP TABLE t1;
495 SHOW TABLES;
496 Tables_in_test
497 CREATE TEMPORARY TABLE t1(c1 TIMESTAMP NOT NULL);
498 SHOW TABLES;
499 Tables_in_test
500 SHOW CREATE TABLE t1;
501 Table Create Table
502 t1 CREATE TEMPORARY TABLE `t1` (
503 `c1` timestamp NOT NULL
504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 DROP TABLE t1;
506 SHOW TABLES;
507 Tables_in_test
508 CREATE TEMPORARY TABLE t1(c1 DATETIME NOT NULL);
509 SHOW TABLES;
510 Tables_in_test
511 SHOW CREATE TABLE t1;
512 Table Create Table
513 t1 CREATE TEMPORARY TABLE `t1` (
514 `c1` datetime NOT NULL
515 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
516 DROP TABLE t1;
517 SHOW TABLES;
518 Tables_in_test
519 CREATE TEMPORARY TABLE t1(c1 YEAR NOT NULL);
520 SHOW TABLES;
521 Tables_in_test
522 SHOW CREATE TABLE t1;
523 Table Create Table
524 t1 CREATE TEMPORARY TABLE `t1` (
525 `c1` year NOT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
527 DROP TABLE t1;
528 SHOW TABLES;
529 Tables_in_test
530 CREATE TEMPORARY TABLE t1(c1 TINYBLOB NOT NULL);
531 SHOW TABLES;
532 Tables_in_test
533 SHOW CREATE TABLE t1;
534 Table Create Table
535 t1 CREATE TEMPORARY TABLE `t1` (
536 `c1` tinyblob NOT NULL
537 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
538 DROP TABLE t1;
539 SHOW TABLES;
540 Tables_in_test
541 CREATE TEMPORARY TABLE t1(c1 BLOB NOT NULL);
542 SHOW TABLES;
543 Tables_in_test
544 SHOW CREATE TABLE t1;
545 Table Create Table
546 t1 CREATE TEMPORARY TABLE `t1` (
547 `c1` blob NOT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
549 DROP TABLE t1;
550 SHOW TABLES;
551 Tables_in_test
552 CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB NOT NULL);
553 SHOW TABLES;
554 Tables_in_test
555 SHOW CREATE TABLE t1;
556 Table Create Table
557 t1 CREATE TEMPORARY TABLE `t1` (
558 `c1` mediumblob NOT NULL
559 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
560 DROP TABLE t1;
561 SHOW TABLES;
562 Tables_in_test
563 CREATE TEMPORARY TABLE t1(c1 LONGBLOB NOT NULL);
564 SHOW TABLES;
565 Tables_in_test
566 SHOW CREATE TABLE t1;
567 Table Create Table
568 t1 CREATE TEMPORARY TABLE `t1` (
569 `c1` longblob NOT NULL
570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
571 DROP TABLE t1;
572 SHOW TABLES;
573 Tables_in_test
574 CREATE TEMPORARY TABLE t1(c1 TINYTEXT NOT NULL);
575 SHOW TABLES;
576 Tables_in_test
577 SHOW CREATE TABLE t1;
578 Table Create Table
579 t1 CREATE TEMPORARY TABLE `t1` (
580 `c1` tinytext NOT NULL
581 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
582 DROP TABLE t1;
583 SHOW TABLES;
584 Tables_in_test
585 CREATE TEMPORARY TABLE t1(c1 TEXT NOT NULL);
586 SHOW TABLES;
587 Tables_in_test
588 SHOW CREATE TABLE t1;
589 Table Create Table
590 t1 CREATE TEMPORARY TABLE `t1` (
591 `c1` text NOT NULL
592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
593 DROP TABLE t1;
594 SHOW TABLES;
595 Tables_in_test
596 CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT NOT NULL);
597 SHOW TABLES;
598 Tables_in_test
599 SHOW CREATE TABLE t1;
600 Table Create Table
601 t1 CREATE TEMPORARY TABLE `t1` (
602 `c1` mediumtext NOT NULL
603 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
604 DROP TABLE t1;
605 SHOW TABLES;
606 Tables_in_test
607 CREATE TEMPORARY TABLE t1(c1 LONGTEXT NOT NULL);
608 SHOW TABLES;
609 Tables_in_test
610 SHOW CREATE TABLE t1;
611 Table Create Table
612 t1 CREATE TEMPORARY TABLE `t1` (
613 `c1` longtext NOT NULL
614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
615 DROP TABLE t1;
616 SHOW TABLES;
617 Tables_in_test