Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) 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) NOT NULL,
10 `c2` int NOT NULL,
11 `c3` char(10) DEFAULT NULL,
12 PRIMARY KEY (`c1`)
13 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
14 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
15 SHOW TABLES;
16 Tables_in_test
17 t5
18 SHOW CREATE TABLE t5;
19 Table Create Table
20 t5 CREATE TABLE `t5` (
21 `c1` bit(1) NOT NULL,
22 `c2` int NOT NULL,
23 `c4` char(5) DEFAULT NULL,
24 `c3` char(10) DEFAULT NULL,
25 PRIMARY KEY (`c1`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t5;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
31 SHOW TABLES;
32 Tables_in_test
33 t5
34 SHOW CREATE TABLE t5;
35 Table Create Table
36 t5 CREATE TABLE `t5` (
37 `c1` tinyint NOT NULL,
38 `c2` int NOT NULL,
39 `c3` char(10) DEFAULT NULL,
40 PRIMARY KEY (`c1`)
41 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
42 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
43 SHOW TABLES;
44 Tables_in_test
45 t5
46 SHOW CREATE TABLE t5;
47 Table Create Table
48 t5 CREATE TABLE `t5` (
49 `c1` tinyint NOT NULL,
50 `c2` int NOT NULL,
51 `c4` char(5) DEFAULT NULL,
52 `c3` char(10) DEFAULT NULL,
53 PRIMARY KEY (`c1`)
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t5;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
59 SHOW TABLES;
60 Tables_in_test
61 t5
62 SHOW CREATE TABLE t5;
63 Table Create Table
64 t5 CREATE TABLE `t5` (
65 `c1` smallint NOT NULL,
66 `c2` int NOT NULL,
67 `c3` char(10) DEFAULT NULL,
68 PRIMARY KEY (`c1`)
69 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
70 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
71 SHOW TABLES;
72 Tables_in_test
73 t5
74 SHOW CREATE TABLE t5;
75 Table Create Table
76 t5 CREATE TABLE `t5` (
77 `c1` smallint NOT NULL,
78 `c2` int NOT NULL,
79 `c4` char(5) DEFAULT NULL,
80 `c3` char(10) DEFAULT NULL,
81 PRIMARY KEY (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t5;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t5
90 SHOW CREATE TABLE t5;
91 Table Create Table
92 t5 CREATE TABLE `t5` (
93 `c1` mediumint NOT NULL,
94 `c2` int NOT NULL,
95 `c3` char(10) DEFAULT NULL,
96 PRIMARY KEY (`c1`)
97 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
98 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
99 SHOW TABLES;
100 Tables_in_test
101 t5
102 SHOW CREATE TABLE t5;
103 Table Create Table
104 t5 CREATE TABLE `t5` (
105 `c1` mediumint NOT NULL,
106 `c2` int NOT NULL,
107 `c4` char(5) DEFAULT NULL,
108 `c3` char(10) DEFAULT NULL,
109 PRIMARY KEY (`c1`)
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t5;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
115 SHOW TABLES;
116 Tables_in_test
117 t5
118 SHOW CREATE TABLE t5;
119 Table Create Table
120 t5 CREATE TABLE `t5` (
121 `c1` int NOT NULL,
122 `c2` int NOT NULL,
123 `c3` char(10) DEFAULT NULL,
124 PRIMARY KEY (`c1`)
125 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
126 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
127 SHOW TABLES;
128 Tables_in_test
129 t5
130 SHOW CREATE TABLE t5;
131 Table Create Table
132 t5 CREATE TABLE `t5` (
133 `c1` int NOT NULL,
134 `c2` int NOT NULL,
135 `c4` char(5) DEFAULT NULL,
136 `c3` char(10) DEFAULT NULL,
137 PRIMARY KEY (`c1`)
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t5;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
143 SHOW TABLES;
144 Tables_in_test
145 t5
146 SHOW CREATE TABLE t5;
147 Table Create Table
148 t5 CREATE TABLE `t5` (
149 `c1` int NOT NULL,
150 `c2` int NOT NULL,
151 `c3` char(10) DEFAULT NULL,
152 PRIMARY KEY (`c1`)
153 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
154 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
155 SHOW TABLES;
156 Tables_in_test
157 t5
158 SHOW CREATE TABLE t5;
159 Table Create Table
160 t5 CREATE TABLE `t5` (
161 `c1` int NOT NULL,
162 `c2` int NOT NULL,
163 `c4` char(5) DEFAULT NULL,
164 `c3` char(10) DEFAULT NULL,
165 PRIMARY KEY (`c1`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t5;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
171 SHOW TABLES;
172 Tables_in_test
173 t5
174 SHOW CREATE TABLE t5;
175 Table Create Table
176 t5 CREATE TABLE `t5` (
177 `c1` bigint NOT NULL,
178 `c2` int NOT NULL,
179 `c3` char(10) DEFAULT NULL,
180 PRIMARY KEY (`c1`)
181 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
182 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
183 SHOW TABLES;
184 Tables_in_test
185 t5
186 SHOW CREATE TABLE t5;
187 Table Create Table
188 t5 CREATE TABLE `t5` (
189 `c1` bigint NOT NULL,
190 `c2` int NOT NULL,
191 `c4` char(5) DEFAULT NULL,
192 `c3` char(10) DEFAULT NULL,
193 PRIMARY KEY (`c1`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t5;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
199 SHOW TABLES;
200 Tables_in_test
201 t5
202 SHOW CREATE TABLE t5;
203 Table Create Table
204 t5 CREATE TABLE `t5` (
205 `c1` double NOT NULL,
206 `c2` int NOT NULL,
207 `c3` char(10) DEFAULT NULL,
208 PRIMARY KEY (`c1`)
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
211 SHOW TABLES;
212 Tables_in_test
213 t5
214 SHOW CREATE TABLE t5;
215 Table Create Table
216 t5 CREATE TABLE `t5` (
217 `c1` double NOT NULL,
218 `c2` int NOT NULL,
219 `c4` char(5) DEFAULT NULL,
220 `c3` char(10) DEFAULT NULL,
221 PRIMARY KEY (`c1`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t5;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
227 SHOW TABLES;
228 Tables_in_test
229 t5
230 SHOW CREATE TABLE t5;
231 Table Create Table
232 t5 CREATE TABLE `t5` (
233 `c1` double NOT NULL,
234 `c2` int NOT NULL,
235 `c3` char(10) DEFAULT NULL,
236 PRIMARY KEY (`c1`)
237 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
238 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
239 SHOW TABLES;
240 Tables_in_test
241 t5
242 SHOW CREATE TABLE t5;
243 Table Create Table
244 t5 CREATE TABLE `t5` (
245 `c1` double NOT NULL,
246 `c2` int NOT NULL,
247 `c4` char(5) DEFAULT NULL,
248 `c3` char(10) DEFAULT NULL,
249 PRIMARY KEY (`c1`)
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
251 DROP TABLE t5;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t5
258 SHOW CREATE TABLE t5;
259 Table Create Table
260 t5 CREATE TABLE `t5` (
261 `c1` float NOT NULL,
262 `c2` int NOT NULL,
263 `c3` char(10) DEFAULT NULL,
264 PRIMARY KEY (`c1`)
265 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
266 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
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` float NOT NULL,
274 `c2` int NOT NULL,
275 `c4` char(5) DEFAULT NULL,
276 `c3` char(10) DEFAULT NULL,
277 PRIMARY KEY (`c1`)
278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 DROP TABLE t5;
280 SHOW TABLES;
281 Tables_in_test
282 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
283 SHOW TABLES;
284 Tables_in_test
285 t5
286 SHOW CREATE TABLE t5;
287 Table Create Table
288 t5 CREATE TABLE `t5` (
289 `c1` decimal(10,0) NOT NULL,
290 `c2` int NOT NULL,
291 `c3` char(10) DEFAULT NULL,
292 PRIMARY KEY (`c1`)
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
295 SHOW TABLES;
296 Tables_in_test
297 t5
298 SHOW CREATE TABLE t5;
299 Table Create Table
300 t5 CREATE TABLE `t5` (
301 `c1` decimal(10,0) NOT NULL,
302 `c2` int NOT NULL,
303 `c4` char(5) DEFAULT NULL,
304 `c3` char(10) DEFAULT NULL,
305 PRIMARY KEY (`c1`)
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 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) 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` decimal(10,0) NOT NULL,
318 `c2` int NOT NULL,
319 `c3` char(10) DEFAULT NULL,
320 PRIMARY KEY (`c1`)
321 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
322 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
323 SHOW TABLES;
324 Tables_in_test
325 t5
326 SHOW CREATE TABLE t5;
327 Table Create Table
328 t5 CREATE TABLE `t5` (
329 `c1` decimal(10,0) NOT NULL,
330 `c2` int NOT NULL,
331 `c4` char(5) DEFAULT NULL,
332 `c3` char(10) DEFAULT NULL,
333 PRIMARY KEY (`c1`)
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
335 DROP TABLE t5;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
339 SHOW TABLES;
340 Tables_in_test
341 t5
342 SHOW CREATE TABLE t5;
343 Table Create Table
344 t5 CREATE TABLE `t5` (
345 `c1` date NOT NULL,
346 `c2` int NOT NULL,
347 `c3` char(10) DEFAULT NULL,
348 PRIMARY KEY (`c1`)
349 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
350 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
351 SHOW TABLES;
352 Tables_in_test
353 t5
354 SHOW CREATE TABLE t5;
355 Table Create Table
356 t5 CREATE TABLE `t5` (
357 `c1` date NOT NULL,
358 `c2` int NOT NULL,
359 `c4` char(5) DEFAULT NULL,
360 `c3` char(10) DEFAULT NULL,
361 PRIMARY KEY (`c1`)
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 DROP TABLE t5;
364 SHOW TABLES;
365 Tables_in_test
366 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
367 SHOW TABLES;
368 Tables_in_test
369 t5
370 SHOW CREATE TABLE t5;
371 Table Create Table
372 t5 CREATE TABLE `t5` (
373 `c1` time NOT NULL,
374 `c2` int NOT NULL,
375 `c3` char(10) DEFAULT NULL,
376 PRIMARY KEY (`c1`)
377 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
378 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
379 SHOW TABLES;
380 Tables_in_test
381 t5
382 SHOW CREATE TABLE t5;
383 Table Create Table
384 t5 CREATE TABLE `t5` (
385 `c1` time NOT NULL,
386 `c2` int NOT NULL,
387 `c4` char(5) DEFAULT NULL,
388 `c3` char(10) DEFAULT NULL,
389 PRIMARY KEY (`c1`)
390 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
391 DROP TABLE t5;
392 SHOW TABLES;
393 Tables_in_test
394 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
395 SHOW TABLES;
396 Tables_in_test
397 t5
398 SHOW CREATE TABLE t5;
399 Table Create Table
400 t5 CREATE TABLE `t5` (
401 `c1` timestamp NOT NULL,
402 `c2` int NOT NULL,
403 `c3` char(10) DEFAULT NULL,
404 PRIMARY KEY (`c1`)
405 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
406 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
407 SHOW TABLES;
408 Tables_in_test
409 t5
410 SHOW CREATE TABLE t5;
411 Table Create Table
412 t5 CREATE TABLE `t5` (
413 `c1` timestamp NOT NULL,
414 `c2` int NOT NULL,
415 `c4` char(5) DEFAULT NULL,
416 `c3` char(10) DEFAULT NULL,
417 PRIMARY KEY (`c1`)
418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
419 DROP TABLE t5;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
423 SHOW TABLES;
424 Tables_in_test
425 t5
426 SHOW CREATE TABLE t5;
427 Table Create Table
428 t5 CREATE TABLE `t5` (
429 `c1` year NOT NULL,
430 `c2` int NOT NULL,
431 `c3` char(10) DEFAULT NULL,
432 PRIMARY KEY (`c1`)
433 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
434 ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
435 SHOW TABLES;
436 Tables_in_test
437 t5
438 SHOW CREATE TABLE t5;
439 Table Create Table
440 t5 CREATE TABLE `t5` (
441 `c1` year NOT NULL,
442 `c2` int NOT NULL,
443 `c4` char(5) DEFAULT NULL,
444 `c3` char(10) DEFAULT NULL,
445 PRIMARY KEY (`c1`)
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 DROP TABLE t5;
448 SHOW TABLES;
449 Tables_in_test
450 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
451 SHOW TABLES;
452 Tables_in_test
453 t5
454 SHOW CREATE TABLE t5;
455 Table Create Table
456 t5 CREATE TABLE `t5` (
457 `c1` bit(1) NOT NULL,
458 `c2` int NOT NULL,
459 `c3` char(10) NOT NULL,
460 PRIMARY KEY (`c1`)
461 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
462 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
463 SHOW TABLES;
464 Tables_in_test
465 t5
466 SHOW CREATE TABLE t5;
467 Table Create Table
468 t5 CREATE TABLE `t5` (
469 `c1` bit(1) NOT NULL,
470 `c2` int NOT NULL,
471 `c4` char(5) NOT NULL,
472 `c3` char(10) NOT NULL,
473 PRIMARY KEY (`c1`)
474 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
475 DROP TABLE t5;
476 SHOW TABLES;
477 Tables_in_test
478 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
479 SHOW TABLES;
480 Tables_in_test
481 t5
482 SHOW CREATE TABLE t5;
483 Table Create Table
484 t5 CREATE TABLE `t5` (
485 `c1` tinyint NOT NULL,
486 `c2` int NOT NULL,
487 `c3` char(10) NOT NULL,
488 PRIMARY KEY (`c1`)
489 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
490 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
491 SHOW TABLES;
492 Tables_in_test
493 t5
494 SHOW CREATE TABLE t5;
495 Table Create Table
496 t5 CREATE TABLE `t5` (
497 `c1` tinyint NOT NULL,
498 `c2` int NOT NULL,
499 `c4` char(5) NOT NULL,
500 `c3` char(10) NOT NULL,
501 PRIMARY KEY (`c1`)
502 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
503 DROP TABLE t5;
504 SHOW TABLES;
505 Tables_in_test
506 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
507 SHOW TABLES;
508 Tables_in_test
509 t5
510 SHOW CREATE TABLE t5;
511 Table Create Table
512 t5 CREATE TABLE `t5` (
513 `c1` smallint NOT NULL,
514 `c2` int NOT NULL,
515 `c3` char(10) NOT NULL,
516 PRIMARY KEY (`c1`)
517 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
518 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
519 SHOW TABLES;
520 Tables_in_test
521 t5
522 SHOW CREATE TABLE t5;
523 Table Create Table
524 t5 CREATE TABLE `t5` (
525 `c1` smallint NOT NULL,
526 `c2` int NOT NULL,
527 `c4` char(5) NOT NULL,
528 `c3` char(10) NOT NULL,
529 PRIMARY KEY (`c1`)
530 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
531 DROP TABLE t5;
532 SHOW TABLES;
533 Tables_in_test
534 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
535 SHOW TABLES;
536 Tables_in_test
537 t5
538 SHOW CREATE TABLE t5;
539 Table Create Table
540 t5 CREATE TABLE `t5` (
541 `c1` mediumint NOT NULL,
542 `c2` int NOT NULL,
543 `c3` char(10) NOT NULL,
544 PRIMARY KEY (`c1`)
545 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
546 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
547 SHOW TABLES;
548 Tables_in_test
549 t5
550 SHOW CREATE TABLE t5;
551 Table Create Table
552 t5 CREATE TABLE `t5` (
553 `c1` mediumint NOT NULL,
554 `c2` int NOT NULL,
555 `c4` char(5) NOT NULL,
556 `c3` char(10) NOT NULL,
557 PRIMARY KEY (`c1`)
558 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
559 DROP TABLE t5;
560 SHOW TABLES;
561 Tables_in_test
562 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
563 SHOW TABLES;
564 Tables_in_test
565 t5
566 SHOW CREATE TABLE t5;
567 Table Create Table
568 t5 CREATE TABLE `t5` (
569 `c1` int NOT NULL,
570 `c2` int NOT NULL,
571 `c3` char(10) NOT NULL,
572 PRIMARY KEY (`c1`)
573 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
574 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
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` int NOT NULL,
582 `c2` int NOT NULL,
583 `c4` char(5) NOT NULL,
584 `c3` char(10) NOT NULL,
585 PRIMARY KEY (`c1`)
586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
587 DROP TABLE t5;
588 SHOW TABLES;
589 Tables_in_test
590 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
591 SHOW TABLES;
592 Tables_in_test
593 t5
594 SHOW CREATE TABLE t5;
595 Table Create Table
596 t5 CREATE TABLE `t5` (
597 `c1` int NOT NULL,
598 `c2` int NOT NULL,
599 `c3` char(10) NOT NULL,
600 PRIMARY KEY (`c1`)
601 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
602 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
603 SHOW TABLES;
604 Tables_in_test
605 t5
606 SHOW CREATE TABLE t5;
607 Table Create Table
608 t5 CREATE TABLE `t5` (
609 `c1` int NOT NULL,
610 `c2` int NOT NULL,
611 `c4` char(5) NOT NULL,
612 `c3` char(10) NOT NULL,
613 PRIMARY KEY (`c1`)
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 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) 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` bigint NOT NULL,
626 `c2` int NOT NULL,
627 `c3` char(10) NOT NULL,
628 PRIMARY KEY (`c1`)
629 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
630 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
631 SHOW TABLES;
632 Tables_in_test
633 t5
634 SHOW CREATE TABLE t5;
635 Table Create Table
636 t5 CREATE TABLE `t5` (
637 `c1` bigint NOT NULL,
638 `c2` int NOT NULL,
639 `c4` char(5) NOT NULL,
640 `c3` char(10) NOT NULL,
641 PRIMARY KEY (`c1`)
642 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 DROP TABLE t5;
644 SHOW TABLES;
645 Tables_in_test
646 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
647 SHOW TABLES;
648 Tables_in_test
649 t5
650 SHOW CREATE TABLE t5;
651 Table Create Table
652 t5 CREATE TABLE `t5` (
653 `c1` double NOT NULL,
654 `c2` int NOT NULL,
655 `c3` char(10) NOT NULL,
656 PRIMARY KEY (`c1`)
657 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
658 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
659 SHOW TABLES;
660 Tables_in_test
661 t5
662 SHOW CREATE TABLE t5;
663 Table Create Table
664 t5 CREATE TABLE `t5` (
665 `c1` double NOT NULL,
666 `c2` int NOT NULL,
667 `c4` char(5) NOT NULL,
668 `c3` char(10) NOT NULL,
669 PRIMARY KEY (`c1`)
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
671 DROP TABLE t5;
672 SHOW TABLES;
673 Tables_in_test
674 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
675 SHOW TABLES;
676 Tables_in_test
677 t5
678 SHOW CREATE TABLE t5;
679 Table Create Table
680 t5 CREATE TABLE `t5` (
681 `c1` double NOT NULL,
682 `c2` int NOT NULL,
683 `c3` char(10) NOT NULL,
684 PRIMARY KEY (`c1`)
685 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
686 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
687 SHOW TABLES;
688 Tables_in_test
689 t5
690 SHOW CREATE TABLE t5;
691 Table Create Table
692 t5 CREATE TABLE `t5` (
693 `c1` double NOT NULL,
694 `c2` int NOT NULL,
695 `c4` char(5) NOT NULL,
696 `c3` char(10) NOT NULL,
697 PRIMARY KEY (`c1`)
698 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
699 DROP TABLE t5;
700 SHOW TABLES;
701 Tables_in_test
702 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
703 SHOW TABLES;
704 Tables_in_test
705 t5
706 SHOW CREATE TABLE t5;
707 Table Create Table
708 t5 CREATE TABLE `t5` (
709 `c1` float NOT NULL,
710 `c2` int NOT NULL,
711 `c3` char(10) NOT NULL,
712 PRIMARY KEY (`c1`)
713 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
714 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
715 SHOW TABLES;
716 Tables_in_test
717 t5
718 SHOW CREATE TABLE t5;
719 Table Create Table
720 t5 CREATE TABLE `t5` (
721 `c1` float NOT NULL,
722 `c2` int NOT NULL,
723 `c4` char(5) NOT NULL,
724 `c3` char(10) NOT NULL,
725 PRIMARY KEY (`c1`)
726 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
727 DROP TABLE t5;
728 SHOW TABLES;
729 Tables_in_test
730 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
731 SHOW TABLES;
732 Tables_in_test
733 t5
734 SHOW CREATE TABLE t5;
735 Table Create Table
736 t5 CREATE TABLE `t5` (
737 `c1` decimal(10,0) NOT NULL,
738 `c2` int NOT NULL,
739 `c3` char(10) NOT NULL,
740 PRIMARY KEY (`c1`)
741 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
742 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
743 SHOW TABLES;
744 Tables_in_test
745 t5
746 SHOW CREATE TABLE t5;
747 Table Create Table
748 t5 CREATE TABLE `t5` (
749 `c1` decimal(10,0) NOT NULL,
750 `c2` int NOT NULL,
751 `c4` char(5) NOT NULL,
752 `c3` char(10) NOT NULL,
753 PRIMARY KEY (`c1`)
754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
755 DROP TABLE t5;
756 SHOW TABLES;
757 Tables_in_test
758 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
759 SHOW TABLES;
760 Tables_in_test
761 t5
762 SHOW CREATE TABLE t5;
763 Table Create Table
764 t5 CREATE TABLE `t5` (
765 `c1` decimal(10,0) NOT NULL,
766 `c2` int NOT NULL,
767 `c3` char(10) NOT NULL,
768 PRIMARY KEY (`c1`)
769 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
770 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
771 SHOW TABLES;
772 Tables_in_test
773 t5
774 SHOW CREATE TABLE t5;
775 Table Create Table
776 t5 CREATE TABLE `t5` (
777 `c1` decimal(10,0) NOT NULL,
778 `c2` int NOT NULL,
779 `c4` char(5) NOT NULL,
780 `c3` char(10) NOT NULL,
781 PRIMARY KEY (`c1`)
782 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
783 DROP TABLE t5;
784 SHOW TABLES;
785 Tables_in_test
786 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
787 SHOW TABLES;
788 Tables_in_test
789 t5
790 SHOW CREATE TABLE t5;
791 Table Create Table
792 t5 CREATE TABLE `t5` (
793 `c1` date NOT NULL,
794 `c2` int NOT NULL,
795 `c3` char(10) NOT NULL,
796 PRIMARY KEY (`c1`)
797 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
798 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
799 SHOW TABLES;
800 Tables_in_test
801 t5
802 SHOW CREATE TABLE t5;
803 Table Create Table
804 t5 CREATE TABLE `t5` (
805 `c1` date NOT NULL,
806 `c2` int NOT NULL,
807 `c4` char(5) NOT NULL,
808 `c3` char(10) NOT NULL,
809 PRIMARY KEY (`c1`)
810 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
811 DROP TABLE t5;
812 SHOW TABLES;
813 Tables_in_test
814 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
815 SHOW TABLES;
816 Tables_in_test
817 t5
818 SHOW CREATE TABLE t5;
819 Table Create Table
820 t5 CREATE TABLE `t5` (
821 `c1` time NOT NULL,
822 `c2` int NOT NULL,
823 `c3` char(10) NOT NULL,
824 PRIMARY KEY (`c1`)
825 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
826 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
827 SHOW TABLES;
828 Tables_in_test
829 t5
830 SHOW CREATE TABLE t5;
831 Table Create Table
832 t5 CREATE TABLE `t5` (
833 `c1` time NOT NULL,
834 `c2` int NOT NULL,
835 `c4` char(5) NOT NULL,
836 `c3` char(10) NOT NULL,
837 PRIMARY KEY (`c1`)
838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
839 DROP TABLE t5;
840 SHOW TABLES;
841 Tables_in_test
842 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
843 SHOW TABLES;
844 Tables_in_test
845 t5
846 SHOW CREATE TABLE t5;
847 Table Create Table
848 t5 CREATE TABLE `t5` (
849 `c1` timestamp NOT NULL,
850 `c2` int NOT NULL,
851 `c3` char(10) NOT NULL,
852 PRIMARY KEY (`c1`)
853 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
854 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
855 SHOW TABLES;
856 Tables_in_test
857 t5
858 SHOW CREATE TABLE t5;
859 Table Create Table
860 t5 CREATE TABLE `t5` (
861 `c1` timestamp NOT NULL,
862 `c2` int NOT NULL,
863 `c4` char(5) NOT NULL,
864 `c3` char(10) NOT NULL,
865 PRIMARY KEY (`c1`)
866 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
867 DROP TABLE t5;
868 SHOW TABLES;
869 Tables_in_test
870 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
871 SHOW TABLES;
872 Tables_in_test
873 t5
874 SHOW CREATE TABLE t5;
875 Table Create Table
876 t5 CREATE TABLE `t5` (
877 `c1` year NOT NULL,
878 `c2` int NOT NULL,
879 `c3` char(10) NOT NULL,
880 PRIMARY KEY (`c1`)
881 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
882 ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
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` year NOT NULL,
890 `c2` int NOT NULL,
891 `c4` char(5) NOT NULL,
892 `c3` char(10) NOT NULL,
893 PRIMARY KEY (`c1`)
894 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
895 DROP TABLE t5;
896 SHOW TABLES;
897 Tables_in_test
898 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
899 SHOW TABLES;
900 Tables_in_test
901 t5
902 SHOW CREATE TABLE t5;
903 Table Create Table
904 t5 CREATE TABLE `t5` (
905 `c1` bit(1) NOT NULL,
906 `c2` int NOT NULL,
907 `c3` varchar(10) DEFAULT NULL,
908 PRIMARY KEY (`c1`)
909 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
910 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
911 SHOW TABLES;
912 Tables_in_test
913 t5
914 SHOW CREATE TABLE t5;
915 Table Create Table
916 t5 CREATE TABLE `t5` (
917 `c1` bit(1) NOT NULL,
918 `c2` int NOT NULL,
919 `c4` varchar(5) DEFAULT NULL,
920 `c3` varchar(10) DEFAULT NULL,
921 PRIMARY KEY (`c1`)
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 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) 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` tinyint NOT NULL,
934 `c2` int NOT NULL,
935 `c3` varchar(10) DEFAULT NULL,
936 PRIMARY KEY (`c1`)
937 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
938 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
939 SHOW TABLES;
940 Tables_in_test
941 t5
942 SHOW CREATE TABLE t5;
943 Table Create Table
944 t5 CREATE TABLE `t5` (
945 `c1` tinyint NOT NULL,
946 `c2` int NOT NULL,
947 `c4` varchar(5) DEFAULT NULL,
948 `c3` varchar(10) DEFAULT NULL,
949 PRIMARY KEY (`c1`)
950 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
951 DROP TABLE t5;
952 SHOW TABLES;
953 Tables_in_test
954 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
955 SHOW TABLES;
956 Tables_in_test
957 t5
958 SHOW CREATE TABLE t5;
959 Table Create Table
960 t5 CREATE TABLE `t5` (
961 `c1` smallint NOT NULL,
962 `c2` int NOT NULL,
963 `c3` varchar(10) DEFAULT NULL,
964 PRIMARY KEY (`c1`)
965 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
966 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
967 SHOW TABLES;
968 Tables_in_test
969 t5
970 SHOW CREATE TABLE t5;
971 Table Create Table
972 t5 CREATE TABLE `t5` (
973 `c1` smallint NOT NULL,
974 `c2` int NOT NULL,
975 `c4` varchar(5) DEFAULT NULL,
976 `c3` varchar(10) DEFAULT NULL,
977 PRIMARY KEY (`c1`)
978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
979 DROP TABLE t5;
980 SHOW TABLES;
981 Tables_in_test
982 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
983 SHOW TABLES;
984 Tables_in_test
985 t5
986 SHOW CREATE TABLE t5;
987 Table Create Table
988 t5 CREATE TABLE `t5` (
989 `c1` mediumint NOT NULL,
990 `c2` int NOT NULL,
991 `c3` varchar(10) DEFAULT NULL,
992 PRIMARY KEY (`c1`)
993 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
994 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
995 SHOW TABLES;
996 Tables_in_test
997 t5
998 SHOW CREATE TABLE t5;
999 Table Create Table
1000 t5 CREATE TABLE `t5` (
1001 `c1` mediumint NOT NULL,
1002 `c2` int NOT NULL,
1003 `c4` varchar(5) DEFAULT NULL,
1004 `c3` varchar(10) DEFAULT NULL,
1005 PRIMARY KEY (`c1`)
1006 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1007 DROP TABLE t5;
1008 SHOW TABLES;
1009 Tables_in_test
1010 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1011 SHOW TABLES;
1012 Tables_in_test
1013 t5
1014 SHOW CREATE TABLE t5;
1015 Table Create Table
1016 t5 CREATE TABLE `t5` (
1017 `c1` int NOT NULL,
1018 `c2` int NOT NULL,
1019 `c3` varchar(10) DEFAULT NULL,
1020 PRIMARY KEY (`c1`)
1021 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1022 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1023 SHOW TABLES;
1024 Tables_in_test
1025 t5
1026 SHOW CREATE TABLE t5;
1027 Table Create Table
1028 t5 CREATE TABLE `t5` (
1029 `c1` int NOT NULL,
1030 `c2` int NOT NULL,
1031 `c4` varchar(5) DEFAULT NULL,
1032 `c3` varchar(10) DEFAULT NULL,
1033 PRIMARY KEY (`c1`)
1034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1035 DROP TABLE t5;
1036 SHOW TABLES;
1037 Tables_in_test
1038 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1039 SHOW TABLES;
1040 Tables_in_test
1041 t5
1042 SHOW CREATE TABLE t5;
1043 Table Create Table
1044 t5 CREATE TABLE `t5` (
1045 `c1` int NOT NULL,
1046 `c2` int NOT NULL,
1047 `c3` varchar(10) DEFAULT NULL,
1048 PRIMARY KEY (`c1`)
1049 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1050 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1051 SHOW TABLES;
1052 Tables_in_test
1053 t5
1054 SHOW CREATE TABLE t5;
1055 Table Create Table
1056 t5 CREATE TABLE `t5` (
1057 `c1` int NOT NULL,
1058 `c2` int NOT NULL,
1059 `c4` varchar(5) DEFAULT NULL,
1060 `c3` varchar(10) DEFAULT NULL,
1061 PRIMARY KEY (`c1`)
1062 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1063 DROP TABLE t5;
1064 SHOW TABLES;
1065 Tables_in_test
1066 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1067 SHOW TABLES;
1068 Tables_in_test
1069 t5
1070 SHOW CREATE TABLE t5;
1071 Table Create Table
1072 t5 CREATE TABLE `t5` (
1073 `c1` bigint NOT NULL,
1074 `c2` int NOT NULL,
1075 `c3` varchar(10) DEFAULT NULL,
1076 PRIMARY KEY (`c1`)
1077 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1078 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1079 SHOW TABLES;
1080 Tables_in_test
1081 t5
1082 SHOW CREATE TABLE t5;
1083 Table Create Table
1084 t5 CREATE TABLE `t5` (
1085 `c1` bigint NOT NULL,
1086 `c2` int NOT NULL,
1087 `c4` varchar(5) DEFAULT NULL,
1088 `c3` varchar(10) DEFAULT NULL,
1089 PRIMARY KEY (`c1`)
1090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1091 DROP TABLE t5;
1092 SHOW TABLES;
1093 Tables_in_test
1094 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1095 SHOW TABLES;
1096 Tables_in_test
1097 t5
1098 SHOW CREATE TABLE t5;
1099 Table Create Table
1100 t5 CREATE TABLE `t5` (
1101 `c1` double NOT NULL,
1102 `c2` int NOT NULL,
1103 `c3` varchar(10) DEFAULT NULL,
1104 PRIMARY KEY (`c1`)
1105 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1106 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1107 SHOW TABLES;
1108 Tables_in_test
1109 t5
1110 SHOW CREATE TABLE t5;
1111 Table Create Table
1112 t5 CREATE TABLE `t5` (
1113 `c1` double NOT NULL,
1114 `c2` int NOT NULL,
1115 `c4` varchar(5) DEFAULT NULL,
1116 `c3` varchar(10) DEFAULT NULL,
1117 PRIMARY KEY (`c1`)
1118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1119 DROP TABLE t5;
1120 SHOW TABLES;
1121 Tables_in_test
1122 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1123 SHOW TABLES;
1124 Tables_in_test
1125 t5
1126 SHOW CREATE TABLE t5;
1127 Table Create Table
1128 t5 CREATE TABLE `t5` (
1129 `c1` double NOT NULL,
1130 `c2` int NOT NULL,
1131 `c3` varchar(10) DEFAULT NULL,
1132 PRIMARY KEY (`c1`)
1133 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1134 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1135 SHOW TABLES;
1136 Tables_in_test
1137 t5
1138 SHOW CREATE TABLE t5;
1139 Table Create Table
1140 t5 CREATE TABLE `t5` (
1141 `c1` double NOT NULL,
1142 `c2` int NOT NULL,
1143 `c4` varchar(5) DEFAULT NULL,
1144 `c3` varchar(10) DEFAULT NULL,
1145 PRIMARY KEY (`c1`)
1146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1147 DROP TABLE t5;
1148 SHOW TABLES;
1149 Tables_in_test
1150 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1151 SHOW TABLES;
1152 Tables_in_test
1153 t5
1154 SHOW CREATE TABLE t5;
1155 Table Create Table
1156 t5 CREATE TABLE `t5` (
1157 `c1` float NOT NULL,
1158 `c2` int NOT NULL,
1159 `c3` varchar(10) DEFAULT NULL,
1160 PRIMARY KEY (`c1`)
1161 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1162 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1163 SHOW TABLES;
1164 Tables_in_test
1165 t5
1166 SHOW CREATE TABLE t5;
1167 Table Create Table
1168 t5 CREATE TABLE `t5` (
1169 `c1` float NOT NULL,
1170 `c2` int NOT NULL,
1171 `c4` varchar(5) DEFAULT NULL,
1172 `c3` varchar(10) DEFAULT NULL,
1173 PRIMARY KEY (`c1`)
1174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1175 DROP TABLE t5;
1176 SHOW TABLES;
1177 Tables_in_test
1178 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1179 SHOW TABLES;
1180 Tables_in_test
1181 t5
1182 SHOW CREATE TABLE t5;
1183 Table Create Table
1184 t5 CREATE TABLE `t5` (
1185 `c1` decimal(10,0) NOT NULL,
1186 `c2` int NOT NULL,
1187 `c3` varchar(10) DEFAULT NULL,
1188 PRIMARY KEY (`c1`)
1189 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1190 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
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` decimal(10,0) NOT NULL,
1198 `c2` int NOT NULL,
1199 `c4` varchar(5) DEFAULT NULL,
1200 `c3` varchar(10) DEFAULT NULL,
1201 PRIMARY KEY (`c1`)
1202 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1203 DROP TABLE t5;
1204 SHOW TABLES;
1205 Tables_in_test
1206 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1207 SHOW TABLES;
1208 Tables_in_test
1209 t5
1210 SHOW CREATE TABLE t5;
1211 Table Create Table
1212 t5 CREATE TABLE `t5` (
1213 `c1` decimal(10,0) NOT NULL,
1214 `c2` int NOT NULL,
1215 `c3` varchar(10) DEFAULT NULL,
1216 PRIMARY KEY (`c1`)
1217 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1218 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1219 SHOW TABLES;
1220 Tables_in_test
1221 t5
1222 SHOW CREATE TABLE t5;
1223 Table Create Table
1224 t5 CREATE TABLE `t5` (
1225 `c1` decimal(10,0) NOT NULL,
1226 `c2` int NOT NULL,
1227 `c4` varchar(5) DEFAULT NULL,
1228 `c3` varchar(10) DEFAULT NULL,
1229 PRIMARY KEY (`c1`)
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 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) 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` date NOT NULL,
1242 `c2` int NOT NULL,
1243 `c3` varchar(10) DEFAULT NULL,
1244 PRIMARY KEY (`c1`)
1245 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1246 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1247 SHOW TABLES;
1248 Tables_in_test
1249 t5
1250 SHOW CREATE TABLE t5;
1251 Table Create Table
1252 t5 CREATE TABLE `t5` (
1253 `c1` date NOT NULL,
1254 `c2` int NOT NULL,
1255 `c4` varchar(5) DEFAULT NULL,
1256 `c3` varchar(10) DEFAULT NULL,
1257 PRIMARY KEY (`c1`)
1258 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1259 DROP TABLE t5;
1260 SHOW TABLES;
1261 Tables_in_test
1262 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1263 SHOW TABLES;
1264 Tables_in_test
1265 t5
1266 SHOW CREATE TABLE t5;
1267 Table Create Table
1268 t5 CREATE TABLE `t5` (
1269 `c1` time NOT NULL,
1270 `c2` int NOT NULL,
1271 `c3` varchar(10) DEFAULT NULL,
1272 PRIMARY KEY (`c1`)
1273 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1274 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1275 SHOW TABLES;
1276 Tables_in_test
1277 t5
1278 SHOW CREATE TABLE t5;
1279 Table Create Table
1280 t5 CREATE TABLE `t5` (
1281 `c1` time NOT NULL,
1282 `c2` int NOT NULL,
1283 `c4` varchar(5) DEFAULT NULL,
1284 `c3` varchar(10) DEFAULT NULL,
1285 PRIMARY KEY (`c1`)
1286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1287 DROP TABLE t5;
1288 SHOW TABLES;
1289 Tables_in_test
1290 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1291 SHOW TABLES;
1292 Tables_in_test
1293 t5
1294 SHOW CREATE TABLE t5;
1295 Table Create Table
1296 t5 CREATE TABLE `t5` (
1297 `c1` timestamp NOT NULL,
1298 `c2` int NOT NULL,
1299 `c3` varchar(10) DEFAULT NULL,
1300 PRIMARY KEY (`c1`)
1301 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1302 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1303 SHOW TABLES;
1304 Tables_in_test
1305 t5
1306 SHOW CREATE TABLE t5;
1307 Table Create Table
1308 t5 CREATE TABLE `t5` (
1309 `c1` timestamp NOT NULL,
1310 `c2` int NOT NULL,
1311 `c4` varchar(5) DEFAULT NULL,
1312 `c3` varchar(10) DEFAULT NULL,
1313 PRIMARY KEY (`c1`)
1314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1315 DROP TABLE t5;
1316 SHOW TABLES;
1317 Tables_in_test
1318 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1319 SHOW TABLES;
1320 Tables_in_test
1321 t5
1322 SHOW CREATE TABLE t5;
1323 Table Create Table
1324 t5 CREATE TABLE `t5` (
1325 `c1` year NOT NULL,
1326 `c2` int NOT NULL,
1327 `c3` varchar(10) DEFAULT NULL,
1328 PRIMARY KEY (`c1`)
1329 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1330 ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1331 SHOW TABLES;
1332 Tables_in_test
1333 t5
1334 SHOW CREATE TABLE t5;
1335 Table Create Table
1336 t5 CREATE TABLE `t5` (
1337 `c1` year NOT NULL,
1338 `c2` int NOT NULL,
1339 `c4` varchar(5) DEFAULT NULL,
1340 `c3` varchar(10) DEFAULT NULL,
1341 PRIMARY KEY (`c1`)
1342 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1343 DROP TABLE t5;
1344 SHOW TABLES;
1345 Tables_in_test
1346 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1347 SHOW TABLES;
1348 Tables_in_test
1349 t5
1350 SHOW CREATE TABLE t5;
1351 Table Create Table
1352 t5 CREATE TABLE `t5` (
1353 `c1` bit(1) NOT NULL,
1354 `c2` int NOT NULL,
1355 `c3` varchar(10) NOT NULL,
1356 PRIMARY KEY (`c1`)
1357 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1358 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1359 SHOW TABLES;
1360 Tables_in_test
1361 t5
1362 SHOW CREATE TABLE t5;
1363 Table Create Table
1364 t5 CREATE TABLE `t5` (
1365 `c1` bit(1) NOT NULL,
1366 `c2` int NOT NULL,
1367 `c4` varchar(5) NOT NULL,
1368 `c3` varchar(10) NOT NULL,
1369 PRIMARY KEY (`c1`)
1370 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1371 DROP TABLE t5;
1372 SHOW TABLES;
1373 Tables_in_test
1374 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1375 SHOW TABLES;
1376 Tables_in_test
1377 t5
1378 SHOW CREATE TABLE t5;
1379 Table Create Table
1380 t5 CREATE TABLE `t5` (
1381 `c1` tinyint NOT NULL,
1382 `c2` int NOT NULL,
1383 `c3` varchar(10) NOT NULL,
1384 PRIMARY KEY (`c1`)
1385 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1386 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1387 SHOW TABLES;
1388 Tables_in_test
1389 t5
1390 SHOW CREATE TABLE t5;
1391 Table Create Table
1392 t5 CREATE TABLE `t5` (
1393 `c1` tinyint NOT NULL,
1394 `c2` int NOT NULL,
1395 `c4` varchar(5) NOT NULL,
1396 `c3` varchar(10) NOT NULL,
1397 PRIMARY KEY (`c1`)
1398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1399 DROP TABLE t5;
1400 SHOW TABLES;
1401 Tables_in_test
1402 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1403 SHOW TABLES;
1404 Tables_in_test
1405 t5
1406 SHOW CREATE TABLE t5;
1407 Table Create Table
1408 t5 CREATE TABLE `t5` (
1409 `c1` smallint NOT NULL,
1410 `c2` int NOT NULL,
1411 `c3` varchar(10) NOT NULL,
1412 PRIMARY KEY (`c1`)
1413 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1414 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1415 SHOW TABLES;
1416 Tables_in_test
1417 t5
1418 SHOW CREATE TABLE t5;
1419 Table Create Table
1420 t5 CREATE TABLE `t5` (
1421 `c1` smallint NOT NULL,
1422 `c2` int NOT NULL,
1423 `c4` varchar(5) NOT NULL,
1424 `c3` varchar(10) NOT NULL,
1425 PRIMARY KEY (`c1`)
1426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1427 DROP TABLE t5;
1428 SHOW TABLES;
1429 Tables_in_test
1430 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1431 SHOW TABLES;
1432 Tables_in_test
1433 t5
1434 SHOW CREATE TABLE t5;
1435 Table Create Table
1436 t5 CREATE TABLE `t5` (
1437 `c1` mediumint NOT NULL,
1438 `c2` int NOT NULL,
1439 `c3` varchar(10) NOT NULL,
1440 PRIMARY KEY (`c1`)
1441 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1442 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1443 SHOW TABLES;
1444 Tables_in_test
1445 t5
1446 SHOW CREATE TABLE t5;
1447 Table Create Table
1448 t5 CREATE TABLE `t5` (
1449 `c1` mediumint NOT NULL,
1450 `c2` int NOT NULL,
1451 `c4` varchar(5) NOT NULL,
1452 `c3` varchar(10) NOT NULL,
1453 PRIMARY KEY (`c1`)
1454 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1455 DROP TABLE t5;
1456 SHOW TABLES;
1457 Tables_in_test
1458 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1459 SHOW TABLES;
1460 Tables_in_test
1461 t5
1462 SHOW CREATE TABLE t5;
1463 Table Create Table
1464 t5 CREATE TABLE `t5` (
1465 `c1` int NOT NULL,
1466 `c2` int NOT NULL,
1467 `c3` varchar(10) NOT NULL,
1468 PRIMARY KEY (`c1`)
1469 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1470 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1471 SHOW TABLES;
1472 Tables_in_test
1473 t5
1474 SHOW CREATE TABLE t5;
1475 Table Create Table
1476 t5 CREATE TABLE `t5` (
1477 `c1` int NOT NULL,
1478 `c2` int NOT NULL,
1479 `c4` varchar(5) NOT NULL,
1480 `c3` varchar(10) NOT NULL,
1481 PRIMARY KEY (`c1`)
1482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1483 DROP TABLE t5;
1484 SHOW TABLES;
1485 Tables_in_test
1486 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1487 SHOW TABLES;
1488 Tables_in_test
1489 t5
1490 SHOW CREATE TABLE t5;
1491 Table Create Table
1492 t5 CREATE TABLE `t5` (
1493 `c1` int NOT NULL,
1494 `c2` int NOT NULL,
1495 `c3` varchar(10) NOT NULL,
1496 PRIMARY KEY (`c1`)
1497 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1498 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
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` int NOT NULL,
1506 `c2` int NOT NULL,
1507 `c4` varchar(5) NOT NULL,
1508 `c3` varchar(10) NOT NULL,
1509 PRIMARY KEY (`c1`)
1510 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1511 DROP TABLE t5;
1512 SHOW TABLES;
1513 Tables_in_test
1514 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1515 SHOW TABLES;
1516 Tables_in_test
1517 t5
1518 SHOW CREATE TABLE t5;
1519 Table Create Table
1520 t5 CREATE TABLE `t5` (
1521 `c1` bigint NOT NULL,
1522 `c2` int NOT NULL,
1523 `c3` varchar(10) NOT NULL,
1524 PRIMARY KEY (`c1`)
1525 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1526 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1527 SHOW TABLES;
1528 Tables_in_test
1529 t5
1530 SHOW CREATE TABLE t5;
1531 Table Create Table
1532 t5 CREATE TABLE `t5` (
1533 `c1` bigint NOT NULL,
1534 `c2` int NOT NULL,
1535 `c4` varchar(5) NOT NULL,
1536 `c3` varchar(10) NOT NULL,
1537 PRIMARY KEY (`c1`)
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 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT 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` double NOT NULL,
1550 `c2` int NOT NULL,
1551 `c3` varchar(10) NOT NULL,
1552 PRIMARY KEY (`c1`)
1553 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1554 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1555 SHOW TABLES;
1556 Tables_in_test
1557 t5
1558 SHOW CREATE TABLE t5;
1559 Table Create Table
1560 t5 CREATE TABLE `t5` (
1561 `c1` double NOT NULL,
1562 `c2` int NOT NULL,
1563 `c4` varchar(5) NOT NULL,
1564 `c3` varchar(10) NOT NULL,
1565 PRIMARY KEY (`c1`)
1566 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1567 DROP TABLE t5;
1568 SHOW TABLES;
1569 Tables_in_test
1570 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1571 SHOW TABLES;
1572 Tables_in_test
1573 t5
1574 SHOW CREATE TABLE t5;
1575 Table Create Table
1576 t5 CREATE TABLE `t5` (
1577 `c1` double NOT NULL,
1578 `c2` int NOT NULL,
1579 `c3` varchar(10) NOT NULL,
1580 PRIMARY KEY (`c1`)
1581 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1582 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1583 SHOW TABLES;
1584 Tables_in_test
1585 t5
1586 SHOW CREATE TABLE t5;
1587 Table Create Table
1588 t5 CREATE TABLE `t5` (
1589 `c1` double NOT NULL,
1590 `c2` int NOT NULL,
1591 `c4` varchar(5) NOT NULL,
1592 `c3` varchar(10) NOT NULL,
1593 PRIMARY KEY (`c1`)
1594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1595 DROP TABLE t5;
1596 SHOW TABLES;
1597 Tables_in_test
1598 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1599 SHOW TABLES;
1600 Tables_in_test
1601 t5
1602 SHOW CREATE TABLE t5;
1603 Table Create Table
1604 t5 CREATE TABLE `t5` (
1605 `c1` float NOT NULL,
1606 `c2` int NOT NULL,
1607 `c3` varchar(10) NOT NULL,
1608 PRIMARY KEY (`c1`)
1609 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1610 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1611 SHOW TABLES;
1612 Tables_in_test
1613 t5
1614 SHOW CREATE TABLE t5;
1615 Table Create Table
1616 t5 CREATE TABLE `t5` (
1617 `c1` float NOT NULL,
1618 `c2` int NOT NULL,
1619 `c4` varchar(5) NOT NULL,
1620 `c3` varchar(10) NOT NULL,
1621 PRIMARY KEY (`c1`)
1622 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1623 DROP TABLE t5;
1624 SHOW TABLES;
1625 Tables_in_test
1626 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1627 SHOW TABLES;
1628 Tables_in_test
1629 t5
1630 SHOW CREATE TABLE t5;
1631 Table Create Table
1632 t5 CREATE TABLE `t5` (
1633 `c1` decimal(10,0) NOT NULL,
1634 `c2` int NOT NULL,
1635 `c3` varchar(10) NOT NULL,
1636 PRIMARY KEY (`c1`)
1637 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1638 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1639 SHOW TABLES;
1640 Tables_in_test
1641 t5
1642 SHOW CREATE TABLE t5;
1643 Table Create Table
1644 t5 CREATE TABLE `t5` (
1645 `c1` decimal(10,0) NOT NULL,
1646 `c2` int NOT NULL,
1647 `c4` varchar(5) NOT NULL,
1648 `c3` varchar(10) NOT NULL,
1649 PRIMARY KEY (`c1`)
1650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1651 DROP TABLE t5;
1652 SHOW TABLES;
1653 Tables_in_test
1654 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1655 SHOW TABLES;
1656 Tables_in_test
1657 t5
1658 SHOW CREATE TABLE t5;
1659 Table Create Table
1660 t5 CREATE TABLE `t5` (
1661 `c1` decimal(10,0) NOT NULL,
1662 `c2` int NOT NULL,
1663 `c3` varchar(10) NOT NULL,
1664 PRIMARY KEY (`c1`)
1665 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1666 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1667 SHOW TABLES;
1668 Tables_in_test
1669 t5
1670 SHOW CREATE TABLE t5;
1671 Table Create Table
1672 t5 CREATE TABLE `t5` (
1673 `c1` decimal(10,0) NOT NULL,
1674 `c2` int NOT NULL,
1675 `c4` varchar(5) NOT NULL,
1676 `c3` varchar(10) NOT NULL,
1677 PRIMARY KEY (`c1`)
1678 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1679 DROP TABLE t5;
1680 SHOW TABLES;
1681 Tables_in_test
1682 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1683 SHOW TABLES;
1684 Tables_in_test
1685 t5
1686 SHOW CREATE TABLE t5;
1687 Table Create Table
1688 t5 CREATE TABLE `t5` (
1689 `c1` date NOT NULL,
1690 `c2` int NOT NULL,
1691 `c3` varchar(10) NOT NULL,
1692 PRIMARY KEY (`c1`)
1693 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1694 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1695 SHOW TABLES;
1696 Tables_in_test
1697 t5
1698 SHOW CREATE TABLE t5;
1699 Table Create Table
1700 t5 CREATE TABLE `t5` (
1701 `c1` date NOT NULL,
1702 `c2` int NOT NULL,
1703 `c4` varchar(5) NOT NULL,
1704 `c3` varchar(10) NOT NULL,
1705 PRIMARY KEY (`c1`)
1706 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1707 DROP TABLE t5;
1708 SHOW TABLES;
1709 Tables_in_test
1710 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1711 SHOW TABLES;
1712 Tables_in_test
1713 t5
1714 SHOW CREATE TABLE t5;
1715 Table Create Table
1716 t5 CREATE TABLE `t5` (
1717 `c1` time NOT NULL,
1718 `c2` int NOT NULL,
1719 `c3` varchar(10) NOT NULL,
1720 PRIMARY KEY (`c1`)
1721 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1722 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1723 SHOW TABLES;
1724 Tables_in_test
1725 t5
1726 SHOW CREATE TABLE t5;
1727 Table Create Table
1728 t5 CREATE TABLE `t5` (
1729 `c1` time NOT NULL,
1730 `c2` int NOT NULL,
1731 `c4` varchar(5) NOT NULL,
1732 `c3` varchar(10) NOT NULL,
1733 PRIMARY KEY (`c1`)
1734 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1735 DROP TABLE t5;
1736 SHOW TABLES;
1737 Tables_in_test
1738 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1739 SHOW TABLES;
1740 Tables_in_test
1741 t5
1742 SHOW CREATE TABLE t5;
1743 Table Create Table
1744 t5 CREATE TABLE `t5` (
1745 `c1` timestamp NOT NULL,
1746 `c2` int NOT NULL,
1747 `c3` varchar(10) NOT NULL,
1748 PRIMARY KEY (`c1`)
1749 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1750 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1751 SHOW TABLES;
1752 Tables_in_test
1753 t5
1754 SHOW CREATE TABLE t5;
1755 Table Create Table
1756 t5 CREATE TABLE `t5` (
1757 `c1` timestamp NOT NULL,
1758 `c2` int NOT NULL,
1759 `c4` varchar(5) NOT NULL,
1760 `c3` varchar(10) NOT NULL,
1761 PRIMARY KEY (`c1`)
1762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1763 DROP TABLE t5;
1764 SHOW TABLES;
1765 Tables_in_test
1766 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1767 SHOW TABLES;
1768 Tables_in_test
1769 t5
1770 SHOW CREATE TABLE t5;
1771 Table Create Table
1772 t5 CREATE TABLE `t5` (
1773 `c1` year NOT NULL,
1774 `c2` int NOT NULL,
1775 `c3` varchar(10) NOT NULL,
1776 PRIMARY KEY (`c1`)
1777 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1778 ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1779 SHOW TABLES;
1780 Tables_in_test
1781 t5
1782 SHOW CREATE TABLE t5;
1783 Table Create Table
1784 t5 CREATE TABLE `t5` (
1785 `c1` year NOT NULL,
1786 `c2` int NOT NULL,
1787 `c4` varchar(5) NOT NULL,
1788 `c3` varchar(10) NOT NULL,
1789 PRIMARY KEY (`c1`)
1790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1791 DROP TABLE t5;
1792 SHOW TABLES;
1793 Tables_in_test
1794 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1795 SHOW TABLES;
1796 Tables_in_test
1797 t5
1798 SHOW CREATE TABLE t5;
1799 Table Create Table
1800 t5 CREATE TABLE `t5` (
1801 `c1` bit(1) NOT NULL,
1802 `c2` int NOT NULL,
1803 `c3` binary(10) DEFAULT NULL,
1804 PRIMARY KEY (`c1`)
1805 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1806 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
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` bit(1) NOT NULL,
1814 `c2` int NOT NULL,
1815 `c4` binary(5) DEFAULT NULL,
1816 `c3` binary(10) DEFAULT NULL,
1817 PRIMARY KEY (`c1`)
1818 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1819 DROP TABLE t5;
1820 SHOW TABLES;
1821 Tables_in_test
1822 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1823 SHOW TABLES;
1824 Tables_in_test
1825 t5
1826 SHOW CREATE TABLE t5;
1827 Table Create Table
1828 t5 CREATE TABLE `t5` (
1829 `c1` tinyint NOT NULL,
1830 `c2` int NOT NULL,
1831 `c3` binary(10) DEFAULT NULL,
1832 PRIMARY KEY (`c1`)
1833 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1834 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1835 SHOW TABLES;
1836 Tables_in_test
1837 t5
1838 SHOW CREATE TABLE t5;
1839 Table Create Table
1840 t5 CREATE TABLE `t5` (
1841 `c1` tinyint NOT NULL,
1842 `c2` int NOT NULL,
1843 `c4` binary(5) DEFAULT NULL,
1844 `c3` binary(10) DEFAULT NULL,
1845 PRIMARY KEY (`c1`)
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 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) 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` smallint NOT NULL,
1858 `c2` int NOT NULL,
1859 `c3` binary(10) DEFAULT NULL,
1860 PRIMARY KEY (`c1`)
1861 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1862 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1863 SHOW TABLES;
1864 Tables_in_test
1865 t5
1866 SHOW CREATE TABLE t5;
1867 Table Create Table
1868 t5 CREATE TABLE `t5` (
1869 `c1` smallint NOT NULL,
1870 `c2` int NOT NULL,
1871 `c4` binary(5) DEFAULT NULL,
1872 `c3` binary(10) DEFAULT NULL,
1873 PRIMARY KEY (`c1`)
1874 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1875 DROP TABLE t5;
1876 SHOW TABLES;
1877 Tables_in_test
1878 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1879 SHOW TABLES;
1880 Tables_in_test
1881 t5
1882 SHOW CREATE TABLE t5;
1883 Table Create Table
1884 t5 CREATE TABLE `t5` (
1885 `c1` mediumint NOT NULL,
1886 `c2` int NOT NULL,
1887 `c3` binary(10) DEFAULT NULL,
1888 PRIMARY KEY (`c1`)
1889 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1890 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1891 SHOW TABLES;
1892 Tables_in_test
1893 t5
1894 SHOW CREATE TABLE t5;
1895 Table Create Table
1896 t5 CREATE TABLE `t5` (
1897 `c1` mediumint NOT NULL,
1898 `c2` int NOT NULL,
1899 `c4` binary(5) DEFAULT NULL,
1900 `c3` binary(10) DEFAULT NULL,
1901 PRIMARY KEY (`c1`)
1902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1903 DROP TABLE t5;
1904 SHOW TABLES;
1905 Tables_in_test
1906 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1907 SHOW TABLES;
1908 Tables_in_test
1909 t5
1910 SHOW CREATE TABLE t5;
1911 Table Create Table
1912 t5 CREATE TABLE `t5` (
1913 `c1` int NOT NULL,
1914 `c2` int NOT NULL,
1915 `c3` binary(10) DEFAULT NULL,
1916 PRIMARY KEY (`c1`)
1917 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1918 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1919 SHOW TABLES;
1920 Tables_in_test
1921 t5
1922 SHOW CREATE TABLE t5;
1923 Table Create Table
1924 t5 CREATE TABLE `t5` (
1925 `c1` int NOT NULL,
1926 `c2` int NOT NULL,
1927 `c4` binary(5) DEFAULT NULL,
1928 `c3` binary(10) DEFAULT NULL,
1929 PRIMARY KEY (`c1`)
1930 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1931 DROP TABLE t5;
1932 SHOW TABLES;
1933 Tables_in_test
1934 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1935 SHOW TABLES;
1936 Tables_in_test
1937 t5
1938 SHOW CREATE TABLE t5;
1939 Table Create Table
1940 t5 CREATE TABLE `t5` (
1941 `c1` int NOT NULL,
1942 `c2` int NOT NULL,
1943 `c3` binary(10) DEFAULT NULL,
1944 PRIMARY KEY (`c1`)
1945 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1946 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1947 SHOW TABLES;
1948 Tables_in_test
1949 t5
1950 SHOW CREATE TABLE t5;
1951 Table Create Table
1952 t5 CREATE TABLE `t5` (
1953 `c1` int NOT NULL,
1954 `c2` int NOT NULL,
1955 `c4` binary(5) DEFAULT NULL,
1956 `c3` binary(10) DEFAULT NULL,
1957 PRIMARY KEY (`c1`)
1958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1959 DROP TABLE t5;
1960 SHOW TABLES;
1961 Tables_in_test
1962 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1963 SHOW TABLES;
1964 Tables_in_test
1965 t5
1966 SHOW CREATE TABLE t5;
1967 Table Create Table
1968 t5 CREATE TABLE `t5` (
1969 `c1` bigint NOT NULL,
1970 `c2` int NOT NULL,
1971 `c3` binary(10) DEFAULT NULL,
1972 PRIMARY KEY (`c1`)
1973 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1974 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1975 SHOW TABLES;
1976 Tables_in_test
1977 t5
1978 SHOW CREATE TABLE t5;
1979 Table Create Table
1980 t5 CREATE TABLE `t5` (
1981 `c1` bigint NOT NULL,
1982 `c2` int NOT NULL,
1983 `c4` binary(5) DEFAULT NULL,
1984 `c3` binary(10) DEFAULT NULL,
1985 PRIMARY KEY (`c1`)
1986 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1987 DROP TABLE t5;
1988 SHOW TABLES;
1989 Tables_in_test
1990 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1991 SHOW TABLES;
1992 Tables_in_test
1993 t5
1994 SHOW CREATE TABLE t5;
1995 Table Create Table
1996 t5 CREATE TABLE `t5` (
1997 `c1` double NOT NULL,
1998 `c2` int NOT NULL,
1999 `c3` binary(10) DEFAULT NULL,
2000 PRIMARY KEY (`c1`)
2001 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2002 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2003 SHOW TABLES;
2004 Tables_in_test
2005 t5
2006 SHOW CREATE TABLE t5;
2007 Table Create Table
2008 t5 CREATE TABLE `t5` (
2009 `c1` double NOT NULL,
2010 `c2` int NOT NULL,
2011 `c4` binary(5) DEFAULT NULL,
2012 `c3` binary(10) DEFAULT NULL,
2013 PRIMARY KEY (`c1`)
2014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2015 DROP TABLE t5;
2016 SHOW TABLES;
2017 Tables_in_test
2018 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2019 SHOW TABLES;
2020 Tables_in_test
2021 t5
2022 SHOW CREATE TABLE t5;
2023 Table Create Table
2024 t5 CREATE TABLE `t5` (
2025 `c1` double NOT NULL,
2026 `c2` int NOT NULL,
2027 `c3` binary(10) DEFAULT NULL,
2028 PRIMARY KEY (`c1`)
2029 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2030 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2031 SHOW TABLES;
2032 Tables_in_test
2033 t5
2034 SHOW CREATE TABLE t5;
2035 Table Create Table
2036 t5 CREATE TABLE `t5` (
2037 `c1` double NOT NULL,
2038 `c2` int NOT NULL,
2039 `c4` binary(5) DEFAULT NULL,
2040 `c3` binary(10) DEFAULT NULL,
2041 PRIMARY KEY (`c1`)
2042 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2043 DROP TABLE t5;
2044 SHOW TABLES;
2045 Tables_in_test
2046 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2047 SHOW TABLES;
2048 Tables_in_test
2049 t5
2050 SHOW CREATE TABLE t5;
2051 Table Create Table
2052 t5 CREATE TABLE `t5` (
2053 `c1` float NOT NULL,
2054 `c2` int NOT NULL,
2055 `c3` binary(10) DEFAULT NULL,
2056 PRIMARY KEY (`c1`)
2057 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2058 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2059 SHOW TABLES;
2060 Tables_in_test
2061 t5
2062 SHOW CREATE TABLE t5;
2063 Table Create Table
2064 t5 CREATE TABLE `t5` (
2065 `c1` float NOT NULL,
2066 `c2` int NOT NULL,
2067 `c4` binary(5) DEFAULT NULL,
2068 `c3` binary(10) DEFAULT NULL,
2069 PRIMARY KEY (`c1`)
2070 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2071 DROP TABLE t5;
2072 SHOW TABLES;
2073 Tables_in_test
2074 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2075 SHOW TABLES;
2076 Tables_in_test
2077 t5
2078 SHOW CREATE TABLE t5;
2079 Table Create Table
2080 t5 CREATE TABLE `t5` (
2081 `c1` decimal(10,0) NOT NULL,
2082 `c2` int NOT NULL,
2083 `c3` binary(10) DEFAULT NULL,
2084 PRIMARY KEY (`c1`)
2085 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2086 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2087 SHOW TABLES;
2088 Tables_in_test
2089 t5
2090 SHOW CREATE TABLE t5;
2091 Table Create Table
2092 t5 CREATE TABLE `t5` (
2093 `c1` decimal(10,0) NOT NULL,
2094 `c2` int NOT NULL,
2095 `c4` binary(5) DEFAULT NULL,
2096 `c3` binary(10) DEFAULT NULL,
2097 PRIMARY KEY (`c1`)
2098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2099 DROP TABLE t5;
2100 SHOW TABLES;
2101 Tables_in_test
2102 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2103 SHOW TABLES;
2104 Tables_in_test
2105 t5
2106 SHOW CREATE TABLE t5;
2107 Table Create Table
2108 t5 CREATE TABLE `t5` (
2109 `c1` decimal(10,0) NOT NULL,
2110 `c2` int NOT NULL,
2111 `c3` binary(10) DEFAULT NULL,
2112 PRIMARY KEY (`c1`)
2113 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2114 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
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` decimal(10,0) NOT NULL,
2122 `c2` int NOT NULL,
2123 `c4` binary(5) DEFAULT NULL,
2124 `c3` binary(10) DEFAULT NULL,
2125 PRIMARY KEY (`c1`)
2126 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2127 DROP TABLE t5;
2128 SHOW TABLES;
2129 Tables_in_test
2130 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2131 SHOW TABLES;
2132 Tables_in_test
2133 t5
2134 SHOW CREATE TABLE t5;
2135 Table Create Table
2136 t5 CREATE TABLE `t5` (
2137 `c1` date NOT NULL,
2138 `c2` int NOT NULL,
2139 `c3` binary(10) DEFAULT NULL,
2140 PRIMARY KEY (`c1`)
2141 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2142 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2143 SHOW TABLES;
2144 Tables_in_test
2145 t5
2146 SHOW CREATE TABLE t5;
2147 Table Create Table
2148 t5 CREATE TABLE `t5` (
2149 `c1` date NOT NULL,
2150 `c2` int NOT NULL,
2151 `c4` binary(5) DEFAULT NULL,
2152 `c3` binary(10) DEFAULT NULL,
2153 PRIMARY KEY (`c1`)
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 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) 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` time NOT NULL,
2166 `c2` int NOT NULL,
2167 `c3` binary(10) DEFAULT NULL,
2168 PRIMARY KEY (`c1`)
2169 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2170 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2171 SHOW TABLES;
2172 Tables_in_test
2173 t5
2174 SHOW CREATE TABLE t5;
2175 Table Create Table
2176 t5 CREATE TABLE `t5` (
2177 `c1` time NOT NULL,
2178 `c2` int NOT NULL,
2179 `c4` binary(5) DEFAULT NULL,
2180 `c3` binary(10) DEFAULT NULL,
2181 PRIMARY KEY (`c1`)
2182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2183 DROP TABLE t5;
2184 SHOW TABLES;
2185 Tables_in_test
2186 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2187 SHOW TABLES;
2188 Tables_in_test
2189 t5
2190 SHOW CREATE TABLE t5;
2191 Table Create Table
2192 t5 CREATE TABLE `t5` (
2193 `c1` timestamp NOT NULL,
2194 `c2` int NOT NULL,
2195 `c3` binary(10) DEFAULT NULL,
2196 PRIMARY KEY (`c1`)
2197 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2198 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2199 SHOW TABLES;
2200 Tables_in_test
2201 t5
2202 SHOW CREATE TABLE t5;
2203 Table Create Table
2204 t5 CREATE TABLE `t5` (
2205 `c1` timestamp NOT NULL,
2206 `c2` int NOT NULL,
2207 `c4` binary(5) DEFAULT NULL,
2208 `c3` binary(10) DEFAULT NULL,
2209 PRIMARY KEY (`c1`)
2210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2211 DROP TABLE t5;
2212 SHOW TABLES;
2213 Tables_in_test
2214 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2215 SHOW TABLES;
2216 Tables_in_test
2217 t5
2218 SHOW CREATE TABLE t5;
2219 Table Create Table
2220 t5 CREATE TABLE `t5` (
2221 `c1` year NOT NULL,
2222 `c2` int NOT NULL,
2223 `c3` binary(10) DEFAULT NULL,
2224 PRIMARY KEY (`c1`)
2225 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2226 ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2227 SHOW TABLES;
2228 Tables_in_test
2229 t5
2230 SHOW CREATE TABLE t5;
2231 Table Create Table
2232 t5 CREATE TABLE `t5` (
2233 `c1` year NOT NULL,
2234 `c2` int NOT NULL,
2235 `c4` binary(5) DEFAULT NULL,
2236 `c3` binary(10) DEFAULT NULL,
2237 PRIMARY KEY (`c1`)
2238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2239 DROP TABLE t5;
2240 SHOW TABLES;
2241 Tables_in_test
2242 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2243 SHOW TABLES;
2244 Tables_in_test
2245 t5
2246 SHOW CREATE TABLE t5;
2247 Table Create Table
2248 t5 CREATE TABLE `t5` (
2249 `c1` bit(1) NOT NULL,
2250 `c2` int NOT NULL,
2251 `c3` binary(10) NOT NULL,
2252 PRIMARY KEY (`c1`)
2253 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2254 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2255 SHOW TABLES;
2256 Tables_in_test
2257 t5
2258 SHOW CREATE TABLE t5;
2259 Table Create Table
2260 t5 CREATE TABLE `t5` (
2261 `c1` bit(1) NOT NULL,
2262 `c2` int NOT NULL,
2263 `c4` binary(5) NOT NULL,
2264 `c3` binary(10) NOT NULL,
2265 PRIMARY KEY (`c1`)
2266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2267 DROP TABLE t5;
2268 SHOW TABLES;
2269 Tables_in_test
2270 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2271 SHOW TABLES;
2272 Tables_in_test
2273 t5
2274 SHOW CREATE TABLE t5;
2275 Table Create Table
2276 t5 CREATE TABLE `t5` (
2277 `c1` tinyint NOT NULL,
2278 `c2` int NOT NULL,
2279 `c3` binary(10) NOT NULL,
2280 PRIMARY KEY (`c1`)
2281 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2282 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2283 SHOW TABLES;
2284 Tables_in_test
2285 t5
2286 SHOW CREATE TABLE t5;
2287 Table Create Table
2288 t5 CREATE TABLE `t5` (
2289 `c1` tinyint NOT NULL,
2290 `c2` int NOT NULL,
2291 `c4` binary(5) NOT NULL,
2292 `c3` binary(10) NOT NULL,
2293 PRIMARY KEY (`c1`)
2294 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2295 DROP TABLE t5;
2296 SHOW TABLES;
2297 Tables_in_test
2298 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2299 SHOW TABLES;
2300 Tables_in_test
2301 t5
2302 SHOW CREATE TABLE t5;
2303 Table Create Table
2304 t5 CREATE TABLE `t5` (
2305 `c1` smallint NOT NULL,
2306 `c2` int NOT NULL,
2307 `c3` binary(10) NOT NULL,
2308 PRIMARY KEY (`c1`)
2309 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2310 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2311 SHOW TABLES;
2312 Tables_in_test
2313 t5
2314 SHOW CREATE TABLE t5;
2315 Table Create Table
2316 t5 CREATE TABLE `t5` (
2317 `c1` smallint NOT NULL,
2318 `c2` int NOT NULL,
2319 `c4` binary(5) NOT NULL,
2320 `c3` binary(10) NOT NULL,
2321 PRIMARY KEY (`c1`)
2322 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2323 DROP TABLE t5;
2324 SHOW TABLES;
2325 Tables_in_test
2326 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2327 SHOW TABLES;
2328 Tables_in_test
2329 t5
2330 SHOW CREATE TABLE t5;
2331 Table Create Table
2332 t5 CREATE TABLE `t5` (
2333 `c1` mediumint NOT NULL,
2334 `c2` int NOT NULL,
2335 `c3` binary(10) NOT NULL,
2336 PRIMARY KEY (`c1`)
2337 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2338 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2339 SHOW TABLES;
2340 Tables_in_test
2341 t5
2342 SHOW CREATE TABLE t5;
2343 Table Create Table
2344 t5 CREATE TABLE `t5` (
2345 `c1` mediumint NOT NULL,
2346 `c2` int NOT NULL,
2347 `c4` binary(5) NOT NULL,
2348 `c3` binary(10) NOT NULL,
2349 PRIMARY KEY (`c1`)
2350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2351 DROP TABLE t5;
2352 SHOW TABLES;
2353 Tables_in_test
2354 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2355 SHOW TABLES;
2356 Tables_in_test
2357 t5
2358 SHOW CREATE TABLE t5;
2359 Table Create Table
2360 t5 CREATE TABLE `t5` (
2361 `c1` int NOT NULL,
2362 `c2` int NOT NULL,
2363 `c3` binary(10) NOT NULL,
2364 PRIMARY KEY (`c1`)
2365 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2366 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2367 SHOW TABLES;
2368 Tables_in_test
2369 t5
2370 SHOW CREATE TABLE t5;
2371 Table Create Table
2372 t5 CREATE TABLE `t5` (
2373 `c1` int NOT NULL,
2374 `c2` int NOT NULL,
2375 `c4` binary(5) NOT NULL,
2376 `c3` binary(10) NOT NULL,
2377 PRIMARY KEY (`c1`)
2378 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2379 DROP TABLE t5;
2380 SHOW TABLES;
2381 Tables_in_test
2382 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2383 SHOW TABLES;
2384 Tables_in_test
2385 t5
2386 SHOW CREATE TABLE t5;
2387 Table Create Table
2388 t5 CREATE TABLE `t5` (
2389 `c1` int NOT NULL,
2390 `c2` int NOT NULL,
2391 `c3` binary(10) NOT NULL,
2392 PRIMARY KEY (`c1`)
2393 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2394 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2395 SHOW TABLES;
2396 Tables_in_test
2397 t5
2398 SHOW CREATE TABLE t5;
2399 Table Create Table
2400 t5 CREATE TABLE `t5` (
2401 `c1` int NOT NULL,
2402 `c2` int NOT NULL,
2403 `c4` binary(5) NOT NULL,
2404 `c3` binary(10) NOT NULL,
2405 PRIMARY KEY (`c1`)
2406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2407 DROP TABLE t5;
2408 SHOW TABLES;
2409 Tables_in_test
2410 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2411 SHOW TABLES;
2412 Tables_in_test
2413 t5
2414 SHOW CREATE TABLE t5;
2415 Table Create Table
2416 t5 CREATE TABLE `t5` (
2417 `c1` bigint NOT NULL,
2418 `c2` int NOT NULL,
2419 `c3` binary(10) NOT NULL,
2420 PRIMARY KEY (`c1`)
2421 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2422 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
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` bigint NOT NULL,
2430 `c2` int NOT NULL,
2431 `c4` binary(5) NOT NULL,
2432 `c3` binary(10) NOT NULL,
2433 PRIMARY KEY (`c1`)
2434 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2435 DROP TABLE t5;
2436 SHOW TABLES;
2437 Tables_in_test
2438 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2439 SHOW TABLES;
2440 Tables_in_test
2441 t5
2442 SHOW CREATE TABLE t5;
2443 Table Create Table
2444 t5 CREATE TABLE `t5` (
2445 `c1` double NOT NULL,
2446 `c2` int NOT NULL,
2447 `c3` binary(10) NOT NULL,
2448 PRIMARY KEY (`c1`)
2449 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2450 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2451 SHOW TABLES;
2452 Tables_in_test
2453 t5
2454 SHOW CREATE TABLE t5;
2455 Table Create Table
2456 t5 CREATE TABLE `t5` (
2457 `c1` double NOT NULL,
2458 `c2` int NOT NULL,
2459 `c4` binary(5) NOT NULL,
2460 `c3` binary(10) NOT NULL,
2461 PRIMARY KEY (`c1`)
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 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT 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` double NOT NULL,
2474 `c2` int NOT NULL,
2475 `c3` binary(10) NOT NULL,
2476 PRIMARY KEY (`c1`)
2477 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2478 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2479 SHOW TABLES;
2480 Tables_in_test
2481 t5
2482 SHOW CREATE TABLE t5;
2483 Table Create Table
2484 t5 CREATE TABLE `t5` (
2485 `c1` double NOT NULL,
2486 `c2` int NOT NULL,
2487 `c4` binary(5) NOT NULL,
2488 `c3` binary(10) NOT NULL,
2489 PRIMARY KEY (`c1`)
2490 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2491 DROP TABLE t5;
2492 SHOW TABLES;
2493 Tables_in_test
2494 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2495 SHOW TABLES;
2496 Tables_in_test
2497 t5
2498 SHOW CREATE TABLE t5;
2499 Table Create Table
2500 t5 CREATE TABLE `t5` (
2501 `c1` float NOT NULL,
2502 `c2` int NOT NULL,
2503 `c3` binary(10) NOT NULL,
2504 PRIMARY KEY (`c1`)
2505 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2506 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2507 SHOW TABLES;
2508 Tables_in_test
2509 t5
2510 SHOW CREATE TABLE t5;
2511 Table Create Table
2512 t5 CREATE TABLE `t5` (
2513 `c1` float NOT NULL,
2514 `c2` int NOT NULL,
2515 `c4` binary(5) NOT NULL,
2516 `c3` binary(10) NOT NULL,
2517 PRIMARY KEY (`c1`)
2518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2519 DROP TABLE t5;
2520 SHOW TABLES;
2521 Tables_in_test
2522 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2523 SHOW TABLES;
2524 Tables_in_test
2525 t5
2526 SHOW CREATE TABLE t5;
2527 Table Create Table
2528 t5 CREATE TABLE `t5` (
2529 `c1` decimal(10,0) NOT NULL,
2530 `c2` int NOT NULL,
2531 `c3` binary(10) NOT NULL,
2532 PRIMARY KEY (`c1`)
2533 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2534 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2535 SHOW TABLES;
2536 Tables_in_test
2537 t5
2538 SHOW CREATE TABLE t5;
2539 Table Create Table
2540 t5 CREATE TABLE `t5` (
2541 `c1` decimal(10,0) NOT NULL,
2542 `c2` int NOT NULL,
2543 `c4` binary(5) NOT NULL,
2544 `c3` binary(10) NOT NULL,
2545 PRIMARY KEY (`c1`)
2546 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2547 DROP TABLE t5;
2548 SHOW TABLES;
2549 Tables_in_test
2550 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2551 SHOW TABLES;
2552 Tables_in_test
2553 t5
2554 SHOW CREATE TABLE t5;
2555 Table Create Table
2556 t5 CREATE TABLE `t5` (
2557 `c1` decimal(10,0) NOT NULL,
2558 `c2` int NOT NULL,
2559 `c3` binary(10) NOT NULL,
2560 PRIMARY KEY (`c1`)
2561 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2562 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2563 SHOW TABLES;
2564 Tables_in_test
2565 t5
2566 SHOW CREATE TABLE t5;
2567 Table Create Table
2568 t5 CREATE TABLE `t5` (
2569 `c1` decimal(10,0) NOT NULL,
2570 `c2` int NOT NULL,
2571 `c4` binary(5) NOT NULL,
2572 `c3` binary(10) NOT NULL,
2573 PRIMARY KEY (`c1`)
2574 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2575 DROP TABLE t5;
2576 SHOW TABLES;
2577 Tables_in_test
2578 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2579 SHOW TABLES;
2580 Tables_in_test
2581 t5
2582 SHOW CREATE TABLE t5;
2583 Table Create Table
2584 t5 CREATE TABLE `t5` (
2585 `c1` date NOT NULL,
2586 `c2` int NOT NULL,
2587 `c3` binary(10) NOT NULL,
2588 PRIMARY KEY (`c1`)
2589 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2590 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2591 SHOW TABLES;
2592 Tables_in_test
2593 t5
2594 SHOW CREATE TABLE t5;
2595 Table Create Table
2596 t5 CREATE TABLE `t5` (
2597 `c1` date NOT NULL,
2598 `c2` int NOT NULL,
2599 `c4` binary(5) NOT NULL,
2600 `c3` binary(10) NOT NULL,
2601 PRIMARY KEY (`c1`)
2602 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2603 DROP TABLE t5;
2604 SHOW TABLES;
2605 Tables_in_test
2606 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2607 SHOW TABLES;
2608 Tables_in_test
2609 t5
2610 SHOW CREATE TABLE t5;
2611 Table Create Table
2612 t5 CREATE TABLE `t5` (
2613 `c1` time NOT NULL,
2614 `c2` int NOT NULL,
2615 `c3` binary(10) NOT NULL,
2616 PRIMARY KEY (`c1`)
2617 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2618 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2619 SHOW TABLES;
2620 Tables_in_test
2621 t5
2622 SHOW CREATE TABLE t5;
2623 Table Create Table
2624 t5 CREATE TABLE `t5` (
2625 `c1` time NOT NULL,
2626 `c2` int NOT NULL,
2627 `c4` binary(5) NOT NULL,
2628 `c3` binary(10) NOT NULL,
2629 PRIMARY KEY (`c1`)
2630 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2631 DROP TABLE t5;
2632 SHOW TABLES;
2633 Tables_in_test
2634 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2635 SHOW TABLES;
2636 Tables_in_test
2637 t5
2638 SHOW CREATE TABLE t5;
2639 Table Create Table
2640 t5 CREATE TABLE `t5` (
2641 `c1` timestamp NOT NULL,
2642 `c2` int NOT NULL,
2643 `c3` binary(10) NOT NULL,
2644 PRIMARY KEY (`c1`)
2645 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2646 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2647 SHOW TABLES;
2648 Tables_in_test
2649 t5
2650 SHOW CREATE TABLE t5;
2651 Table Create Table
2652 t5 CREATE TABLE `t5` (
2653 `c1` timestamp NOT NULL,
2654 `c2` int NOT NULL,
2655 `c4` binary(5) NOT NULL,
2656 `c3` binary(10) NOT NULL,
2657 PRIMARY KEY (`c1`)
2658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2659 DROP TABLE t5;
2660 SHOW TABLES;
2661 Tables_in_test
2662 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2663 SHOW TABLES;
2664 Tables_in_test
2665 t5
2666 SHOW CREATE TABLE t5;
2667 Table Create Table
2668 t5 CREATE TABLE `t5` (
2669 `c1` year NOT NULL,
2670 `c2` int NOT NULL,
2671 `c3` binary(10) NOT NULL,
2672 PRIMARY KEY (`c1`)
2673 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2674 ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2675 SHOW TABLES;
2676 Tables_in_test
2677 t5
2678 SHOW CREATE TABLE t5;
2679 Table Create Table
2680 t5 CREATE TABLE `t5` (
2681 `c1` year NOT NULL,
2682 `c2` int NOT NULL,
2683 `c4` binary(5) NOT NULL,
2684 `c3` binary(10) NOT NULL,
2685 PRIMARY KEY (`c1`)
2686 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2687 DROP TABLE t5;
2688 SHOW TABLES;
2689 Tables_in_test
2690 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2691 SHOW TABLES;
2692 Tables_in_test
2693 t5
2694 SHOW CREATE TABLE t5;
2695 Table Create Table
2696 t5 CREATE TABLE `t5` (
2697 `c1` bit(1) NOT NULL,
2698 `c2` int NOT NULL,
2699 `c3` varbinary(10) DEFAULT NULL,
2700 PRIMARY KEY (`c1`)
2701 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2702 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2703 SHOW TABLES;
2704 Tables_in_test
2705 t5
2706 SHOW CREATE TABLE t5;
2707 Table Create Table
2708 t5 CREATE TABLE `t5` (
2709 `c1` bit(1) NOT NULL,
2710 `c2` int NOT NULL,
2711 `c4` varbinary(5) DEFAULT NULL,
2712 `c3` varbinary(10) DEFAULT NULL,
2713 PRIMARY KEY (`c1`)
2714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2715 DROP TABLE t5;
2716 SHOW TABLES;
2717 Tables_in_test
2718 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2719 SHOW TABLES;
2720 Tables_in_test
2721 t5
2722 SHOW CREATE TABLE t5;
2723 Table Create Table
2724 t5 CREATE TABLE `t5` (
2725 `c1` tinyint NOT NULL,
2726 `c2` int NOT NULL,
2727 `c3` varbinary(10) DEFAULT NULL,
2728 PRIMARY KEY (`c1`)
2729 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2730 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
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` tinyint NOT NULL,
2738 `c2` int NOT NULL,
2739 `c4` varbinary(5) DEFAULT NULL,
2740 `c3` varbinary(10) DEFAULT NULL,
2741 PRIMARY KEY (`c1`)
2742 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2743 DROP TABLE t5;
2744 SHOW TABLES;
2745 Tables_in_test
2746 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2747 SHOW TABLES;
2748 Tables_in_test
2749 t5
2750 SHOW CREATE TABLE t5;
2751 Table Create Table
2752 t5 CREATE TABLE `t5` (
2753 `c1` smallint NOT NULL,
2754 `c2` int NOT NULL,
2755 `c3` varbinary(10) DEFAULT NULL,
2756 PRIMARY KEY (`c1`)
2757 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2758 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2759 SHOW TABLES;
2760 Tables_in_test
2761 t5
2762 SHOW CREATE TABLE t5;
2763 Table Create Table
2764 t5 CREATE TABLE `t5` (
2765 `c1` smallint NOT NULL,
2766 `c2` int NOT NULL,
2767 `c4` varbinary(5) DEFAULT NULL,
2768 `c3` varbinary(10) DEFAULT NULL,
2769 PRIMARY KEY (`c1`)
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 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) 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` mediumint NOT NULL,
2782 `c2` int NOT NULL,
2783 `c3` varbinary(10) DEFAULT NULL,
2784 PRIMARY KEY (`c1`)
2785 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2786 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2787 SHOW TABLES;
2788 Tables_in_test
2789 t5
2790 SHOW CREATE TABLE t5;
2791 Table Create Table
2792 t5 CREATE TABLE `t5` (
2793 `c1` mediumint NOT NULL,
2794 `c2` int NOT NULL,
2795 `c4` varbinary(5) DEFAULT NULL,
2796 `c3` varbinary(10) DEFAULT NULL,
2797 PRIMARY KEY (`c1`)
2798 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2799 DROP TABLE t5;
2800 SHOW TABLES;
2801 Tables_in_test
2802 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2803 SHOW TABLES;
2804 Tables_in_test
2805 t5
2806 SHOW CREATE TABLE t5;
2807 Table Create Table
2808 t5 CREATE TABLE `t5` (
2809 `c1` int NOT NULL,
2810 `c2` int NOT NULL,
2811 `c3` varbinary(10) DEFAULT NULL,
2812 PRIMARY KEY (`c1`)
2813 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2814 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2815 SHOW TABLES;
2816 Tables_in_test
2817 t5
2818 SHOW CREATE TABLE t5;
2819 Table Create Table
2820 t5 CREATE TABLE `t5` (
2821 `c1` int NOT NULL,
2822 `c2` int NOT NULL,
2823 `c4` varbinary(5) DEFAULT NULL,
2824 `c3` varbinary(10) DEFAULT NULL,
2825 PRIMARY KEY (`c1`)
2826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2827 DROP TABLE t5;
2828 SHOW TABLES;
2829 Tables_in_test
2830 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2831 SHOW TABLES;
2832 Tables_in_test
2833 t5
2834 SHOW CREATE TABLE t5;
2835 Table Create Table
2836 t5 CREATE TABLE `t5` (
2837 `c1` int NOT NULL,
2838 `c2` int NOT NULL,
2839 `c3` varbinary(10) DEFAULT NULL,
2840 PRIMARY KEY (`c1`)
2841 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2842 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2843 SHOW TABLES;
2844 Tables_in_test
2845 t5
2846 SHOW CREATE TABLE t5;
2847 Table Create Table
2848 t5 CREATE TABLE `t5` (
2849 `c1` int NOT NULL,
2850 `c2` int NOT NULL,
2851 `c4` varbinary(5) DEFAULT NULL,
2852 `c3` varbinary(10) DEFAULT NULL,
2853 PRIMARY KEY (`c1`)
2854 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2855 DROP TABLE t5;
2856 SHOW TABLES;
2857 Tables_in_test
2858 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2859 SHOW TABLES;
2860 Tables_in_test
2861 t5
2862 SHOW CREATE TABLE t5;
2863 Table Create Table
2864 t5 CREATE TABLE `t5` (
2865 `c1` bigint NOT NULL,
2866 `c2` int NOT NULL,
2867 `c3` varbinary(10) DEFAULT NULL,
2868 PRIMARY KEY (`c1`)
2869 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2870 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2871 SHOW TABLES;
2872 Tables_in_test
2873 t5
2874 SHOW CREATE TABLE t5;
2875 Table Create Table
2876 t5 CREATE TABLE `t5` (
2877 `c1` bigint NOT NULL,
2878 `c2` int NOT NULL,
2879 `c4` varbinary(5) DEFAULT NULL,
2880 `c3` varbinary(10) DEFAULT NULL,
2881 PRIMARY KEY (`c1`)
2882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2883 DROP TABLE t5;
2884 SHOW TABLES;
2885 Tables_in_test
2886 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2887 SHOW TABLES;
2888 Tables_in_test
2889 t5
2890 SHOW CREATE TABLE t5;
2891 Table Create Table
2892 t5 CREATE TABLE `t5` (
2893 `c1` double NOT NULL,
2894 `c2` int NOT NULL,
2895 `c3` varbinary(10) DEFAULT NULL,
2896 PRIMARY KEY (`c1`)
2897 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2898 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2899 SHOW TABLES;
2900 Tables_in_test
2901 t5
2902 SHOW CREATE TABLE t5;
2903 Table Create Table
2904 t5 CREATE TABLE `t5` (
2905 `c1` double NOT NULL,
2906 `c2` int NOT NULL,
2907 `c4` varbinary(5) DEFAULT NULL,
2908 `c3` varbinary(10) DEFAULT NULL,
2909 PRIMARY KEY (`c1`)
2910 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2911 DROP TABLE t5;
2912 SHOW TABLES;
2913 Tables_in_test
2914 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2915 SHOW TABLES;
2916 Tables_in_test
2917 t5
2918 SHOW CREATE TABLE t5;
2919 Table Create Table
2920 t5 CREATE TABLE `t5` (
2921 `c1` double NOT NULL,
2922 `c2` int NOT NULL,
2923 `c3` varbinary(10) DEFAULT NULL,
2924 PRIMARY KEY (`c1`)
2925 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2926 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2927 SHOW TABLES;
2928 Tables_in_test
2929 t5
2930 SHOW CREATE TABLE t5;
2931 Table Create Table
2932 t5 CREATE TABLE `t5` (
2933 `c1` double NOT NULL,
2934 `c2` int NOT NULL,
2935 `c4` varbinary(5) DEFAULT NULL,
2936 `c3` varbinary(10) DEFAULT NULL,
2937 PRIMARY KEY (`c1`)
2938 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2939 DROP TABLE t5;
2940 SHOW TABLES;
2941 Tables_in_test
2942 CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2943 SHOW TABLES;
2944 Tables_in_test
2945 t5
2946 SHOW CREATE TABLE t5;
2947 Table Create Table
2948 t5 CREATE TABLE `t5` (
2949 `c1` float NOT NULL,
2950 `c2` int NOT NULL,
2951 `c3` varbinary(10) DEFAULT NULL,
2952 PRIMARY KEY (`c1`)
2953 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2954 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2955 SHOW TABLES;
2956 Tables_in_test
2957 t5
2958 SHOW CREATE TABLE t5;
2959 Table Create Table
2960 t5 CREATE TABLE `t5` (
2961 `c1` float NOT NULL,
2962 `c2` int NOT NULL,
2963 `c4` varbinary(5) DEFAULT NULL,
2964 `c3` varbinary(10) DEFAULT NULL,
2965 PRIMARY KEY (`c1`)
2966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2967 DROP TABLE t5;
2968 SHOW TABLES;
2969 Tables_in_test
2970 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2971 SHOW TABLES;
2972 Tables_in_test
2973 t5
2974 SHOW CREATE TABLE t5;
2975 Table Create Table
2976 t5 CREATE TABLE `t5` (
2977 `c1` decimal(10,0) NOT NULL,
2978 `c2` int NOT NULL,
2979 `c3` varbinary(10) DEFAULT NULL,
2980 PRIMARY KEY (`c1`)
2981 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2982 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2983 SHOW TABLES;
2984 Tables_in_test
2985 t5
2986 SHOW CREATE TABLE t5;
2987 Table Create Table
2988 t5 CREATE TABLE `t5` (
2989 `c1` decimal(10,0) NOT NULL,
2990 `c2` int NOT NULL,
2991 `c4` varbinary(5) DEFAULT NULL,
2992 `c3` varbinary(10) DEFAULT NULL,
2993 PRIMARY KEY (`c1`)
2994 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2995 DROP TABLE t5;
2996 SHOW TABLES;
2997 Tables_in_test
2998 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2999 SHOW TABLES;
3000 Tables_in_test
3001 t5
3002 SHOW CREATE TABLE t5;
3003 Table Create Table
3004 t5 CREATE TABLE `t5` (
3005 `c1` decimal(10,0) NOT NULL,
3006 `c2` int NOT NULL,
3007 `c3` varbinary(10) DEFAULT NULL,
3008 PRIMARY KEY (`c1`)
3009 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3010 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3011 SHOW TABLES;
3012 Tables_in_test
3013 t5
3014 SHOW CREATE TABLE t5;
3015 Table Create Table
3016 t5 CREATE TABLE `t5` (
3017 `c1` decimal(10,0) NOT NULL,
3018 `c2` int NOT NULL,
3019 `c4` varbinary(5) DEFAULT NULL,
3020 `c3` varbinary(10) DEFAULT NULL,
3021 PRIMARY KEY (`c1`)
3022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3023 DROP TABLE t5;
3024 SHOW TABLES;
3025 Tables_in_test
3026 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3027 SHOW TABLES;
3028 Tables_in_test
3029 t5
3030 SHOW CREATE TABLE t5;
3031 Table Create Table
3032 t5 CREATE TABLE `t5` (
3033 `c1` date NOT NULL,
3034 `c2` int NOT NULL,
3035 `c3` varbinary(10) DEFAULT NULL,
3036 PRIMARY KEY (`c1`)
3037 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3038 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
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` date NOT NULL,
3046 `c2` int NOT NULL,
3047 `c4` varbinary(5) DEFAULT NULL,
3048 `c3` varbinary(10) DEFAULT NULL,
3049 PRIMARY KEY (`c1`)
3050 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3051 DROP TABLE t5;
3052 SHOW TABLES;
3053 Tables_in_test
3054 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3055 SHOW TABLES;
3056 Tables_in_test
3057 t5
3058 SHOW CREATE TABLE t5;
3059 Table Create Table
3060 t5 CREATE TABLE `t5` (
3061 `c1` time NOT NULL,
3062 `c2` int NOT NULL,
3063 `c3` varbinary(10) DEFAULT NULL,
3064 PRIMARY KEY (`c1`)
3065 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3066 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3067 SHOW TABLES;
3068 Tables_in_test
3069 t5
3070 SHOW CREATE TABLE t5;
3071 Table Create Table
3072 t5 CREATE TABLE `t5` (
3073 `c1` time NOT NULL,
3074 `c2` int NOT NULL,
3075 `c4` varbinary(5) DEFAULT NULL,
3076 `c3` varbinary(10) DEFAULT NULL,
3077 PRIMARY KEY (`c1`)
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 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) 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` timestamp NOT NULL,
3090 `c2` int NOT NULL,
3091 `c3` varbinary(10) DEFAULT NULL,
3092 PRIMARY KEY (`c1`)
3093 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3094 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3095 SHOW TABLES;
3096 Tables_in_test
3097 t5
3098 SHOW CREATE TABLE t5;
3099 Table Create Table
3100 t5 CREATE TABLE `t5` (
3101 `c1` timestamp NOT NULL,
3102 `c2` int NOT NULL,
3103 `c4` varbinary(5) DEFAULT NULL,
3104 `c3` varbinary(10) DEFAULT NULL,
3105 PRIMARY KEY (`c1`)
3106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3107 DROP TABLE t5;
3108 SHOW TABLES;
3109 Tables_in_test
3110 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3111 SHOW TABLES;
3112 Tables_in_test
3113 t5
3114 SHOW CREATE TABLE t5;
3115 Table Create Table
3116 t5 CREATE TABLE `t5` (
3117 `c1` year NOT NULL,
3118 `c2` int NOT NULL,
3119 `c3` varbinary(10) DEFAULT NULL,
3120 PRIMARY KEY (`c1`)
3121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3122 ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3123 SHOW TABLES;
3124 Tables_in_test
3125 t5
3126 SHOW CREATE TABLE t5;
3127 Table Create Table
3128 t5 CREATE TABLE `t5` (
3129 `c1` year NOT NULL,
3130 `c2` int NOT NULL,
3131 `c4` varbinary(5) DEFAULT NULL,
3132 `c3` varbinary(10) DEFAULT NULL,
3133 PRIMARY KEY (`c1`)
3134 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3135 DROP TABLE t5;
3136 SHOW TABLES;
3137 Tables_in_test
3138 CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3139 SHOW TABLES;
3140 Tables_in_test
3141 t5
3142 SHOW CREATE TABLE t5;
3143 Table Create Table
3144 t5 CREATE TABLE `t5` (
3145 `c1` bit(1) NOT NULL,
3146 `c2` int NOT NULL,
3147 `c3` varbinary(10) NOT NULL,
3148 PRIMARY KEY (`c1`)
3149 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3150 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3151 SHOW TABLES;
3152 Tables_in_test
3153 t5
3154 SHOW CREATE TABLE t5;
3155 Table Create Table
3156 t5 CREATE TABLE `t5` (
3157 `c1` bit(1) NOT NULL,
3158 `c2` int NOT NULL,
3159 `c4` varbinary(5) NOT NULL,
3160 `c3` varbinary(10) NOT NULL,
3161 PRIMARY KEY (`c1`)
3162 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3163 DROP TABLE t5;
3164 SHOW TABLES;
3165 Tables_in_test
3166 CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3167 SHOW TABLES;
3168 Tables_in_test
3169 t5
3170 SHOW CREATE TABLE t5;
3171 Table Create Table
3172 t5 CREATE TABLE `t5` (
3173 `c1` tinyint NOT NULL,
3174 `c2` int NOT NULL,
3175 `c3` varbinary(10) NOT NULL,
3176 PRIMARY KEY (`c1`)
3177 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3178 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3179 SHOW TABLES;
3180 Tables_in_test
3181 t5
3182 SHOW CREATE TABLE t5;
3183 Table Create Table
3184 t5 CREATE TABLE `t5` (
3185 `c1` tinyint NOT NULL,
3186 `c2` int NOT NULL,
3187 `c4` varbinary(5) NOT NULL,
3188 `c3` varbinary(10) NOT NULL,
3189 PRIMARY KEY (`c1`)
3190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3191 DROP TABLE t5;
3192 SHOW TABLES;
3193 Tables_in_test
3194 CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3195 SHOW TABLES;
3196 Tables_in_test
3197 t5
3198 SHOW CREATE TABLE t5;
3199 Table Create Table
3200 t5 CREATE TABLE `t5` (
3201 `c1` smallint NOT NULL,
3202 `c2` int NOT NULL,
3203 `c3` varbinary(10) NOT NULL,
3204 PRIMARY KEY (`c1`)
3205 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3206 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3207 SHOW TABLES;
3208 Tables_in_test
3209 t5
3210 SHOW CREATE TABLE t5;
3211 Table Create Table
3212 t5 CREATE TABLE `t5` (
3213 `c1` smallint NOT NULL,
3214 `c2` int NOT NULL,
3215 `c4` varbinary(5) NOT NULL,
3216 `c3` varbinary(10) NOT NULL,
3217 PRIMARY KEY (`c1`)
3218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3219 DROP TABLE t5;
3220 SHOW TABLES;
3221 Tables_in_test
3222 CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3223 SHOW TABLES;
3224 Tables_in_test
3225 t5
3226 SHOW CREATE TABLE t5;
3227 Table Create Table
3228 t5 CREATE TABLE `t5` (
3229 `c1` mediumint NOT NULL,
3230 `c2` int NOT NULL,
3231 `c3` varbinary(10) NOT NULL,
3232 PRIMARY KEY (`c1`)
3233 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3234 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3235 SHOW TABLES;
3236 Tables_in_test
3237 t5
3238 SHOW CREATE TABLE t5;
3239 Table Create Table
3240 t5 CREATE TABLE `t5` (
3241 `c1` mediumint NOT NULL,
3242 `c2` int NOT NULL,
3243 `c4` varbinary(5) NOT NULL,
3244 `c3` varbinary(10) NOT NULL,
3245 PRIMARY KEY (`c1`)
3246 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3247 DROP TABLE t5;
3248 SHOW TABLES;
3249 Tables_in_test
3250 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3251 SHOW TABLES;
3252 Tables_in_test
3253 t5
3254 SHOW CREATE TABLE t5;
3255 Table Create Table
3256 t5 CREATE TABLE `t5` (
3257 `c1` int NOT NULL,
3258 `c2` int NOT NULL,
3259 `c3` varbinary(10) NOT NULL,
3260 PRIMARY KEY (`c1`)
3261 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3262 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3263 SHOW TABLES;
3264 Tables_in_test
3265 t5
3266 SHOW CREATE TABLE t5;
3267 Table Create Table
3268 t5 CREATE TABLE `t5` (
3269 `c1` int NOT NULL,
3270 `c2` int NOT NULL,
3271 `c4` varbinary(5) NOT NULL,
3272 `c3` varbinary(10) NOT NULL,
3273 PRIMARY KEY (`c1`)
3274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3275 DROP TABLE t5;
3276 SHOW TABLES;
3277 Tables_in_test
3278 CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3279 SHOW TABLES;
3280 Tables_in_test
3281 t5
3282 SHOW CREATE TABLE t5;
3283 Table Create Table
3284 t5 CREATE TABLE `t5` (
3285 `c1` int NOT NULL,
3286 `c2` int NOT NULL,
3287 `c3` varbinary(10) NOT NULL,
3288 PRIMARY KEY (`c1`)
3289 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3290 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3291 SHOW TABLES;
3292 Tables_in_test
3293 t5
3294 SHOW CREATE TABLE t5;
3295 Table Create Table
3296 t5 CREATE TABLE `t5` (
3297 `c1` int NOT NULL,
3298 `c2` int NOT NULL,
3299 `c4` varbinary(5) NOT NULL,
3300 `c3` varbinary(10) NOT NULL,
3301 PRIMARY KEY (`c1`)
3302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3303 DROP TABLE t5;
3304 SHOW TABLES;
3305 Tables_in_test
3306 CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3307 SHOW TABLES;
3308 Tables_in_test
3309 t5
3310 SHOW CREATE TABLE t5;
3311 Table Create Table
3312 t5 CREATE TABLE `t5` (
3313 `c1` bigint NOT NULL,
3314 `c2` int NOT NULL,
3315 `c3` varbinary(10) NOT NULL,
3316 PRIMARY KEY (`c1`)
3317 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3318 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3319 SHOW TABLES;
3320 Tables_in_test
3321 t5
3322 SHOW CREATE TABLE t5;
3323 Table Create Table
3324 t5 CREATE TABLE `t5` (
3325 `c1` bigint NOT NULL,
3326 `c2` int NOT NULL,
3327 `c4` varbinary(5) NOT NULL,
3328 `c3` varbinary(10) NOT NULL,
3329 PRIMARY KEY (`c1`)
3330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3331 DROP TABLE t5;
3332 SHOW TABLES;
3333 Tables_in_test
3334 CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3335 SHOW TABLES;
3336 Tables_in_test
3337 t5
3338 SHOW CREATE TABLE t5;
3339 Table Create Table
3340 t5 CREATE TABLE `t5` (
3341 `c1` double NOT NULL,
3342 `c2` int NOT NULL,
3343 `c3` varbinary(10) NOT NULL,
3344 PRIMARY KEY (`c1`)
3345 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3346 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
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 NOT NULL,
3354 `c2` int NOT NULL,
3355 `c4` varbinary(5) NOT NULL,
3356 `c3` varbinary(10) NOT NULL,
3357 PRIMARY KEY (`c1`)
3358 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3359 DROP TABLE t5;
3360 SHOW TABLES;
3361 Tables_in_test
3362 CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3363 SHOW TABLES;
3364 Tables_in_test
3365 t5
3366 SHOW CREATE TABLE t5;
3367 Table Create Table
3368 t5 CREATE TABLE `t5` (
3369 `c1` double NOT NULL,
3370 `c2` int NOT NULL,
3371 `c3` varbinary(10) NOT NULL,
3372 PRIMARY KEY (`c1`)
3373 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3374 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3375 SHOW TABLES;
3376 Tables_in_test
3377 t5
3378 SHOW CREATE TABLE t5;
3379 Table Create Table
3380 t5 CREATE TABLE `t5` (
3381 `c1` double NOT NULL,
3382 `c2` int NOT NULL,
3383 `c4` varbinary(5) NOT NULL,
3384 `c3` varbinary(10) NOT NULL,
3385 PRIMARY KEY (`c1`)
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 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT 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` float NOT NULL,
3398 `c2` int NOT NULL,
3399 `c3` varbinary(10) NOT NULL,
3400 PRIMARY KEY (`c1`)
3401 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3402 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3403 SHOW TABLES;
3404 Tables_in_test
3405 t5
3406 SHOW CREATE TABLE t5;
3407 Table Create Table
3408 t5 CREATE TABLE `t5` (
3409 `c1` float NOT NULL,
3410 `c2` int NOT NULL,
3411 `c4` varbinary(5) NOT NULL,
3412 `c3` varbinary(10) NOT NULL,
3413 PRIMARY KEY (`c1`)
3414 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3415 DROP TABLE t5;
3416 SHOW TABLES;
3417 Tables_in_test
3418 CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3419 SHOW TABLES;
3420 Tables_in_test
3421 t5
3422 SHOW CREATE TABLE t5;
3423 Table Create Table
3424 t5 CREATE TABLE `t5` (
3425 `c1` decimal(10,0) NOT NULL,
3426 `c2` int NOT NULL,
3427 `c3` varbinary(10) NOT NULL,
3428 PRIMARY KEY (`c1`)
3429 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3430 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3431 SHOW TABLES;
3432 Tables_in_test
3433 t5
3434 SHOW CREATE TABLE t5;
3435 Table Create Table
3436 t5 CREATE TABLE `t5` (
3437 `c1` decimal(10,0) NOT NULL,
3438 `c2` int NOT NULL,
3439 `c4` varbinary(5) NOT NULL,
3440 `c3` varbinary(10) NOT NULL,
3441 PRIMARY KEY (`c1`)
3442 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3443 DROP TABLE t5;
3444 SHOW TABLES;
3445 Tables_in_test
3446 CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3447 SHOW TABLES;
3448 Tables_in_test
3449 t5
3450 SHOW CREATE TABLE t5;
3451 Table Create Table
3452 t5 CREATE TABLE `t5` (
3453 `c1` decimal(10,0) NOT NULL,
3454 `c2` int NOT NULL,
3455 `c3` varbinary(10) NOT NULL,
3456 PRIMARY KEY (`c1`)
3457 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3458 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3459 SHOW TABLES;
3460 Tables_in_test
3461 t5
3462 SHOW CREATE TABLE t5;
3463 Table Create Table
3464 t5 CREATE TABLE `t5` (
3465 `c1` decimal(10,0) NOT NULL,
3466 `c2` int NOT NULL,
3467 `c4` varbinary(5) NOT NULL,
3468 `c3` varbinary(10) NOT NULL,
3469 PRIMARY KEY (`c1`)
3470 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3471 DROP TABLE t5;
3472 SHOW TABLES;
3473 Tables_in_test
3474 CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3475 SHOW TABLES;
3476 Tables_in_test
3477 t5
3478 SHOW CREATE TABLE t5;
3479 Table Create Table
3480 t5 CREATE TABLE `t5` (
3481 `c1` date NOT NULL,
3482 `c2` int NOT NULL,
3483 `c3` varbinary(10) NOT NULL,
3484 PRIMARY KEY (`c1`)
3485 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3486 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3487 SHOW TABLES;
3488 Tables_in_test
3489 t5
3490 SHOW CREATE TABLE t5;
3491 Table Create Table
3492 t5 CREATE TABLE `t5` (
3493 `c1` date NOT NULL,
3494 `c2` int NOT NULL,
3495 `c4` varbinary(5) NOT NULL,
3496 `c3` varbinary(10) NOT NULL,
3497 PRIMARY KEY (`c1`)
3498 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3499 DROP TABLE t5;
3500 SHOW TABLES;
3501 Tables_in_test
3502 CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3503 SHOW TABLES;
3504 Tables_in_test
3505 t5
3506 SHOW CREATE TABLE t5;
3507 Table Create Table
3508 t5 CREATE TABLE `t5` (
3509 `c1` time NOT NULL,
3510 `c2` int NOT NULL,
3511 `c3` varbinary(10) NOT NULL,
3512 PRIMARY KEY (`c1`)
3513 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3514 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3515 SHOW TABLES;
3516 Tables_in_test
3517 t5
3518 SHOW CREATE TABLE t5;
3519 Table Create Table
3520 t5 CREATE TABLE `t5` (
3521 `c1` time NOT NULL,
3522 `c2` int NOT NULL,
3523 `c4` varbinary(5) NOT NULL,
3524 `c3` varbinary(10) NOT NULL,
3525 PRIMARY KEY (`c1`)
3526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3527 DROP TABLE t5;
3528 SHOW TABLES;
3529 Tables_in_test
3530 CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3531 SHOW TABLES;
3532 Tables_in_test
3533 t5
3534 SHOW CREATE TABLE t5;
3535 Table Create Table
3536 t5 CREATE TABLE `t5` (
3537 `c1` timestamp NOT NULL,
3538 `c2` int NOT NULL,
3539 `c3` varbinary(10) NOT NULL,
3540 PRIMARY KEY (`c1`)
3541 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3542 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3543 SHOW TABLES;
3544 Tables_in_test
3545 t5
3546 SHOW CREATE TABLE t5;
3547 Table Create Table
3548 t5 CREATE TABLE `t5` (
3549 `c1` timestamp NOT NULL,
3550 `c2` int NOT NULL,
3551 `c4` varbinary(5) NOT NULL,
3552 `c3` varbinary(10) NOT NULL,
3553 PRIMARY KEY (`c1`)
3554 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3555 DROP TABLE t5;
3556 SHOW TABLES;
3557 Tables_in_test
3558 CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3559 SHOW TABLES;
3560 Tables_in_test
3561 t5
3562 SHOW CREATE TABLE t5;
3563 Table Create Table
3564 t5 CREATE TABLE `t5` (
3565 `c1` year NOT NULL,
3566 `c2` int NOT NULL,
3567 `c3` varbinary(10) NOT NULL,
3568 PRIMARY KEY (`c1`)
3569 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3570 ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3571 SHOW TABLES;
3572 Tables_in_test
3573 t5
3574 SHOW CREATE TABLE t5;
3575 Table Create Table
3576 t5 CREATE TABLE `t5` (
3577 `c1` year NOT NULL,
3578 `c2` int NOT NULL,
3579 `c4` varbinary(5) NOT NULL,
3580 `c3` varbinary(10) NOT NULL,
3581 PRIMARY KEY (`c1`)
3582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3583 DROP TABLE t5;
3584 SHOW TABLES;
3585 Tables_in_test