Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 BIT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t5
6 SHOW CREATE TABLE t5;
7 Table Create Table
8 t5 CREATE TABLE `t5` (
9 `c1` bit(1) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
12 SHOW TABLES;
13 Tables_in_test
14 t5
15 SHOW CREATE TABLE t5;
16 Table Create Table
17 t5 CREATE TABLE `t5` (
18 `c2` char(5) DEFAULT NULL,
19 `c1` bit(1) DEFAULT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t5;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t5(c1 TINYINT NULL);
25 SHOW TABLES;
26 Tables_in_test
27 t5
28 SHOW CREATE TABLE t5;
29 Table Create Table
30 t5 CREATE TABLE `t5` (
31 `c1` tinyint DEFAULT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
34 SHOW TABLES;
35 Tables_in_test
36 t5
37 SHOW CREATE TABLE t5;
38 Table Create Table
39 t5 CREATE TABLE `t5` (
40 `c2` char(5) DEFAULT NULL,
41 `c1` tinyint DEFAULT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t5;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t5(c1 SMALLINT NULL);
47 SHOW TABLES;
48 Tables_in_test
49 t5
50 SHOW CREATE TABLE t5;
51 Table Create Table
52 t5 CREATE TABLE `t5` (
53 `c1` smallint DEFAULT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
56 SHOW TABLES;
57 Tables_in_test
58 t5
59 SHOW CREATE TABLE t5;
60 Table Create Table
61 t5 CREATE TABLE `t5` (
62 `c2` char(5) DEFAULT NULL,
63 `c1` smallint DEFAULT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t5;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t5(c1 MEDIUMINT NULL);
69 SHOW TABLES;
70 Tables_in_test
71 t5
72 SHOW CREATE TABLE t5;
73 Table Create Table
74 t5 CREATE TABLE `t5` (
75 `c1` mediumint DEFAULT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
78 SHOW TABLES;
79 Tables_in_test
80 t5
81 SHOW CREATE TABLE t5;
82 Table Create Table
83 t5 CREATE TABLE `t5` (
84 `c2` char(5) DEFAULT NULL,
85 `c1` mediumint DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t5;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t5(c1 INT NULL);
91 SHOW TABLES;
92 Tables_in_test
93 t5
94 SHOW CREATE TABLE t5;
95 Table Create Table
96 t5 CREATE TABLE `t5` (
97 `c1` int DEFAULT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
100 SHOW TABLES;
101 Tables_in_test
102 t5
103 SHOW CREATE TABLE t5;
104 Table Create Table
105 t5 CREATE TABLE `t5` (
106 `c2` char(5) DEFAULT NULL,
107 `c1` int DEFAULT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t5;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t5(c1 INTEGER NULL);
113 SHOW TABLES;
114 Tables_in_test
115 t5
116 SHOW CREATE TABLE t5;
117 Table Create Table
118 t5 CREATE TABLE `t5` (
119 `c1` int DEFAULT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
122 SHOW TABLES;
123 Tables_in_test
124 t5
125 SHOW CREATE TABLE t5;
126 Table Create Table
127 t5 CREATE TABLE `t5` (
128 `c2` char(5) DEFAULT NULL,
129 `c1` int DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t5;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t5(c1 BIGINT NULL);
135 SHOW TABLES;
136 Tables_in_test
137 t5
138 SHOW CREATE TABLE t5;
139 Table Create Table
140 t5 CREATE TABLE `t5` (
141 `c1` bigint DEFAULT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
144 SHOW TABLES;
145 Tables_in_test
146 t5
147 SHOW CREATE TABLE t5;
148 Table Create Table
149 t5 CREATE TABLE `t5` (
150 `c2` char(5) DEFAULT NULL,
151 `c1` bigint DEFAULT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t5;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t5(c1 REAL NULL);
157 SHOW TABLES;
158 Tables_in_test
159 t5
160 SHOW CREATE TABLE t5;
161 Table Create Table
162 t5 CREATE TABLE `t5` (
163 `c1` double DEFAULT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
165 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
166 SHOW TABLES;
167 Tables_in_test
168 t5
169 SHOW CREATE TABLE t5;
170 Table Create Table
171 t5 CREATE TABLE `t5` (
172 `c2` char(5) DEFAULT NULL,
173 `c1` double DEFAULT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t5;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t5(c1 DOUBLE NULL);
179 SHOW TABLES;
180 Tables_in_test
181 t5
182 SHOW CREATE TABLE t5;
183 Table Create Table
184 t5 CREATE TABLE `t5` (
185 `c1` double DEFAULT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
187 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
188 SHOW TABLES;
189 Tables_in_test
190 t5
191 SHOW CREATE TABLE t5;
192 Table Create Table
193 t5 CREATE TABLE `t5` (
194 `c2` char(5) DEFAULT NULL,
195 `c1` double DEFAULT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t5;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t5(c1 FLOAT NULL);
201 SHOW TABLES;
202 Tables_in_test
203 t5
204 SHOW CREATE TABLE t5;
205 Table Create Table
206 t5 CREATE TABLE `t5` (
207 `c1` float DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
210 SHOW TABLES;
211 Tables_in_test
212 t5
213 SHOW CREATE TABLE t5;
214 Table Create Table
215 t5 CREATE TABLE `t5` (
216 `c2` char(5) DEFAULT NULL,
217 `c1` float DEFAULT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t5;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t5(c1 DECIMAL NULL);
223 SHOW TABLES;
224 Tables_in_test
225 t5
226 SHOW CREATE TABLE t5;
227 Table Create Table
228 t5 CREATE TABLE `t5` (
229 `c1` decimal(10,0) DEFAULT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
232 SHOW TABLES;
233 Tables_in_test
234 t5
235 SHOW CREATE TABLE t5;
236 Table Create Table
237 t5 CREATE TABLE `t5` (
238 `c2` char(5) DEFAULT NULL,
239 `c1` decimal(10,0) DEFAULT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t5;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t5(c1 NUMERIC NULL);
245 SHOW TABLES;
246 Tables_in_test
247 t5
248 SHOW CREATE TABLE t5;
249 Table Create Table
250 t5 CREATE TABLE `t5` (
251 `c1` decimal(10,0) DEFAULT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
254 SHOW TABLES;
255 Tables_in_test
256 t5
257 SHOW CREATE TABLE t5;
258 Table Create Table
259 t5 CREATE TABLE `t5` (
260 `c2` char(5) DEFAULT NULL,
261 `c1` decimal(10,0) DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t5;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t5(c1 DATE NULL);
267 SHOW TABLES;
268 Tables_in_test
269 t5
270 SHOW CREATE TABLE t5;
271 Table Create Table
272 t5 CREATE TABLE `t5` (
273 `c1` date DEFAULT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
276 SHOW TABLES;
277 Tables_in_test
278 t5
279 SHOW CREATE TABLE t5;
280 Table Create Table
281 t5 CREATE TABLE `t5` (
282 `c2` char(5) DEFAULT NULL,
283 `c1` date DEFAULT NULL
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t5;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TABLE t5(c1 TIME NULL);
289 SHOW TABLES;
290 Tables_in_test
291 t5
292 SHOW CREATE TABLE t5;
293 Table Create Table
294 t5 CREATE TABLE `t5` (
295 `c1` time DEFAULT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
298 SHOW TABLES;
299 Tables_in_test
300 t5
301 SHOW CREATE TABLE t5;
302 Table Create Table
303 t5 CREATE TABLE `t5` (
304 `c2` char(5) DEFAULT NULL,
305 `c1` time DEFAULT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t5;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t5(c1 TIMESTAMP NULL);
311 SHOW TABLES;
312 Tables_in_test
313 t5
314 SHOW CREATE TABLE t5;
315 Table Create Table
316 t5 CREATE TABLE `t5` (
317 `c1` timestamp NULL DEFAULT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
320 SHOW TABLES;
321 Tables_in_test
322 t5
323 SHOW CREATE TABLE t5;
324 Table Create Table
325 t5 CREATE TABLE `t5` (
326 `c2` char(5) DEFAULT NULL,
327 `c1` timestamp NULL DEFAULT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t5;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t5(c1 YEAR NULL);
333 SHOW TABLES;
334 Tables_in_test
335 t5
336 SHOW CREATE TABLE t5;
337 Table Create Table
338 t5 CREATE TABLE `t5` (
339 `c1` year DEFAULT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
341 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
342 SHOW TABLES;
343 Tables_in_test
344 t5
345 SHOW CREATE TABLE t5;
346 Table Create Table
347 t5 CREATE TABLE `t5` (
348 `c2` char(5) DEFAULT NULL,
349 `c1` year DEFAULT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t5;
352 SHOW TABLES;
353 Tables_in_test
354 CREATE TABLE t5(c1 TINYBLOB NULL);
355 SHOW TABLES;
356 Tables_in_test
357 t5
358 SHOW CREATE TABLE t5;
359 Table Create Table
360 t5 CREATE TABLE `t5` (
361 `c1` tinyblob
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
364 SHOW TABLES;
365 Tables_in_test
366 t5
367 SHOW CREATE TABLE t5;
368 Table Create Table
369 t5 CREATE TABLE `t5` (
370 `c2` char(5) DEFAULT NULL,
371 `c1` tinyblob
372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
373 DROP TABLE t5;
374 SHOW TABLES;
375 Tables_in_test
376 CREATE TABLE t5(c1 BLOB NULL);
377 SHOW TABLES;
378 Tables_in_test
379 t5
380 SHOW CREATE TABLE t5;
381 Table Create Table
382 t5 CREATE TABLE `t5` (
383 `c1` blob
384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
385 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
386 SHOW TABLES;
387 Tables_in_test
388 t5
389 SHOW CREATE TABLE t5;
390 Table Create Table
391 t5 CREATE TABLE `t5` (
392 `c2` char(5) DEFAULT NULL,
393 `c1` blob
394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
395 DROP TABLE t5;
396 SHOW TABLES;
397 Tables_in_test
398 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
399 SHOW TABLES;
400 Tables_in_test
401 t5
402 SHOW CREATE TABLE t5;
403 Table Create Table
404 t5 CREATE TABLE `t5` (
405 `c1` mediumblob
406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
407 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
408 SHOW TABLES;
409 Tables_in_test
410 t5
411 SHOW CREATE TABLE t5;
412 Table Create Table
413 t5 CREATE TABLE `t5` (
414 `c2` char(5) DEFAULT NULL,
415 `c1` mediumblob
416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
417 DROP TABLE t5;
418 SHOW TABLES;
419 Tables_in_test
420 CREATE TABLE t5(c1 LONGBLOB NULL);
421 SHOW TABLES;
422 Tables_in_test
423 t5
424 SHOW CREATE TABLE t5;
425 Table Create Table
426 t5 CREATE TABLE `t5` (
427 `c1` longblob
428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
429 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
430 SHOW TABLES;
431 Tables_in_test
432 t5
433 SHOW CREATE TABLE t5;
434 Table Create Table
435 t5 CREATE TABLE `t5` (
436 `c2` char(5) DEFAULT NULL,
437 `c1` longblob
438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 DROP TABLE t5;
440 SHOW TABLES;
441 Tables_in_test
442 CREATE TABLE t5(c1 TINYTEXT NULL);
443 SHOW TABLES;
444 Tables_in_test
445 t5
446 SHOW CREATE TABLE t5;
447 Table Create Table
448 t5 CREATE TABLE `t5` (
449 `c1` tinytext
450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
451 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
452 SHOW TABLES;
453 Tables_in_test
454 t5
455 SHOW CREATE TABLE t5;
456 Table Create Table
457 t5 CREATE TABLE `t5` (
458 `c2` char(5) DEFAULT NULL,
459 `c1` tinytext
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
461 DROP TABLE t5;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TABLE t5(c1 TEXT NULL);
465 SHOW TABLES;
466 Tables_in_test
467 t5
468 SHOW CREATE TABLE t5;
469 Table Create Table
470 t5 CREATE TABLE `t5` (
471 `c1` text
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
473 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
474 SHOW TABLES;
475 Tables_in_test
476 t5
477 SHOW CREATE TABLE t5;
478 Table Create Table
479 t5 CREATE TABLE `t5` (
480 `c2` char(5) DEFAULT NULL,
481 `c1` text
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t5;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
487 SHOW TABLES;
488 Tables_in_test
489 t5
490 SHOW CREATE TABLE t5;
491 Table Create Table
492 t5 CREATE TABLE `t5` (
493 `c1` mediumtext
494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
495 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
496 SHOW TABLES;
497 Tables_in_test
498 t5
499 SHOW CREATE TABLE t5;
500 Table Create Table
501 t5 CREATE TABLE `t5` (
502 `c2` char(5) DEFAULT NULL,
503 `c1` mediumtext
504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 DROP TABLE t5;
506 SHOW TABLES;
507 Tables_in_test
508 CREATE TABLE t5(c1 LONGTEXT NULL);
509 SHOW TABLES;
510 Tables_in_test
511 t5
512 SHOW CREATE TABLE t5;
513 Table Create Table
514 t5 CREATE TABLE `t5` (
515 `c1` longtext
516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
517 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST;
518 SHOW TABLES;
519 Tables_in_test
520 t5
521 SHOW CREATE TABLE t5;
522 Table Create Table
523 t5 CREATE TABLE `t5` (
524 `c2` char(5) DEFAULT NULL,
525 `c1` longtext
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
527 DROP TABLE t5;
528 SHOW TABLES;
529 Tables_in_test
530 CREATE TABLE t5(c1 BIT NOT NULL);
531 SHOW TABLES;
532 Tables_in_test
533 t5
534 SHOW CREATE TABLE t5;
535 Table Create Table
536 t5 CREATE TABLE `t5` (
537 `c1` bit(1) NOT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
539 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
540 SHOW TABLES;
541 Tables_in_test
542 t5
543 SHOW CREATE TABLE t5;
544 Table Create Table
545 t5 CREATE TABLE `t5` (
546 `c2` char(5) NOT NULL,
547 `c1` bit(1) NOT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
549 DROP TABLE t5;
550 SHOW TABLES;
551 Tables_in_test
552 CREATE TABLE t5(c1 TINYINT NOT NULL);
553 SHOW TABLES;
554 Tables_in_test
555 t5
556 SHOW CREATE TABLE t5;
557 Table Create Table
558 t5 CREATE TABLE `t5` (
559 `c1` tinyint NOT NULL
560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
561 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
562 SHOW TABLES;
563 Tables_in_test
564 t5
565 SHOW CREATE TABLE t5;
566 Table Create Table
567 t5 CREATE TABLE `t5` (
568 `c2` char(5) NOT NULL,
569 `c1` tinyint NOT NULL
570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
571 DROP TABLE t5;
572 SHOW TABLES;
573 Tables_in_test
574 CREATE TABLE t5(c1 SMALLINT NOT NULL);
575 SHOW TABLES;
576 Tables_in_test
577 t5
578 SHOW CREATE TABLE t5;
579 Table Create Table
580 t5 CREATE TABLE `t5` (
581 `c1` smallint NOT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
583 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
584 SHOW TABLES;
585 Tables_in_test
586 t5
587 SHOW CREATE TABLE t5;
588 Table Create Table
589 t5 CREATE TABLE `t5` (
590 `c2` char(5) NOT NULL,
591 `c1` smallint NOT NULL
592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
593 DROP TABLE t5;
594 SHOW TABLES;
595 Tables_in_test
596 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
597 SHOW TABLES;
598 Tables_in_test
599 t5
600 SHOW CREATE TABLE t5;
601 Table Create Table
602 t5 CREATE TABLE `t5` (
603 `c1` mediumint NOT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
605 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
606 SHOW TABLES;
607 Tables_in_test
608 t5
609 SHOW CREATE TABLE t5;
610 Table Create Table
611 t5 CREATE TABLE `t5` (
612 `c2` char(5) NOT NULL,
613 `c1` mediumint NOT NULL
614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
615 DROP TABLE t5;
616 SHOW TABLES;
617 Tables_in_test
618 CREATE TABLE t5(c1 INT NOT NULL);
619 SHOW TABLES;
620 Tables_in_test
621 t5
622 SHOW CREATE TABLE t5;
623 Table Create Table
624 t5 CREATE TABLE `t5` (
625 `c1` int NOT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
628 SHOW TABLES;
629 Tables_in_test
630 t5
631 SHOW CREATE TABLE t5;
632 Table Create Table
633 t5 CREATE TABLE `t5` (
634 `c2` char(5) NOT NULL,
635 `c1` int NOT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
637 DROP TABLE t5;
638 SHOW TABLES;
639 Tables_in_test
640 CREATE TABLE t5(c1 INTEGER NOT NULL);
641 SHOW TABLES;
642 Tables_in_test
643 t5
644 SHOW CREATE TABLE t5;
645 Table Create Table
646 t5 CREATE TABLE `t5` (
647 `c1` int NOT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
649 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
650 SHOW TABLES;
651 Tables_in_test
652 t5
653 SHOW CREATE TABLE t5;
654 Table Create Table
655 t5 CREATE TABLE `t5` (
656 `c2` char(5) NOT NULL,
657 `c1` int NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
659 DROP TABLE t5;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t5(c1 BIGINT NOT NULL);
663 SHOW TABLES;
664 Tables_in_test
665 t5
666 SHOW CREATE TABLE t5;
667 Table Create Table
668 t5 CREATE TABLE `t5` (
669 `c1` bigint NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
671 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
672 SHOW TABLES;
673 Tables_in_test
674 t5
675 SHOW CREATE TABLE t5;
676 Table Create Table
677 t5 CREATE TABLE `t5` (
678 `c2` char(5) NOT NULL,
679 `c1` bigint NOT NULL
680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
681 DROP TABLE t5;
682 SHOW TABLES;
683 Tables_in_test
684 CREATE TABLE t5(c1 REAL NOT NULL);
685 SHOW TABLES;
686 Tables_in_test
687 t5
688 SHOW CREATE TABLE t5;
689 Table Create Table
690 t5 CREATE TABLE `t5` (
691 `c1` double NOT NULL
692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
693 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
694 SHOW TABLES;
695 Tables_in_test
696 t5
697 SHOW CREATE TABLE t5;
698 Table Create Table
699 t5 CREATE TABLE `t5` (
700 `c2` char(5) NOT NULL,
701 `c1` double NOT NULL
702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
703 DROP TABLE t5;
704 SHOW TABLES;
705 Tables_in_test
706 CREATE TABLE t5(c1 DOUBLE NOT NULL);
707 SHOW TABLES;
708 Tables_in_test
709 t5
710 SHOW CREATE TABLE t5;
711 Table Create Table
712 t5 CREATE TABLE `t5` (
713 `c1` double NOT NULL
714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
715 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
716 SHOW TABLES;
717 Tables_in_test
718 t5
719 SHOW CREATE TABLE t5;
720 Table Create Table
721 t5 CREATE TABLE `t5` (
722 `c2` char(5) NOT NULL,
723 `c1` double NOT NULL
724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
725 DROP TABLE t5;
726 SHOW TABLES;
727 Tables_in_test
728 CREATE TABLE t5(c1 FLOAT NOT NULL);
729 SHOW TABLES;
730 Tables_in_test
731 t5
732 SHOW CREATE TABLE t5;
733 Table Create Table
734 t5 CREATE TABLE `t5` (
735 `c1` float NOT NULL
736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
737 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
738 SHOW TABLES;
739 Tables_in_test
740 t5
741 SHOW CREATE TABLE t5;
742 Table Create Table
743 t5 CREATE TABLE `t5` (
744 `c2` char(5) NOT NULL,
745 `c1` float NOT NULL
746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
747 DROP TABLE t5;
748 SHOW TABLES;
749 Tables_in_test
750 CREATE TABLE t5(c1 DECIMAL NOT NULL);
751 SHOW TABLES;
752 Tables_in_test
753 t5
754 SHOW CREATE TABLE t5;
755 Table Create Table
756 t5 CREATE TABLE `t5` (
757 `c1` decimal(10,0) NOT NULL
758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
759 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
760 SHOW TABLES;
761 Tables_in_test
762 t5
763 SHOW CREATE TABLE t5;
764 Table Create Table
765 t5 CREATE TABLE `t5` (
766 `c2` char(5) NOT NULL,
767 `c1` decimal(10,0) NOT NULL
768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
769 DROP TABLE t5;
770 SHOW TABLES;
771 Tables_in_test
772 CREATE TABLE t5(c1 NUMERIC NOT NULL);
773 SHOW TABLES;
774 Tables_in_test
775 t5
776 SHOW CREATE TABLE t5;
777 Table Create Table
778 t5 CREATE TABLE `t5` (
779 `c1` decimal(10,0) NOT NULL
780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
781 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
782 SHOW TABLES;
783 Tables_in_test
784 t5
785 SHOW CREATE TABLE t5;
786 Table Create Table
787 t5 CREATE TABLE `t5` (
788 `c2` char(5) NOT NULL,
789 `c1` decimal(10,0) NOT NULL
790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
791 DROP TABLE t5;
792 SHOW TABLES;
793 Tables_in_test
794 CREATE TABLE t5(c1 DATE NOT NULL);
795 SHOW TABLES;
796 Tables_in_test
797 t5
798 SHOW CREATE TABLE t5;
799 Table Create Table
800 t5 CREATE TABLE `t5` (
801 `c1` date NOT NULL
802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
803 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
804 SHOW TABLES;
805 Tables_in_test
806 t5
807 SHOW CREATE TABLE t5;
808 Table Create Table
809 t5 CREATE TABLE `t5` (
810 `c2` char(5) NOT NULL,
811 `c1` date NOT NULL
812 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
813 DROP TABLE t5;
814 SHOW TABLES;
815 Tables_in_test
816 CREATE TABLE t5(c1 TIME NOT NULL);
817 SHOW TABLES;
818 Tables_in_test
819 t5
820 SHOW CREATE TABLE t5;
821 Table Create Table
822 t5 CREATE TABLE `t5` (
823 `c1` time NOT NULL
824 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
825 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
826 SHOW TABLES;
827 Tables_in_test
828 t5
829 SHOW CREATE TABLE t5;
830 Table Create Table
831 t5 CREATE TABLE `t5` (
832 `c2` char(5) NOT NULL,
833 `c1` time NOT NULL
834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
835 DROP TABLE t5;
836 SHOW TABLES;
837 Tables_in_test
838 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
839 SHOW TABLES;
840 Tables_in_test
841 t5
842 SHOW CREATE TABLE t5;
843 Table Create Table
844 t5 CREATE TABLE `t5` (
845 `c1` timestamp NOT NULL
846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
847 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
848 SHOW TABLES;
849 Tables_in_test
850 t5
851 SHOW CREATE TABLE t5;
852 Table Create Table
853 t5 CREATE TABLE `t5` (
854 `c2` char(5) NOT NULL,
855 `c1` timestamp NOT NULL
856 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
857 DROP TABLE t5;
858 SHOW TABLES;
859 Tables_in_test
860 CREATE TABLE t5(c1 YEAR NOT NULL);
861 SHOW TABLES;
862 Tables_in_test
863 t5
864 SHOW CREATE TABLE t5;
865 Table Create Table
866 t5 CREATE TABLE `t5` (
867 `c1` year NOT NULL
868 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
869 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
870 SHOW TABLES;
871 Tables_in_test
872 t5
873 SHOW CREATE TABLE t5;
874 Table Create Table
875 t5 CREATE TABLE `t5` (
876 `c2` char(5) NOT NULL,
877 `c1` year NOT NULL
878 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
879 DROP TABLE t5;
880 SHOW TABLES;
881 Tables_in_test
882 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
883 SHOW TABLES;
884 Tables_in_test
885 t5
886 SHOW CREATE TABLE t5;
887 Table Create Table
888 t5 CREATE TABLE `t5` (
889 `c1` tinyblob NOT NULL
890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
891 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
892 SHOW TABLES;
893 Tables_in_test
894 t5
895 SHOW CREATE TABLE t5;
896 Table Create Table
897 t5 CREATE TABLE `t5` (
898 `c2` char(5) NOT NULL,
899 `c1` tinyblob NOT NULL
900 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
901 DROP TABLE t5;
902 SHOW TABLES;
903 Tables_in_test
904 CREATE TABLE t5(c1 BLOB NOT NULL);
905 SHOW TABLES;
906 Tables_in_test
907 t5
908 SHOW CREATE TABLE t5;
909 Table Create Table
910 t5 CREATE TABLE `t5` (
911 `c1` blob NOT NULL
912 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
913 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
914 SHOW TABLES;
915 Tables_in_test
916 t5
917 SHOW CREATE TABLE t5;
918 Table Create Table
919 t5 CREATE TABLE `t5` (
920 `c2` char(5) NOT NULL,
921 `c1` blob NOT NULL
922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
923 DROP TABLE t5;
924 SHOW TABLES;
925 Tables_in_test
926 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
927 SHOW TABLES;
928 Tables_in_test
929 t5
930 SHOW CREATE TABLE t5;
931 Table Create Table
932 t5 CREATE TABLE `t5` (
933 `c1` mediumblob NOT NULL
934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
935 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
936 SHOW TABLES;
937 Tables_in_test
938 t5
939 SHOW CREATE TABLE t5;
940 Table Create Table
941 t5 CREATE TABLE `t5` (
942 `c2` char(5) NOT NULL,
943 `c1` mediumblob NOT NULL
944 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
945 DROP TABLE t5;
946 SHOW TABLES;
947 Tables_in_test
948 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
949 SHOW TABLES;
950 Tables_in_test
951 t5
952 SHOW CREATE TABLE t5;
953 Table Create Table
954 t5 CREATE TABLE `t5` (
955 `c1` longblob NOT NULL
956 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
957 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
958 SHOW TABLES;
959 Tables_in_test
960 t5
961 SHOW CREATE TABLE t5;
962 Table Create Table
963 t5 CREATE TABLE `t5` (
964 `c2` char(5) NOT NULL,
965 `c1` longblob NOT NULL
966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
967 DROP TABLE t5;
968 SHOW TABLES;
969 Tables_in_test
970 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
971 SHOW TABLES;
972 Tables_in_test
973 t5
974 SHOW CREATE TABLE t5;
975 Table Create Table
976 t5 CREATE TABLE `t5` (
977 `c1` tinytext NOT NULL
978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
979 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
980 SHOW TABLES;
981 Tables_in_test
982 t5
983 SHOW CREATE TABLE t5;
984 Table Create Table
985 t5 CREATE TABLE `t5` (
986 `c2` char(5) NOT NULL,
987 `c1` tinytext NOT NULL
988 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
989 DROP TABLE t5;
990 SHOW TABLES;
991 Tables_in_test
992 CREATE TABLE t5(c1 TEXT NOT NULL);
993 SHOW TABLES;
994 Tables_in_test
995 t5
996 SHOW CREATE TABLE t5;
997 Table Create Table
998 t5 CREATE TABLE `t5` (
999 `c1` text NOT NULL
1000 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1001 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
1002 SHOW TABLES;
1003 Tables_in_test
1004 t5
1005 SHOW CREATE TABLE t5;
1006 Table Create Table
1007 t5 CREATE TABLE `t5` (
1008 `c2` char(5) NOT NULL,
1009 `c1` text NOT NULL
1010 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1011 DROP TABLE t5;
1012 SHOW TABLES;
1013 Tables_in_test
1014 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
1015 SHOW TABLES;
1016 Tables_in_test
1017 t5
1018 SHOW CREATE TABLE t5;
1019 Table Create Table
1020 t5 CREATE TABLE `t5` (
1021 `c1` mediumtext NOT NULL
1022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1023 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
1024 SHOW TABLES;
1025 Tables_in_test
1026 t5
1027 SHOW CREATE TABLE t5;
1028 Table Create Table
1029 t5 CREATE TABLE `t5` (
1030 `c2` char(5) NOT NULL,
1031 `c1` mediumtext NOT NULL
1032 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1033 DROP TABLE t5;
1034 SHOW TABLES;
1035 Tables_in_test
1036 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
1037 SHOW TABLES;
1038 Tables_in_test
1039 t5
1040 SHOW CREATE TABLE t5;
1041 Table Create Table
1042 t5 CREATE TABLE `t5` (
1043 `c1` longtext NOT NULL
1044 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1045 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST;
1046 SHOW TABLES;
1047 Tables_in_test
1048 t5
1049 SHOW CREATE TABLE t5;
1050 Table Create Table
1051 t5 CREATE TABLE `t5` (
1052 `c2` char(5) NOT NULL,
1053 `c1` longtext NOT NULL
1054 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1055 DROP TABLE t5;
1056 SHOW TABLES;
1057 Tables_in_test
1058 CREATE TABLE t5(c1 BIT NULL);
1059 SHOW TABLES;
1060 Tables_in_test
1061 t5
1062 SHOW CREATE TABLE t5;
1063 Table Create Table
1064 t5 CREATE TABLE `t5` (
1065 `c1` bit(1) DEFAULT NULL
1066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1067 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1068 SHOW TABLES;
1069 Tables_in_test
1070 t5
1071 SHOW CREATE TABLE t5;
1072 Table Create Table
1073 t5 CREATE TABLE `t5` (
1074 `c2` varchar(5) DEFAULT NULL,
1075 `c1` bit(1) DEFAULT NULL
1076 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1077 DROP TABLE t5;
1078 SHOW TABLES;
1079 Tables_in_test
1080 CREATE TABLE t5(c1 TINYINT NULL);
1081 SHOW TABLES;
1082 Tables_in_test
1083 t5
1084 SHOW CREATE TABLE t5;
1085 Table Create Table
1086 t5 CREATE TABLE `t5` (
1087 `c1` tinyint DEFAULT NULL
1088 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1089 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1090 SHOW TABLES;
1091 Tables_in_test
1092 t5
1093 SHOW CREATE TABLE t5;
1094 Table Create Table
1095 t5 CREATE TABLE `t5` (
1096 `c2` varchar(5) DEFAULT NULL,
1097 `c1` tinyint DEFAULT NULL
1098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1099 DROP TABLE t5;
1100 SHOW TABLES;
1101 Tables_in_test
1102 CREATE TABLE t5(c1 SMALLINT NULL);
1103 SHOW TABLES;
1104 Tables_in_test
1105 t5
1106 SHOW CREATE TABLE t5;
1107 Table Create Table
1108 t5 CREATE TABLE `t5` (
1109 `c1` smallint DEFAULT NULL
1110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1111 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1112 SHOW TABLES;
1113 Tables_in_test
1114 t5
1115 SHOW CREATE TABLE t5;
1116 Table Create Table
1117 t5 CREATE TABLE `t5` (
1118 `c2` varchar(5) DEFAULT NULL,
1119 `c1` smallint DEFAULT NULL
1120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1121 DROP TABLE t5;
1122 SHOW TABLES;
1123 Tables_in_test
1124 CREATE TABLE t5(c1 MEDIUMINT NULL);
1125 SHOW TABLES;
1126 Tables_in_test
1127 t5
1128 SHOW CREATE TABLE t5;
1129 Table Create Table
1130 t5 CREATE TABLE `t5` (
1131 `c1` mediumint DEFAULT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1133 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1134 SHOW TABLES;
1135 Tables_in_test
1136 t5
1137 SHOW CREATE TABLE t5;
1138 Table Create Table
1139 t5 CREATE TABLE `t5` (
1140 `c2` varchar(5) DEFAULT NULL,
1141 `c1` mediumint DEFAULT NULL
1142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1143 DROP TABLE t5;
1144 SHOW TABLES;
1145 Tables_in_test
1146 CREATE TABLE t5(c1 INT NULL);
1147 SHOW TABLES;
1148 Tables_in_test
1149 t5
1150 SHOW CREATE TABLE t5;
1151 Table Create Table
1152 t5 CREATE TABLE `t5` (
1153 `c1` int DEFAULT NULL
1154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1155 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1156 SHOW TABLES;
1157 Tables_in_test
1158 t5
1159 SHOW CREATE TABLE t5;
1160 Table Create Table
1161 t5 CREATE TABLE `t5` (
1162 `c2` varchar(5) DEFAULT NULL,
1163 `c1` int DEFAULT NULL
1164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1165 DROP TABLE t5;
1166 SHOW TABLES;
1167 Tables_in_test
1168 CREATE TABLE t5(c1 INTEGER NULL);
1169 SHOW TABLES;
1170 Tables_in_test
1171 t5
1172 SHOW CREATE TABLE t5;
1173 Table Create Table
1174 t5 CREATE TABLE `t5` (
1175 `c1` int DEFAULT NULL
1176 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1177 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1178 SHOW TABLES;
1179 Tables_in_test
1180 t5
1181 SHOW CREATE TABLE t5;
1182 Table Create Table
1183 t5 CREATE TABLE `t5` (
1184 `c2` varchar(5) DEFAULT NULL,
1185 `c1` int DEFAULT NULL
1186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1187 DROP TABLE t5;
1188 SHOW TABLES;
1189 Tables_in_test
1190 CREATE TABLE t5(c1 BIGINT NULL);
1191 SHOW TABLES;
1192 Tables_in_test
1193 t5
1194 SHOW CREATE TABLE t5;
1195 Table Create Table
1196 t5 CREATE TABLE `t5` (
1197 `c1` bigint DEFAULT NULL
1198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1199 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1200 SHOW TABLES;
1201 Tables_in_test
1202 t5
1203 SHOW CREATE TABLE t5;
1204 Table Create Table
1205 t5 CREATE TABLE `t5` (
1206 `c2` varchar(5) DEFAULT NULL,
1207 `c1` bigint DEFAULT NULL
1208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1209 DROP TABLE t5;
1210 SHOW TABLES;
1211 Tables_in_test
1212 CREATE TABLE t5(c1 REAL NULL);
1213 SHOW TABLES;
1214 Tables_in_test
1215 t5
1216 SHOW CREATE TABLE t5;
1217 Table Create Table
1218 t5 CREATE TABLE `t5` (
1219 `c1` double DEFAULT NULL
1220 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1221 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1222 SHOW TABLES;
1223 Tables_in_test
1224 t5
1225 SHOW CREATE TABLE t5;
1226 Table Create Table
1227 t5 CREATE TABLE `t5` (
1228 `c2` varchar(5) DEFAULT NULL,
1229 `c1` double DEFAULT NULL
1230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1231 DROP TABLE t5;
1232 SHOW TABLES;
1233 Tables_in_test
1234 CREATE TABLE t5(c1 DOUBLE NULL);
1235 SHOW TABLES;
1236 Tables_in_test
1237 t5
1238 SHOW CREATE TABLE t5;
1239 Table Create Table
1240 t5 CREATE TABLE `t5` (
1241 `c1` double DEFAULT NULL
1242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1243 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1244 SHOW TABLES;
1245 Tables_in_test
1246 t5
1247 SHOW CREATE TABLE t5;
1248 Table Create Table
1249 t5 CREATE TABLE `t5` (
1250 `c2` varchar(5) DEFAULT NULL,
1251 `c1` double DEFAULT NULL
1252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1253 DROP TABLE t5;
1254 SHOW TABLES;
1255 Tables_in_test
1256 CREATE TABLE t5(c1 FLOAT NULL);
1257 SHOW TABLES;
1258 Tables_in_test
1259 t5
1260 SHOW CREATE TABLE t5;
1261 Table Create Table
1262 t5 CREATE TABLE `t5` (
1263 `c1` float DEFAULT NULL
1264 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1265 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1266 SHOW TABLES;
1267 Tables_in_test
1268 t5
1269 SHOW CREATE TABLE t5;
1270 Table Create Table
1271 t5 CREATE TABLE `t5` (
1272 `c2` varchar(5) DEFAULT NULL,
1273 `c1` float DEFAULT NULL
1274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1275 DROP TABLE t5;
1276 SHOW TABLES;
1277 Tables_in_test
1278 CREATE TABLE t5(c1 DECIMAL NULL);
1279 SHOW TABLES;
1280 Tables_in_test
1281 t5
1282 SHOW CREATE TABLE t5;
1283 Table Create Table
1284 t5 CREATE TABLE `t5` (
1285 `c1` decimal(10,0) DEFAULT NULL
1286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1287 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1288 SHOW TABLES;
1289 Tables_in_test
1290 t5
1291 SHOW CREATE TABLE t5;
1292 Table Create Table
1293 t5 CREATE TABLE `t5` (
1294 `c2` varchar(5) DEFAULT NULL,
1295 `c1` decimal(10,0) DEFAULT NULL
1296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1297 DROP TABLE t5;
1298 SHOW TABLES;
1299 Tables_in_test
1300 CREATE TABLE t5(c1 NUMERIC NULL);
1301 SHOW TABLES;
1302 Tables_in_test
1303 t5
1304 SHOW CREATE TABLE t5;
1305 Table Create Table
1306 t5 CREATE TABLE `t5` (
1307 `c1` decimal(10,0) DEFAULT NULL
1308 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1309 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1310 SHOW TABLES;
1311 Tables_in_test
1312 t5
1313 SHOW CREATE TABLE t5;
1314 Table Create Table
1315 t5 CREATE TABLE `t5` (
1316 `c2` varchar(5) DEFAULT NULL,
1317 `c1` decimal(10,0) DEFAULT NULL
1318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1319 DROP TABLE t5;
1320 SHOW TABLES;
1321 Tables_in_test
1322 CREATE TABLE t5(c1 DATE NULL);
1323 SHOW TABLES;
1324 Tables_in_test
1325 t5
1326 SHOW CREATE TABLE t5;
1327 Table Create Table
1328 t5 CREATE TABLE `t5` (
1329 `c1` date DEFAULT NULL
1330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1331 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1332 SHOW TABLES;
1333 Tables_in_test
1334 t5
1335 SHOW CREATE TABLE t5;
1336 Table Create Table
1337 t5 CREATE TABLE `t5` (
1338 `c2` varchar(5) DEFAULT NULL,
1339 `c1` date DEFAULT NULL
1340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1341 DROP TABLE t5;
1342 SHOW TABLES;
1343 Tables_in_test
1344 CREATE TABLE t5(c1 TIME NULL);
1345 SHOW TABLES;
1346 Tables_in_test
1347 t5
1348 SHOW CREATE TABLE t5;
1349 Table Create Table
1350 t5 CREATE TABLE `t5` (
1351 `c1` time DEFAULT NULL
1352 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1353 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1354 SHOW TABLES;
1355 Tables_in_test
1356 t5
1357 SHOW CREATE TABLE t5;
1358 Table Create Table
1359 t5 CREATE TABLE `t5` (
1360 `c2` varchar(5) DEFAULT NULL,
1361 `c1` time DEFAULT NULL
1362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1363 DROP TABLE t5;
1364 SHOW TABLES;
1365 Tables_in_test
1366 CREATE TABLE t5(c1 TIMESTAMP NULL);
1367 SHOW TABLES;
1368 Tables_in_test
1369 t5
1370 SHOW CREATE TABLE t5;
1371 Table Create Table
1372 t5 CREATE TABLE `t5` (
1373 `c1` timestamp NULL DEFAULT NULL
1374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1375 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1376 SHOW TABLES;
1377 Tables_in_test
1378 t5
1379 SHOW CREATE TABLE t5;
1380 Table Create Table
1381 t5 CREATE TABLE `t5` (
1382 `c2` varchar(5) DEFAULT NULL,
1383 `c1` timestamp NULL DEFAULT NULL
1384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1385 DROP TABLE t5;
1386 SHOW TABLES;
1387 Tables_in_test
1388 CREATE TABLE t5(c1 YEAR NULL);
1389 SHOW TABLES;
1390 Tables_in_test
1391 t5
1392 SHOW CREATE TABLE t5;
1393 Table Create Table
1394 t5 CREATE TABLE `t5` (
1395 `c1` year DEFAULT NULL
1396 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1397 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1398 SHOW TABLES;
1399 Tables_in_test
1400 t5
1401 SHOW CREATE TABLE t5;
1402 Table Create Table
1403 t5 CREATE TABLE `t5` (
1404 `c2` varchar(5) DEFAULT NULL,
1405 `c1` year DEFAULT NULL
1406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1407 DROP TABLE t5;
1408 SHOW TABLES;
1409 Tables_in_test
1410 CREATE TABLE t5(c1 TINYBLOB NULL);
1411 SHOW TABLES;
1412 Tables_in_test
1413 t5
1414 SHOW CREATE TABLE t5;
1415 Table Create Table
1416 t5 CREATE TABLE `t5` (
1417 `c1` tinyblob
1418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1419 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1420 SHOW TABLES;
1421 Tables_in_test
1422 t5
1423 SHOW CREATE TABLE t5;
1424 Table Create Table
1425 t5 CREATE TABLE `t5` (
1426 `c2` varchar(5) DEFAULT NULL,
1427 `c1` tinyblob
1428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1429 DROP TABLE t5;
1430 SHOW TABLES;
1431 Tables_in_test
1432 CREATE TABLE t5(c1 BLOB NULL);
1433 SHOW TABLES;
1434 Tables_in_test
1435 t5
1436 SHOW CREATE TABLE t5;
1437 Table Create Table
1438 t5 CREATE TABLE `t5` (
1439 `c1` blob
1440 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1441 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1442 SHOW TABLES;
1443 Tables_in_test
1444 t5
1445 SHOW CREATE TABLE t5;
1446 Table Create Table
1447 t5 CREATE TABLE `t5` (
1448 `c2` varchar(5) DEFAULT NULL,
1449 `c1` blob
1450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1451 DROP TABLE t5;
1452 SHOW TABLES;
1453 Tables_in_test
1454 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
1455 SHOW TABLES;
1456 Tables_in_test
1457 t5
1458 SHOW CREATE TABLE t5;
1459 Table Create Table
1460 t5 CREATE TABLE `t5` (
1461 `c1` mediumblob
1462 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1463 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1464 SHOW TABLES;
1465 Tables_in_test
1466 t5
1467 SHOW CREATE TABLE t5;
1468 Table Create Table
1469 t5 CREATE TABLE `t5` (
1470 `c2` varchar(5) DEFAULT NULL,
1471 `c1` mediumblob
1472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1473 DROP TABLE t5;
1474 SHOW TABLES;
1475 Tables_in_test
1476 CREATE TABLE t5(c1 LONGBLOB NULL);
1477 SHOW TABLES;
1478 Tables_in_test
1479 t5
1480 SHOW CREATE TABLE t5;
1481 Table Create Table
1482 t5 CREATE TABLE `t5` (
1483 `c1` longblob
1484 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1485 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1486 SHOW TABLES;
1487 Tables_in_test
1488 t5
1489 SHOW CREATE TABLE t5;
1490 Table Create Table
1491 t5 CREATE TABLE `t5` (
1492 `c2` varchar(5) DEFAULT NULL,
1493 `c1` longblob
1494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1495 DROP TABLE t5;
1496 SHOW TABLES;
1497 Tables_in_test
1498 CREATE TABLE t5(c1 TINYTEXT NULL);
1499 SHOW TABLES;
1500 Tables_in_test
1501 t5
1502 SHOW CREATE TABLE t5;
1503 Table Create Table
1504 t5 CREATE TABLE `t5` (
1505 `c1` tinytext
1506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1507 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1508 SHOW TABLES;
1509 Tables_in_test
1510 t5
1511 SHOW CREATE TABLE t5;
1512 Table Create Table
1513 t5 CREATE TABLE `t5` (
1514 `c2` varchar(5) DEFAULT NULL,
1515 `c1` tinytext
1516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1517 DROP TABLE t5;
1518 SHOW TABLES;
1519 Tables_in_test
1520 CREATE TABLE t5(c1 TEXT NULL);
1521 SHOW TABLES;
1522 Tables_in_test
1523 t5
1524 SHOW CREATE TABLE t5;
1525 Table Create Table
1526 t5 CREATE TABLE `t5` (
1527 `c1` text
1528 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1529 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1530 SHOW TABLES;
1531 Tables_in_test
1532 t5
1533 SHOW CREATE TABLE t5;
1534 Table Create Table
1535 t5 CREATE TABLE `t5` (
1536 `c2` varchar(5) DEFAULT NULL,
1537 `c1` text
1538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1539 DROP TABLE t5;
1540 SHOW TABLES;
1541 Tables_in_test
1542 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
1543 SHOW TABLES;
1544 Tables_in_test
1545 t5
1546 SHOW CREATE TABLE t5;
1547 Table Create Table
1548 t5 CREATE TABLE `t5` (
1549 `c1` mediumtext
1550 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1551 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1552 SHOW TABLES;
1553 Tables_in_test
1554 t5
1555 SHOW CREATE TABLE t5;
1556 Table Create Table
1557 t5 CREATE TABLE `t5` (
1558 `c2` varchar(5) DEFAULT NULL,
1559 `c1` mediumtext
1560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1561 DROP TABLE t5;
1562 SHOW TABLES;
1563 Tables_in_test
1564 CREATE TABLE t5(c1 LONGTEXT NULL);
1565 SHOW TABLES;
1566 Tables_in_test
1567 t5
1568 SHOW CREATE TABLE t5;
1569 Table Create Table
1570 t5 CREATE TABLE `t5` (
1571 `c1` longtext
1572 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1573 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST;
1574 SHOW TABLES;
1575 Tables_in_test
1576 t5
1577 SHOW CREATE TABLE t5;
1578 Table Create Table
1579 t5 CREATE TABLE `t5` (
1580 `c2` varchar(5) DEFAULT NULL,
1581 `c1` longtext
1582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1583 DROP TABLE t5;
1584 SHOW TABLES;
1585 Tables_in_test
1586 CREATE TABLE t5(c1 BIT NOT NULL);
1587 SHOW TABLES;
1588 Tables_in_test
1589 t5
1590 SHOW CREATE TABLE t5;
1591 Table Create Table
1592 t5 CREATE TABLE `t5` (
1593 `c1` bit(1) NOT NULL
1594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1595 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1596 SHOW TABLES;
1597 Tables_in_test
1598 t5
1599 SHOW CREATE TABLE t5;
1600 Table Create Table
1601 t5 CREATE TABLE `t5` (
1602 `c2` varchar(5) NOT NULL,
1603 `c1` bit(1) NOT NULL
1604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1605 DROP TABLE t5;
1606 SHOW TABLES;
1607 Tables_in_test
1608 CREATE TABLE t5(c1 TINYINT NOT NULL);
1609 SHOW TABLES;
1610 Tables_in_test
1611 t5
1612 SHOW CREATE TABLE t5;
1613 Table Create Table
1614 t5 CREATE TABLE `t5` (
1615 `c1` tinyint NOT NULL
1616 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1617 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1618 SHOW TABLES;
1619 Tables_in_test
1620 t5
1621 SHOW CREATE TABLE t5;
1622 Table Create Table
1623 t5 CREATE TABLE `t5` (
1624 `c2` varchar(5) NOT NULL,
1625 `c1` tinyint NOT NULL
1626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1627 DROP TABLE t5;
1628 SHOW TABLES;
1629 Tables_in_test
1630 CREATE TABLE t5(c1 SMALLINT NOT NULL);
1631 SHOW TABLES;
1632 Tables_in_test
1633 t5
1634 SHOW CREATE TABLE t5;
1635 Table Create Table
1636 t5 CREATE TABLE `t5` (
1637 `c1` smallint NOT NULL
1638 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1639 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1640 SHOW TABLES;
1641 Tables_in_test
1642 t5
1643 SHOW CREATE TABLE t5;
1644 Table Create Table
1645 t5 CREATE TABLE `t5` (
1646 `c2` varchar(5) NOT NULL,
1647 `c1` smallint NOT NULL
1648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1649 DROP TABLE t5;
1650 SHOW TABLES;
1651 Tables_in_test
1652 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
1653 SHOW TABLES;
1654 Tables_in_test
1655 t5
1656 SHOW CREATE TABLE t5;
1657 Table Create Table
1658 t5 CREATE TABLE `t5` (
1659 `c1` mediumint NOT NULL
1660 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1661 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1662 SHOW TABLES;
1663 Tables_in_test
1664 t5
1665 SHOW CREATE TABLE t5;
1666 Table Create Table
1667 t5 CREATE TABLE `t5` (
1668 `c2` varchar(5) NOT NULL,
1669 `c1` mediumint NOT NULL
1670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1671 DROP TABLE t5;
1672 SHOW TABLES;
1673 Tables_in_test
1674 CREATE TABLE t5(c1 INT NOT NULL);
1675 SHOW TABLES;
1676 Tables_in_test
1677 t5
1678 SHOW CREATE TABLE t5;
1679 Table Create Table
1680 t5 CREATE TABLE `t5` (
1681 `c1` int NOT NULL
1682 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1683 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1684 SHOW TABLES;
1685 Tables_in_test
1686 t5
1687 SHOW CREATE TABLE t5;
1688 Table Create Table
1689 t5 CREATE TABLE `t5` (
1690 `c2` varchar(5) NOT NULL,
1691 `c1` int NOT NULL
1692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1693 DROP TABLE t5;
1694 SHOW TABLES;
1695 Tables_in_test
1696 CREATE TABLE t5(c1 INTEGER NOT NULL);
1697 SHOW TABLES;
1698 Tables_in_test
1699 t5
1700 SHOW CREATE TABLE t5;
1701 Table Create Table
1702 t5 CREATE TABLE `t5` (
1703 `c1` int NOT NULL
1704 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1705 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1706 SHOW TABLES;
1707 Tables_in_test
1708 t5
1709 SHOW CREATE TABLE t5;
1710 Table Create Table
1711 t5 CREATE TABLE `t5` (
1712 `c2` varchar(5) NOT NULL,
1713 `c1` int NOT NULL
1714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1715 DROP TABLE t5;
1716 SHOW TABLES;
1717 Tables_in_test
1718 CREATE TABLE t5(c1 BIGINT NOT NULL);
1719 SHOW TABLES;
1720 Tables_in_test
1721 t5
1722 SHOW CREATE TABLE t5;
1723 Table Create Table
1724 t5 CREATE TABLE `t5` (
1725 `c1` bigint NOT NULL
1726 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1727 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1728 SHOW TABLES;
1729 Tables_in_test
1730 t5
1731 SHOW CREATE TABLE t5;
1732 Table Create Table
1733 t5 CREATE TABLE `t5` (
1734 `c2` varchar(5) NOT NULL,
1735 `c1` bigint NOT NULL
1736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1737 DROP TABLE t5;
1738 SHOW TABLES;
1739 Tables_in_test
1740 CREATE TABLE t5(c1 REAL NOT NULL);
1741 SHOW TABLES;
1742 Tables_in_test
1743 t5
1744 SHOW CREATE TABLE t5;
1745 Table Create Table
1746 t5 CREATE TABLE `t5` (
1747 `c1` double NOT NULL
1748 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1749 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1750 SHOW TABLES;
1751 Tables_in_test
1752 t5
1753 SHOW CREATE TABLE t5;
1754 Table Create Table
1755 t5 CREATE TABLE `t5` (
1756 `c2` varchar(5) NOT NULL,
1757 `c1` double NOT NULL
1758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1759 DROP TABLE t5;
1760 SHOW TABLES;
1761 Tables_in_test
1762 CREATE TABLE t5(c1 DOUBLE NOT NULL);
1763 SHOW TABLES;
1764 Tables_in_test
1765 t5
1766 SHOW CREATE TABLE t5;
1767 Table Create Table
1768 t5 CREATE TABLE `t5` (
1769 `c1` double NOT NULL
1770 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1771 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1772 SHOW TABLES;
1773 Tables_in_test
1774 t5
1775 SHOW CREATE TABLE t5;
1776 Table Create Table
1777 t5 CREATE TABLE `t5` (
1778 `c2` varchar(5) NOT NULL,
1779 `c1` double NOT NULL
1780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1781 DROP TABLE t5;
1782 SHOW TABLES;
1783 Tables_in_test
1784 CREATE TABLE t5(c1 FLOAT NOT NULL);
1785 SHOW TABLES;
1786 Tables_in_test
1787 t5
1788 SHOW CREATE TABLE t5;
1789 Table Create Table
1790 t5 CREATE TABLE `t5` (
1791 `c1` float NOT NULL
1792 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1793 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1794 SHOW TABLES;
1795 Tables_in_test
1796 t5
1797 SHOW CREATE TABLE t5;
1798 Table Create Table
1799 t5 CREATE TABLE `t5` (
1800 `c2` varchar(5) NOT NULL,
1801 `c1` float NOT NULL
1802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1803 DROP TABLE t5;
1804 SHOW TABLES;
1805 Tables_in_test
1806 CREATE TABLE t5(c1 DECIMAL NOT NULL);
1807 SHOW TABLES;
1808 Tables_in_test
1809 t5
1810 SHOW CREATE TABLE t5;
1811 Table Create Table
1812 t5 CREATE TABLE `t5` (
1813 `c1` decimal(10,0) NOT NULL
1814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1815 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1816 SHOW TABLES;
1817 Tables_in_test
1818 t5
1819 SHOW CREATE TABLE t5;
1820 Table Create Table
1821 t5 CREATE TABLE `t5` (
1822 `c2` varchar(5) NOT NULL,
1823 `c1` decimal(10,0) NOT NULL
1824 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1825 DROP TABLE t5;
1826 SHOW TABLES;
1827 Tables_in_test
1828 CREATE TABLE t5(c1 NUMERIC NOT NULL);
1829 SHOW TABLES;
1830 Tables_in_test
1831 t5
1832 SHOW CREATE TABLE t5;
1833 Table Create Table
1834 t5 CREATE TABLE `t5` (
1835 `c1` decimal(10,0) NOT NULL
1836 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1837 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1838 SHOW TABLES;
1839 Tables_in_test
1840 t5
1841 SHOW CREATE TABLE t5;
1842 Table Create Table
1843 t5 CREATE TABLE `t5` (
1844 `c2` varchar(5) NOT NULL,
1845 `c1` decimal(10,0) NOT NULL
1846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1847 DROP TABLE t5;
1848 SHOW TABLES;
1849 Tables_in_test
1850 CREATE TABLE t5(c1 DATE NOT NULL);
1851 SHOW TABLES;
1852 Tables_in_test
1853 t5
1854 SHOW CREATE TABLE t5;
1855 Table Create Table
1856 t5 CREATE TABLE `t5` (
1857 `c1` date NOT NULL
1858 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1859 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1860 SHOW TABLES;
1861 Tables_in_test
1862 t5
1863 SHOW CREATE TABLE t5;
1864 Table Create Table
1865 t5 CREATE TABLE `t5` (
1866 `c2` varchar(5) NOT NULL,
1867 `c1` date NOT NULL
1868 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1869 DROP TABLE t5;
1870 SHOW TABLES;
1871 Tables_in_test
1872 CREATE TABLE t5(c1 TIME NOT NULL);
1873 SHOW TABLES;
1874 Tables_in_test
1875 t5
1876 SHOW CREATE TABLE t5;
1877 Table Create Table
1878 t5 CREATE TABLE `t5` (
1879 `c1` time NOT NULL
1880 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1881 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1882 SHOW TABLES;
1883 Tables_in_test
1884 t5
1885 SHOW CREATE TABLE t5;
1886 Table Create Table
1887 t5 CREATE TABLE `t5` (
1888 `c2` varchar(5) NOT NULL,
1889 `c1` time NOT NULL
1890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1891 DROP TABLE t5;
1892 SHOW TABLES;
1893 Tables_in_test
1894 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
1895 SHOW TABLES;
1896 Tables_in_test
1897 t5
1898 SHOW CREATE TABLE t5;
1899 Table Create Table
1900 t5 CREATE TABLE `t5` (
1901 `c1` timestamp NOT NULL
1902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1903 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1904 SHOW TABLES;
1905 Tables_in_test
1906 t5
1907 SHOW CREATE TABLE t5;
1908 Table Create Table
1909 t5 CREATE TABLE `t5` (
1910 `c2` varchar(5) NOT NULL,
1911 `c1` timestamp NOT NULL
1912 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1913 DROP TABLE t5;
1914 SHOW TABLES;
1915 Tables_in_test
1916 CREATE TABLE t5(c1 YEAR NOT NULL);
1917 SHOW TABLES;
1918 Tables_in_test
1919 t5
1920 SHOW CREATE TABLE t5;
1921 Table Create Table
1922 t5 CREATE TABLE `t5` (
1923 `c1` year NOT NULL
1924 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1925 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1926 SHOW TABLES;
1927 Tables_in_test
1928 t5
1929 SHOW CREATE TABLE t5;
1930 Table Create Table
1931 t5 CREATE TABLE `t5` (
1932 `c2` varchar(5) NOT NULL,
1933 `c1` year NOT NULL
1934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1935 DROP TABLE t5;
1936 SHOW TABLES;
1937 Tables_in_test
1938 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
1939 SHOW TABLES;
1940 Tables_in_test
1941 t5
1942 SHOW CREATE TABLE t5;
1943 Table Create Table
1944 t5 CREATE TABLE `t5` (
1945 `c1` tinyblob NOT NULL
1946 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1947 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1948 SHOW TABLES;
1949 Tables_in_test
1950 t5
1951 SHOW CREATE TABLE t5;
1952 Table Create Table
1953 t5 CREATE TABLE `t5` (
1954 `c2` varchar(5) NOT NULL,
1955 `c1` tinyblob NOT NULL
1956 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1957 DROP TABLE t5;
1958 SHOW TABLES;
1959 Tables_in_test
1960 CREATE TABLE t5(c1 BLOB NOT NULL);
1961 SHOW TABLES;
1962 Tables_in_test
1963 t5
1964 SHOW CREATE TABLE t5;
1965 Table Create Table
1966 t5 CREATE TABLE `t5` (
1967 `c1` blob NOT NULL
1968 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1969 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1970 SHOW TABLES;
1971 Tables_in_test
1972 t5
1973 SHOW CREATE TABLE t5;
1974 Table Create Table
1975 t5 CREATE TABLE `t5` (
1976 `c2` varchar(5) NOT NULL,
1977 `c1` blob NOT NULL
1978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1979 DROP TABLE t5;
1980 SHOW TABLES;
1981 Tables_in_test
1982 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
1983 SHOW TABLES;
1984 Tables_in_test
1985 t5
1986 SHOW CREATE TABLE t5;
1987 Table Create Table
1988 t5 CREATE TABLE `t5` (
1989 `c1` mediumblob NOT NULL
1990 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1991 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
1992 SHOW TABLES;
1993 Tables_in_test
1994 t5
1995 SHOW CREATE TABLE t5;
1996 Table Create Table
1997 t5 CREATE TABLE `t5` (
1998 `c2` varchar(5) NOT NULL,
1999 `c1` mediumblob NOT NULL
2000 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2001 DROP TABLE t5;
2002 SHOW TABLES;
2003 Tables_in_test
2004 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
2005 SHOW TABLES;
2006 Tables_in_test
2007 t5
2008 SHOW CREATE TABLE t5;
2009 Table Create Table
2010 t5 CREATE TABLE `t5` (
2011 `c1` longblob NOT NULL
2012 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2013 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
2014 SHOW TABLES;
2015 Tables_in_test
2016 t5
2017 SHOW CREATE TABLE t5;
2018 Table Create Table
2019 t5 CREATE TABLE `t5` (
2020 `c2` varchar(5) NOT NULL,
2021 `c1` longblob NOT NULL
2022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2023 DROP TABLE t5;
2024 SHOW TABLES;
2025 Tables_in_test
2026 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
2027 SHOW TABLES;
2028 Tables_in_test
2029 t5
2030 SHOW CREATE TABLE t5;
2031 Table Create Table
2032 t5 CREATE TABLE `t5` (
2033 `c1` tinytext NOT NULL
2034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2035 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
2036 SHOW TABLES;
2037 Tables_in_test
2038 t5
2039 SHOW CREATE TABLE t5;
2040 Table Create Table
2041 t5 CREATE TABLE `t5` (
2042 `c2` varchar(5) NOT NULL,
2043 `c1` tinytext NOT NULL
2044 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2045 DROP TABLE t5;
2046 SHOW TABLES;
2047 Tables_in_test
2048 CREATE TABLE t5(c1 TEXT NOT NULL);
2049 SHOW TABLES;
2050 Tables_in_test
2051 t5
2052 SHOW CREATE TABLE t5;
2053 Table Create Table
2054 t5 CREATE TABLE `t5` (
2055 `c1` text NOT NULL
2056 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2057 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
2058 SHOW TABLES;
2059 Tables_in_test
2060 t5
2061 SHOW CREATE TABLE t5;
2062 Table Create Table
2063 t5 CREATE TABLE `t5` (
2064 `c2` varchar(5) NOT NULL,
2065 `c1` text NOT NULL
2066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2067 DROP TABLE t5;
2068 SHOW TABLES;
2069 Tables_in_test
2070 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
2071 SHOW TABLES;
2072 Tables_in_test
2073 t5
2074 SHOW CREATE TABLE t5;
2075 Table Create Table
2076 t5 CREATE TABLE `t5` (
2077 `c1` mediumtext NOT NULL
2078 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2079 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
2080 SHOW TABLES;
2081 Tables_in_test
2082 t5
2083 SHOW CREATE TABLE t5;
2084 Table Create Table
2085 t5 CREATE TABLE `t5` (
2086 `c2` varchar(5) NOT NULL,
2087 `c1` mediumtext NOT NULL
2088 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2089 DROP TABLE t5;
2090 SHOW TABLES;
2091 Tables_in_test
2092 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
2093 SHOW TABLES;
2094 Tables_in_test
2095 t5
2096 SHOW CREATE TABLE t5;
2097 Table Create Table
2098 t5 CREATE TABLE `t5` (
2099 `c1` longtext NOT NULL
2100 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2101 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST;
2102 SHOW TABLES;
2103 Tables_in_test
2104 t5
2105 SHOW CREATE TABLE t5;
2106 Table Create Table
2107 t5 CREATE TABLE `t5` (
2108 `c2` varchar(5) NOT NULL,
2109 `c1` longtext NOT NULL
2110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2111 DROP TABLE t5;
2112 SHOW TABLES;
2113 Tables_in_test
2114 CREATE TABLE t5(c1 BIT NULL);
2115 SHOW TABLES;
2116 Tables_in_test
2117 t5
2118 SHOW CREATE TABLE t5;
2119 Table Create Table
2120 t5 CREATE TABLE `t5` (
2121 `c1` bit(1) DEFAULT NULL
2122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2123 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2124 SHOW TABLES;
2125 Tables_in_test
2126 t5
2127 SHOW CREATE TABLE t5;
2128 Table Create Table
2129 t5 CREATE TABLE `t5` (
2130 `c2` binary(5) DEFAULT NULL,
2131 `c1` bit(1) DEFAULT NULL
2132 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2133 DROP TABLE t5;
2134 SHOW TABLES;
2135 Tables_in_test
2136 CREATE TABLE t5(c1 TINYINT NULL);
2137 SHOW TABLES;
2138 Tables_in_test
2139 t5
2140 SHOW CREATE TABLE t5;
2141 Table Create Table
2142 t5 CREATE TABLE `t5` (
2143 `c1` tinyint DEFAULT NULL
2144 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2145 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2146 SHOW TABLES;
2147 Tables_in_test
2148 t5
2149 SHOW CREATE TABLE t5;
2150 Table Create Table
2151 t5 CREATE TABLE `t5` (
2152 `c2` binary(5) DEFAULT NULL,
2153 `c1` tinyint DEFAULT NULL
2154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2155 DROP TABLE t5;
2156 SHOW TABLES;
2157 Tables_in_test
2158 CREATE TABLE t5(c1 SMALLINT NULL);
2159 SHOW TABLES;
2160 Tables_in_test
2161 t5
2162 SHOW CREATE TABLE t5;
2163 Table Create Table
2164 t5 CREATE TABLE `t5` (
2165 `c1` smallint DEFAULT NULL
2166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2167 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2168 SHOW TABLES;
2169 Tables_in_test
2170 t5
2171 SHOW CREATE TABLE t5;
2172 Table Create Table
2173 t5 CREATE TABLE `t5` (
2174 `c2` binary(5) DEFAULT NULL,
2175 `c1` smallint DEFAULT NULL
2176 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2177 DROP TABLE t5;
2178 SHOW TABLES;
2179 Tables_in_test
2180 CREATE TABLE t5(c1 MEDIUMINT NULL);
2181 SHOW TABLES;
2182 Tables_in_test
2183 t5
2184 SHOW CREATE TABLE t5;
2185 Table Create Table
2186 t5 CREATE TABLE `t5` (
2187 `c1` mediumint DEFAULT NULL
2188 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2189 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2190 SHOW TABLES;
2191 Tables_in_test
2192 t5
2193 SHOW CREATE TABLE t5;
2194 Table Create Table
2195 t5 CREATE TABLE `t5` (
2196 `c2` binary(5) DEFAULT NULL,
2197 `c1` mediumint DEFAULT NULL
2198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2199 DROP TABLE t5;
2200 SHOW TABLES;
2201 Tables_in_test
2202 CREATE TABLE t5(c1 INT NULL);
2203 SHOW TABLES;
2204 Tables_in_test
2205 t5
2206 SHOW CREATE TABLE t5;
2207 Table Create Table
2208 t5 CREATE TABLE `t5` (
2209 `c1` int DEFAULT NULL
2210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2211 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2212 SHOW TABLES;
2213 Tables_in_test
2214 t5
2215 SHOW CREATE TABLE t5;
2216 Table Create Table
2217 t5 CREATE TABLE `t5` (
2218 `c2` binary(5) DEFAULT NULL,
2219 `c1` int DEFAULT NULL
2220 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2221 DROP TABLE t5;
2222 SHOW TABLES;
2223 Tables_in_test
2224 CREATE TABLE t5(c1 INTEGER NULL);
2225 SHOW TABLES;
2226 Tables_in_test
2227 t5
2228 SHOW CREATE TABLE t5;
2229 Table Create Table
2230 t5 CREATE TABLE `t5` (
2231 `c1` int DEFAULT NULL
2232 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2233 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2234 SHOW TABLES;
2235 Tables_in_test
2236 t5
2237 SHOW CREATE TABLE t5;
2238 Table Create Table
2239 t5 CREATE TABLE `t5` (
2240 `c2` binary(5) DEFAULT NULL,
2241 `c1` int DEFAULT NULL
2242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2243 DROP TABLE t5;
2244 SHOW TABLES;
2245 Tables_in_test
2246 CREATE TABLE t5(c1 BIGINT NULL);
2247 SHOW TABLES;
2248 Tables_in_test
2249 t5
2250 SHOW CREATE TABLE t5;
2251 Table Create Table
2252 t5 CREATE TABLE `t5` (
2253 `c1` bigint DEFAULT NULL
2254 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2255 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2256 SHOW TABLES;
2257 Tables_in_test
2258 t5
2259 SHOW CREATE TABLE t5;
2260 Table Create Table
2261 t5 CREATE TABLE `t5` (
2262 `c2` binary(5) DEFAULT NULL,
2263 `c1` bigint DEFAULT NULL
2264 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2265 DROP TABLE t5;
2266 SHOW TABLES;
2267 Tables_in_test
2268 CREATE TABLE t5(c1 REAL NULL);
2269 SHOW TABLES;
2270 Tables_in_test
2271 t5
2272 SHOW CREATE TABLE t5;
2273 Table Create Table
2274 t5 CREATE TABLE `t5` (
2275 `c1` double DEFAULT NULL
2276 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2277 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2278 SHOW TABLES;
2279 Tables_in_test
2280 t5
2281 SHOW CREATE TABLE t5;
2282 Table Create Table
2283 t5 CREATE TABLE `t5` (
2284 `c2` binary(5) DEFAULT NULL,
2285 `c1` double DEFAULT NULL
2286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2287 DROP TABLE t5;
2288 SHOW TABLES;
2289 Tables_in_test
2290 CREATE TABLE t5(c1 DOUBLE NULL);
2291 SHOW TABLES;
2292 Tables_in_test
2293 t5
2294 SHOW CREATE TABLE t5;
2295 Table Create Table
2296 t5 CREATE TABLE `t5` (
2297 `c1` double DEFAULT NULL
2298 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2299 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2300 SHOW TABLES;
2301 Tables_in_test
2302 t5
2303 SHOW CREATE TABLE t5;
2304 Table Create Table
2305 t5 CREATE TABLE `t5` (
2306 `c2` binary(5) DEFAULT NULL,
2307 `c1` double DEFAULT NULL
2308 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2309 DROP TABLE t5;
2310 SHOW TABLES;
2311 Tables_in_test
2312 CREATE TABLE t5(c1 FLOAT NULL);
2313 SHOW TABLES;
2314 Tables_in_test
2315 t5
2316 SHOW CREATE TABLE t5;
2317 Table Create Table
2318 t5 CREATE TABLE `t5` (
2319 `c1` float DEFAULT NULL
2320 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2321 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2322 SHOW TABLES;
2323 Tables_in_test
2324 t5
2325 SHOW CREATE TABLE t5;
2326 Table Create Table
2327 t5 CREATE TABLE `t5` (
2328 `c2` binary(5) DEFAULT NULL,
2329 `c1` float DEFAULT NULL
2330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2331 DROP TABLE t5;
2332 SHOW TABLES;
2333 Tables_in_test
2334 CREATE TABLE t5(c1 DECIMAL NULL);
2335 SHOW TABLES;
2336 Tables_in_test
2337 t5
2338 SHOW CREATE TABLE t5;
2339 Table Create Table
2340 t5 CREATE TABLE `t5` (
2341 `c1` decimal(10,0) DEFAULT NULL
2342 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2343 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2344 SHOW TABLES;
2345 Tables_in_test
2346 t5
2347 SHOW CREATE TABLE t5;
2348 Table Create Table
2349 t5 CREATE TABLE `t5` (
2350 `c2` binary(5) DEFAULT NULL,
2351 `c1` decimal(10,0) DEFAULT NULL
2352 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2353 DROP TABLE t5;
2354 SHOW TABLES;
2355 Tables_in_test
2356 CREATE TABLE t5(c1 NUMERIC NULL);
2357 SHOW TABLES;
2358 Tables_in_test
2359 t5
2360 SHOW CREATE TABLE t5;
2361 Table Create Table
2362 t5 CREATE TABLE `t5` (
2363 `c1` decimal(10,0) DEFAULT NULL
2364 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2365 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2366 SHOW TABLES;
2367 Tables_in_test
2368 t5
2369 SHOW CREATE TABLE t5;
2370 Table Create Table
2371 t5 CREATE TABLE `t5` (
2372 `c2` binary(5) DEFAULT NULL,
2373 `c1` decimal(10,0) DEFAULT NULL
2374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2375 DROP TABLE t5;
2376 SHOW TABLES;
2377 Tables_in_test
2378 CREATE TABLE t5(c1 DATE NULL);
2379 SHOW TABLES;
2380 Tables_in_test
2381 t5
2382 SHOW CREATE TABLE t5;
2383 Table Create Table
2384 t5 CREATE TABLE `t5` (
2385 `c1` date DEFAULT NULL
2386 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2387 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2388 SHOW TABLES;
2389 Tables_in_test
2390 t5
2391 SHOW CREATE TABLE t5;
2392 Table Create Table
2393 t5 CREATE TABLE `t5` (
2394 `c2` binary(5) DEFAULT NULL,
2395 `c1` date DEFAULT NULL
2396 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2397 DROP TABLE t5;
2398 SHOW TABLES;
2399 Tables_in_test
2400 CREATE TABLE t5(c1 TIME NULL);
2401 SHOW TABLES;
2402 Tables_in_test
2403 t5
2404 SHOW CREATE TABLE t5;
2405 Table Create Table
2406 t5 CREATE TABLE `t5` (
2407 `c1` time DEFAULT NULL
2408 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2409 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2410 SHOW TABLES;
2411 Tables_in_test
2412 t5
2413 SHOW CREATE TABLE t5;
2414 Table Create Table
2415 t5 CREATE TABLE `t5` (
2416 `c2` binary(5) DEFAULT NULL,
2417 `c1` time DEFAULT NULL
2418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2419 DROP TABLE t5;
2420 SHOW TABLES;
2421 Tables_in_test
2422 CREATE TABLE t5(c1 TIMESTAMP NULL);
2423 SHOW TABLES;
2424 Tables_in_test
2425 t5
2426 SHOW CREATE TABLE t5;
2427 Table Create Table
2428 t5 CREATE TABLE `t5` (
2429 `c1` timestamp NULL DEFAULT NULL
2430 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2431 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2432 SHOW TABLES;
2433 Tables_in_test
2434 t5
2435 SHOW CREATE TABLE t5;
2436 Table Create Table
2437 t5 CREATE TABLE `t5` (
2438 `c2` binary(5) DEFAULT NULL,
2439 `c1` timestamp NULL DEFAULT NULL
2440 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2441 DROP TABLE t5;
2442 SHOW TABLES;
2443 Tables_in_test
2444 CREATE TABLE t5(c1 YEAR NULL);
2445 SHOW TABLES;
2446 Tables_in_test
2447 t5
2448 SHOW CREATE TABLE t5;
2449 Table Create Table
2450 t5 CREATE TABLE `t5` (
2451 `c1` year DEFAULT NULL
2452 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2453 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2454 SHOW TABLES;
2455 Tables_in_test
2456 t5
2457 SHOW CREATE TABLE t5;
2458 Table Create Table
2459 t5 CREATE TABLE `t5` (
2460 `c2` binary(5) DEFAULT NULL,
2461 `c1` year DEFAULT NULL
2462 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2463 DROP TABLE t5;
2464 SHOW TABLES;
2465 Tables_in_test
2466 CREATE TABLE t5(c1 TINYBLOB NULL);
2467 SHOW TABLES;
2468 Tables_in_test
2469 t5
2470 SHOW CREATE TABLE t5;
2471 Table Create Table
2472 t5 CREATE TABLE `t5` (
2473 `c1` tinyblob
2474 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2475 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2476 SHOW TABLES;
2477 Tables_in_test
2478 t5
2479 SHOW CREATE TABLE t5;
2480 Table Create Table
2481 t5 CREATE TABLE `t5` (
2482 `c2` binary(5) DEFAULT NULL,
2483 `c1` tinyblob
2484 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2485 DROP TABLE t5;
2486 SHOW TABLES;
2487 Tables_in_test
2488 CREATE TABLE t5(c1 BLOB NULL);
2489 SHOW TABLES;
2490 Tables_in_test
2491 t5
2492 SHOW CREATE TABLE t5;
2493 Table Create Table
2494 t5 CREATE TABLE `t5` (
2495 `c1` blob
2496 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2497 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2498 SHOW TABLES;
2499 Tables_in_test
2500 t5
2501 SHOW CREATE TABLE t5;
2502 Table Create Table
2503 t5 CREATE TABLE `t5` (
2504 `c2` binary(5) DEFAULT NULL,
2505 `c1` blob
2506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2507 DROP TABLE t5;
2508 SHOW TABLES;
2509 Tables_in_test
2510 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
2511 SHOW TABLES;
2512 Tables_in_test
2513 t5
2514 SHOW CREATE TABLE t5;
2515 Table Create Table
2516 t5 CREATE TABLE `t5` (
2517 `c1` mediumblob
2518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2519 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2520 SHOW TABLES;
2521 Tables_in_test
2522 t5
2523 SHOW CREATE TABLE t5;
2524 Table Create Table
2525 t5 CREATE TABLE `t5` (
2526 `c2` binary(5) DEFAULT NULL,
2527 `c1` mediumblob
2528 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2529 DROP TABLE t5;
2530 SHOW TABLES;
2531 Tables_in_test
2532 CREATE TABLE t5(c1 LONGBLOB NULL);
2533 SHOW TABLES;
2534 Tables_in_test
2535 t5
2536 SHOW CREATE TABLE t5;
2537 Table Create Table
2538 t5 CREATE TABLE `t5` (
2539 `c1` longblob
2540 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2541 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2542 SHOW TABLES;
2543 Tables_in_test
2544 t5
2545 SHOW CREATE TABLE t5;
2546 Table Create Table
2547 t5 CREATE TABLE `t5` (
2548 `c2` binary(5) DEFAULT NULL,
2549 `c1` longblob
2550 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2551 DROP TABLE t5;
2552 SHOW TABLES;
2553 Tables_in_test
2554 CREATE TABLE t5(c1 TINYTEXT NULL);
2555 SHOW TABLES;
2556 Tables_in_test
2557 t5
2558 SHOW CREATE TABLE t5;
2559 Table Create Table
2560 t5 CREATE TABLE `t5` (
2561 `c1` tinytext
2562 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2563 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2564 SHOW TABLES;
2565 Tables_in_test
2566 t5
2567 SHOW CREATE TABLE t5;
2568 Table Create Table
2569 t5 CREATE TABLE `t5` (
2570 `c2` binary(5) DEFAULT NULL,
2571 `c1` tinytext
2572 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2573 DROP TABLE t5;
2574 SHOW TABLES;
2575 Tables_in_test
2576 CREATE TABLE t5(c1 TEXT NULL);
2577 SHOW TABLES;
2578 Tables_in_test
2579 t5
2580 SHOW CREATE TABLE t5;
2581 Table Create Table
2582 t5 CREATE TABLE `t5` (
2583 `c1` text
2584 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2585 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2586 SHOW TABLES;
2587 Tables_in_test
2588 t5
2589 SHOW CREATE TABLE t5;
2590 Table Create Table
2591 t5 CREATE TABLE `t5` (
2592 `c2` binary(5) DEFAULT NULL,
2593 `c1` text
2594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2595 DROP TABLE t5;
2596 SHOW TABLES;
2597 Tables_in_test
2598 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
2599 SHOW TABLES;
2600 Tables_in_test
2601 t5
2602 SHOW CREATE TABLE t5;
2603 Table Create Table
2604 t5 CREATE TABLE `t5` (
2605 `c1` mediumtext
2606 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2607 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2608 SHOW TABLES;
2609 Tables_in_test
2610 t5
2611 SHOW CREATE TABLE t5;
2612 Table Create Table
2613 t5 CREATE TABLE `t5` (
2614 `c2` binary(5) DEFAULT NULL,
2615 `c1` mediumtext
2616 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2617 DROP TABLE t5;
2618 SHOW TABLES;
2619 Tables_in_test
2620 CREATE TABLE t5(c1 LONGTEXT NULL);
2621 SHOW TABLES;
2622 Tables_in_test
2623 t5
2624 SHOW CREATE TABLE t5;
2625 Table Create Table
2626 t5 CREATE TABLE `t5` (
2627 `c1` longtext
2628 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2629 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST;
2630 SHOW TABLES;
2631 Tables_in_test
2632 t5
2633 SHOW CREATE TABLE t5;
2634 Table Create Table
2635 t5 CREATE TABLE `t5` (
2636 `c2` binary(5) DEFAULT NULL,
2637 `c1` longtext
2638 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2639 DROP TABLE t5;
2640 SHOW TABLES;
2641 Tables_in_test
2642 CREATE TABLE t5(c1 BIT NOT NULL);
2643 SHOW TABLES;
2644 Tables_in_test
2645 t5
2646 SHOW CREATE TABLE t5;
2647 Table Create Table
2648 t5 CREATE TABLE `t5` (
2649 `c1` bit(1) NOT NULL
2650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2651 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2652 SHOW TABLES;
2653 Tables_in_test
2654 t5
2655 SHOW CREATE TABLE t5;
2656 Table Create Table
2657 t5 CREATE TABLE `t5` (
2658 `c2` binary(5) NOT NULL,
2659 `c1` bit(1) NOT NULL
2660 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2661 DROP TABLE t5;
2662 SHOW TABLES;
2663 Tables_in_test
2664 CREATE TABLE t5(c1 TINYINT NOT NULL);
2665 SHOW TABLES;
2666 Tables_in_test
2667 t5
2668 SHOW CREATE TABLE t5;
2669 Table Create Table
2670 t5 CREATE TABLE `t5` (
2671 `c1` tinyint NOT NULL
2672 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2673 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2674 SHOW TABLES;
2675 Tables_in_test
2676 t5
2677 SHOW CREATE TABLE t5;
2678 Table Create Table
2679 t5 CREATE TABLE `t5` (
2680 `c2` binary(5) NOT NULL,
2681 `c1` tinyint NOT NULL
2682 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2683 DROP TABLE t5;
2684 SHOW TABLES;
2685 Tables_in_test
2686 CREATE TABLE t5(c1 SMALLINT NOT NULL);
2687 SHOW TABLES;
2688 Tables_in_test
2689 t5
2690 SHOW CREATE TABLE t5;
2691 Table Create Table
2692 t5 CREATE TABLE `t5` (
2693 `c1` smallint NOT NULL
2694 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2695 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2696 SHOW TABLES;
2697 Tables_in_test
2698 t5
2699 SHOW CREATE TABLE t5;
2700 Table Create Table
2701 t5 CREATE TABLE `t5` (
2702 `c2` binary(5) NOT NULL,
2703 `c1` smallint NOT NULL
2704 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2705 DROP TABLE t5;
2706 SHOW TABLES;
2707 Tables_in_test
2708 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
2709 SHOW TABLES;
2710 Tables_in_test
2711 t5
2712 SHOW CREATE TABLE t5;
2713 Table Create Table
2714 t5 CREATE TABLE `t5` (
2715 `c1` mediumint NOT NULL
2716 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2717 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2718 SHOW TABLES;
2719 Tables_in_test
2720 t5
2721 SHOW CREATE TABLE t5;
2722 Table Create Table
2723 t5 CREATE TABLE `t5` (
2724 `c2` binary(5) NOT NULL,
2725 `c1` mediumint NOT NULL
2726 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2727 DROP TABLE t5;
2728 SHOW TABLES;
2729 Tables_in_test
2730 CREATE TABLE t5(c1 INT NOT NULL);
2731 SHOW TABLES;
2732 Tables_in_test
2733 t5
2734 SHOW CREATE TABLE t5;
2735 Table Create Table
2736 t5 CREATE TABLE `t5` (
2737 `c1` int NOT NULL
2738 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2739 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2740 SHOW TABLES;
2741 Tables_in_test
2742 t5
2743 SHOW CREATE TABLE t5;
2744 Table Create Table
2745 t5 CREATE TABLE `t5` (
2746 `c2` binary(5) NOT NULL,
2747 `c1` int NOT NULL
2748 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2749 DROP TABLE t5;
2750 SHOW TABLES;
2751 Tables_in_test
2752 CREATE TABLE t5(c1 INTEGER NOT NULL);
2753 SHOW TABLES;
2754 Tables_in_test
2755 t5
2756 SHOW CREATE TABLE t5;
2757 Table Create Table
2758 t5 CREATE TABLE `t5` (
2759 `c1` int NOT NULL
2760 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2761 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2762 SHOW TABLES;
2763 Tables_in_test
2764 t5
2765 SHOW CREATE TABLE t5;
2766 Table Create Table
2767 t5 CREATE TABLE `t5` (
2768 `c2` binary(5) NOT NULL,
2769 `c1` int NOT NULL
2770 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2771 DROP TABLE t5;
2772 SHOW TABLES;
2773 Tables_in_test
2774 CREATE TABLE t5(c1 BIGINT NOT NULL);
2775 SHOW TABLES;
2776 Tables_in_test
2777 t5
2778 SHOW CREATE TABLE t5;
2779 Table Create Table
2780 t5 CREATE TABLE `t5` (
2781 `c1` bigint NOT NULL
2782 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2783 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2784 SHOW TABLES;
2785 Tables_in_test
2786 t5
2787 SHOW CREATE TABLE t5;
2788 Table Create Table
2789 t5 CREATE TABLE `t5` (
2790 `c2` binary(5) NOT NULL,
2791 `c1` bigint NOT NULL
2792 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2793 DROP TABLE t5;
2794 SHOW TABLES;
2795 Tables_in_test
2796 CREATE TABLE t5(c1 REAL NOT NULL);
2797 SHOW TABLES;
2798 Tables_in_test
2799 t5
2800 SHOW CREATE TABLE t5;
2801 Table Create Table
2802 t5 CREATE TABLE `t5` (
2803 `c1` double NOT NULL
2804 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2805 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2806 SHOW TABLES;
2807 Tables_in_test
2808 t5
2809 SHOW CREATE TABLE t5;
2810 Table Create Table
2811 t5 CREATE TABLE `t5` (
2812 `c2` binary(5) NOT NULL,
2813 `c1` double NOT NULL
2814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2815 DROP TABLE t5;
2816 SHOW TABLES;
2817 Tables_in_test
2818 CREATE TABLE t5(c1 DOUBLE NOT NULL);
2819 SHOW TABLES;
2820 Tables_in_test
2821 t5
2822 SHOW CREATE TABLE t5;
2823 Table Create Table
2824 t5 CREATE TABLE `t5` (
2825 `c1` double NOT NULL
2826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2827 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2828 SHOW TABLES;
2829 Tables_in_test
2830 t5
2831 SHOW CREATE TABLE t5;
2832 Table Create Table
2833 t5 CREATE TABLE `t5` (
2834 `c2` binary(5) NOT NULL,
2835 `c1` double NOT NULL
2836 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2837 DROP TABLE t5;
2838 SHOW TABLES;
2839 Tables_in_test
2840 CREATE TABLE t5(c1 FLOAT NOT NULL);
2841 SHOW TABLES;
2842 Tables_in_test
2843 t5
2844 SHOW CREATE TABLE t5;
2845 Table Create Table
2846 t5 CREATE TABLE `t5` (
2847 `c1` float NOT NULL
2848 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2849 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2850 SHOW TABLES;
2851 Tables_in_test
2852 t5
2853 SHOW CREATE TABLE t5;
2854 Table Create Table
2855 t5 CREATE TABLE `t5` (
2856 `c2` binary(5) NOT NULL,
2857 `c1` float NOT NULL
2858 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2859 DROP TABLE t5;
2860 SHOW TABLES;
2861 Tables_in_test
2862 CREATE TABLE t5(c1 DECIMAL NOT NULL);
2863 SHOW TABLES;
2864 Tables_in_test
2865 t5
2866 SHOW CREATE TABLE t5;
2867 Table Create Table
2868 t5 CREATE TABLE `t5` (
2869 `c1` decimal(10,0) NOT NULL
2870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2871 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2872 SHOW TABLES;
2873 Tables_in_test
2874 t5
2875 SHOW CREATE TABLE t5;
2876 Table Create Table
2877 t5 CREATE TABLE `t5` (
2878 `c2` binary(5) NOT NULL,
2879 `c1` decimal(10,0) NOT NULL
2880 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2881 DROP TABLE t5;
2882 SHOW TABLES;
2883 Tables_in_test
2884 CREATE TABLE t5(c1 NUMERIC NOT NULL);
2885 SHOW TABLES;
2886 Tables_in_test
2887 t5
2888 SHOW CREATE TABLE t5;
2889 Table Create Table
2890 t5 CREATE TABLE `t5` (
2891 `c1` decimal(10,0) NOT NULL
2892 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2893 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2894 SHOW TABLES;
2895 Tables_in_test
2896 t5
2897 SHOW CREATE TABLE t5;
2898 Table Create Table
2899 t5 CREATE TABLE `t5` (
2900 `c2` binary(5) NOT NULL,
2901 `c1` decimal(10,0) NOT NULL
2902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2903 DROP TABLE t5;
2904 SHOW TABLES;
2905 Tables_in_test
2906 CREATE TABLE t5(c1 DATE NOT NULL);
2907 SHOW TABLES;
2908 Tables_in_test
2909 t5
2910 SHOW CREATE TABLE t5;
2911 Table Create Table
2912 t5 CREATE TABLE `t5` (
2913 `c1` date NOT NULL
2914 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2915 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2916 SHOW TABLES;
2917 Tables_in_test
2918 t5
2919 SHOW CREATE TABLE t5;
2920 Table Create Table
2921 t5 CREATE TABLE `t5` (
2922 `c2` binary(5) NOT NULL,
2923 `c1` date NOT NULL
2924 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2925 DROP TABLE t5;
2926 SHOW TABLES;
2927 Tables_in_test
2928 CREATE TABLE t5(c1 TIME NOT NULL);
2929 SHOW TABLES;
2930 Tables_in_test
2931 t5
2932 SHOW CREATE TABLE t5;
2933 Table Create Table
2934 t5 CREATE TABLE `t5` (
2935 `c1` time NOT NULL
2936 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2937 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2938 SHOW TABLES;
2939 Tables_in_test
2940 t5
2941 SHOW CREATE TABLE t5;
2942 Table Create Table
2943 t5 CREATE TABLE `t5` (
2944 `c2` binary(5) NOT NULL,
2945 `c1` time NOT NULL
2946 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2947 DROP TABLE t5;
2948 SHOW TABLES;
2949 Tables_in_test
2950 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
2951 SHOW TABLES;
2952 Tables_in_test
2953 t5
2954 SHOW CREATE TABLE t5;
2955 Table Create Table
2956 t5 CREATE TABLE `t5` (
2957 `c1` timestamp NOT NULL
2958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2959 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2960 SHOW TABLES;
2961 Tables_in_test
2962 t5
2963 SHOW CREATE TABLE t5;
2964 Table Create Table
2965 t5 CREATE TABLE `t5` (
2966 `c2` binary(5) NOT NULL,
2967 `c1` timestamp NOT NULL
2968 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2969 DROP TABLE t5;
2970 SHOW TABLES;
2971 Tables_in_test
2972 CREATE TABLE t5(c1 YEAR NOT NULL);
2973 SHOW TABLES;
2974 Tables_in_test
2975 t5
2976 SHOW CREATE TABLE t5;
2977 Table Create Table
2978 t5 CREATE TABLE `t5` (
2979 `c1` year NOT NULL
2980 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2981 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
2982 SHOW TABLES;
2983 Tables_in_test
2984 t5
2985 SHOW CREATE TABLE t5;
2986 Table Create Table
2987 t5 CREATE TABLE `t5` (
2988 `c2` binary(5) NOT NULL,
2989 `c1` year NOT NULL
2990 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2991 DROP TABLE t5;
2992 SHOW TABLES;
2993 Tables_in_test
2994 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
2995 SHOW TABLES;
2996 Tables_in_test
2997 t5
2998 SHOW CREATE TABLE t5;
2999 Table Create Table
3000 t5 CREATE TABLE `t5` (
3001 `c1` tinyblob NOT NULL
3002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3003 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3004 SHOW TABLES;
3005 Tables_in_test
3006 t5
3007 SHOW CREATE TABLE t5;
3008 Table Create Table
3009 t5 CREATE TABLE `t5` (
3010 `c2` binary(5) NOT NULL,
3011 `c1` tinyblob NOT NULL
3012 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3013 DROP TABLE t5;
3014 SHOW TABLES;
3015 Tables_in_test
3016 CREATE TABLE t5(c1 BLOB NOT NULL);
3017 SHOW TABLES;
3018 Tables_in_test
3019 t5
3020 SHOW CREATE TABLE t5;
3021 Table Create Table
3022 t5 CREATE TABLE `t5` (
3023 `c1` blob NOT NULL
3024 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3025 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3026 SHOW TABLES;
3027 Tables_in_test
3028 t5
3029 SHOW CREATE TABLE t5;
3030 Table Create Table
3031 t5 CREATE TABLE `t5` (
3032 `c2` binary(5) NOT NULL,
3033 `c1` blob NOT NULL
3034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3035 DROP TABLE t5;
3036 SHOW TABLES;
3037 Tables_in_test
3038 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
3039 SHOW TABLES;
3040 Tables_in_test
3041 t5
3042 SHOW CREATE TABLE t5;
3043 Table Create Table
3044 t5 CREATE TABLE `t5` (
3045 `c1` mediumblob NOT NULL
3046 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3047 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3048 SHOW TABLES;
3049 Tables_in_test
3050 t5
3051 SHOW CREATE TABLE t5;
3052 Table Create Table
3053 t5 CREATE TABLE `t5` (
3054 `c2` binary(5) NOT NULL,
3055 `c1` mediumblob NOT NULL
3056 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3057 DROP TABLE t5;
3058 SHOW TABLES;
3059 Tables_in_test
3060 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
3061 SHOW TABLES;
3062 Tables_in_test
3063 t5
3064 SHOW CREATE TABLE t5;
3065 Table Create Table
3066 t5 CREATE TABLE `t5` (
3067 `c1` longblob NOT NULL
3068 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3069 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3070 SHOW TABLES;
3071 Tables_in_test
3072 t5
3073 SHOW CREATE TABLE t5;
3074 Table Create Table
3075 t5 CREATE TABLE `t5` (
3076 `c2` binary(5) NOT NULL,
3077 `c1` longblob NOT NULL
3078 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3079 DROP TABLE t5;
3080 SHOW TABLES;
3081 Tables_in_test
3082 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
3083 SHOW TABLES;
3084 Tables_in_test
3085 t5
3086 SHOW CREATE TABLE t5;
3087 Table Create Table
3088 t5 CREATE TABLE `t5` (
3089 `c1` tinytext NOT NULL
3090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3091 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3092 SHOW TABLES;
3093 Tables_in_test
3094 t5
3095 SHOW CREATE TABLE t5;
3096 Table Create Table
3097 t5 CREATE TABLE `t5` (
3098 `c2` binary(5) NOT NULL,
3099 `c1` tinytext NOT NULL
3100 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3101 DROP TABLE t5;
3102 SHOW TABLES;
3103 Tables_in_test
3104 CREATE TABLE t5(c1 TEXT NOT NULL);
3105 SHOW TABLES;
3106 Tables_in_test
3107 t5
3108 SHOW CREATE TABLE t5;
3109 Table Create Table
3110 t5 CREATE TABLE `t5` (
3111 `c1` text NOT NULL
3112 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3113 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3114 SHOW TABLES;
3115 Tables_in_test
3116 t5
3117 SHOW CREATE TABLE t5;
3118 Table Create Table
3119 t5 CREATE TABLE `t5` (
3120 `c2` binary(5) NOT NULL,
3121 `c1` text NOT NULL
3122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3123 DROP TABLE t5;
3124 SHOW TABLES;
3125 Tables_in_test
3126 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
3127 SHOW TABLES;
3128 Tables_in_test
3129 t5
3130 SHOW CREATE TABLE t5;
3131 Table Create Table
3132 t5 CREATE TABLE `t5` (
3133 `c1` mediumtext NOT NULL
3134 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3135 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3136 SHOW TABLES;
3137 Tables_in_test
3138 t5
3139 SHOW CREATE TABLE t5;
3140 Table Create Table
3141 t5 CREATE TABLE `t5` (
3142 `c2` binary(5) NOT NULL,
3143 `c1` mediumtext NOT NULL
3144 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3145 DROP TABLE t5;
3146 SHOW TABLES;
3147 Tables_in_test
3148 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
3149 SHOW TABLES;
3150 Tables_in_test
3151 t5
3152 SHOW CREATE TABLE t5;
3153 Table Create Table
3154 t5 CREATE TABLE `t5` (
3155 `c1` longtext NOT NULL
3156 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3157 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST;
3158 SHOW TABLES;
3159 Tables_in_test
3160 t5
3161 SHOW CREATE TABLE t5;
3162 Table Create Table
3163 t5 CREATE TABLE `t5` (
3164 `c2` binary(5) NOT NULL,
3165 `c1` longtext NOT NULL
3166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3167 DROP TABLE t5;
3168 SHOW TABLES;
3169 Tables_in_test
3170 CREATE TABLE t5(c1 BIT NULL);
3171 SHOW TABLES;
3172 Tables_in_test
3173 t5
3174 SHOW CREATE TABLE t5;
3175 Table Create Table
3176 t5 CREATE TABLE `t5` (
3177 `c1` bit(1) DEFAULT NULL
3178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3179 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3180 SHOW TABLES;
3181 Tables_in_test
3182 t5
3183 SHOW CREATE TABLE t5;
3184 Table Create Table
3185 t5 CREATE TABLE `t5` (
3186 `c2` varbinary(5) DEFAULT NULL,
3187 `c1` bit(1) DEFAULT NULL
3188 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3189 DROP TABLE t5;
3190 SHOW TABLES;
3191 Tables_in_test
3192 CREATE TABLE t5(c1 TINYINT NULL);
3193 SHOW TABLES;
3194 Tables_in_test
3195 t5
3196 SHOW CREATE TABLE t5;
3197 Table Create Table
3198 t5 CREATE TABLE `t5` (
3199 `c1` tinyint DEFAULT NULL
3200 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3201 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3202 SHOW TABLES;
3203 Tables_in_test
3204 t5
3205 SHOW CREATE TABLE t5;
3206 Table Create Table
3207 t5 CREATE TABLE `t5` (
3208 `c2` varbinary(5) DEFAULT NULL,
3209 `c1` tinyint DEFAULT NULL
3210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3211 DROP TABLE t5;
3212 SHOW TABLES;
3213 Tables_in_test
3214 CREATE TABLE t5(c1 SMALLINT NULL);
3215 SHOW TABLES;
3216 Tables_in_test
3217 t5
3218 SHOW CREATE TABLE t5;
3219 Table Create Table
3220 t5 CREATE TABLE `t5` (
3221 `c1` smallint DEFAULT NULL
3222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3223 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3224 SHOW TABLES;
3225 Tables_in_test
3226 t5
3227 SHOW CREATE TABLE t5;
3228 Table Create Table
3229 t5 CREATE TABLE `t5` (
3230 `c2` varbinary(5) DEFAULT NULL,
3231 `c1` smallint DEFAULT NULL
3232 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3233 DROP TABLE t5;
3234 SHOW TABLES;
3235 Tables_in_test
3236 CREATE TABLE t5(c1 MEDIUMINT NULL);
3237 SHOW TABLES;
3238 Tables_in_test
3239 t5
3240 SHOW CREATE TABLE t5;
3241 Table Create Table
3242 t5 CREATE TABLE `t5` (
3243 `c1` mediumint DEFAULT NULL
3244 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3245 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3246 SHOW TABLES;
3247 Tables_in_test
3248 t5
3249 SHOW CREATE TABLE t5;
3250 Table Create Table
3251 t5 CREATE TABLE `t5` (
3252 `c2` varbinary(5) DEFAULT NULL,
3253 `c1` mediumint DEFAULT NULL
3254 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3255 DROP TABLE t5;
3256 SHOW TABLES;
3257 Tables_in_test
3258 CREATE TABLE t5(c1 INT NULL);
3259 SHOW TABLES;
3260 Tables_in_test
3261 t5
3262 SHOW CREATE TABLE t5;
3263 Table Create Table
3264 t5 CREATE TABLE `t5` (
3265 `c1` int DEFAULT NULL
3266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3267 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3268 SHOW TABLES;
3269 Tables_in_test
3270 t5
3271 SHOW CREATE TABLE t5;
3272 Table Create Table
3273 t5 CREATE TABLE `t5` (
3274 `c2` varbinary(5) DEFAULT NULL,
3275 `c1` int DEFAULT NULL
3276 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3277 DROP TABLE t5;
3278 SHOW TABLES;
3279 Tables_in_test
3280 CREATE TABLE t5(c1 INTEGER NULL);
3281 SHOW TABLES;
3282 Tables_in_test
3283 t5
3284 SHOW CREATE TABLE t5;
3285 Table Create Table
3286 t5 CREATE TABLE `t5` (
3287 `c1` int DEFAULT NULL
3288 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3289 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3290 SHOW TABLES;
3291 Tables_in_test
3292 t5
3293 SHOW CREATE TABLE t5;
3294 Table Create Table
3295 t5 CREATE TABLE `t5` (
3296 `c2` varbinary(5) DEFAULT NULL,
3297 `c1` int DEFAULT NULL
3298 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3299 DROP TABLE t5;
3300 SHOW TABLES;
3301 Tables_in_test
3302 CREATE TABLE t5(c1 BIGINT NULL);
3303 SHOW TABLES;
3304 Tables_in_test
3305 t5
3306 SHOW CREATE TABLE t5;
3307 Table Create Table
3308 t5 CREATE TABLE `t5` (
3309 `c1` bigint DEFAULT NULL
3310 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3311 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3312 SHOW TABLES;
3313 Tables_in_test
3314 t5
3315 SHOW CREATE TABLE t5;
3316 Table Create Table
3317 t5 CREATE TABLE `t5` (
3318 `c2` varbinary(5) DEFAULT NULL,
3319 `c1` bigint DEFAULT NULL
3320 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3321 DROP TABLE t5;
3322 SHOW TABLES;
3323 Tables_in_test
3324 CREATE TABLE t5(c1 REAL NULL);
3325 SHOW TABLES;
3326 Tables_in_test
3327 t5
3328 SHOW CREATE TABLE t5;
3329 Table Create Table
3330 t5 CREATE TABLE `t5` (
3331 `c1` double DEFAULT NULL
3332 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3333 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3334 SHOW TABLES;
3335 Tables_in_test
3336 t5
3337 SHOW CREATE TABLE t5;
3338 Table Create Table
3339 t5 CREATE TABLE `t5` (
3340 `c2` varbinary(5) DEFAULT NULL,
3341 `c1` double DEFAULT NULL
3342 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3343 DROP TABLE t5;
3344 SHOW TABLES;
3345 Tables_in_test
3346 CREATE TABLE t5(c1 DOUBLE NULL);
3347 SHOW TABLES;
3348 Tables_in_test
3349 t5
3350 SHOW CREATE TABLE t5;
3351 Table Create Table
3352 t5 CREATE TABLE `t5` (
3353 `c1` double DEFAULT NULL
3354 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3355 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3356 SHOW TABLES;
3357 Tables_in_test
3358 t5
3359 SHOW CREATE TABLE t5;
3360 Table Create Table
3361 t5 CREATE TABLE `t5` (
3362 `c2` varbinary(5) DEFAULT NULL,
3363 `c1` double DEFAULT NULL
3364 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3365 DROP TABLE t5;
3366 SHOW TABLES;
3367 Tables_in_test
3368 CREATE TABLE t5(c1 FLOAT NULL);
3369 SHOW TABLES;
3370 Tables_in_test
3371 t5
3372 SHOW CREATE TABLE t5;
3373 Table Create Table
3374 t5 CREATE TABLE `t5` (
3375 `c1` float DEFAULT NULL
3376 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3377 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3378 SHOW TABLES;
3379 Tables_in_test
3380 t5
3381 SHOW CREATE TABLE t5;
3382 Table Create Table
3383 t5 CREATE TABLE `t5` (
3384 `c2` varbinary(5) DEFAULT NULL,
3385 `c1` float DEFAULT NULL
3386 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3387 DROP TABLE t5;
3388 SHOW TABLES;
3389 Tables_in_test
3390 CREATE TABLE t5(c1 DECIMAL NULL);
3391 SHOW TABLES;
3392 Tables_in_test
3393 t5
3394 SHOW CREATE TABLE t5;
3395 Table Create Table
3396 t5 CREATE TABLE `t5` (
3397 `c1` decimal(10,0) DEFAULT NULL
3398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3399 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3400 SHOW TABLES;
3401 Tables_in_test
3402 t5
3403 SHOW CREATE TABLE t5;
3404 Table Create Table
3405 t5 CREATE TABLE `t5` (
3406 `c2` varbinary(5) DEFAULT NULL,
3407 `c1` decimal(10,0) DEFAULT NULL
3408 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3409 DROP TABLE t5;
3410 SHOW TABLES;
3411 Tables_in_test
3412 CREATE TABLE t5(c1 NUMERIC NULL);
3413 SHOW TABLES;
3414 Tables_in_test
3415 t5
3416 SHOW CREATE TABLE t5;
3417 Table Create Table
3418 t5 CREATE TABLE `t5` (
3419 `c1` decimal(10,0) DEFAULT NULL
3420 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3421 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3422 SHOW TABLES;
3423 Tables_in_test
3424 t5
3425 SHOW CREATE TABLE t5;
3426 Table Create Table
3427 t5 CREATE TABLE `t5` (
3428 `c2` varbinary(5) DEFAULT NULL,
3429 `c1` decimal(10,0) DEFAULT NULL
3430 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3431 DROP TABLE t5;
3432 SHOW TABLES;
3433 Tables_in_test
3434 CREATE TABLE t5(c1 DATE NULL);
3435 SHOW TABLES;
3436 Tables_in_test
3437 t5
3438 SHOW CREATE TABLE t5;
3439 Table Create Table
3440 t5 CREATE TABLE `t5` (
3441 `c1` date DEFAULT NULL
3442 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3443 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3444 SHOW TABLES;
3445 Tables_in_test
3446 t5
3447 SHOW CREATE TABLE t5;
3448 Table Create Table
3449 t5 CREATE TABLE `t5` (
3450 `c2` varbinary(5) DEFAULT NULL,
3451 `c1` date DEFAULT NULL
3452 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3453 DROP TABLE t5;
3454 SHOW TABLES;
3455 Tables_in_test
3456 CREATE TABLE t5(c1 TIME NULL);
3457 SHOW TABLES;
3458 Tables_in_test
3459 t5
3460 SHOW CREATE TABLE t5;
3461 Table Create Table
3462 t5 CREATE TABLE `t5` (
3463 `c1` time DEFAULT NULL
3464 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3465 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3466 SHOW TABLES;
3467 Tables_in_test
3468 t5
3469 SHOW CREATE TABLE t5;
3470 Table Create Table
3471 t5 CREATE TABLE `t5` (
3472 `c2` varbinary(5) DEFAULT NULL,
3473 `c1` time DEFAULT NULL
3474 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3475 DROP TABLE t5;
3476 SHOW TABLES;
3477 Tables_in_test
3478 CREATE TABLE t5(c1 TIMESTAMP NULL);
3479 SHOW TABLES;
3480 Tables_in_test
3481 t5
3482 SHOW CREATE TABLE t5;
3483 Table Create Table
3484 t5 CREATE TABLE `t5` (
3485 `c1` timestamp NULL DEFAULT NULL
3486 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3487 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3488 SHOW TABLES;
3489 Tables_in_test
3490 t5
3491 SHOW CREATE TABLE t5;
3492 Table Create Table
3493 t5 CREATE TABLE `t5` (
3494 `c2` varbinary(5) DEFAULT NULL,
3495 `c1` timestamp NULL DEFAULT NULL
3496 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3497 DROP TABLE t5;
3498 SHOW TABLES;
3499 Tables_in_test
3500 CREATE TABLE t5(c1 YEAR NULL);
3501 SHOW TABLES;
3502 Tables_in_test
3503 t5
3504 SHOW CREATE TABLE t5;
3505 Table Create Table
3506 t5 CREATE TABLE `t5` (
3507 `c1` year DEFAULT NULL
3508 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3509 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3510 SHOW TABLES;
3511 Tables_in_test
3512 t5
3513 SHOW CREATE TABLE t5;
3514 Table Create Table
3515 t5 CREATE TABLE `t5` (
3516 `c2` varbinary(5) DEFAULT NULL,
3517 `c1` year DEFAULT NULL
3518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3519 DROP TABLE t5;
3520 SHOW TABLES;
3521 Tables_in_test
3522 CREATE TABLE t5(c1 TINYBLOB NULL);
3523 SHOW TABLES;
3524 Tables_in_test
3525 t5
3526 SHOW CREATE TABLE t5;
3527 Table Create Table
3528 t5 CREATE TABLE `t5` (
3529 `c1` tinyblob
3530 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3531 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3532 SHOW TABLES;
3533 Tables_in_test
3534 t5
3535 SHOW CREATE TABLE t5;
3536 Table Create Table
3537 t5 CREATE TABLE `t5` (
3538 `c2` varbinary(5) DEFAULT NULL,
3539 `c1` tinyblob
3540 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3541 DROP TABLE t5;
3542 SHOW TABLES;
3543 Tables_in_test
3544 CREATE TABLE t5(c1 BLOB NULL);
3545 SHOW TABLES;
3546 Tables_in_test
3547 t5
3548 SHOW CREATE TABLE t5;
3549 Table Create Table
3550 t5 CREATE TABLE `t5` (
3551 `c1` blob
3552 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3553 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3554 SHOW TABLES;
3555 Tables_in_test
3556 t5
3557 SHOW CREATE TABLE t5;
3558 Table Create Table
3559 t5 CREATE TABLE `t5` (
3560 `c2` varbinary(5) DEFAULT NULL,
3561 `c1` blob
3562 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3563 DROP TABLE t5;
3564 SHOW TABLES;
3565 Tables_in_test
3566 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
3567 SHOW TABLES;
3568 Tables_in_test
3569 t5
3570 SHOW CREATE TABLE t5;
3571 Table Create Table
3572 t5 CREATE TABLE `t5` (
3573 `c1` mediumblob
3574 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3575 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3576 SHOW TABLES;
3577 Tables_in_test
3578 t5
3579 SHOW CREATE TABLE t5;
3580 Table Create Table
3581 t5 CREATE TABLE `t5` (
3582 `c2` varbinary(5) DEFAULT NULL,
3583 `c1` mediumblob
3584 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3585 DROP TABLE t5;
3586 SHOW TABLES;
3587 Tables_in_test
3588 CREATE TABLE t5(c1 LONGBLOB NULL);
3589 SHOW TABLES;
3590 Tables_in_test
3591 t5
3592 SHOW CREATE TABLE t5;
3593 Table Create Table
3594 t5 CREATE TABLE `t5` (
3595 `c1` longblob
3596 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3597 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3598 SHOW TABLES;
3599 Tables_in_test
3600 t5
3601 SHOW CREATE TABLE t5;
3602 Table Create Table
3603 t5 CREATE TABLE `t5` (
3604 `c2` varbinary(5) DEFAULT NULL,
3605 `c1` longblob
3606 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3607 DROP TABLE t5;
3608 SHOW TABLES;
3609 Tables_in_test
3610 CREATE TABLE t5(c1 TINYTEXT NULL);
3611 SHOW TABLES;
3612 Tables_in_test
3613 t5
3614 SHOW CREATE TABLE t5;
3615 Table Create Table
3616 t5 CREATE TABLE `t5` (
3617 `c1` tinytext
3618 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3619 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3620 SHOW TABLES;
3621 Tables_in_test
3622 t5
3623 SHOW CREATE TABLE t5;
3624 Table Create Table
3625 t5 CREATE TABLE `t5` (
3626 `c2` varbinary(5) DEFAULT NULL,
3627 `c1` tinytext
3628 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3629 DROP TABLE t5;
3630 SHOW TABLES;
3631 Tables_in_test
3632 CREATE TABLE t5(c1 TEXT NULL);
3633 SHOW TABLES;
3634 Tables_in_test
3635 t5
3636 SHOW CREATE TABLE t5;
3637 Table Create Table
3638 t5 CREATE TABLE `t5` (
3639 `c1` text
3640 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3641 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3642 SHOW TABLES;
3643 Tables_in_test
3644 t5
3645 SHOW CREATE TABLE t5;
3646 Table Create Table
3647 t5 CREATE TABLE `t5` (
3648 `c2` varbinary(5) DEFAULT NULL,
3649 `c1` text
3650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3651 DROP TABLE t5;
3652 SHOW TABLES;
3653 Tables_in_test
3654 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
3655 SHOW TABLES;
3656 Tables_in_test
3657 t5
3658 SHOW CREATE TABLE t5;
3659 Table Create Table
3660 t5 CREATE TABLE `t5` (
3661 `c1` mediumtext
3662 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3663 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3664 SHOW TABLES;
3665 Tables_in_test
3666 t5
3667 SHOW CREATE TABLE t5;
3668 Table Create Table
3669 t5 CREATE TABLE `t5` (
3670 `c2` varbinary(5) DEFAULT NULL,
3671 `c1` mediumtext
3672 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3673 DROP TABLE t5;
3674 SHOW TABLES;
3675 Tables_in_test
3676 CREATE TABLE t5(c1 LONGTEXT NULL);
3677 SHOW TABLES;
3678 Tables_in_test
3679 t5
3680 SHOW CREATE TABLE t5;
3681 Table Create Table
3682 t5 CREATE TABLE `t5` (
3683 `c1` longtext
3684 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3685 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST;
3686 SHOW TABLES;
3687 Tables_in_test
3688 t5
3689 SHOW CREATE TABLE t5;
3690 Table Create Table
3691 t5 CREATE TABLE `t5` (
3692 `c2` varbinary(5) DEFAULT NULL,
3693 `c1` longtext
3694 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3695 DROP TABLE t5;
3696 SHOW TABLES;
3697 Tables_in_test
3698 CREATE TABLE t5(c1 BIT NOT NULL);
3699 SHOW TABLES;
3700 Tables_in_test
3701 t5
3702 SHOW CREATE TABLE t5;
3703 Table Create Table
3704 t5 CREATE TABLE `t5` (
3705 `c1` bit(1) NOT NULL
3706 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3707 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3708 SHOW TABLES;
3709 Tables_in_test
3710 t5
3711 SHOW CREATE TABLE t5;
3712 Table Create Table
3713 t5 CREATE TABLE `t5` (
3714 `c2` varbinary(5) NOT NULL,
3715 `c1` bit(1) NOT NULL
3716 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3717 DROP TABLE t5;
3718 SHOW TABLES;
3719 Tables_in_test
3720 CREATE TABLE t5(c1 TINYINT NOT NULL);
3721 SHOW TABLES;
3722 Tables_in_test
3723 t5
3724 SHOW CREATE TABLE t5;
3725 Table Create Table
3726 t5 CREATE TABLE `t5` (
3727 `c1` tinyint NOT NULL
3728 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3729 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3730 SHOW TABLES;
3731 Tables_in_test
3732 t5
3733 SHOW CREATE TABLE t5;
3734 Table Create Table
3735 t5 CREATE TABLE `t5` (
3736 `c2` varbinary(5) NOT NULL,
3737 `c1` tinyint NOT NULL
3738 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3739 DROP TABLE t5;
3740 SHOW TABLES;
3741 Tables_in_test
3742 CREATE TABLE t5(c1 SMALLINT NOT NULL);
3743 SHOW TABLES;
3744 Tables_in_test
3745 t5
3746 SHOW CREATE TABLE t5;
3747 Table Create Table
3748 t5 CREATE TABLE `t5` (
3749 `c1` smallint NOT NULL
3750 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3751 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3752 SHOW TABLES;
3753 Tables_in_test
3754 t5
3755 SHOW CREATE TABLE t5;
3756 Table Create Table
3757 t5 CREATE TABLE `t5` (
3758 `c2` varbinary(5) NOT NULL,
3759 `c1` smallint NOT NULL
3760 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3761 DROP TABLE t5;
3762 SHOW TABLES;
3763 Tables_in_test
3764 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
3765 SHOW TABLES;
3766 Tables_in_test
3767 t5
3768 SHOW CREATE TABLE t5;
3769 Table Create Table
3770 t5 CREATE TABLE `t5` (
3771 `c1` mediumint NOT NULL
3772 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3773 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3774 SHOW TABLES;
3775 Tables_in_test
3776 t5
3777 SHOW CREATE TABLE t5;
3778 Table Create Table
3779 t5 CREATE TABLE `t5` (
3780 `c2` varbinary(5) NOT NULL,
3781 `c1` mediumint NOT NULL
3782 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3783 DROP TABLE t5;
3784 SHOW TABLES;
3785 Tables_in_test
3786 CREATE TABLE t5(c1 INT NOT NULL);
3787 SHOW TABLES;
3788 Tables_in_test
3789 t5
3790 SHOW CREATE TABLE t5;
3791 Table Create Table
3792 t5 CREATE TABLE `t5` (
3793 `c1` int NOT NULL
3794 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3795 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3796 SHOW TABLES;
3797 Tables_in_test
3798 t5
3799 SHOW CREATE TABLE t5;
3800 Table Create Table
3801 t5 CREATE TABLE `t5` (
3802 `c2` varbinary(5) NOT NULL,
3803 `c1` int NOT NULL
3804 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3805 DROP TABLE t5;
3806 SHOW TABLES;
3807 Tables_in_test
3808 CREATE TABLE t5(c1 INTEGER NOT NULL);
3809 SHOW TABLES;
3810 Tables_in_test
3811 t5
3812 SHOW CREATE TABLE t5;
3813 Table Create Table
3814 t5 CREATE TABLE `t5` (
3815 `c1` int NOT NULL
3816 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3817 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3818 SHOW TABLES;
3819 Tables_in_test
3820 t5
3821 SHOW CREATE TABLE t5;
3822 Table Create Table
3823 t5 CREATE TABLE `t5` (
3824 `c2` varbinary(5) NOT NULL,
3825 `c1` int NOT NULL
3826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3827 DROP TABLE t5;
3828 SHOW TABLES;
3829 Tables_in_test
3830 CREATE TABLE t5(c1 BIGINT NOT NULL);
3831 SHOW TABLES;
3832 Tables_in_test
3833 t5
3834 SHOW CREATE TABLE t5;
3835 Table Create Table
3836 t5 CREATE TABLE `t5` (
3837 `c1` bigint NOT NULL
3838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3839 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3840 SHOW TABLES;
3841 Tables_in_test
3842 t5
3843 SHOW CREATE TABLE t5;
3844 Table Create Table
3845 t5 CREATE TABLE `t5` (
3846 `c2` varbinary(5) NOT NULL,
3847 `c1` bigint NOT NULL
3848 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3849 DROP TABLE t5;
3850 SHOW TABLES;
3851 Tables_in_test
3852 CREATE TABLE t5(c1 REAL NOT NULL);
3853 SHOW TABLES;
3854 Tables_in_test
3855 t5
3856 SHOW CREATE TABLE t5;
3857 Table Create Table
3858 t5 CREATE TABLE `t5` (
3859 `c1` double NOT NULL
3860 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3861 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3862 SHOW TABLES;
3863 Tables_in_test
3864 t5
3865 SHOW CREATE TABLE t5;
3866 Table Create Table
3867 t5 CREATE TABLE `t5` (
3868 `c2` varbinary(5) NOT NULL,
3869 `c1` double NOT NULL
3870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3871 DROP TABLE t5;
3872 SHOW TABLES;
3873 Tables_in_test
3874 CREATE TABLE t5(c1 DOUBLE NOT NULL);
3875 SHOW TABLES;
3876 Tables_in_test
3877 t5
3878 SHOW CREATE TABLE t5;
3879 Table Create Table
3880 t5 CREATE TABLE `t5` (
3881 `c1` double NOT NULL
3882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3883 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3884 SHOW TABLES;
3885 Tables_in_test
3886 t5
3887 SHOW CREATE TABLE t5;
3888 Table Create Table
3889 t5 CREATE TABLE `t5` (
3890 `c2` varbinary(5) NOT NULL,
3891 `c1` double NOT NULL
3892 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3893 DROP TABLE t5;
3894 SHOW TABLES;
3895 Tables_in_test
3896 CREATE TABLE t5(c1 FLOAT NOT NULL);
3897 SHOW TABLES;
3898 Tables_in_test
3899 t5
3900 SHOW CREATE TABLE t5;
3901 Table Create Table
3902 t5 CREATE TABLE `t5` (
3903 `c1` float NOT NULL
3904 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3905 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3906 SHOW TABLES;
3907 Tables_in_test
3908 t5
3909 SHOW CREATE TABLE t5;
3910 Table Create Table
3911 t5 CREATE TABLE `t5` (
3912 `c2` varbinary(5) NOT NULL,
3913 `c1` float NOT NULL
3914 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3915 DROP TABLE t5;
3916 SHOW TABLES;
3917 Tables_in_test
3918 CREATE TABLE t5(c1 DECIMAL NOT NULL);
3919 SHOW TABLES;
3920 Tables_in_test
3921 t5
3922 SHOW CREATE TABLE t5;
3923 Table Create Table
3924 t5 CREATE TABLE `t5` (
3925 `c1` decimal(10,0) NOT NULL
3926 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3927 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3928 SHOW TABLES;
3929 Tables_in_test
3930 t5
3931 SHOW CREATE TABLE t5;
3932 Table Create Table
3933 t5 CREATE TABLE `t5` (
3934 `c2` varbinary(5) NOT NULL,
3935 `c1` decimal(10,0) NOT NULL
3936 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3937 DROP TABLE t5;
3938 SHOW TABLES;
3939 Tables_in_test
3940 CREATE TABLE t5(c1 NUMERIC NOT NULL);
3941 SHOW TABLES;
3942 Tables_in_test
3943 t5
3944 SHOW CREATE TABLE t5;
3945 Table Create Table
3946 t5 CREATE TABLE `t5` (
3947 `c1` decimal(10,0) NOT NULL
3948 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3949 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3950 SHOW TABLES;
3951 Tables_in_test
3952 t5
3953 SHOW CREATE TABLE t5;
3954 Table Create Table
3955 t5 CREATE TABLE `t5` (
3956 `c2` varbinary(5) NOT NULL,
3957 `c1` decimal(10,0) NOT NULL
3958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3959 DROP TABLE t5;
3960 SHOW TABLES;
3961 Tables_in_test
3962 CREATE TABLE t5(c1 DATE NOT NULL);
3963 SHOW TABLES;
3964 Tables_in_test
3965 t5
3966 SHOW CREATE TABLE t5;
3967 Table Create Table
3968 t5 CREATE TABLE `t5` (
3969 `c1` date NOT NULL
3970 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3971 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3972 SHOW TABLES;
3973 Tables_in_test
3974 t5
3975 SHOW CREATE TABLE t5;
3976 Table Create Table
3977 t5 CREATE TABLE `t5` (
3978 `c2` varbinary(5) NOT NULL,
3979 `c1` date NOT NULL
3980 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3981 DROP TABLE t5;
3982 SHOW TABLES;
3983 Tables_in_test
3984 CREATE TABLE t5(c1 TIME NOT NULL);
3985 SHOW TABLES;
3986 Tables_in_test
3987 t5
3988 SHOW CREATE TABLE t5;
3989 Table Create Table
3990 t5 CREATE TABLE `t5` (
3991 `c1` time NOT NULL
3992 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3993 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
3994 SHOW TABLES;
3995 Tables_in_test
3996 t5
3997 SHOW CREATE TABLE t5;
3998 Table Create Table
3999 t5 CREATE TABLE `t5` (
4000 `c2` varbinary(5) NOT NULL,
4001 `c1` time NOT NULL
4002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4003 DROP TABLE t5;
4004 SHOW TABLES;
4005 Tables_in_test
4006 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
4007 SHOW TABLES;
4008 Tables_in_test
4009 t5
4010 SHOW CREATE TABLE t5;
4011 Table Create Table
4012 t5 CREATE TABLE `t5` (
4013 `c1` timestamp NOT NULL
4014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4015 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4016 SHOW TABLES;
4017 Tables_in_test
4018 t5
4019 SHOW CREATE TABLE t5;
4020 Table Create Table
4021 t5 CREATE TABLE `t5` (
4022 `c2` varbinary(5) NOT NULL,
4023 `c1` timestamp NOT NULL
4024 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4025 DROP TABLE t5;
4026 SHOW TABLES;
4027 Tables_in_test
4028 CREATE TABLE t5(c1 YEAR NOT NULL);
4029 SHOW TABLES;
4030 Tables_in_test
4031 t5
4032 SHOW CREATE TABLE t5;
4033 Table Create Table
4034 t5 CREATE TABLE `t5` (
4035 `c1` year NOT NULL
4036 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4037 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4038 SHOW TABLES;
4039 Tables_in_test
4040 t5
4041 SHOW CREATE TABLE t5;
4042 Table Create Table
4043 t5 CREATE TABLE `t5` (
4044 `c2` varbinary(5) NOT NULL,
4045 `c1` year NOT NULL
4046 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4047 DROP TABLE t5;
4048 SHOW TABLES;
4049 Tables_in_test
4050 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
4051 SHOW TABLES;
4052 Tables_in_test
4053 t5
4054 SHOW CREATE TABLE t5;
4055 Table Create Table
4056 t5 CREATE TABLE `t5` (
4057 `c1` tinyblob NOT NULL
4058 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4059 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4060 SHOW TABLES;
4061 Tables_in_test
4062 t5
4063 SHOW CREATE TABLE t5;
4064 Table Create Table
4065 t5 CREATE TABLE `t5` (
4066 `c2` varbinary(5) NOT NULL,
4067 `c1` tinyblob NOT NULL
4068 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4069 DROP TABLE t5;
4070 SHOW TABLES;
4071 Tables_in_test
4072 CREATE TABLE t5(c1 BLOB NOT NULL);
4073 SHOW TABLES;
4074 Tables_in_test
4075 t5
4076 SHOW CREATE TABLE t5;
4077 Table Create Table
4078 t5 CREATE TABLE `t5` (
4079 `c1` blob NOT NULL
4080 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4081 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4082 SHOW TABLES;
4083 Tables_in_test
4084 t5
4085 SHOW CREATE TABLE t5;
4086 Table Create Table
4087 t5 CREATE TABLE `t5` (
4088 `c2` varbinary(5) NOT NULL,
4089 `c1` blob NOT NULL
4090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4091 DROP TABLE t5;
4092 SHOW TABLES;
4093 Tables_in_test
4094 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
4095 SHOW TABLES;
4096 Tables_in_test
4097 t5
4098 SHOW CREATE TABLE t5;
4099 Table Create Table
4100 t5 CREATE TABLE `t5` (
4101 `c1` mediumblob NOT NULL
4102 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4103 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4104 SHOW TABLES;
4105 Tables_in_test
4106 t5
4107 SHOW CREATE TABLE t5;
4108 Table Create Table
4109 t5 CREATE TABLE `t5` (
4110 `c2` varbinary(5) NOT NULL,
4111 `c1` mediumblob NOT NULL
4112 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4113 DROP TABLE t5;
4114 SHOW TABLES;
4115 Tables_in_test
4116 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
4117 SHOW TABLES;
4118 Tables_in_test
4119 t5
4120 SHOW CREATE TABLE t5;
4121 Table Create Table
4122 t5 CREATE TABLE `t5` (
4123 `c1` longblob NOT NULL
4124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4125 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4126 SHOW TABLES;
4127 Tables_in_test
4128 t5
4129 SHOW CREATE TABLE t5;
4130 Table Create Table
4131 t5 CREATE TABLE `t5` (
4132 `c2` varbinary(5) NOT NULL,
4133 `c1` longblob NOT NULL
4134 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4135 DROP TABLE t5;
4136 SHOW TABLES;
4137 Tables_in_test
4138 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
4139 SHOW TABLES;
4140 Tables_in_test
4141 t5
4142 SHOW CREATE TABLE t5;
4143 Table Create Table
4144 t5 CREATE TABLE `t5` (
4145 `c1` tinytext NOT NULL
4146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4147 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4148 SHOW TABLES;
4149 Tables_in_test
4150 t5
4151 SHOW CREATE TABLE t5;
4152 Table Create Table
4153 t5 CREATE TABLE `t5` (
4154 `c2` varbinary(5) NOT NULL,
4155 `c1` tinytext NOT NULL
4156 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4157 DROP TABLE t5;
4158 SHOW TABLES;
4159 Tables_in_test
4160 CREATE TABLE t5(c1 TEXT NOT NULL);
4161 SHOW TABLES;
4162 Tables_in_test
4163 t5
4164 SHOW CREATE TABLE t5;
4165 Table Create Table
4166 t5 CREATE TABLE `t5` (
4167 `c1` text NOT NULL
4168 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4169 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4170 SHOW TABLES;
4171 Tables_in_test
4172 t5
4173 SHOW CREATE TABLE t5;
4174 Table Create Table
4175 t5 CREATE TABLE `t5` (
4176 `c2` varbinary(5) NOT NULL,
4177 `c1` text NOT NULL
4178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4179 DROP TABLE t5;
4180 SHOW TABLES;
4181 Tables_in_test
4182 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
4183 SHOW TABLES;
4184 Tables_in_test
4185 t5
4186 SHOW CREATE TABLE t5;
4187 Table Create Table
4188 t5 CREATE TABLE `t5` (
4189 `c1` mediumtext NOT NULL
4190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4191 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4192 SHOW TABLES;
4193 Tables_in_test
4194 t5
4195 SHOW CREATE TABLE t5;
4196 Table Create Table
4197 t5 CREATE TABLE `t5` (
4198 `c2` varbinary(5) NOT NULL,
4199 `c1` mediumtext NOT NULL
4200 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4201 DROP TABLE t5;
4202 SHOW TABLES;
4203 Tables_in_test
4204 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
4205 SHOW TABLES;
4206 Tables_in_test
4207 t5
4208 SHOW CREATE TABLE t5;
4209 Table Create Table
4210 t5 CREATE TABLE `t5` (
4211 `c1` longtext NOT NULL
4212 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4213 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST;
4214 SHOW TABLES;
4215 Tables_in_test
4216 t5
4217 SHOW CREATE TABLE t5;
4218 Table Create Table
4219 t5 CREATE TABLE `t5` (
4220 `c2` varbinary(5) NOT NULL,
4221 `c1` longtext NOT NULL
4222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4223 DROP TABLE t5;
4224 SHOW TABLES;
4225 Tables_in_test