Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` char(15) NOT NULL,
10 `c2` int NOT NULL,
11 `c3` char(20) DEFAULT NULL,
12 PRIMARY KEY (`c1`)
13 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
14 ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
15 SHOW TABLES;
16 Tables_in_test
17 t1
18 SHOW CREATE TABLE t1;
19 Table Create Table
20 t1 CREATE TABLE `t1` (
21 `c1` char(15) NOT NULL,
22 `c2` int NOT NULL,
23 `c4` bit(1) DEFAULT NULL,
24 `c3` char(20) DEFAULT NULL,
25 PRIMARY KEY (`c1`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t1;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
31 SHOW TABLES;
32 Tables_in_test
33 t1
34 SHOW CREATE TABLE t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `c1` varchar(15) NOT NULL,
38 `c2` int NOT NULL,
39 `c3` varchar(20) DEFAULT NULL,
40 PRIMARY KEY (`c1`)
41 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
42 ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
43 SHOW TABLES;
44 Tables_in_test
45 t1
46 SHOW CREATE TABLE t1;
47 Table Create Table
48 t1 CREATE TABLE `t1` (
49 `c1` varchar(15) NOT NULL,
50 `c2` int NOT NULL,
51 `c4` bit(1) DEFAULT NULL,
52 `c3` varchar(20) DEFAULT NULL,
53 PRIMARY KEY (`c1`)
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t1;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
59 SHOW TABLES;
60 Tables_in_test
61 t1
62 SHOW CREATE TABLE t1;
63 Table Create Table
64 t1 CREATE TABLE `t1` (
65 `c1` binary(15) NOT NULL,
66 `c2` int NOT NULL,
67 `c3` binary(20) DEFAULT NULL,
68 PRIMARY KEY (`c1`)
69 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
70 ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
71 SHOW TABLES;
72 Tables_in_test
73 t1
74 SHOW CREATE TABLE t1;
75 Table Create Table
76 t1 CREATE TABLE `t1` (
77 `c1` binary(15) NOT NULL,
78 `c2` int NOT NULL,
79 `c4` bit(1) DEFAULT NULL,
80 `c3` binary(20) DEFAULT NULL,
81 PRIMARY KEY (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t1;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t1
90 SHOW CREATE TABLE t1;
91 Table Create Table
92 t1 CREATE TABLE `t1` (
93 `c1` varbinary(15) NOT NULL,
94 `c2` int NOT NULL,
95 `c3` varbinary(20) DEFAULT NULL,
96 PRIMARY KEY (`c1`)
97 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
98 ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
99 SHOW TABLES;
100 Tables_in_test
101 t1
102 SHOW CREATE TABLE t1;
103 Table Create Table
104 t1 CREATE TABLE `t1` (
105 `c1` varbinary(15) NOT NULL,
106 `c2` int NOT NULL,
107 `c4` bit(1) DEFAULT NULL,
108 `c3` varbinary(20) DEFAULT NULL,
109 PRIMARY KEY (`c1`)
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t1;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
115 SHOW TABLES;
116 Tables_in_test
117 t1
118 SHOW CREATE TABLE t1;
119 Table Create Table
120 t1 CREATE TABLE `t1` (
121 `c1` char(15) NOT NULL,
122 `c2` int NOT NULL,
123 `c3` char(20) NOT NULL,
124 PRIMARY KEY (`c1`)
125 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
126 ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
127 SHOW TABLES;
128 Tables_in_test
129 t1
130 SHOW CREATE TABLE t1;
131 Table Create Table
132 t1 CREATE TABLE `t1` (
133 `c1` char(15) NOT NULL,
134 `c2` int NOT NULL,
135 `c4` bit(1) NOT NULL,
136 `c3` char(20) NOT NULL,
137 PRIMARY KEY (`c1`)
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t1;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
143 SHOW TABLES;
144 Tables_in_test
145 t1
146 SHOW CREATE TABLE t1;
147 Table Create Table
148 t1 CREATE TABLE `t1` (
149 `c1` varchar(15) NOT NULL,
150 `c2` int NOT NULL,
151 `c3` varchar(20) NOT NULL,
152 PRIMARY KEY (`c1`)
153 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
154 ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
155 SHOW TABLES;
156 Tables_in_test
157 t1
158 SHOW CREATE TABLE t1;
159 Table Create Table
160 t1 CREATE TABLE `t1` (
161 `c1` varchar(15) NOT NULL,
162 `c2` int NOT NULL,
163 `c4` bit(1) NOT NULL,
164 `c3` varchar(20) NOT NULL,
165 PRIMARY KEY (`c1`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t1;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
171 SHOW TABLES;
172 Tables_in_test
173 t1
174 SHOW CREATE TABLE t1;
175 Table Create Table
176 t1 CREATE TABLE `t1` (
177 `c1` binary(15) NOT NULL,
178 `c2` int NOT NULL,
179 `c3` binary(20) NOT NULL,
180 PRIMARY KEY (`c1`)
181 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
182 ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
183 SHOW TABLES;
184 Tables_in_test
185 t1
186 SHOW CREATE TABLE t1;
187 Table Create Table
188 t1 CREATE TABLE `t1` (
189 `c1` binary(15) NOT NULL,
190 `c2` int NOT NULL,
191 `c4` bit(1) NOT NULL,
192 `c3` binary(20) NOT NULL,
193 PRIMARY KEY (`c1`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t1;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
199 SHOW TABLES;
200 Tables_in_test
201 t1
202 SHOW CREATE TABLE t1;
203 Table Create Table
204 t1 CREATE TABLE `t1` (
205 `c1` varbinary(15) NOT NULL,
206 `c2` int NOT NULL,
207 `c3` varbinary(20) NOT NULL,
208 PRIMARY KEY (`c1`)
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
211 SHOW TABLES;
212 Tables_in_test
213 t1
214 SHOW CREATE TABLE t1;
215 Table Create Table
216 t1 CREATE TABLE `t1` (
217 `c1` varbinary(15) NOT NULL,
218 `c2` int NOT NULL,
219 `c4` bit(1) NOT NULL,
220 `c3` varbinary(20) NOT NULL,
221 PRIMARY KEY (`c1`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t1;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
227 SHOW TABLES;
228 Tables_in_test
229 t1
230 SHOW CREATE TABLE t1;
231 Table Create Table
232 t1 CREATE TABLE `t1` (
233 `c1` char(15) NOT NULL,
234 `c2` int NOT NULL,
235 `c3` char(20) DEFAULT NULL,
236 PRIMARY KEY (`c1`)
237 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
238 ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
239 SHOW TABLES;
240 Tables_in_test
241 t1
242 SHOW CREATE TABLE t1;
243 Table Create Table
244 t1 CREATE TABLE `t1` (
245 `c1` char(15) NOT NULL,
246 `c2` int NOT NULL,
247 `c4` tinyint DEFAULT NULL,
248 `c3` char(20) DEFAULT NULL,
249 PRIMARY KEY (`c1`)
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
251 DROP TABLE t1;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t1
258 SHOW CREATE TABLE t1;
259 Table Create Table
260 t1 CREATE TABLE `t1` (
261 `c1` varchar(15) NOT NULL,
262 `c2` int NOT NULL,
263 `c3` varchar(20) DEFAULT NULL,
264 PRIMARY KEY (`c1`)
265 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
266 ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
267 SHOW TABLES;
268 Tables_in_test
269 t1
270 SHOW CREATE TABLE t1;
271 Table Create Table
272 t1 CREATE TABLE `t1` (
273 `c1` varchar(15) NOT NULL,
274 `c2` int NOT NULL,
275 `c4` tinyint DEFAULT NULL,
276 `c3` varchar(20) DEFAULT NULL,
277 PRIMARY KEY (`c1`)
278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 DROP TABLE t1;
280 SHOW TABLES;
281 Tables_in_test
282 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
283 SHOW TABLES;
284 Tables_in_test
285 t1
286 SHOW CREATE TABLE t1;
287 Table Create Table
288 t1 CREATE TABLE `t1` (
289 `c1` binary(15) NOT NULL,
290 `c2` int NOT NULL,
291 `c3` binary(20) DEFAULT NULL,
292 PRIMARY KEY (`c1`)
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
295 SHOW TABLES;
296 Tables_in_test
297 t1
298 SHOW CREATE TABLE t1;
299 Table Create Table
300 t1 CREATE TABLE `t1` (
301 `c1` binary(15) NOT NULL,
302 `c2` int NOT NULL,
303 `c4` tinyint DEFAULT NULL,
304 `c3` binary(20) DEFAULT NULL,
305 PRIMARY KEY (`c1`)
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
311 SHOW TABLES;
312 Tables_in_test
313 t1
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `c1` varbinary(15) NOT NULL,
318 `c2` int NOT NULL,
319 `c3` varbinary(20) DEFAULT NULL,
320 PRIMARY KEY (`c1`)
321 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
322 ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
323 SHOW TABLES;
324 Tables_in_test
325 t1
326 SHOW CREATE TABLE t1;
327 Table Create Table
328 t1 CREATE TABLE `t1` (
329 `c1` varbinary(15) NOT NULL,
330 `c2` int NOT NULL,
331 `c4` tinyint DEFAULT NULL,
332 `c3` varbinary(20) DEFAULT NULL,
333 PRIMARY KEY (`c1`)
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
335 DROP TABLE t1;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
339 SHOW TABLES;
340 Tables_in_test
341 t1
342 SHOW CREATE TABLE t1;
343 Table Create Table
344 t1 CREATE TABLE `t1` (
345 `c1` char(15) NOT NULL,
346 `c2` int NOT NULL,
347 `c3` char(20) NOT NULL,
348 PRIMARY KEY (`c1`)
349 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
350 ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
351 SHOW TABLES;
352 Tables_in_test
353 t1
354 SHOW CREATE TABLE t1;
355 Table Create Table
356 t1 CREATE TABLE `t1` (
357 `c1` char(15) NOT NULL,
358 `c2` int NOT NULL,
359 `c4` tinyint NOT NULL,
360 `c3` char(20) NOT NULL,
361 PRIMARY KEY (`c1`)
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 DROP TABLE t1;
364 SHOW TABLES;
365 Tables_in_test
366 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
367 SHOW TABLES;
368 Tables_in_test
369 t1
370 SHOW CREATE TABLE t1;
371 Table Create Table
372 t1 CREATE TABLE `t1` (
373 `c1` varchar(15) NOT NULL,
374 `c2` int NOT NULL,
375 `c3` varchar(20) NOT NULL,
376 PRIMARY KEY (`c1`)
377 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
378 ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
379 SHOW TABLES;
380 Tables_in_test
381 t1
382 SHOW CREATE TABLE t1;
383 Table Create Table
384 t1 CREATE TABLE `t1` (
385 `c1` varchar(15) NOT NULL,
386 `c2` int NOT NULL,
387 `c4` tinyint NOT NULL,
388 `c3` varchar(20) NOT NULL,
389 PRIMARY KEY (`c1`)
390 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
391 DROP TABLE t1;
392 SHOW TABLES;
393 Tables_in_test
394 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
395 SHOW TABLES;
396 Tables_in_test
397 t1
398 SHOW CREATE TABLE t1;
399 Table Create Table
400 t1 CREATE TABLE `t1` (
401 `c1` binary(15) NOT NULL,
402 `c2` int NOT NULL,
403 `c3` binary(20) NOT NULL,
404 PRIMARY KEY (`c1`)
405 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
406 ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
407 SHOW TABLES;
408 Tables_in_test
409 t1
410 SHOW CREATE TABLE t1;
411 Table Create Table
412 t1 CREATE TABLE `t1` (
413 `c1` binary(15) NOT NULL,
414 `c2` int NOT NULL,
415 `c4` tinyint NOT NULL,
416 `c3` binary(20) NOT NULL,
417 PRIMARY KEY (`c1`)
418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
419 DROP TABLE t1;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
423 SHOW TABLES;
424 Tables_in_test
425 t1
426 SHOW CREATE TABLE t1;
427 Table Create Table
428 t1 CREATE TABLE `t1` (
429 `c1` varbinary(15) NOT NULL,
430 `c2` int NOT NULL,
431 `c3` varbinary(20) NOT NULL,
432 PRIMARY KEY (`c1`)
433 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
434 ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
435 SHOW TABLES;
436 Tables_in_test
437 t1
438 SHOW CREATE TABLE t1;
439 Table Create Table
440 t1 CREATE TABLE `t1` (
441 `c1` varbinary(15) NOT NULL,
442 `c2` int NOT NULL,
443 `c4` tinyint NOT NULL,
444 `c3` varbinary(20) NOT NULL,
445 PRIMARY KEY (`c1`)
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 DROP TABLE t1;
448 SHOW TABLES;
449 Tables_in_test
450 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
451 SHOW TABLES;
452 Tables_in_test
453 t1
454 SHOW CREATE TABLE t1;
455 Table Create Table
456 t1 CREATE TABLE `t1` (
457 `c1` char(15) NOT NULL,
458 `c2` int NOT NULL,
459 `c3` char(20) DEFAULT NULL,
460 PRIMARY KEY (`c1`)
461 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
462 ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
463 SHOW TABLES;
464 Tables_in_test
465 t1
466 SHOW CREATE TABLE t1;
467 Table Create Table
468 t1 CREATE TABLE `t1` (
469 `c1` char(15) NOT NULL,
470 `c2` int NOT NULL,
471 `c4` smallint DEFAULT NULL,
472 `c3` char(20) DEFAULT NULL,
473 PRIMARY KEY (`c1`)
474 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
475 DROP TABLE t1;
476 SHOW TABLES;
477 Tables_in_test
478 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
479 SHOW TABLES;
480 Tables_in_test
481 t1
482 SHOW CREATE TABLE t1;
483 Table Create Table
484 t1 CREATE TABLE `t1` (
485 `c1` varchar(15) NOT NULL,
486 `c2` int NOT NULL,
487 `c3` varchar(20) DEFAULT NULL,
488 PRIMARY KEY (`c1`)
489 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
490 ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
491 SHOW TABLES;
492 Tables_in_test
493 t1
494 SHOW CREATE TABLE t1;
495 Table Create Table
496 t1 CREATE TABLE `t1` (
497 `c1` varchar(15) NOT NULL,
498 `c2` int NOT NULL,
499 `c4` smallint DEFAULT NULL,
500 `c3` varchar(20) DEFAULT NULL,
501 PRIMARY KEY (`c1`)
502 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
503 DROP TABLE t1;
504 SHOW TABLES;
505 Tables_in_test
506 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
507 SHOW TABLES;
508 Tables_in_test
509 t1
510 SHOW CREATE TABLE t1;
511 Table Create Table
512 t1 CREATE TABLE `t1` (
513 `c1` binary(15) NOT NULL,
514 `c2` int NOT NULL,
515 `c3` binary(20) DEFAULT NULL,
516 PRIMARY KEY (`c1`)
517 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
518 ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
519 SHOW TABLES;
520 Tables_in_test
521 t1
522 SHOW CREATE TABLE t1;
523 Table Create Table
524 t1 CREATE TABLE `t1` (
525 `c1` binary(15) NOT NULL,
526 `c2` int NOT NULL,
527 `c4` smallint DEFAULT NULL,
528 `c3` binary(20) DEFAULT NULL,
529 PRIMARY KEY (`c1`)
530 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
531 DROP TABLE t1;
532 SHOW TABLES;
533 Tables_in_test
534 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
535 SHOW TABLES;
536 Tables_in_test
537 t1
538 SHOW CREATE TABLE t1;
539 Table Create Table
540 t1 CREATE TABLE `t1` (
541 `c1` varbinary(15) NOT NULL,
542 `c2` int NOT NULL,
543 `c3` varbinary(20) DEFAULT NULL,
544 PRIMARY KEY (`c1`)
545 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
546 ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
547 SHOW TABLES;
548 Tables_in_test
549 t1
550 SHOW CREATE TABLE t1;
551 Table Create Table
552 t1 CREATE TABLE `t1` (
553 `c1` varbinary(15) NOT NULL,
554 `c2` int NOT NULL,
555 `c4` smallint DEFAULT NULL,
556 `c3` varbinary(20) DEFAULT NULL,
557 PRIMARY KEY (`c1`)
558 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
559 DROP TABLE t1;
560 SHOW TABLES;
561 Tables_in_test
562 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
563 SHOW TABLES;
564 Tables_in_test
565 t1
566 SHOW CREATE TABLE t1;
567 Table Create Table
568 t1 CREATE TABLE `t1` (
569 `c1` char(15) NOT NULL,
570 `c2` int NOT NULL,
571 `c3` char(20) NOT NULL,
572 PRIMARY KEY (`c1`)
573 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
574 ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
575 SHOW TABLES;
576 Tables_in_test
577 t1
578 SHOW CREATE TABLE t1;
579 Table Create Table
580 t1 CREATE TABLE `t1` (
581 `c1` char(15) NOT NULL,
582 `c2` int NOT NULL,
583 `c4` smallint NOT NULL,
584 `c3` char(20) NOT NULL,
585 PRIMARY KEY (`c1`)
586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
587 DROP TABLE t1;
588 SHOW TABLES;
589 Tables_in_test
590 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
591 SHOW TABLES;
592 Tables_in_test
593 t1
594 SHOW CREATE TABLE t1;
595 Table Create Table
596 t1 CREATE TABLE `t1` (
597 `c1` varchar(15) NOT NULL,
598 `c2` int NOT NULL,
599 `c3` varchar(20) NOT NULL,
600 PRIMARY KEY (`c1`)
601 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
602 ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
603 SHOW TABLES;
604 Tables_in_test
605 t1
606 SHOW CREATE TABLE t1;
607 Table Create Table
608 t1 CREATE TABLE `t1` (
609 `c1` varchar(15) NOT NULL,
610 `c2` int NOT NULL,
611 `c4` smallint NOT NULL,
612 `c3` varchar(20) NOT NULL,
613 PRIMARY KEY (`c1`)
614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
615 DROP TABLE t1;
616 SHOW TABLES;
617 Tables_in_test
618 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
619 SHOW TABLES;
620 Tables_in_test
621 t1
622 SHOW CREATE TABLE t1;
623 Table Create Table
624 t1 CREATE TABLE `t1` (
625 `c1` binary(15) NOT NULL,
626 `c2` int NOT NULL,
627 `c3` binary(20) NOT NULL,
628 PRIMARY KEY (`c1`)
629 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
630 ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
631 SHOW TABLES;
632 Tables_in_test
633 t1
634 SHOW CREATE TABLE t1;
635 Table Create Table
636 t1 CREATE TABLE `t1` (
637 `c1` binary(15) NOT NULL,
638 `c2` int NOT NULL,
639 `c4` smallint NOT NULL,
640 `c3` binary(20) NOT NULL,
641 PRIMARY KEY (`c1`)
642 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 DROP TABLE t1;
644 SHOW TABLES;
645 Tables_in_test
646 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
647 SHOW TABLES;
648 Tables_in_test
649 t1
650 SHOW CREATE TABLE t1;
651 Table Create Table
652 t1 CREATE TABLE `t1` (
653 `c1` varbinary(15) NOT NULL,
654 `c2` int NOT NULL,
655 `c3` varbinary(20) NOT NULL,
656 PRIMARY KEY (`c1`)
657 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
658 ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
659 SHOW TABLES;
660 Tables_in_test
661 t1
662 SHOW CREATE TABLE t1;
663 Table Create Table
664 t1 CREATE TABLE `t1` (
665 `c1` varbinary(15) NOT NULL,
666 `c2` int NOT NULL,
667 `c4` smallint NOT NULL,
668 `c3` varbinary(20) NOT NULL,
669 PRIMARY KEY (`c1`)
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
671 DROP TABLE t1;
672 SHOW TABLES;
673 Tables_in_test
674 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
675 SHOW TABLES;
676 Tables_in_test
677 t1
678 SHOW CREATE TABLE t1;
679 Table Create Table
680 t1 CREATE TABLE `t1` (
681 `c1` char(15) NOT NULL,
682 `c2` int NOT NULL,
683 `c3` char(20) DEFAULT NULL,
684 PRIMARY KEY (`c1`)
685 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
686 ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
687 SHOW TABLES;
688 Tables_in_test
689 t1
690 SHOW CREATE TABLE t1;
691 Table Create Table
692 t1 CREATE TABLE `t1` (
693 `c1` char(15) NOT NULL,
694 `c2` int NOT NULL,
695 `c4` mediumint DEFAULT NULL,
696 `c3` char(20) DEFAULT NULL,
697 PRIMARY KEY (`c1`)
698 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
699 DROP TABLE t1;
700 SHOW TABLES;
701 Tables_in_test
702 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
703 SHOW TABLES;
704 Tables_in_test
705 t1
706 SHOW CREATE TABLE t1;
707 Table Create Table
708 t1 CREATE TABLE `t1` (
709 `c1` varchar(15) NOT NULL,
710 `c2` int NOT NULL,
711 `c3` varchar(20) DEFAULT NULL,
712 PRIMARY KEY (`c1`)
713 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
714 ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
715 SHOW TABLES;
716 Tables_in_test
717 t1
718 SHOW CREATE TABLE t1;
719 Table Create Table
720 t1 CREATE TABLE `t1` (
721 `c1` varchar(15) NOT NULL,
722 `c2` int NOT NULL,
723 `c4` mediumint DEFAULT NULL,
724 `c3` varchar(20) DEFAULT NULL,
725 PRIMARY KEY (`c1`)
726 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
727 DROP TABLE t1;
728 SHOW TABLES;
729 Tables_in_test
730 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
731 SHOW TABLES;
732 Tables_in_test
733 t1
734 SHOW CREATE TABLE t1;
735 Table Create Table
736 t1 CREATE TABLE `t1` (
737 `c1` binary(15) NOT NULL,
738 `c2` int NOT NULL,
739 `c3` binary(20) DEFAULT NULL,
740 PRIMARY KEY (`c1`)
741 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
742 ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
743 SHOW TABLES;
744 Tables_in_test
745 t1
746 SHOW CREATE TABLE t1;
747 Table Create Table
748 t1 CREATE TABLE `t1` (
749 `c1` binary(15) NOT NULL,
750 `c2` int NOT NULL,
751 `c4` mediumint DEFAULT NULL,
752 `c3` binary(20) DEFAULT NULL,
753 PRIMARY KEY (`c1`)
754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
755 DROP TABLE t1;
756 SHOW TABLES;
757 Tables_in_test
758 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
759 SHOW TABLES;
760 Tables_in_test
761 t1
762 SHOW CREATE TABLE t1;
763 Table Create Table
764 t1 CREATE TABLE `t1` (
765 `c1` varbinary(15) NOT NULL,
766 `c2` int NOT NULL,
767 `c3` varbinary(20) DEFAULT NULL,
768 PRIMARY KEY (`c1`)
769 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
770 ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
771 SHOW TABLES;
772 Tables_in_test
773 t1
774 SHOW CREATE TABLE t1;
775 Table Create Table
776 t1 CREATE TABLE `t1` (
777 `c1` varbinary(15) NOT NULL,
778 `c2` int NOT NULL,
779 `c4` mediumint DEFAULT NULL,
780 `c3` varbinary(20) DEFAULT NULL,
781 PRIMARY KEY (`c1`)
782 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
783 DROP TABLE t1;
784 SHOW TABLES;
785 Tables_in_test
786 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
787 SHOW TABLES;
788 Tables_in_test
789 t1
790 SHOW CREATE TABLE t1;
791 Table Create Table
792 t1 CREATE TABLE `t1` (
793 `c1` char(15) NOT NULL,
794 `c2` int NOT NULL,
795 `c3` char(20) NOT NULL,
796 PRIMARY KEY (`c1`)
797 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
798 ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
799 SHOW TABLES;
800 Tables_in_test
801 t1
802 SHOW CREATE TABLE t1;
803 Table Create Table
804 t1 CREATE TABLE `t1` (
805 `c1` char(15) NOT NULL,
806 `c2` int NOT NULL,
807 `c4` mediumint NOT NULL,
808 `c3` char(20) NOT NULL,
809 PRIMARY KEY (`c1`)
810 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
811 DROP TABLE t1;
812 SHOW TABLES;
813 Tables_in_test
814 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
815 SHOW TABLES;
816 Tables_in_test
817 t1
818 SHOW CREATE TABLE t1;
819 Table Create Table
820 t1 CREATE TABLE `t1` (
821 `c1` varchar(15) NOT NULL,
822 `c2` int NOT NULL,
823 `c3` varchar(20) NOT NULL,
824 PRIMARY KEY (`c1`)
825 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
826 ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
827 SHOW TABLES;
828 Tables_in_test
829 t1
830 SHOW CREATE TABLE t1;
831 Table Create Table
832 t1 CREATE TABLE `t1` (
833 `c1` varchar(15) NOT NULL,
834 `c2` int NOT NULL,
835 `c4` mediumint NOT NULL,
836 `c3` varchar(20) NOT NULL,
837 PRIMARY KEY (`c1`)
838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
839 DROP TABLE t1;
840 SHOW TABLES;
841 Tables_in_test
842 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
843 SHOW TABLES;
844 Tables_in_test
845 t1
846 SHOW CREATE TABLE t1;
847 Table Create Table
848 t1 CREATE TABLE `t1` (
849 `c1` binary(15) NOT NULL,
850 `c2` int NOT NULL,
851 `c3` binary(20) NOT NULL,
852 PRIMARY KEY (`c1`)
853 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
854 ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
855 SHOW TABLES;
856 Tables_in_test
857 t1
858 SHOW CREATE TABLE t1;
859 Table Create Table
860 t1 CREATE TABLE `t1` (
861 `c1` binary(15) NOT NULL,
862 `c2` int NOT NULL,
863 `c4` mediumint NOT NULL,
864 `c3` binary(20) NOT NULL,
865 PRIMARY KEY (`c1`)
866 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
867 DROP TABLE t1;
868 SHOW TABLES;
869 Tables_in_test
870 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
871 SHOW TABLES;
872 Tables_in_test
873 t1
874 SHOW CREATE TABLE t1;
875 Table Create Table
876 t1 CREATE TABLE `t1` (
877 `c1` varbinary(15) NOT NULL,
878 `c2` int NOT NULL,
879 `c3` varbinary(20) NOT NULL,
880 PRIMARY KEY (`c1`)
881 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
882 ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
883 SHOW TABLES;
884 Tables_in_test
885 t1
886 SHOW CREATE TABLE t1;
887 Table Create Table
888 t1 CREATE TABLE `t1` (
889 `c1` varbinary(15) NOT NULL,
890 `c2` int NOT NULL,
891 `c4` mediumint NOT NULL,
892 `c3` varbinary(20) NOT NULL,
893 PRIMARY KEY (`c1`)
894 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
895 DROP TABLE t1;
896 SHOW TABLES;
897 Tables_in_test
898 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
899 SHOW TABLES;
900 Tables_in_test
901 t1
902 SHOW CREATE TABLE t1;
903 Table Create Table
904 t1 CREATE TABLE `t1` (
905 `c1` char(15) NOT NULL,
906 `c2` int NOT NULL,
907 `c3` char(20) DEFAULT NULL,
908 PRIMARY KEY (`c1`)
909 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
910 ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
911 SHOW TABLES;
912 Tables_in_test
913 t1
914 SHOW CREATE TABLE t1;
915 Table Create Table
916 t1 CREATE TABLE `t1` (
917 `c1` char(15) NOT NULL,
918 `c2` int NOT NULL,
919 `c4` int DEFAULT NULL,
920 `c3` char(20) DEFAULT NULL,
921 PRIMARY KEY (`c1`)
922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
923 DROP TABLE t1;
924 SHOW TABLES;
925 Tables_in_test
926 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
927 SHOW TABLES;
928 Tables_in_test
929 t1
930 SHOW CREATE TABLE t1;
931 Table Create Table
932 t1 CREATE TABLE `t1` (
933 `c1` varchar(15) NOT NULL,
934 `c2` int NOT NULL,
935 `c3` varchar(20) DEFAULT NULL,
936 PRIMARY KEY (`c1`)
937 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
938 ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
939 SHOW TABLES;
940 Tables_in_test
941 t1
942 SHOW CREATE TABLE t1;
943 Table Create Table
944 t1 CREATE TABLE `t1` (
945 `c1` varchar(15) NOT NULL,
946 `c2` int NOT NULL,
947 `c4` int DEFAULT NULL,
948 `c3` varchar(20) DEFAULT NULL,
949 PRIMARY KEY (`c1`)
950 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
951 DROP TABLE t1;
952 SHOW TABLES;
953 Tables_in_test
954 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
955 SHOW TABLES;
956 Tables_in_test
957 t1
958 SHOW CREATE TABLE t1;
959 Table Create Table
960 t1 CREATE TABLE `t1` (
961 `c1` binary(15) NOT NULL,
962 `c2` int NOT NULL,
963 `c3` binary(20) DEFAULT NULL,
964 PRIMARY KEY (`c1`)
965 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
966 ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
967 SHOW TABLES;
968 Tables_in_test
969 t1
970 SHOW CREATE TABLE t1;
971 Table Create Table
972 t1 CREATE TABLE `t1` (
973 `c1` binary(15) NOT NULL,
974 `c2` int NOT NULL,
975 `c4` int DEFAULT NULL,
976 `c3` binary(20) DEFAULT NULL,
977 PRIMARY KEY (`c1`)
978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
979 DROP TABLE t1;
980 SHOW TABLES;
981 Tables_in_test
982 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
983 SHOW TABLES;
984 Tables_in_test
985 t1
986 SHOW CREATE TABLE t1;
987 Table Create Table
988 t1 CREATE TABLE `t1` (
989 `c1` varbinary(15) NOT NULL,
990 `c2` int NOT NULL,
991 `c3` varbinary(20) DEFAULT NULL,
992 PRIMARY KEY (`c1`)
993 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
994 ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
995 SHOW TABLES;
996 Tables_in_test
997 t1
998 SHOW CREATE TABLE t1;
999 Table Create Table
1000 t1 CREATE TABLE `t1` (
1001 `c1` varbinary(15) NOT NULL,
1002 `c2` int NOT NULL,
1003 `c4` int DEFAULT NULL,
1004 `c3` varbinary(20) DEFAULT NULL,
1005 PRIMARY KEY (`c1`)
1006 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1007 DROP TABLE t1;
1008 SHOW TABLES;
1009 Tables_in_test
1010 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1011 SHOW TABLES;
1012 Tables_in_test
1013 t1
1014 SHOW CREATE TABLE t1;
1015 Table Create Table
1016 t1 CREATE TABLE `t1` (
1017 `c1` char(15) NOT NULL,
1018 `c2` int NOT NULL,
1019 `c3` char(20) NOT NULL,
1020 PRIMARY KEY (`c1`)
1021 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1022 ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
1023 SHOW TABLES;
1024 Tables_in_test
1025 t1
1026 SHOW CREATE TABLE t1;
1027 Table Create Table
1028 t1 CREATE TABLE `t1` (
1029 `c1` char(15) NOT NULL,
1030 `c2` int NOT NULL,
1031 `c4` int NOT NULL,
1032 `c3` char(20) NOT NULL,
1033 PRIMARY KEY (`c1`)
1034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1035 DROP TABLE t1;
1036 SHOW TABLES;
1037 Tables_in_test
1038 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1039 SHOW TABLES;
1040 Tables_in_test
1041 t1
1042 SHOW CREATE TABLE t1;
1043 Table Create Table
1044 t1 CREATE TABLE `t1` (
1045 `c1` varchar(15) NOT NULL,
1046 `c2` int NOT NULL,
1047 `c3` varchar(20) NOT NULL,
1048 PRIMARY KEY (`c1`)
1049 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1050 ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
1051 SHOW TABLES;
1052 Tables_in_test
1053 t1
1054 SHOW CREATE TABLE t1;
1055 Table Create Table
1056 t1 CREATE TABLE `t1` (
1057 `c1` varchar(15) NOT NULL,
1058 `c2` int NOT NULL,
1059 `c4` int NOT NULL,
1060 `c3` varchar(20) NOT NULL,
1061 PRIMARY KEY (`c1`)
1062 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1063 DROP TABLE t1;
1064 SHOW TABLES;
1065 Tables_in_test
1066 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1067 SHOW TABLES;
1068 Tables_in_test
1069 t1
1070 SHOW CREATE TABLE t1;
1071 Table Create Table
1072 t1 CREATE TABLE `t1` (
1073 `c1` binary(15) NOT NULL,
1074 `c2` int NOT NULL,
1075 `c3` binary(20) NOT NULL,
1076 PRIMARY KEY (`c1`)
1077 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1078 ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
1079 SHOW TABLES;
1080 Tables_in_test
1081 t1
1082 SHOW CREATE TABLE t1;
1083 Table Create Table
1084 t1 CREATE TABLE `t1` (
1085 `c1` binary(15) NOT NULL,
1086 `c2` int NOT NULL,
1087 `c4` int NOT NULL,
1088 `c3` binary(20) NOT NULL,
1089 PRIMARY KEY (`c1`)
1090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1091 DROP TABLE t1;
1092 SHOW TABLES;
1093 Tables_in_test
1094 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1095 SHOW TABLES;
1096 Tables_in_test
1097 t1
1098 SHOW CREATE TABLE t1;
1099 Table Create Table
1100 t1 CREATE TABLE `t1` (
1101 `c1` varbinary(15) NOT NULL,
1102 `c2` int NOT NULL,
1103 `c3` varbinary(20) NOT NULL,
1104 PRIMARY KEY (`c1`)
1105 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1106 ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
1107 SHOW TABLES;
1108 Tables_in_test
1109 t1
1110 SHOW CREATE TABLE t1;
1111 Table Create Table
1112 t1 CREATE TABLE `t1` (
1113 `c1` varbinary(15) NOT NULL,
1114 `c2` int NOT NULL,
1115 `c4` int NOT NULL,
1116 `c3` varbinary(20) NOT NULL,
1117 PRIMARY KEY (`c1`)
1118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1119 DROP TABLE t1;
1120 SHOW TABLES;
1121 Tables_in_test
1122 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1123 SHOW TABLES;
1124 Tables_in_test
1125 t1
1126 SHOW CREATE TABLE t1;
1127 Table Create Table
1128 t1 CREATE TABLE `t1` (
1129 `c1` char(15) NOT NULL,
1130 `c2` int NOT NULL,
1131 `c3` char(20) DEFAULT NULL,
1132 PRIMARY KEY (`c1`)
1133 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1134 ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
1135 SHOW TABLES;
1136 Tables_in_test
1137 t1
1138 SHOW CREATE TABLE t1;
1139 Table Create Table
1140 t1 CREATE TABLE `t1` (
1141 `c1` char(15) NOT NULL,
1142 `c2` int NOT NULL,
1143 `c4` int DEFAULT NULL,
1144 `c3` char(20) DEFAULT NULL,
1145 PRIMARY KEY (`c1`)
1146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1147 DROP TABLE t1;
1148 SHOW TABLES;
1149 Tables_in_test
1150 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1151 SHOW TABLES;
1152 Tables_in_test
1153 t1
1154 SHOW CREATE TABLE t1;
1155 Table Create Table
1156 t1 CREATE TABLE `t1` (
1157 `c1` varchar(15) NOT NULL,
1158 `c2` int NOT NULL,
1159 `c3` varchar(20) DEFAULT NULL,
1160 PRIMARY KEY (`c1`)
1161 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1162 ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
1163 SHOW TABLES;
1164 Tables_in_test
1165 t1
1166 SHOW CREATE TABLE t1;
1167 Table Create Table
1168 t1 CREATE TABLE `t1` (
1169 `c1` varchar(15) NOT NULL,
1170 `c2` int NOT NULL,
1171 `c4` int DEFAULT NULL,
1172 `c3` varchar(20) DEFAULT NULL,
1173 PRIMARY KEY (`c1`)
1174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1175 DROP TABLE t1;
1176 SHOW TABLES;
1177 Tables_in_test
1178 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1179 SHOW TABLES;
1180 Tables_in_test
1181 t1
1182 SHOW CREATE TABLE t1;
1183 Table Create Table
1184 t1 CREATE TABLE `t1` (
1185 `c1` binary(15) NOT NULL,
1186 `c2` int NOT NULL,
1187 `c3` binary(20) DEFAULT NULL,
1188 PRIMARY KEY (`c1`)
1189 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1190 ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
1191 SHOW TABLES;
1192 Tables_in_test
1193 t1
1194 SHOW CREATE TABLE t1;
1195 Table Create Table
1196 t1 CREATE TABLE `t1` (
1197 `c1` binary(15) NOT NULL,
1198 `c2` int NOT NULL,
1199 `c4` int DEFAULT NULL,
1200 `c3` binary(20) DEFAULT NULL,
1201 PRIMARY KEY (`c1`)
1202 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1203 DROP TABLE t1;
1204 SHOW TABLES;
1205 Tables_in_test
1206 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1207 SHOW TABLES;
1208 Tables_in_test
1209 t1
1210 SHOW CREATE TABLE t1;
1211 Table Create Table
1212 t1 CREATE TABLE `t1` (
1213 `c1` varbinary(15) NOT NULL,
1214 `c2` int NOT NULL,
1215 `c3` varbinary(20) DEFAULT NULL,
1216 PRIMARY KEY (`c1`)
1217 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1218 ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
1219 SHOW TABLES;
1220 Tables_in_test
1221 t1
1222 SHOW CREATE TABLE t1;
1223 Table Create Table
1224 t1 CREATE TABLE `t1` (
1225 `c1` varbinary(15) NOT NULL,
1226 `c2` int NOT NULL,
1227 `c4` int DEFAULT NULL,
1228 `c3` varbinary(20) DEFAULT NULL,
1229 PRIMARY KEY (`c1`)
1230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1231 DROP TABLE t1;
1232 SHOW TABLES;
1233 Tables_in_test
1234 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1235 SHOW TABLES;
1236 Tables_in_test
1237 t1
1238 SHOW CREATE TABLE t1;
1239 Table Create Table
1240 t1 CREATE TABLE `t1` (
1241 `c1` char(15) NOT NULL,
1242 `c2` int NOT NULL,
1243 `c3` char(20) NOT NULL,
1244 PRIMARY KEY (`c1`)
1245 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1246 ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
1247 SHOW TABLES;
1248 Tables_in_test
1249 t1
1250 SHOW CREATE TABLE t1;
1251 Table Create Table
1252 t1 CREATE TABLE `t1` (
1253 `c1` char(15) NOT NULL,
1254 `c2` int NOT NULL,
1255 `c4` int NOT NULL,
1256 `c3` char(20) NOT NULL,
1257 PRIMARY KEY (`c1`)
1258 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1259 DROP TABLE t1;
1260 SHOW TABLES;
1261 Tables_in_test
1262 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1263 SHOW TABLES;
1264 Tables_in_test
1265 t1
1266 SHOW CREATE TABLE t1;
1267 Table Create Table
1268 t1 CREATE TABLE `t1` (
1269 `c1` varchar(15) NOT NULL,
1270 `c2` int NOT NULL,
1271 `c3` varchar(20) NOT NULL,
1272 PRIMARY KEY (`c1`)
1273 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1274 ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
1275 SHOW TABLES;
1276 Tables_in_test
1277 t1
1278 SHOW CREATE TABLE t1;
1279 Table Create Table
1280 t1 CREATE TABLE `t1` (
1281 `c1` varchar(15) NOT NULL,
1282 `c2` int NOT NULL,
1283 `c4` int NOT NULL,
1284 `c3` varchar(20) NOT NULL,
1285 PRIMARY KEY (`c1`)
1286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1287 DROP TABLE t1;
1288 SHOW TABLES;
1289 Tables_in_test
1290 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1291 SHOW TABLES;
1292 Tables_in_test
1293 t1
1294 SHOW CREATE TABLE t1;
1295 Table Create Table
1296 t1 CREATE TABLE `t1` (
1297 `c1` binary(15) NOT NULL,
1298 `c2` int NOT NULL,
1299 `c3` binary(20) NOT NULL,
1300 PRIMARY KEY (`c1`)
1301 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1302 ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
1303 SHOW TABLES;
1304 Tables_in_test
1305 t1
1306 SHOW CREATE TABLE t1;
1307 Table Create Table
1308 t1 CREATE TABLE `t1` (
1309 `c1` binary(15) NOT NULL,
1310 `c2` int NOT NULL,
1311 `c4` int NOT NULL,
1312 `c3` binary(20) NOT NULL,
1313 PRIMARY KEY (`c1`)
1314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1315 DROP TABLE t1;
1316 SHOW TABLES;
1317 Tables_in_test
1318 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1319 SHOW TABLES;
1320 Tables_in_test
1321 t1
1322 SHOW CREATE TABLE t1;
1323 Table Create Table
1324 t1 CREATE TABLE `t1` (
1325 `c1` varbinary(15) NOT NULL,
1326 `c2` int NOT NULL,
1327 `c3` varbinary(20) NOT NULL,
1328 PRIMARY KEY (`c1`)
1329 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1330 ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
1331 SHOW TABLES;
1332 Tables_in_test
1333 t1
1334 SHOW CREATE TABLE t1;
1335 Table Create Table
1336 t1 CREATE TABLE `t1` (
1337 `c1` varbinary(15) NOT NULL,
1338 `c2` int NOT NULL,
1339 `c4` int NOT NULL,
1340 `c3` varbinary(20) NOT NULL,
1341 PRIMARY KEY (`c1`)
1342 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1343 DROP TABLE t1;
1344 SHOW TABLES;
1345 Tables_in_test
1346 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1347 SHOW TABLES;
1348 Tables_in_test
1349 t1
1350 SHOW CREATE TABLE t1;
1351 Table Create Table
1352 t1 CREATE TABLE `t1` (
1353 `c1` char(15) NOT NULL,
1354 `c2` int NOT NULL,
1355 `c3` char(20) DEFAULT NULL,
1356 PRIMARY KEY (`c1`)
1357 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1358 ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
1359 SHOW TABLES;
1360 Tables_in_test
1361 t1
1362 SHOW CREATE TABLE t1;
1363 Table Create Table
1364 t1 CREATE TABLE `t1` (
1365 `c1` char(15) NOT NULL,
1366 `c2` int NOT NULL,
1367 `c4` bigint DEFAULT NULL,
1368 `c3` char(20) DEFAULT NULL,
1369 PRIMARY KEY (`c1`)
1370 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1371 DROP TABLE t1;
1372 SHOW TABLES;
1373 Tables_in_test
1374 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1375 SHOW TABLES;
1376 Tables_in_test
1377 t1
1378 SHOW CREATE TABLE t1;
1379 Table Create Table
1380 t1 CREATE TABLE `t1` (
1381 `c1` varchar(15) NOT NULL,
1382 `c2` int NOT NULL,
1383 `c3` varchar(20) DEFAULT NULL,
1384 PRIMARY KEY (`c1`)
1385 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1386 ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
1387 SHOW TABLES;
1388 Tables_in_test
1389 t1
1390 SHOW CREATE TABLE t1;
1391 Table Create Table
1392 t1 CREATE TABLE `t1` (
1393 `c1` varchar(15) NOT NULL,
1394 `c2` int NOT NULL,
1395 `c4` bigint DEFAULT NULL,
1396 `c3` varchar(20) DEFAULT NULL,
1397 PRIMARY KEY (`c1`)
1398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1399 DROP TABLE t1;
1400 SHOW TABLES;
1401 Tables_in_test
1402 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1403 SHOW TABLES;
1404 Tables_in_test
1405 t1
1406 SHOW CREATE TABLE t1;
1407 Table Create Table
1408 t1 CREATE TABLE `t1` (
1409 `c1` binary(15) NOT NULL,
1410 `c2` int NOT NULL,
1411 `c3` binary(20) DEFAULT NULL,
1412 PRIMARY KEY (`c1`)
1413 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1414 ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
1415 SHOW TABLES;
1416 Tables_in_test
1417 t1
1418 SHOW CREATE TABLE t1;
1419 Table Create Table
1420 t1 CREATE TABLE `t1` (
1421 `c1` binary(15) NOT NULL,
1422 `c2` int NOT NULL,
1423 `c4` bigint DEFAULT NULL,
1424 `c3` binary(20) DEFAULT NULL,
1425 PRIMARY KEY (`c1`)
1426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1427 DROP TABLE t1;
1428 SHOW TABLES;
1429 Tables_in_test
1430 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1431 SHOW TABLES;
1432 Tables_in_test
1433 t1
1434 SHOW CREATE TABLE t1;
1435 Table Create Table
1436 t1 CREATE TABLE `t1` (
1437 `c1` varbinary(15) NOT NULL,
1438 `c2` int NOT NULL,
1439 `c3` varbinary(20) DEFAULT NULL,
1440 PRIMARY KEY (`c1`)
1441 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1442 ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
1443 SHOW TABLES;
1444 Tables_in_test
1445 t1
1446 SHOW CREATE TABLE t1;
1447 Table Create Table
1448 t1 CREATE TABLE `t1` (
1449 `c1` varbinary(15) NOT NULL,
1450 `c2` int NOT NULL,
1451 `c4` bigint DEFAULT NULL,
1452 `c3` varbinary(20) DEFAULT NULL,
1453 PRIMARY KEY (`c1`)
1454 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1455 DROP TABLE t1;
1456 SHOW TABLES;
1457 Tables_in_test
1458 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1459 SHOW TABLES;
1460 Tables_in_test
1461 t1
1462 SHOW CREATE TABLE t1;
1463 Table Create Table
1464 t1 CREATE TABLE `t1` (
1465 `c1` char(15) NOT NULL,
1466 `c2` int NOT NULL,
1467 `c3` char(20) NOT NULL,
1468 PRIMARY KEY (`c1`)
1469 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1470 ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
1471 SHOW TABLES;
1472 Tables_in_test
1473 t1
1474 SHOW CREATE TABLE t1;
1475 Table Create Table
1476 t1 CREATE TABLE `t1` (
1477 `c1` char(15) NOT NULL,
1478 `c2` int NOT NULL,
1479 `c4` bigint NOT NULL,
1480 `c3` char(20) NOT NULL,
1481 PRIMARY KEY (`c1`)
1482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1483 DROP TABLE t1;
1484 SHOW TABLES;
1485 Tables_in_test
1486 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1487 SHOW TABLES;
1488 Tables_in_test
1489 t1
1490 SHOW CREATE TABLE t1;
1491 Table Create Table
1492 t1 CREATE TABLE `t1` (
1493 `c1` varchar(15) NOT NULL,
1494 `c2` int NOT NULL,
1495 `c3` varchar(20) NOT NULL,
1496 PRIMARY KEY (`c1`)
1497 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1498 ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
1499 SHOW TABLES;
1500 Tables_in_test
1501 t1
1502 SHOW CREATE TABLE t1;
1503 Table Create Table
1504 t1 CREATE TABLE `t1` (
1505 `c1` varchar(15) NOT NULL,
1506 `c2` int NOT NULL,
1507 `c4` bigint NOT NULL,
1508 `c3` varchar(20) NOT NULL,
1509 PRIMARY KEY (`c1`)
1510 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1511 DROP TABLE t1;
1512 SHOW TABLES;
1513 Tables_in_test
1514 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1515 SHOW TABLES;
1516 Tables_in_test
1517 t1
1518 SHOW CREATE TABLE t1;
1519 Table Create Table
1520 t1 CREATE TABLE `t1` (
1521 `c1` binary(15) NOT NULL,
1522 `c2` int NOT NULL,
1523 `c3` binary(20) NOT NULL,
1524 PRIMARY KEY (`c1`)
1525 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1526 ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
1527 SHOW TABLES;
1528 Tables_in_test
1529 t1
1530 SHOW CREATE TABLE t1;
1531 Table Create Table
1532 t1 CREATE TABLE `t1` (
1533 `c1` binary(15) NOT NULL,
1534 `c2` int NOT NULL,
1535 `c4` bigint NOT NULL,
1536 `c3` binary(20) NOT NULL,
1537 PRIMARY KEY (`c1`)
1538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1539 DROP TABLE t1;
1540 SHOW TABLES;
1541 Tables_in_test
1542 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1543 SHOW TABLES;
1544 Tables_in_test
1545 t1
1546 SHOW CREATE TABLE t1;
1547 Table Create Table
1548 t1 CREATE TABLE `t1` (
1549 `c1` varbinary(15) NOT NULL,
1550 `c2` int NOT NULL,
1551 `c3` varbinary(20) NOT NULL,
1552 PRIMARY KEY (`c1`)
1553 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1554 ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
1555 SHOW TABLES;
1556 Tables_in_test
1557 t1
1558 SHOW CREATE TABLE t1;
1559 Table Create Table
1560 t1 CREATE TABLE `t1` (
1561 `c1` varbinary(15) NOT NULL,
1562 `c2` int NOT NULL,
1563 `c4` bigint NOT NULL,
1564 `c3` varbinary(20) NOT NULL,
1565 PRIMARY KEY (`c1`)
1566 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1567 DROP TABLE t1;
1568 SHOW TABLES;
1569 Tables_in_test
1570 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1571 SHOW TABLES;
1572 Tables_in_test
1573 t1
1574 SHOW CREATE TABLE t1;
1575 Table Create Table
1576 t1 CREATE TABLE `t1` (
1577 `c1` char(15) NOT NULL,
1578 `c2` int NOT NULL,
1579 `c3` char(20) DEFAULT NULL,
1580 PRIMARY KEY (`c1`)
1581 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1582 ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
1583 SHOW TABLES;
1584 Tables_in_test
1585 t1
1586 SHOW CREATE TABLE t1;
1587 Table Create Table
1588 t1 CREATE TABLE `t1` (
1589 `c1` char(15) NOT NULL,
1590 `c2` int NOT NULL,
1591 `c4` double DEFAULT NULL,
1592 `c3` char(20) DEFAULT NULL,
1593 PRIMARY KEY (`c1`)
1594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1595 DROP TABLE t1;
1596 SHOW TABLES;
1597 Tables_in_test
1598 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1599 SHOW TABLES;
1600 Tables_in_test
1601 t1
1602 SHOW CREATE TABLE t1;
1603 Table Create Table
1604 t1 CREATE TABLE `t1` (
1605 `c1` varchar(15) NOT NULL,
1606 `c2` int NOT NULL,
1607 `c3` varchar(20) DEFAULT NULL,
1608 PRIMARY KEY (`c1`)
1609 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1610 ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
1611 SHOW TABLES;
1612 Tables_in_test
1613 t1
1614 SHOW CREATE TABLE t1;
1615 Table Create Table
1616 t1 CREATE TABLE `t1` (
1617 `c1` varchar(15) NOT NULL,
1618 `c2` int NOT NULL,
1619 `c4` double DEFAULT NULL,
1620 `c3` varchar(20) DEFAULT NULL,
1621 PRIMARY KEY (`c1`)
1622 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1623 DROP TABLE t1;
1624 SHOW TABLES;
1625 Tables_in_test
1626 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1627 SHOW TABLES;
1628 Tables_in_test
1629 t1
1630 SHOW CREATE TABLE t1;
1631 Table Create Table
1632 t1 CREATE TABLE `t1` (
1633 `c1` binary(15) NOT NULL,
1634 `c2` int NOT NULL,
1635 `c3` binary(20) DEFAULT NULL,
1636 PRIMARY KEY (`c1`)
1637 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1638 ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
1639 SHOW TABLES;
1640 Tables_in_test
1641 t1
1642 SHOW CREATE TABLE t1;
1643 Table Create Table
1644 t1 CREATE TABLE `t1` (
1645 `c1` binary(15) NOT NULL,
1646 `c2` int NOT NULL,
1647 `c4` double DEFAULT NULL,
1648 `c3` binary(20) DEFAULT NULL,
1649 PRIMARY KEY (`c1`)
1650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1651 DROP TABLE t1;
1652 SHOW TABLES;
1653 Tables_in_test
1654 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1655 SHOW TABLES;
1656 Tables_in_test
1657 t1
1658 SHOW CREATE TABLE t1;
1659 Table Create Table
1660 t1 CREATE TABLE `t1` (
1661 `c1` varbinary(15) NOT NULL,
1662 `c2` int NOT NULL,
1663 `c3` varbinary(20) DEFAULT NULL,
1664 PRIMARY KEY (`c1`)
1665 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1666 ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
1667 SHOW TABLES;
1668 Tables_in_test
1669 t1
1670 SHOW CREATE TABLE t1;
1671 Table Create Table
1672 t1 CREATE TABLE `t1` (
1673 `c1` varbinary(15) NOT NULL,
1674 `c2` int NOT NULL,
1675 `c4` double DEFAULT NULL,
1676 `c3` varbinary(20) DEFAULT NULL,
1677 PRIMARY KEY (`c1`)
1678 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1679 DROP TABLE t1;
1680 SHOW TABLES;
1681 Tables_in_test
1682 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1683 SHOW TABLES;
1684 Tables_in_test
1685 t1
1686 SHOW CREATE TABLE t1;
1687 Table Create Table
1688 t1 CREATE TABLE `t1` (
1689 `c1` char(15) NOT NULL,
1690 `c2` int NOT NULL,
1691 `c3` char(20) NOT NULL,
1692 PRIMARY KEY (`c1`)
1693 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1694 ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
1695 SHOW TABLES;
1696 Tables_in_test
1697 t1
1698 SHOW CREATE TABLE t1;
1699 Table Create Table
1700 t1 CREATE TABLE `t1` (
1701 `c1` char(15) NOT NULL,
1702 `c2` int NOT NULL,
1703 `c4` double NOT NULL,
1704 `c3` char(20) NOT NULL,
1705 PRIMARY KEY (`c1`)
1706 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1707 DROP TABLE t1;
1708 SHOW TABLES;
1709 Tables_in_test
1710 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1711 SHOW TABLES;
1712 Tables_in_test
1713 t1
1714 SHOW CREATE TABLE t1;
1715 Table Create Table
1716 t1 CREATE TABLE `t1` (
1717 `c1` varchar(15) NOT NULL,
1718 `c2` int NOT NULL,
1719 `c3` varchar(20) NOT NULL,
1720 PRIMARY KEY (`c1`)
1721 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1722 ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
1723 SHOW TABLES;
1724 Tables_in_test
1725 t1
1726 SHOW CREATE TABLE t1;
1727 Table Create Table
1728 t1 CREATE TABLE `t1` (
1729 `c1` varchar(15) NOT NULL,
1730 `c2` int NOT NULL,
1731 `c4` double NOT NULL,
1732 `c3` varchar(20) NOT NULL,
1733 PRIMARY KEY (`c1`)
1734 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1735 DROP TABLE t1;
1736 SHOW TABLES;
1737 Tables_in_test
1738 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1739 SHOW TABLES;
1740 Tables_in_test
1741 t1
1742 SHOW CREATE TABLE t1;
1743 Table Create Table
1744 t1 CREATE TABLE `t1` (
1745 `c1` binary(15) NOT NULL,
1746 `c2` int NOT NULL,
1747 `c3` binary(20) NOT NULL,
1748 PRIMARY KEY (`c1`)
1749 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1750 ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
1751 SHOW TABLES;
1752 Tables_in_test
1753 t1
1754 SHOW CREATE TABLE t1;
1755 Table Create Table
1756 t1 CREATE TABLE `t1` (
1757 `c1` binary(15) NOT NULL,
1758 `c2` int NOT NULL,
1759 `c4` double NOT NULL,
1760 `c3` binary(20) NOT NULL,
1761 PRIMARY KEY (`c1`)
1762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1763 DROP TABLE t1;
1764 SHOW TABLES;
1765 Tables_in_test
1766 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1767 SHOW TABLES;
1768 Tables_in_test
1769 t1
1770 SHOW CREATE TABLE t1;
1771 Table Create Table
1772 t1 CREATE TABLE `t1` (
1773 `c1` varbinary(15) NOT NULL,
1774 `c2` int NOT NULL,
1775 `c3` varbinary(20) NOT NULL,
1776 PRIMARY KEY (`c1`)
1777 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1778 ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
1779 SHOW TABLES;
1780 Tables_in_test
1781 t1
1782 SHOW CREATE TABLE t1;
1783 Table Create Table
1784 t1 CREATE TABLE `t1` (
1785 `c1` varbinary(15) NOT NULL,
1786 `c2` int NOT NULL,
1787 `c4` double NOT NULL,
1788 `c3` varbinary(20) NOT NULL,
1789 PRIMARY KEY (`c1`)
1790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1791 DROP TABLE t1;
1792 SHOW TABLES;
1793 Tables_in_test
1794 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1795 SHOW TABLES;
1796 Tables_in_test
1797 t1
1798 SHOW CREATE TABLE t1;
1799 Table Create Table
1800 t1 CREATE TABLE `t1` (
1801 `c1` char(15) NOT NULL,
1802 `c2` int NOT NULL,
1803 `c3` char(20) DEFAULT NULL,
1804 PRIMARY KEY (`c1`)
1805 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1806 ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
1807 SHOW TABLES;
1808 Tables_in_test
1809 t1
1810 SHOW CREATE TABLE t1;
1811 Table Create Table
1812 t1 CREATE TABLE `t1` (
1813 `c1` char(15) NOT NULL,
1814 `c2` int NOT NULL,
1815 `c4` double DEFAULT NULL,
1816 `c3` char(20) DEFAULT NULL,
1817 PRIMARY KEY (`c1`)
1818 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1819 DROP TABLE t1;
1820 SHOW TABLES;
1821 Tables_in_test
1822 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1823 SHOW TABLES;
1824 Tables_in_test
1825 t1
1826 SHOW CREATE TABLE t1;
1827 Table Create Table
1828 t1 CREATE TABLE `t1` (
1829 `c1` varchar(15) NOT NULL,
1830 `c2` int NOT NULL,
1831 `c3` varchar(20) DEFAULT NULL,
1832 PRIMARY KEY (`c1`)
1833 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1834 ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
1835 SHOW TABLES;
1836 Tables_in_test
1837 t1
1838 SHOW CREATE TABLE t1;
1839 Table Create Table
1840 t1 CREATE TABLE `t1` (
1841 `c1` varchar(15) NOT NULL,
1842 `c2` int NOT NULL,
1843 `c4` double DEFAULT NULL,
1844 `c3` varchar(20) DEFAULT NULL,
1845 PRIMARY KEY (`c1`)
1846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1847 DROP TABLE t1;
1848 SHOW TABLES;
1849 Tables_in_test
1850 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1851 SHOW TABLES;
1852 Tables_in_test
1853 t1
1854 SHOW CREATE TABLE t1;
1855 Table Create Table
1856 t1 CREATE TABLE `t1` (
1857 `c1` binary(15) NOT NULL,
1858 `c2` int NOT NULL,
1859 `c3` binary(20) DEFAULT NULL,
1860 PRIMARY KEY (`c1`)
1861 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1862 ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
1863 SHOW TABLES;
1864 Tables_in_test
1865 t1
1866 SHOW CREATE TABLE t1;
1867 Table Create Table
1868 t1 CREATE TABLE `t1` (
1869 `c1` binary(15) NOT NULL,
1870 `c2` int NOT NULL,
1871 `c4` double DEFAULT NULL,
1872 `c3` binary(20) DEFAULT NULL,
1873 PRIMARY KEY (`c1`)
1874 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1875 DROP TABLE t1;
1876 SHOW TABLES;
1877 Tables_in_test
1878 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1879 SHOW TABLES;
1880 Tables_in_test
1881 t1
1882 SHOW CREATE TABLE t1;
1883 Table Create Table
1884 t1 CREATE TABLE `t1` (
1885 `c1` varbinary(15) NOT NULL,
1886 `c2` int NOT NULL,
1887 `c3` varbinary(20) DEFAULT NULL,
1888 PRIMARY KEY (`c1`)
1889 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1890 ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
1891 SHOW TABLES;
1892 Tables_in_test
1893 t1
1894 SHOW CREATE TABLE t1;
1895 Table Create Table
1896 t1 CREATE TABLE `t1` (
1897 `c1` varbinary(15) NOT NULL,
1898 `c2` int NOT NULL,
1899 `c4` double DEFAULT NULL,
1900 `c3` varbinary(20) DEFAULT NULL,
1901 PRIMARY KEY (`c1`)
1902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1903 DROP TABLE t1;
1904 SHOW TABLES;
1905 Tables_in_test
1906 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1907 SHOW TABLES;
1908 Tables_in_test
1909 t1
1910 SHOW CREATE TABLE t1;
1911 Table Create Table
1912 t1 CREATE TABLE `t1` (
1913 `c1` char(15) NOT NULL,
1914 `c2` int NOT NULL,
1915 `c3` char(20) NOT NULL,
1916 PRIMARY KEY (`c1`)
1917 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1918 ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
1919 SHOW TABLES;
1920 Tables_in_test
1921 t1
1922 SHOW CREATE TABLE t1;
1923 Table Create Table
1924 t1 CREATE TABLE `t1` (
1925 `c1` char(15) NOT NULL,
1926 `c2` int NOT NULL,
1927 `c4` double NOT NULL,
1928 `c3` char(20) NOT NULL,
1929 PRIMARY KEY (`c1`)
1930 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1931 DROP TABLE t1;
1932 SHOW TABLES;
1933 Tables_in_test
1934 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1935 SHOW TABLES;
1936 Tables_in_test
1937 t1
1938 SHOW CREATE TABLE t1;
1939 Table Create Table
1940 t1 CREATE TABLE `t1` (
1941 `c1` varchar(15) NOT NULL,
1942 `c2` int NOT NULL,
1943 `c3` varchar(20) NOT NULL,
1944 PRIMARY KEY (`c1`)
1945 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1946 ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
1947 SHOW TABLES;
1948 Tables_in_test
1949 t1
1950 SHOW CREATE TABLE t1;
1951 Table Create Table
1952 t1 CREATE TABLE `t1` (
1953 `c1` varchar(15) NOT NULL,
1954 `c2` int NOT NULL,
1955 `c4` double NOT NULL,
1956 `c3` varchar(20) NOT NULL,
1957 PRIMARY KEY (`c1`)
1958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1959 DROP TABLE t1;
1960 SHOW TABLES;
1961 Tables_in_test
1962 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1963 SHOW TABLES;
1964 Tables_in_test
1965 t1
1966 SHOW CREATE TABLE t1;
1967 Table Create Table
1968 t1 CREATE TABLE `t1` (
1969 `c1` binary(15) NOT NULL,
1970 `c2` int NOT NULL,
1971 `c3` binary(20) NOT NULL,
1972 PRIMARY KEY (`c1`)
1973 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1974 ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
1975 SHOW TABLES;
1976 Tables_in_test
1977 t1
1978 SHOW CREATE TABLE t1;
1979 Table Create Table
1980 t1 CREATE TABLE `t1` (
1981 `c1` binary(15) NOT NULL,
1982 `c2` int NOT NULL,
1983 `c4` double NOT NULL,
1984 `c3` binary(20) NOT NULL,
1985 PRIMARY KEY (`c1`)
1986 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1987 DROP TABLE t1;
1988 SHOW TABLES;
1989 Tables_in_test
1990 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1991 SHOW TABLES;
1992 Tables_in_test
1993 t1
1994 SHOW CREATE TABLE t1;
1995 Table Create Table
1996 t1 CREATE TABLE `t1` (
1997 `c1` varbinary(15) NOT NULL,
1998 `c2` int NOT NULL,
1999 `c3` varbinary(20) NOT NULL,
2000 PRIMARY KEY (`c1`)
2001 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2002 ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
2003 SHOW TABLES;
2004 Tables_in_test
2005 t1
2006 SHOW CREATE TABLE t1;
2007 Table Create Table
2008 t1 CREATE TABLE `t1` (
2009 `c1` varbinary(15) NOT NULL,
2010 `c2` int NOT NULL,
2011 `c4` double NOT NULL,
2012 `c3` varbinary(20) NOT NULL,
2013 PRIMARY KEY (`c1`)
2014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2015 DROP TABLE t1;
2016 SHOW TABLES;
2017 Tables_in_test
2018 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
2019 SHOW TABLES;
2020 Tables_in_test
2021 t1
2022 SHOW CREATE TABLE t1;
2023 Table Create Table
2024 t1 CREATE TABLE `t1` (
2025 `c1` char(15) NOT NULL,
2026 `c2` int NOT NULL,
2027 `c3` char(20) DEFAULT NULL,
2028 PRIMARY KEY (`c1`)
2029 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2030 ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
2031 SHOW TABLES;
2032 Tables_in_test
2033 t1
2034 SHOW CREATE TABLE t1;
2035 Table Create Table
2036 t1 CREATE TABLE `t1` (
2037 `c1` char(15) NOT NULL,
2038 `c2` int NOT NULL,
2039 `c4` float DEFAULT NULL,
2040 `c3` char(20) DEFAULT NULL,
2041 PRIMARY KEY (`c1`)
2042 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2043 DROP TABLE t1;
2044 SHOW TABLES;
2045 Tables_in_test
2046 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
2047 SHOW TABLES;
2048 Tables_in_test
2049 t1
2050 SHOW CREATE TABLE t1;
2051 Table Create Table
2052 t1 CREATE TABLE `t1` (
2053 `c1` varchar(15) NOT NULL,
2054 `c2` int NOT NULL,
2055 `c3` varchar(20) DEFAULT NULL,
2056 PRIMARY KEY (`c1`)
2057 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2058 ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
2059 SHOW TABLES;
2060 Tables_in_test
2061 t1
2062 SHOW CREATE TABLE t1;
2063 Table Create Table
2064 t1 CREATE TABLE `t1` (
2065 `c1` varchar(15) NOT NULL,
2066 `c2` int NOT NULL,
2067 `c4` float DEFAULT NULL,
2068 `c3` varchar(20) DEFAULT NULL,
2069 PRIMARY KEY (`c1`)
2070 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2071 DROP TABLE t1;
2072 SHOW TABLES;
2073 Tables_in_test
2074 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
2075 SHOW TABLES;
2076 Tables_in_test
2077 t1
2078 SHOW CREATE TABLE t1;
2079 Table Create Table
2080 t1 CREATE TABLE `t1` (
2081 `c1` binary(15) NOT NULL,
2082 `c2` int NOT NULL,
2083 `c3` binary(20) DEFAULT NULL,
2084 PRIMARY KEY (`c1`)
2085 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2086 ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
2087 SHOW TABLES;
2088 Tables_in_test
2089 t1
2090 SHOW CREATE TABLE t1;
2091 Table Create Table
2092 t1 CREATE TABLE `t1` (
2093 `c1` binary(15) NOT NULL,
2094 `c2` int NOT NULL,
2095 `c4` float DEFAULT NULL,
2096 `c3` binary(20) DEFAULT NULL,
2097 PRIMARY KEY (`c1`)
2098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2099 DROP TABLE t1;
2100 SHOW TABLES;
2101 Tables_in_test
2102 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
2103 SHOW TABLES;
2104 Tables_in_test
2105 t1
2106 SHOW CREATE TABLE t1;
2107 Table Create Table
2108 t1 CREATE TABLE `t1` (
2109 `c1` varbinary(15) NOT NULL,
2110 `c2` int NOT NULL,
2111 `c3` varbinary(20) DEFAULT NULL,
2112 PRIMARY KEY (`c1`)
2113 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2114 ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
2115 SHOW TABLES;
2116 Tables_in_test
2117 t1
2118 SHOW CREATE TABLE t1;
2119 Table Create Table
2120 t1 CREATE TABLE `t1` (
2121 `c1` varbinary(15) NOT NULL,
2122 `c2` int NOT NULL,
2123 `c4` float DEFAULT NULL,
2124 `c3` varbinary(20) DEFAULT NULL,
2125 PRIMARY KEY (`c1`)
2126 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2127 DROP TABLE t1;
2128 SHOW TABLES;
2129 Tables_in_test
2130 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
2131 SHOW TABLES;
2132 Tables_in_test
2133 t1
2134 SHOW CREATE TABLE t1;
2135 Table Create Table
2136 t1 CREATE TABLE `t1` (
2137 `c1` char(15) NOT NULL,
2138 `c2` int NOT NULL,
2139 `c3` char(20) NOT NULL,
2140 PRIMARY KEY (`c1`)
2141 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2142 ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
2143 SHOW TABLES;
2144 Tables_in_test
2145 t1
2146 SHOW CREATE TABLE t1;
2147 Table Create Table
2148 t1 CREATE TABLE `t1` (
2149 `c1` char(15) NOT NULL,
2150 `c2` int NOT NULL,
2151 `c4` float NOT NULL,
2152 `c3` char(20) NOT NULL,
2153 PRIMARY KEY (`c1`)
2154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2155 DROP TABLE t1;
2156 SHOW TABLES;
2157 Tables_in_test
2158 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
2159 SHOW TABLES;
2160 Tables_in_test
2161 t1
2162 SHOW CREATE TABLE t1;
2163 Table Create Table
2164 t1 CREATE TABLE `t1` (
2165 `c1` varchar(15) NOT NULL,
2166 `c2` int NOT NULL,
2167 `c3` varchar(20) NOT NULL,
2168 PRIMARY KEY (`c1`)
2169 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2170 ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
2171 SHOW TABLES;
2172 Tables_in_test
2173 t1
2174 SHOW CREATE TABLE t1;
2175 Table Create Table
2176 t1 CREATE TABLE `t1` (
2177 `c1` varchar(15) NOT NULL,
2178 `c2` int NOT NULL,
2179 `c4` float NOT NULL,
2180 `c3` varchar(20) NOT NULL,
2181 PRIMARY KEY (`c1`)
2182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2183 DROP TABLE t1;
2184 SHOW TABLES;
2185 Tables_in_test
2186 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
2187 SHOW TABLES;
2188 Tables_in_test
2189 t1
2190 SHOW CREATE TABLE t1;
2191 Table Create Table
2192 t1 CREATE TABLE `t1` (
2193 `c1` binary(15) NOT NULL,
2194 `c2` int NOT NULL,
2195 `c3` binary(20) NOT NULL,
2196 PRIMARY KEY (`c1`)
2197 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2198 ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
2199 SHOW TABLES;
2200 Tables_in_test
2201 t1
2202 SHOW CREATE TABLE t1;
2203 Table Create Table
2204 t1 CREATE TABLE `t1` (
2205 `c1` binary(15) NOT NULL,
2206 `c2` int NOT NULL,
2207 `c4` float NOT NULL,
2208 `c3` binary(20) NOT NULL,
2209 PRIMARY KEY (`c1`)
2210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2211 DROP TABLE t1;
2212 SHOW TABLES;
2213 Tables_in_test
2214 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
2215 SHOW TABLES;
2216 Tables_in_test
2217 t1
2218 SHOW CREATE TABLE t1;
2219 Table Create Table
2220 t1 CREATE TABLE `t1` (
2221 `c1` varbinary(15) NOT NULL,
2222 `c2` int NOT NULL,
2223 `c3` varbinary(20) NOT NULL,
2224 PRIMARY KEY (`c1`)
2225 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2226 ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
2227 SHOW TABLES;
2228 Tables_in_test
2229 t1
2230 SHOW CREATE TABLE t1;
2231 Table Create Table
2232 t1 CREATE TABLE `t1` (
2233 `c1` varbinary(15) NOT NULL,
2234 `c2` int NOT NULL,
2235 `c4` float NOT NULL,
2236 `c3` varbinary(20) NOT NULL,
2237 PRIMARY KEY (`c1`)
2238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2239 DROP TABLE t1;
2240 SHOW TABLES;
2241 Tables_in_test
2242 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
2243 SHOW TABLES;
2244 Tables_in_test
2245 t1
2246 SHOW CREATE TABLE t1;
2247 Table Create Table
2248 t1 CREATE TABLE `t1` (
2249 `c1` char(15) NOT NULL,
2250 `c2` int NOT NULL,
2251 `c3` char(20) DEFAULT NULL,
2252 PRIMARY KEY (`c1`)
2253 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2254 ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
2255 SHOW TABLES;
2256 Tables_in_test
2257 t1
2258 SHOW CREATE TABLE t1;
2259 Table Create Table
2260 t1 CREATE TABLE `t1` (
2261 `c1` char(15) NOT NULL,
2262 `c2` int NOT NULL,
2263 `c4` decimal(10,0) DEFAULT NULL,
2264 `c3` char(20) DEFAULT NULL,
2265 PRIMARY KEY (`c1`)
2266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2267 DROP TABLE t1;
2268 SHOW TABLES;
2269 Tables_in_test
2270 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
2271 SHOW TABLES;
2272 Tables_in_test
2273 t1
2274 SHOW CREATE TABLE t1;
2275 Table Create Table
2276 t1 CREATE TABLE `t1` (
2277 `c1` varchar(15) NOT NULL,
2278 `c2` int NOT NULL,
2279 `c3` varchar(20) DEFAULT NULL,
2280 PRIMARY KEY (`c1`)
2281 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2282 ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
2283 SHOW TABLES;
2284 Tables_in_test
2285 t1
2286 SHOW CREATE TABLE t1;
2287 Table Create Table
2288 t1 CREATE TABLE `t1` (
2289 `c1` varchar(15) NOT NULL,
2290 `c2` int NOT NULL,
2291 `c4` decimal(10,0) DEFAULT NULL,
2292 `c3` varchar(20) DEFAULT NULL,
2293 PRIMARY KEY (`c1`)
2294 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2295 DROP TABLE t1;
2296 SHOW TABLES;
2297 Tables_in_test
2298 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
2299 SHOW TABLES;
2300 Tables_in_test
2301 t1
2302 SHOW CREATE TABLE t1;
2303 Table Create Table
2304 t1 CREATE TABLE `t1` (
2305 `c1` binary(15) NOT NULL,
2306 `c2` int NOT NULL,
2307 `c3` binary(20) DEFAULT NULL,
2308 PRIMARY KEY (`c1`)
2309 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2310 ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
2311 SHOW TABLES;
2312 Tables_in_test
2313 t1
2314 SHOW CREATE TABLE t1;
2315 Table Create Table
2316 t1 CREATE TABLE `t1` (
2317 `c1` binary(15) NOT NULL,
2318 `c2` int NOT NULL,
2319 `c4` decimal(10,0) DEFAULT NULL,
2320 `c3` binary(20) DEFAULT NULL,
2321 PRIMARY KEY (`c1`)
2322 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2323 DROP TABLE t1;
2324 SHOW TABLES;
2325 Tables_in_test
2326 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
2327 SHOW TABLES;
2328 Tables_in_test
2329 t1
2330 SHOW CREATE TABLE t1;
2331 Table Create Table
2332 t1 CREATE TABLE `t1` (
2333 `c1` varbinary(15) NOT NULL,
2334 `c2` int NOT NULL,
2335 `c3` varbinary(20) DEFAULT NULL,
2336 PRIMARY KEY (`c1`)
2337 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2338 ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
2339 SHOW TABLES;
2340 Tables_in_test
2341 t1
2342 SHOW CREATE TABLE t1;
2343 Table Create Table
2344 t1 CREATE TABLE `t1` (
2345 `c1` varbinary(15) NOT NULL,
2346 `c2` int NOT NULL,
2347 `c4` decimal(10,0) DEFAULT NULL,
2348 `c3` varbinary(20) DEFAULT NULL,
2349 PRIMARY KEY (`c1`)
2350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2351 DROP TABLE t1;
2352 SHOW TABLES;
2353 Tables_in_test
2354 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
2355 SHOW TABLES;
2356 Tables_in_test
2357 t1
2358 SHOW CREATE TABLE t1;
2359 Table Create Table
2360 t1 CREATE TABLE `t1` (
2361 `c1` char(15) NOT NULL,
2362 `c2` int NOT NULL,
2363 `c3` char(20) NOT NULL,
2364 PRIMARY KEY (`c1`)
2365 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2366 ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
2367 SHOW TABLES;
2368 Tables_in_test
2369 t1
2370 SHOW CREATE TABLE t1;
2371 Table Create Table
2372 t1 CREATE TABLE `t1` (
2373 `c1` char(15) NOT NULL,
2374 `c2` int NOT NULL,
2375 `c4` decimal(10,0) NOT NULL,
2376 `c3` char(20) NOT NULL,
2377 PRIMARY KEY (`c1`)
2378 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2379 DROP TABLE t1;
2380 SHOW TABLES;
2381 Tables_in_test
2382 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
2383 SHOW TABLES;
2384 Tables_in_test
2385 t1
2386 SHOW CREATE TABLE t1;
2387 Table Create Table
2388 t1 CREATE TABLE `t1` (
2389 `c1` varchar(15) NOT NULL,
2390 `c2` int NOT NULL,
2391 `c3` varchar(20) NOT NULL,
2392 PRIMARY KEY (`c1`)
2393 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2394 ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
2395 SHOW TABLES;
2396 Tables_in_test
2397 t1
2398 SHOW CREATE TABLE t1;
2399 Table Create Table
2400 t1 CREATE TABLE `t1` (
2401 `c1` varchar(15) NOT NULL,
2402 `c2` int NOT NULL,
2403 `c4` decimal(10,0) NOT NULL,
2404 `c3` varchar(20) NOT NULL,
2405 PRIMARY KEY (`c1`)
2406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2407 DROP TABLE t1;
2408 SHOW TABLES;
2409 Tables_in_test
2410 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
2411 SHOW TABLES;
2412 Tables_in_test
2413 t1
2414 SHOW CREATE TABLE t1;
2415 Table Create Table
2416 t1 CREATE TABLE `t1` (
2417 `c1` binary(15) NOT NULL,
2418 `c2` int NOT NULL,
2419 `c3` binary(20) NOT NULL,
2420 PRIMARY KEY (`c1`)
2421 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2422 ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
2423 SHOW TABLES;
2424 Tables_in_test
2425 t1
2426 SHOW CREATE TABLE t1;
2427 Table Create Table
2428 t1 CREATE TABLE `t1` (
2429 `c1` binary(15) NOT NULL,
2430 `c2` int NOT NULL,
2431 `c4` decimal(10,0) NOT NULL,
2432 `c3` binary(20) NOT NULL,
2433 PRIMARY KEY (`c1`)
2434 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2435 DROP TABLE t1;
2436 SHOW TABLES;
2437 Tables_in_test
2438 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
2439 SHOW TABLES;
2440 Tables_in_test
2441 t1
2442 SHOW CREATE TABLE t1;
2443 Table Create Table
2444 t1 CREATE TABLE `t1` (
2445 `c1` varbinary(15) NOT NULL,
2446 `c2` int NOT NULL,
2447 `c3` varbinary(20) NOT NULL,
2448 PRIMARY KEY (`c1`)
2449 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2450 ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
2451 SHOW TABLES;
2452 Tables_in_test
2453 t1
2454 SHOW CREATE TABLE t1;
2455 Table Create Table
2456 t1 CREATE TABLE `t1` (
2457 `c1` varbinary(15) NOT NULL,
2458 `c2` int NOT NULL,
2459 `c4` decimal(10,0) NOT NULL,
2460 `c3` varbinary(20) NOT NULL,
2461 PRIMARY KEY (`c1`)
2462 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2463 DROP TABLE t1;
2464 SHOW TABLES;
2465 Tables_in_test
2466 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
2467 SHOW TABLES;
2468 Tables_in_test
2469 t1
2470 SHOW CREATE TABLE t1;
2471 Table Create Table
2472 t1 CREATE TABLE `t1` (
2473 `c1` char(15) NOT NULL,
2474 `c2` int NOT NULL,
2475 `c3` char(20) DEFAULT NULL,
2476 PRIMARY KEY (`c1`)
2477 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2478 ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
2479 SHOW TABLES;
2480 Tables_in_test
2481 t1
2482 SHOW CREATE TABLE t1;
2483 Table Create Table
2484 t1 CREATE TABLE `t1` (
2485 `c1` char(15) NOT NULL,
2486 `c2` int NOT NULL,
2487 `c4` decimal(10,0) DEFAULT NULL,
2488 `c3` char(20) DEFAULT NULL,
2489 PRIMARY KEY (`c1`)
2490 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2491 DROP TABLE t1;
2492 SHOW TABLES;
2493 Tables_in_test
2494 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
2495 SHOW TABLES;
2496 Tables_in_test
2497 t1
2498 SHOW CREATE TABLE t1;
2499 Table Create Table
2500 t1 CREATE TABLE `t1` (
2501 `c1` varchar(15) NOT NULL,
2502 `c2` int NOT NULL,
2503 `c3` varchar(20) DEFAULT NULL,
2504 PRIMARY KEY (`c1`)
2505 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2506 ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
2507 SHOW TABLES;
2508 Tables_in_test
2509 t1
2510 SHOW CREATE TABLE t1;
2511 Table Create Table
2512 t1 CREATE TABLE `t1` (
2513 `c1` varchar(15) NOT NULL,
2514 `c2` int NOT NULL,
2515 `c4` decimal(10,0) DEFAULT NULL,
2516 `c3` varchar(20) DEFAULT NULL,
2517 PRIMARY KEY (`c1`)
2518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2519 DROP TABLE t1;
2520 SHOW TABLES;
2521 Tables_in_test
2522 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
2523 SHOW TABLES;
2524 Tables_in_test
2525 t1
2526 SHOW CREATE TABLE t1;
2527 Table Create Table
2528 t1 CREATE TABLE `t1` (
2529 `c1` binary(15) NOT NULL,
2530 `c2` int NOT NULL,
2531 `c3` binary(20) DEFAULT NULL,
2532 PRIMARY KEY (`c1`)
2533 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2534 ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
2535 SHOW TABLES;
2536 Tables_in_test
2537 t1
2538 SHOW CREATE TABLE t1;
2539 Table Create Table
2540 t1 CREATE TABLE `t1` (
2541 `c1` binary(15) NOT NULL,
2542 `c2` int NOT NULL,
2543 `c4` decimal(10,0) DEFAULT NULL,
2544 `c3` binary(20) DEFAULT NULL,
2545 PRIMARY KEY (`c1`)
2546 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2547 DROP TABLE t1;
2548 SHOW TABLES;
2549 Tables_in_test
2550 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
2551 SHOW TABLES;
2552 Tables_in_test
2553 t1
2554 SHOW CREATE TABLE t1;
2555 Table Create Table
2556 t1 CREATE TABLE `t1` (
2557 `c1` varbinary(15) NOT NULL,
2558 `c2` int NOT NULL,
2559 `c3` varbinary(20) DEFAULT NULL,
2560 PRIMARY KEY (`c1`)
2561 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2562 ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
2563 SHOW TABLES;
2564 Tables_in_test
2565 t1
2566 SHOW CREATE TABLE t1;
2567 Table Create Table
2568 t1 CREATE TABLE `t1` (
2569 `c1` varbinary(15) NOT NULL,
2570 `c2` int NOT NULL,
2571 `c4` decimal(10,0) DEFAULT NULL,
2572 `c3` varbinary(20) DEFAULT NULL,
2573 PRIMARY KEY (`c1`)
2574 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2575 DROP TABLE t1;
2576 SHOW TABLES;
2577 Tables_in_test
2578 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
2579 SHOW TABLES;
2580 Tables_in_test
2581 t1
2582 SHOW CREATE TABLE t1;
2583 Table Create Table
2584 t1 CREATE TABLE `t1` (
2585 `c1` char(15) NOT NULL,
2586 `c2` int NOT NULL,
2587 `c3` char(20) NOT NULL,
2588 PRIMARY KEY (`c1`)
2589 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2590 ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
2591 SHOW TABLES;
2592 Tables_in_test
2593 t1
2594 SHOW CREATE TABLE t1;
2595 Table Create Table
2596 t1 CREATE TABLE `t1` (
2597 `c1` char(15) NOT NULL,
2598 `c2` int NOT NULL,
2599 `c4` decimal(10,0) NOT NULL,
2600 `c3` char(20) NOT NULL,
2601 PRIMARY KEY (`c1`)
2602 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2603 DROP TABLE t1;
2604 SHOW TABLES;
2605 Tables_in_test
2606 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
2607 SHOW TABLES;
2608 Tables_in_test
2609 t1
2610 SHOW CREATE TABLE t1;
2611 Table Create Table
2612 t1 CREATE TABLE `t1` (
2613 `c1` varchar(15) NOT NULL,
2614 `c2` int NOT NULL,
2615 `c3` varchar(20) NOT NULL,
2616 PRIMARY KEY (`c1`)
2617 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2618 ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
2619 SHOW TABLES;
2620 Tables_in_test
2621 t1
2622 SHOW CREATE TABLE t1;
2623 Table Create Table
2624 t1 CREATE TABLE `t1` (
2625 `c1` varchar(15) NOT NULL,
2626 `c2` int NOT NULL,
2627 `c4` decimal(10,0) NOT NULL,
2628 `c3` varchar(20) NOT NULL,
2629 PRIMARY KEY (`c1`)
2630 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2631 DROP TABLE t1;
2632 SHOW TABLES;
2633 Tables_in_test
2634 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
2635 SHOW TABLES;
2636 Tables_in_test
2637 t1
2638 SHOW CREATE TABLE t1;
2639 Table Create Table
2640 t1 CREATE TABLE `t1` (
2641 `c1` binary(15) NOT NULL,
2642 `c2` int NOT NULL,
2643 `c3` binary(20) NOT NULL,
2644 PRIMARY KEY (`c1`)
2645 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2646 ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
2647 SHOW TABLES;
2648 Tables_in_test
2649 t1
2650 SHOW CREATE TABLE t1;
2651 Table Create Table
2652 t1 CREATE TABLE `t1` (
2653 `c1` binary(15) NOT NULL,
2654 `c2` int NOT NULL,
2655 `c4` decimal(10,0) NOT NULL,
2656 `c3` binary(20) NOT NULL,
2657 PRIMARY KEY (`c1`)
2658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2659 DROP TABLE t1;
2660 SHOW TABLES;
2661 Tables_in_test
2662 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
2663 SHOW TABLES;
2664 Tables_in_test
2665 t1
2666 SHOW CREATE TABLE t1;
2667 Table Create Table
2668 t1 CREATE TABLE `t1` (
2669 `c1` varbinary(15) NOT NULL,
2670 `c2` int NOT NULL,
2671 `c3` varbinary(20) NOT NULL,
2672 PRIMARY KEY (`c1`)
2673 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2674 ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
2675 SHOW TABLES;
2676 Tables_in_test
2677 t1
2678 SHOW CREATE TABLE t1;
2679 Table Create Table
2680 t1 CREATE TABLE `t1` (
2681 `c1` varbinary(15) NOT NULL,
2682 `c2` int NOT NULL,
2683 `c4` decimal(10,0) NOT NULL,
2684 `c3` varbinary(20) NOT NULL,
2685 PRIMARY KEY (`c1`)
2686 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2687 DROP TABLE t1;
2688 SHOW TABLES;
2689 Tables_in_test
2690 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
2691 SHOW TABLES;
2692 Tables_in_test
2693 t1
2694 SHOW CREATE TABLE t1;
2695 Table Create Table
2696 t1 CREATE TABLE `t1` (
2697 `c1` char(15) NOT NULL,
2698 `c2` int NOT NULL,
2699 `c3` char(20) DEFAULT NULL,
2700 PRIMARY KEY (`c1`)
2701 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2702 ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
2703 SHOW TABLES;
2704 Tables_in_test
2705 t1
2706 SHOW CREATE TABLE t1;
2707 Table Create Table
2708 t1 CREATE TABLE `t1` (
2709 `c1` char(15) NOT NULL,
2710 `c2` int NOT NULL,
2711 `c4` date DEFAULT NULL,
2712 `c3` char(20) DEFAULT NULL,
2713 PRIMARY KEY (`c1`)
2714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2715 DROP TABLE t1;
2716 SHOW TABLES;
2717 Tables_in_test
2718 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
2719 SHOW TABLES;
2720 Tables_in_test
2721 t1
2722 SHOW CREATE TABLE t1;
2723 Table Create Table
2724 t1 CREATE TABLE `t1` (
2725 `c1` varchar(15) NOT NULL,
2726 `c2` int NOT NULL,
2727 `c3` varchar(20) DEFAULT NULL,
2728 PRIMARY KEY (`c1`)
2729 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2730 ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
2731 SHOW TABLES;
2732 Tables_in_test
2733 t1
2734 SHOW CREATE TABLE t1;
2735 Table Create Table
2736 t1 CREATE TABLE `t1` (
2737 `c1` varchar(15) NOT NULL,
2738 `c2` int NOT NULL,
2739 `c4` date DEFAULT NULL,
2740 `c3` varchar(20) DEFAULT NULL,
2741 PRIMARY KEY (`c1`)
2742 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2743 DROP TABLE t1;
2744 SHOW TABLES;
2745 Tables_in_test
2746 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
2747 SHOW TABLES;
2748 Tables_in_test
2749 t1
2750 SHOW CREATE TABLE t1;
2751 Table Create Table
2752 t1 CREATE TABLE `t1` (
2753 `c1` binary(15) NOT NULL,
2754 `c2` int NOT NULL,
2755 `c3` binary(20) DEFAULT NULL,
2756 PRIMARY KEY (`c1`)
2757 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2758 ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
2759 SHOW TABLES;
2760 Tables_in_test
2761 t1
2762 SHOW CREATE TABLE t1;
2763 Table Create Table
2764 t1 CREATE TABLE `t1` (
2765 `c1` binary(15) NOT NULL,
2766 `c2` int NOT NULL,
2767 `c4` date DEFAULT NULL,
2768 `c3` binary(20) DEFAULT NULL,
2769 PRIMARY KEY (`c1`)
2770 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2771 DROP TABLE t1;
2772 SHOW TABLES;
2773 Tables_in_test
2774 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
2775 SHOW TABLES;
2776 Tables_in_test
2777 t1
2778 SHOW CREATE TABLE t1;
2779 Table Create Table
2780 t1 CREATE TABLE `t1` (
2781 `c1` varbinary(15) NOT NULL,
2782 `c2` int NOT NULL,
2783 `c3` varbinary(20) DEFAULT NULL,
2784 PRIMARY KEY (`c1`)
2785 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2786 ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
2787 SHOW TABLES;
2788 Tables_in_test
2789 t1
2790 SHOW CREATE TABLE t1;
2791 Table Create Table
2792 t1 CREATE TABLE `t1` (
2793 `c1` varbinary(15) NOT NULL,
2794 `c2` int NOT NULL,
2795 `c4` date DEFAULT NULL,
2796 `c3` varbinary(20) DEFAULT NULL,
2797 PRIMARY KEY (`c1`)
2798 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2799 DROP TABLE t1;
2800 SHOW TABLES;
2801 Tables_in_test
2802 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
2803 SHOW TABLES;
2804 Tables_in_test
2805 t1
2806 SHOW CREATE TABLE t1;
2807 Table Create Table
2808 t1 CREATE TABLE `t1` (
2809 `c1` char(15) NOT NULL,
2810 `c2` int NOT NULL,
2811 `c3` char(20) NOT NULL,
2812 PRIMARY KEY (`c1`)
2813 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2814 ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
2815 SHOW TABLES;
2816 Tables_in_test
2817 t1
2818 SHOW CREATE TABLE t1;
2819 Table Create Table
2820 t1 CREATE TABLE `t1` (
2821 `c1` char(15) NOT NULL,
2822 `c2` int NOT NULL,
2823 `c4` date NOT NULL,
2824 `c3` char(20) NOT NULL,
2825 PRIMARY KEY (`c1`)
2826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2827 DROP TABLE t1;
2828 SHOW TABLES;
2829 Tables_in_test
2830 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
2831 SHOW TABLES;
2832 Tables_in_test
2833 t1
2834 SHOW CREATE TABLE t1;
2835 Table Create Table
2836 t1 CREATE TABLE `t1` (
2837 `c1` varchar(15) NOT NULL,
2838 `c2` int NOT NULL,
2839 `c3` varchar(20) NOT NULL,
2840 PRIMARY KEY (`c1`)
2841 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2842 ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
2843 SHOW TABLES;
2844 Tables_in_test
2845 t1
2846 SHOW CREATE TABLE t1;
2847 Table Create Table
2848 t1 CREATE TABLE `t1` (
2849 `c1` varchar(15) NOT NULL,
2850 `c2` int NOT NULL,
2851 `c4` date NOT NULL,
2852 `c3` varchar(20) NOT NULL,
2853 PRIMARY KEY (`c1`)
2854 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2855 DROP TABLE t1;
2856 SHOW TABLES;
2857 Tables_in_test
2858 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
2859 SHOW TABLES;
2860 Tables_in_test
2861 t1
2862 SHOW CREATE TABLE t1;
2863 Table Create Table
2864 t1 CREATE TABLE `t1` (
2865 `c1` binary(15) NOT NULL,
2866 `c2` int NOT NULL,
2867 `c3` binary(20) NOT NULL,
2868 PRIMARY KEY (`c1`)
2869 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2870 ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
2871 SHOW TABLES;
2872 Tables_in_test
2873 t1
2874 SHOW CREATE TABLE t1;
2875 Table Create Table
2876 t1 CREATE TABLE `t1` (
2877 `c1` binary(15) NOT NULL,
2878 `c2` int NOT NULL,
2879 `c4` date NOT NULL,
2880 `c3` binary(20) NOT NULL,
2881 PRIMARY KEY (`c1`)
2882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2883 DROP TABLE t1;
2884 SHOW TABLES;
2885 Tables_in_test
2886 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
2887 SHOW TABLES;
2888 Tables_in_test
2889 t1
2890 SHOW CREATE TABLE t1;
2891 Table Create Table
2892 t1 CREATE TABLE `t1` (
2893 `c1` varbinary(15) NOT NULL,
2894 `c2` int NOT NULL,
2895 `c3` varbinary(20) NOT NULL,
2896 PRIMARY KEY (`c1`)
2897 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2898 ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
2899 SHOW TABLES;
2900 Tables_in_test
2901 t1
2902 SHOW CREATE TABLE t1;
2903 Table Create Table
2904 t1 CREATE TABLE `t1` (
2905 `c1` varbinary(15) NOT NULL,
2906 `c2` int NOT NULL,
2907 `c4` date NOT NULL,
2908 `c3` varbinary(20) NOT NULL,
2909 PRIMARY KEY (`c1`)
2910 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2911 DROP TABLE t1;
2912 SHOW TABLES;
2913 Tables_in_test
2914 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
2915 SHOW TABLES;
2916 Tables_in_test
2917 t1
2918 SHOW CREATE TABLE t1;
2919 Table Create Table
2920 t1 CREATE TABLE `t1` (
2921 `c1` char(15) NOT NULL,
2922 `c2` int NOT NULL,
2923 `c3` char(20) DEFAULT NULL,
2924 PRIMARY KEY (`c1`)
2925 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2926 ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
2927 SHOW TABLES;
2928 Tables_in_test
2929 t1
2930 SHOW CREATE TABLE t1;
2931 Table Create Table
2932 t1 CREATE TABLE `t1` (
2933 `c1` char(15) NOT NULL,
2934 `c2` int NOT NULL,
2935 `c4` time DEFAULT NULL,
2936 `c3` char(20) DEFAULT NULL,
2937 PRIMARY KEY (`c1`)
2938 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2939 DROP TABLE t1;
2940 SHOW TABLES;
2941 Tables_in_test
2942 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
2943 SHOW TABLES;
2944 Tables_in_test
2945 t1
2946 SHOW CREATE TABLE t1;
2947 Table Create Table
2948 t1 CREATE TABLE `t1` (
2949 `c1` varchar(15) NOT NULL,
2950 `c2` int NOT NULL,
2951 `c3` varchar(20) DEFAULT NULL,
2952 PRIMARY KEY (`c1`)
2953 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2954 ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
2955 SHOW TABLES;
2956 Tables_in_test
2957 t1
2958 SHOW CREATE TABLE t1;
2959 Table Create Table
2960 t1 CREATE TABLE `t1` (
2961 `c1` varchar(15) NOT NULL,
2962 `c2` int NOT NULL,
2963 `c4` time DEFAULT NULL,
2964 `c3` varchar(20) DEFAULT NULL,
2965 PRIMARY KEY (`c1`)
2966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2967 DROP TABLE t1;
2968 SHOW TABLES;
2969 Tables_in_test
2970 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
2971 SHOW TABLES;
2972 Tables_in_test
2973 t1
2974 SHOW CREATE TABLE t1;
2975 Table Create Table
2976 t1 CREATE TABLE `t1` (
2977 `c1` binary(15) NOT NULL,
2978 `c2` int NOT NULL,
2979 `c3` binary(20) DEFAULT NULL,
2980 PRIMARY KEY (`c1`)
2981 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2982 ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
2983 SHOW TABLES;
2984 Tables_in_test
2985 t1
2986 SHOW CREATE TABLE t1;
2987 Table Create Table
2988 t1 CREATE TABLE `t1` (
2989 `c1` binary(15) NOT NULL,
2990 `c2` int NOT NULL,
2991 `c4` time DEFAULT NULL,
2992 `c3` binary(20) DEFAULT NULL,
2993 PRIMARY KEY (`c1`)
2994 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2995 DROP TABLE t1;
2996 SHOW TABLES;
2997 Tables_in_test
2998 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
2999 SHOW TABLES;
3000 Tables_in_test
3001 t1
3002 SHOW CREATE TABLE t1;
3003 Table Create Table
3004 t1 CREATE TABLE `t1` (
3005 `c1` varbinary(15) NOT NULL,
3006 `c2` int NOT NULL,
3007 `c3` varbinary(20) DEFAULT NULL,
3008 PRIMARY KEY (`c1`)
3009 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3010 ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
3011 SHOW TABLES;
3012 Tables_in_test
3013 t1
3014 SHOW CREATE TABLE t1;
3015 Table Create Table
3016 t1 CREATE TABLE `t1` (
3017 `c1` varbinary(15) NOT NULL,
3018 `c2` int NOT NULL,
3019 `c4` time DEFAULT NULL,
3020 `c3` varbinary(20) DEFAULT NULL,
3021 PRIMARY KEY (`c1`)
3022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3023 DROP TABLE t1;
3024 SHOW TABLES;
3025 Tables_in_test
3026 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
3027 SHOW TABLES;
3028 Tables_in_test
3029 t1
3030 SHOW CREATE TABLE t1;
3031 Table Create Table
3032 t1 CREATE TABLE `t1` (
3033 `c1` char(15) NOT NULL,
3034 `c2` int NOT NULL,
3035 `c3` char(20) NOT NULL,
3036 PRIMARY KEY (`c1`)
3037 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3038 ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
3039 SHOW TABLES;
3040 Tables_in_test
3041 t1
3042 SHOW CREATE TABLE t1;
3043 Table Create Table
3044 t1 CREATE TABLE `t1` (
3045 `c1` char(15) NOT NULL,
3046 `c2` int NOT NULL,
3047 `c4` time NOT NULL,
3048 `c3` char(20) NOT NULL,
3049 PRIMARY KEY (`c1`)
3050 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3051 DROP TABLE t1;
3052 SHOW TABLES;
3053 Tables_in_test
3054 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
3055 SHOW TABLES;
3056 Tables_in_test
3057 t1
3058 SHOW CREATE TABLE t1;
3059 Table Create Table
3060 t1 CREATE TABLE `t1` (
3061 `c1` varchar(15) NOT NULL,
3062 `c2` int NOT NULL,
3063 `c3` varchar(20) NOT NULL,
3064 PRIMARY KEY (`c1`)
3065 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3066 ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
3067 SHOW TABLES;
3068 Tables_in_test
3069 t1
3070 SHOW CREATE TABLE t1;
3071 Table Create Table
3072 t1 CREATE TABLE `t1` (
3073 `c1` varchar(15) NOT NULL,
3074 `c2` int NOT NULL,
3075 `c4` time NOT NULL,
3076 `c3` varchar(20) NOT NULL,
3077 PRIMARY KEY (`c1`)
3078 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3079 DROP TABLE t1;
3080 SHOW TABLES;
3081 Tables_in_test
3082 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
3083 SHOW TABLES;
3084 Tables_in_test
3085 t1
3086 SHOW CREATE TABLE t1;
3087 Table Create Table
3088 t1 CREATE TABLE `t1` (
3089 `c1` binary(15) NOT NULL,
3090 `c2` int NOT NULL,
3091 `c3` binary(20) NOT NULL,
3092 PRIMARY KEY (`c1`)
3093 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3094 ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
3095 SHOW TABLES;
3096 Tables_in_test
3097 t1
3098 SHOW CREATE TABLE t1;
3099 Table Create Table
3100 t1 CREATE TABLE `t1` (
3101 `c1` binary(15) NOT NULL,
3102 `c2` int NOT NULL,
3103 `c4` time NOT NULL,
3104 `c3` binary(20) NOT NULL,
3105 PRIMARY KEY (`c1`)
3106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3107 DROP TABLE t1;
3108 SHOW TABLES;
3109 Tables_in_test
3110 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
3111 SHOW TABLES;
3112 Tables_in_test
3113 t1
3114 SHOW CREATE TABLE t1;
3115 Table Create Table
3116 t1 CREATE TABLE `t1` (
3117 `c1` varbinary(15) NOT NULL,
3118 `c2` int NOT NULL,
3119 `c3` varbinary(20) NOT NULL,
3120 PRIMARY KEY (`c1`)
3121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3122 ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
3123 SHOW TABLES;
3124 Tables_in_test
3125 t1
3126 SHOW CREATE TABLE t1;
3127 Table Create Table
3128 t1 CREATE TABLE `t1` (
3129 `c1` varbinary(15) NOT NULL,
3130 `c2` int NOT NULL,
3131 `c4` time NOT NULL,
3132 `c3` varbinary(20) NOT NULL,
3133 PRIMARY KEY (`c1`)
3134 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3135 DROP TABLE t1;
3136 SHOW TABLES;
3137 Tables_in_test
3138 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
3139 SHOW TABLES;
3140 Tables_in_test
3141 t1
3142 SHOW CREATE TABLE t1;
3143 Table Create Table
3144 t1 CREATE TABLE `t1` (
3145 `c1` char(15) NOT NULL,
3146 `c2` int NOT NULL,
3147 `c3` char(20) DEFAULT NULL,
3148 PRIMARY KEY (`c1`)
3149 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3150 ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
3151 SHOW TABLES;
3152 Tables_in_test
3153 t1
3154 SHOW CREATE TABLE t1;
3155 Table Create Table
3156 t1 CREATE TABLE `t1` (
3157 `c1` char(15) NOT NULL,
3158 `c2` int NOT NULL,
3159 `c4` timestamp NULL DEFAULT NULL,
3160 `c3` char(20) DEFAULT NULL,
3161 PRIMARY KEY (`c1`)
3162 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3163 DROP TABLE t1;
3164 SHOW TABLES;
3165 Tables_in_test
3166 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
3167 SHOW TABLES;
3168 Tables_in_test
3169 t1
3170 SHOW CREATE TABLE t1;
3171 Table Create Table
3172 t1 CREATE TABLE `t1` (
3173 `c1` varchar(15) NOT NULL,
3174 `c2` int NOT NULL,
3175 `c3` varchar(20) DEFAULT NULL,
3176 PRIMARY KEY (`c1`)
3177 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3178 ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
3179 SHOW TABLES;
3180 Tables_in_test
3181 t1
3182 SHOW CREATE TABLE t1;
3183 Table Create Table
3184 t1 CREATE TABLE `t1` (
3185 `c1` varchar(15) NOT NULL,
3186 `c2` int NOT NULL,
3187 `c4` timestamp NULL DEFAULT NULL,
3188 `c3` varchar(20) DEFAULT NULL,
3189 PRIMARY KEY (`c1`)
3190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3191 DROP TABLE t1;
3192 SHOW TABLES;
3193 Tables_in_test
3194 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
3195 SHOW TABLES;
3196 Tables_in_test
3197 t1
3198 SHOW CREATE TABLE t1;
3199 Table Create Table
3200 t1 CREATE TABLE `t1` (
3201 `c1` binary(15) NOT NULL,
3202 `c2` int NOT NULL,
3203 `c3` binary(20) DEFAULT NULL,
3204 PRIMARY KEY (`c1`)
3205 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3206 ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
3207 SHOW TABLES;
3208 Tables_in_test
3209 t1
3210 SHOW CREATE TABLE t1;
3211 Table Create Table
3212 t1 CREATE TABLE `t1` (
3213 `c1` binary(15) NOT NULL,
3214 `c2` int NOT NULL,
3215 `c4` timestamp NULL DEFAULT NULL,
3216 `c3` binary(20) DEFAULT NULL,
3217 PRIMARY KEY (`c1`)
3218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3219 DROP TABLE t1;
3220 SHOW TABLES;
3221 Tables_in_test
3222 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
3223 SHOW TABLES;
3224 Tables_in_test
3225 t1
3226 SHOW CREATE TABLE t1;
3227 Table Create Table
3228 t1 CREATE TABLE `t1` (
3229 `c1` varbinary(15) NOT NULL,
3230 `c2` int NOT NULL,
3231 `c3` varbinary(20) DEFAULT NULL,
3232 PRIMARY KEY (`c1`)
3233 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3234 ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
3235 SHOW TABLES;
3236 Tables_in_test
3237 t1
3238 SHOW CREATE TABLE t1;
3239 Table Create Table
3240 t1 CREATE TABLE `t1` (
3241 `c1` varbinary(15) NOT NULL,
3242 `c2` int NOT NULL,
3243 `c4` timestamp NULL DEFAULT NULL,
3244 `c3` varbinary(20) DEFAULT NULL,
3245 PRIMARY KEY (`c1`)
3246 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3247 DROP TABLE t1;
3248 SHOW TABLES;
3249 Tables_in_test
3250 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
3251 SHOW TABLES;
3252 Tables_in_test
3253 t1
3254 SHOW CREATE TABLE t1;
3255 Table Create Table
3256 t1 CREATE TABLE `t1` (
3257 `c1` char(15) NOT NULL,
3258 `c2` int NOT NULL,
3259 `c3` char(20) NOT NULL,
3260 PRIMARY KEY (`c1`)
3261 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3262 ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
3263 SHOW TABLES;
3264 Tables_in_test
3265 t1
3266 SHOW CREATE TABLE t1;
3267 Table Create Table
3268 t1 CREATE TABLE `t1` (
3269 `c1` char(15) NOT NULL,
3270 `c2` int NOT NULL,
3271 `c4` timestamp NOT NULL,
3272 `c3` char(20) NOT NULL,
3273 PRIMARY KEY (`c1`)
3274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3275 DROP TABLE t1;
3276 SHOW TABLES;
3277 Tables_in_test
3278 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
3279 SHOW TABLES;
3280 Tables_in_test
3281 t1
3282 SHOW CREATE TABLE t1;
3283 Table Create Table
3284 t1 CREATE TABLE `t1` (
3285 `c1` varchar(15) NOT NULL,
3286 `c2` int NOT NULL,
3287 `c3` varchar(20) NOT NULL,
3288 PRIMARY KEY (`c1`)
3289 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3290 ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
3291 SHOW TABLES;
3292 Tables_in_test
3293 t1
3294 SHOW CREATE TABLE t1;
3295 Table Create Table
3296 t1 CREATE TABLE `t1` (
3297 `c1` varchar(15) NOT NULL,
3298 `c2` int NOT NULL,
3299 `c4` timestamp NOT NULL,
3300 `c3` varchar(20) NOT NULL,
3301 PRIMARY KEY (`c1`)
3302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3303 DROP TABLE t1;
3304 SHOW TABLES;
3305 Tables_in_test
3306 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
3307 SHOW TABLES;
3308 Tables_in_test
3309 t1
3310 SHOW CREATE TABLE t1;
3311 Table Create Table
3312 t1 CREATE TABLE `t1` (
3313 `c1` binary(15) NOT NULL,
3314 `c2` int NOT NULL,
3315 `c3` binary(20) NOT NULL,
3316 PRIMARY KEY (`c1`)
3317 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3318 ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
3319 SHOW TABLES;
3320 Tables_in_test
3321 t1
3322 SHOW CREATE TABLE t1;
3323 Table Create Table
3324 t1 CREATE TABLE `t1` (
3325 `c1` binary(15) NOT NULL,
3326 `c2` int NOT NULL,
3327 `c4` timestamp NOT NULL,
3328 `c3` binary(20) NOT NULL,
3329 PRIMARY KEY (`c1`)
3330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3331 DROP TABLE t1;
3332 SHOW TABLES;
3333 Tables_in_test
3334 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
3335 SHOW TABLES;
3336 Tables_in_test
3337 t1
3338 SHOW CREATE TABLE t1;
3339 Table Create Table
3340 t1 CREATE TABLE `t1` (
3341 `c1` varbinary(15) NOT NULL,
3342 `c2` int NOT NULL,
3343 `c3` varbinary(20) NOT NULL,
3344 PRIMARY KEY (`c1`)
3345 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3346 ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
3347 SHOW TABLES;
3348 Tables_in_test
3349 t1
3350 SHOW CREATE TABLE t1;
3351 Table Create Table
3352 t1 CREATE TABLE `t1` (
3353 `c1` varbinary(15) NOT NULL,
3354 `c2` int NOT NULL,
3355 `c4` timestamp NOT NULL,
3356 `c3` varbinary(20) NOT NULL,
3357 PRIMARY KEY (`c1`)
3358 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3359 DROP TABLE t1;
3360 SHOW TABLES;
3361 Tables_in_test
3362 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
3363 SHOW TABLES;
3364 Tables_in_test
3365 t1
3366 SHOW CREATE TABLE t1;
3367 Table Create Table
3368 t1 CREATE TABLE `t1` (
3369 `c1` char(15) NOT NULL,
3370 `c2` int NOT NULL,
3371 `c3` char(20) DEFAULT NULL,
3372 PRIMARY KEY (`c1`)
3373 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3374 ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
3375 SHOW TABLES;
3376 Tables_in_test
3377 t1
3378 SHOW CREATE TABLE t1;
3379 Table Create Table
3380 t1 CREATE TABLE `t1` (
3381 `c1` char(15) NOT NULL,
3382 `c2` int NOT NULL,
3383 `c4` year DEFAULT NULL,
3384 `c3` char(20) DEFAULT NULL,
3385 PRIMARY KEY (`c1`)
3386 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3387 DROP TABLE t1;
3388 SHOW TABLES;
3389 Tables_in_test
3390 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
3391 SHOW TABLES;
3392 Tables_in_test
3393 t1
3394 SHOW CREATE TABLE t1;
3395 Table Create Table
3396 t1 CREATE TABLE `t1` (
3397 `c1` varchar(15) NOT NULL,
3398 `c2` int NOT NULL,
3399 `c3` varchar(20) DEFAULT NULL,
3400 PRIMARY KEY (`c1`)
3401 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3402 ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
3403 SHOW TABLES;
3404 Tables_in_test
3405 t1
3406 SHOW CREATE TABLE t1;
3407 Table Create Table
3408 t1 CREATE TABLE `t1` (
3409 `c1` varchar(15) NOT NULL,
3410 `c2` int NOT NULL,
3411 `c4` year DEFAULT NULL,
3412 `c3` varchar(20) DEFAULT NULL,
3413 PRIMARY KEY (`c1`)
3414 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3415 DROP TABLE t1;
3416 SHOW TABLES;
3417 Tables_in_test
3418 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
3419 SHOW TABLES;
3420 Tables_in_test
3421 t1
3422 SHOW CREATE TABLE t1;
3423 Table Create Table
3424 t1 CREATE TABLE `t1` (
3425 `c1` binary(15) NOT NULL,
3426 `c2` int NOT NULL,
3427 `c3` binary(20) DEFAULT NULL,
3428 PRIMARY KEY (`c1`)
3429 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3430 ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
3431 SHOW TABLES;
3432 Tables_in_test
3433 t1
3434 SHOW CREATE TABLE t1;
3435 Table Create Table
3436 t1 CREATE TABLE `t1` (
3437 `c1` binary(15) NOT NULL,
3438 `c2` int NOT NULL,
3439 `c4` year DEFAULT NULL,
3440 `c3` binary(20) DEFAULT NULL,
3441 PRIMARY KEY (`c1`)
3442 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3443 DROP TABLE t1;
3444 SHOW TABLES;
3445 Tables_in_test
3446 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
3447 SHOW TABLES;
3448 Tables_in_test
3449 t1
3450 SHOW CREATE TABLE t1;
3451 Table Create Table
3452 t1 CREATE TABLE `t1` (
3453 `c1` varbinary(15) NOT NULL,
3454 `c2` int NOT NULL,
3455 `c3` varbinary(20) DEFAULT NULL,
3456 PRIMARY KEY (`c1`)
3457 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3458 ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
3459 SHOW TABLES;
3460 Tables_in_test
3461 t1
3462 SHOW CREATE TABLE t1;
3463 Table Create Table
3464 t1 CREATE TABLE `t1` (
3465 `c1` varbinary(15) NOT NULL,
3466 `c2` int NOT NULL,
3467 `c4` year DEFAULT NULL,
3468 `c3` varbinary(20) DEFAULT NULL,
3469 PRIMARY KEY (`c1`)
3470 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3471 DROP TABLE t1;
3472 SHOW TABLES;
3473 Tables_in_test
3474 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
3475 SHOW TABLES;
3476 Tables_in_test
3477 t1
3478 SHOW CREATE TABLE t1;
3479 Table Create Table
3480 t1 CREATE TABLE `t1` (
3481 `c1` char(15) NOT NULL,
3482 `c2` int NOT NULL,
3483 `c3` char(20) NOT NULL,
3484 PRIMARY KEY (`c1`)
3485 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3486 ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
3487 SHOW TABLES;
3488 Tables_in_test
3489 t1
3490 SHOW CREATE TABLE t1;
3491 Table Create Table
3492 t1 CREATE TABLE `t1` (
3493 `c1` char(15) NOT NULL,
3494 `c2` int NOT NULL,
3495 `c4` year NOT NULL,
3496 `c3` char(20) NOT NULL,
3497 PRIMARY KEY (`c1`)
3498 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3499 DROP TABLE t1;
3500 SHOW TABLES;
3501 Tables_in_test
3502 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
3503 SHOW TABLES;
3504 Tables_in_test
3505 t1
3506 SHOW CREATE TABLE t1;
3507 Table Create Table
3508 t1 CREATE TABLE `t1` (
3509 `c1` varchar(15) NOT NULL,
3510 `c2` int NOT NULL,
3511 `c3` varchar(20) NOT NULL,
3512 PRIMARY KEY (`c1`)
3513 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3514 ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
3515 SHOW TABLES;
3516 Tables_in_test
3517 t1
3518 SHOW CREATE TABLE t1;
3519 Table Create Table
3520 t1 CREATE TABLE `t1` (
3521 `c1` varchar(15) NOT NULL,
3522 `c2` int NOT NULL,
3523 `c4` year NOT NULL,
3524 `c3` varchar(20) NOT NULL,
3525 PRIMARY KEY (`c1`)
3526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3527 DROP TABLE t1;
3528 SHOW TABLES;
3529 Tables_in_test
3530 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
3531 SHOW TABLES;
3532 Tables_in_test
3533 t1
3534 SHOW CREATE TABLE t1;
3535 Table Create Table
3536 t1 CREATE TABLE `t1` (
3537 `c1` binary(15) NOT NULL,
3538 `c2` int NOT NULL,
3539 `c3` binary(20) NOT NULL,
3540 PRIMARY KEY (`c1`)
3541 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3542 ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
3543 SHOW TABLES;
3544 Tables_in_test
3545 t1
3546 SHOW CREATE TABLE t1;
3547 Table Create Table
3548 t1 CREATE TABLE `t1` (
3549 `c1` binary(15) NOT NULL,
3550 `c2` int NOT NULL,
3551 `c4` year NOT NULL,
3552 `c3` binary(20) NOT NULL,
3553 PRIMARY KEY (`c1`)
3554 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3555 DROP TABLE t1;
3556 SHOW TABLES;
3557 Tables_in_test
3558 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
3559 SHOW TABLES;
3560 Tables_in_test
3561 t1
3562 SHOW CREATE TABLE t1;
3563 Table Create Table
3564 t1 CREATE TABLE `t1` (
3565 `c1` varbinary(15) NOT NULL,
3566 `c2` int NOT NULL,
3567 `c3` varbinary(20) NOT NULL,
3568 PRIMARY KEY (`c1`)
3569 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3570 ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
3571 SHOW TABLES;
3572 Tables_in_test
3573 t1
3574 SHOW CREATE TABLE t1;
3575 Table Create Table
3576 t1 CREATE TABLE `t1` (
3577 `c1` varbinary(15) NOT NULL,
3578 `c2` int NOT NULL,
3579 `c4` year NOT NULL,
3580 `c3` varbinary(20) NOT NULL,
3581 PRIMARY KEY (`c1`)
3582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3583 DROP TABLE t1;
3584 SHOW TABLES;
3585 Tables_in_test
3586 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
3587 SHOW TABLES;
3588 Tables_in_test
3589 t1
3590 SHOW CREATE TABLE t1;
3591 Table Create Table
3592 t1 CREATE TABLE `t1` (
3593 `c1` char(15) NOT NULL,
3594 `c2` int NOT NULL,
3595 `c3` char(20) DEFAULT NULL,
3596 PRIMARY KEY (`c1`)
3597 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3598 ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
3599 SHOW TABLES;
3600 Tables_in_test
3601 t1
3602 SHOW CREATE TABLE t1;
3603 Table Create Table
3604 t1 CREATE TABLE `t1` (
3605 `c1` char(15) NOT NULL,
3606 `c2` int NOT NULL,
3607 `c4` tinyblob,
3608 `c3` char(20) DEFAULT NULL,
3609 PRIMARY KEY (`c1`)
3610 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3611 DROP TABLE t1;
3612 SHOW TABLES;
3613 Tables_in_test
3614 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
3615 SHOW TABLES;
3616 Tables_in_test
3617 t1
3618 SHOW CREATE TABLE t1;
3619 Table Create Table
3620 t1 CREATE TABLE `t1` (
3621 `c1` varchar(15) NOT NULL,
3622 `c2` int NOT NULL,
3623 `c3` varchar(20) DEFAULT NULL,
3624 PRIMARY KEY (`c1`)
3625 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3626 ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
3627 SHOW TABLES;
3628 Tables_in_test
3629 t1
3630 SHOW CREATE TABLE t1;
3631 Table Create Table
3632 t1 CREATE TABLE `t1` (
3633 `c1` varchar(15) NOT NULL,
3634 `c2` int NOT NULL,
3635 `c4` tinyblob,
3636 `c3` varchar(20) DEFAULT NULL,
3637 PRIMARY KEY (`c1`)
3638 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3639 DROP TABLE t1;
3640 SHOW TABLES;
3641 Tables_in_test
3642 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
3643 SHOW TABLES;
3644 Tables_in_test
3645 t1
3646 SHOW CREATE TABLE t1;
3647 Table Create Table
3648 t1 CREATE TABLE `t1` (
3649 `c1` binary(15) NOT NULL,
3650 `c2` int NOT NULL,
3651 `c3` binary(20) DEFAULT NULL,
3652 PRIMARY KEY (`c1`)
3653 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3654 ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
3655 SHOW TABLES;
3656 Tables_in_test
3657 t1
3658 SHOW CREATE TABLE t1;
3659 Table Create Table
3660 t1 CREATE TABLE `t1` (
3661 `c1` binary(15) NOT NULL,
3662 `c2` int NOT NULL,
3663 `c4` tinyblob,
3664 `c3` binary(20) DEFAULT NULL,
3665 PRIMARY KEY (`c1`)
3666 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3667 DROP TABLE t1;
3668 SHOW TABLES;
3669 Tables_in_test
3670 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
3671 SHOW TABLES;
3672 Tables_in_test
3673 t1
3674 SHOW CREATE TABLE t1;
3675 Table Create Table
3676 t1 CREATE TABLE `t1` (
3677 `c1` varbinary(15) NOT NULL,
3678 `c2` int NOT NULL,
3679 `c3` varbinary(20) DEFAULT NULL,
3680 PRIMARY KEY (`c1`)
3681 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3682 ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
3683 SHOW TABLES;
3684 Tables_in_test
3685 t1
3686 SHOW CREATE TABLE t1;
3687 Table Create Table
3688 t1 CREATE TABLE `t1` (
3689 `c1` varbinary(15) NOT NULL,
3690 `c2` int NOT NULL,
3691 `c4` tinyblob,
3692 `c3` varbinary(20) DEFAULT NULL,
3693 PRIMARY KEY (`c1`)
3694 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3695 DROP TABLE t1;
3696 SHOW TABLES;
3697 Tables_in_test
3698 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
3699 SHOW TABLES;
3700 Tables_in_test
3701 t1
3702 SHOW CREATE TABLE t1;
3703 Table Create Table
3704 t1 CREATE TABLE `t1` (
3705 `c1` char(15) NOT NULL,
3706 `c2` int NOT NULL,
3707 `c3` char(20) NOT NULL,
3708 PRIMARY KEY (`c1`)
3709 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3710 ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
3711 SHOW TABLES;
3712 Tables_in_test
3713 t1
3714 SHOW CREATE TABLE t1;
3715 Table Create Table
3716 t1 CREATE TABLE `t1` (
3717 `c1` char(15) NOT NULL,
3718 `c2` int NOT NULL,
3719 `c4` tinyblob NOT NULL,
3720 `c3` char(20) NOT NULL,
3721 PRIMARY KEY (`c1`)
3722 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3723 DROP TABLE t1;
3724 SHOW TABLES;
3725 Tables_in_test
3726 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
3727 SHOW TABLES;
3728 Tables_in_test
3729 t1
3730 SHOW CREATE TABLE t1;
3731 Table Create Table
3732 t1 CREATE TABLE `t1` (
3733 `c1` varchar(15) NOT NULL,
3734 `c2` int NOT NULL,
3735 `c3` varchar(20) NOT NULL,
3736 PRIMARY KEY (`c1`)
3737 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3738 ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
3739 SHOW TABLES;
3740 Tables_in_test
3741 t1
3742 SHOW CREATE TABLE t1;
3743 Table Create Table
3744 t1 CREATE TABLE `t1` (
3745 `c1` varchar(15) NOT NULL,
3746 `c2` int NOT NULL,
3747 `c4` tinyblob NOT NULL,
3748 `c3` varchar(20) NOT NULL,
3749 PRIMARY KEY (`c1`)
3750 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3751 DROP TABLE t1;
3752 SHOW TABLES;
3753 Tables_in_test
3754 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
3755 SHOW TABLES;
3756 Tables_in_test
3757 t1
3758 SHOW CREATE TABLE t1;
3759 Table Create Table
3760 t1 CREATE TABLE `t1` (
3761 `c1` binary(15) NOT NULL,
3762 `c2` int NOT NULL,
3763 `c3` binary(20) NOT NULL,
3764 PRIMARY KEY (`c1`)
3765 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3766 ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
3767 SHOW TABLES;
3768 Tables_in_test
3769 t1
3770 SHOW CREATE TABLE t1;
3771 Table Create Table
3772 t1 CREATE TABLE `t1` (
3773 `c1` binary(15) NOT NULL,
3774 `c2` int NOT NULL,
3775 `c4` tinyblob NOT NULL,
3776 `c3` binary(20) NOT NULL,
3777 PRIMARY KEY (`c1`)
3778 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3779 DROP TABLE t1;
3780 SHOW TABLES;
3781 Tables_in_test
3782 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
3783 SHOW TABLES;
3784 Tables_in_test
3785 t1
3786 SHOW CREATE TABLE t1;
3787 Table Create Table
3788 t1 CREATE TABLE `t1` (
3789 `c1` varbinary(15) NOT NULL,
3790 `c2` int NOT NULL,
3791 `c3` varbinary(20) NOT NULL,
3792 PRIMARY KEY (`c1`)
3793 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3794 ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
3795 SHOW TABLES;
3796 Tables_in_test
3797 t1
3798 SHOW CREATE TABLE t1;
3799 Table Create Table
3800 t1 CREATE TABLE `t1` (
3801 `c1` varbinary(15) NOT NULL,
3802 `c2` int NOT NULL,
3803 `c4` tinyblob NOT NULL,
3804 `c3` varbinary(20) NOT NULL,
3805 PRIMARY KEY (`c1`)
3806 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3807 DROP TABLE t1;
3808 SHOW TABLES;
3809 Tables_in_test
3810 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
3811 SHOW TABLES;
3812 Tables_in_test
3813 t1
3814 SHOW CREATE TABLE t1;
3815 Table Create Table
3816 t1 CREATE TABLE `t1` (
3817 `c1` char(15) NOT NULL,
3818 `c2` int NOT NULL,
3819 `c3` char(20) DEFAULT NULL,
3820 PRIMARY KEY (`c1`)
3821 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3822 ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
3823 SHOW TABLES;
3824 Tables_in_test
3825 t1
3826 SHOW CREATE TABLE t1;
3827 Table Create Table
3828 t1 CREATE TABLE `t1` (
3829 `c1` char(15) NOT NULL,
3830 `c2` int NOT NULL,
3831 `c4` blob,
3832 `c3` char(20) DEFAULT NULL,
3833 PRIMARY KEY (`c1`)
3834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3835 DROP TABLE t1;
3836 SHOW TABLES;
3837 Tables_in_test
3838 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
3839 SHOW TABLES;
3840 Tables_in_test
3841 t1
3842 SHOW CREATE TABLE t1;
3843 Table Create Table
3844 t1 CREATE TABLE `t1` (
3845 `c1` varchar(15) NOT NULL,
3846 `c2` int NOT NULL,
3847 `c3` varchar(20) DEFAULT NULL,
3848 PRIMARY KEY (`c1`)
3849 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3850 ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
3851 SHOW TABLES;
3852 Tables_in_test
3853 t1
3854 SHOW CREATE TABLE t1;
3855 Table Create Table
3856 t1 CREATE TABLE `t1` (
3857 `c1` varchar(15) NOT NULL,
3858 `c2` int NOT NULL,
3859 `c4` blob,
3860 `c3` varchar(20) DEFAULT NULL,
3861 PRIMARY KEY (`c1`)
3862 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3863 DROP TABLE t1;
3864 SHOW TABLES;
3865 Tables_in_test
3866 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
3867 SHOW TABLES;
3868 Tables_in_test
3869 t1
3870 SHOW CREATE TABLE t1;
3871 Table Create Table
3872 t1 CREATE TABLE `t1` (
3873 `c1` binary(15) NOT NULL,
3874 `c2` int NOT NULL,
3875 `c3` binary(20) DEFAULT NULL,
3876 PRIMARY KEY (`c1`)
3877 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3878 ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
3879 SHOW TABLES;
3880 Tables_in_test
3881 t1
3882 SHOW CREATE TABLE t1;
3883 Table Create Table
3884 t1 CREATE TABLE `t1` (
3885 `c1` binary(15) NOT NULL,
3886 `c2` int NOT NULL,
3887 `c4` blob,
3888 `c3` binary(20) DEFAULT NULL,
3889 PRIMARY KEY (`c1`)
3890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3891 DROP TABLE t1;
3892 SHOW TABLES;
3893 Tables_in_test
3894 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
3895 SHOW TABLES;
3896 Tables_in_test
3897 t1
3898 SHOW CREATE TABLE t1;
3899 Table Create Table
3900 t1 CREATE TABLE `t1` (
3901 `c1` varbinary(15) NOT NULL,
3902 `c2` int NOT NULL,
3903 `c3` varbinary(20) DEFAULT NULL,
3904 PRIMARY KEY (`c1`)
3905 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3906 ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
3907 SHOW TABLES;
3908 Tables_in_test
3909 t1
3910 SHOW CREATE TABLE t1;
3911 Table Create Table
3912 t1 CREATE TABLE `t1` (
3913 `c1` varbinary(15) NOT NULL,
3914 `c2` int NOT NULL,
3915 `c4` blob,
3916 `c3` varbinary(20) DEFAULT NULL,
3917 PRIMARY KEY (`c1`)
3918 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3919 DROP TABLE t1;
3920 SHOW TABLES;
3921 Tables_in_test
3922 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
3923 SHOW TABLES;
3924 Tables_in_test
3925 t1
3926 SHOW CREATE TABLE t1;
3927 Table Create Table
3928 t1 CREATE TABLE `t1` (
3929 `c1` char(15) NOT NULL,
3930 `c2` int NOT NULL,
3931 `c3` char(20) NOT NULL,
3932 PRIMARY KEY (`c1`)
3933 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3934 ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
3935 SHOW TABLES;
3936 Tables_in_test
3937 t1
3938 SHOW CREATE TABLE t1;
3939 Table Create Table
3940 t1 CREATE TABLE `t1` (
3941 `c1` char(15) NOT NULL,
3942 `c2` int NOT NULL,
3943 `c4` blob NOT NULL,
3944 `c3` char(20) NOT NULL,
3945 PRIMARY KEY (`c1`)
3946 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3947 DROP TABLE t1;
3948 SHOW TABLES;
3949 Tables_in_test
3950 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
3951 SHOW TABLES;
3952 Tables_in_test
3953 t1
3954 SHOW CREATE TABLE t1;
3955 Table Create Table
3956 t1 CREATE TABLE `t1` (
3957 `c1` varchar(15) NOT NULL,
3958 `c2` int NOT NULL,
3959 `c3` varchar(20) NOT NULL,
3960 PRIMARY KEY (`c1`)
3961 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3962 ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
3963 SHOW TABLES;
3964 Tables_in_test
3965 t1
3966 SHOW CREATE TABLE t1;
3967 Table Create Table
3968 t1 CREATE TABLE `t1` (
3969 `c1` varchar(15) NOT NULL,
3970 `c2` int NOT NULL,
3971 `c4` blob NOT NULL,
3972 `c3` varchar(20) NOT NULL,
3973 PRIMARY KEY (`c1`)
3974 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3975 DROP TABLE t1;
3976 SHOW TABLES;
3977 Tables_in_test
3978 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
3979 SHOW TABLES;
3980 Tables_in_test
3981 t1
3982 SHOW CREATE TABLE t1;
3983 Table Create Table
3984 t1 CREATE TABLE `t1` (
3985 `c1` binary(15) NOT NULL,
3986 `c2` int NOT NULL,
3987 `c3` binary(20) NOT NULL,
3988 PRIMARY KEY (`c1`)
3989 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3990 ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
3991 SHOW TABLES;
3992 Tables_in_test
3993 t1
3994 SHOW CREATE TABLE t1;
3995 Table Create Table
3996 t1 CREATE TABLE `t1` (
3997 `c1` binary(15) NOT NULL,
3998 `c2` int NOT NULL,
3999 `c4` blob NOT NULL,
4000 `c3` binary(20) NOT NULL,
4001 PRIMARY KEY (`c1`)
4002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4003 DROP TABLE t1;
4004 SHOW TABLES;
4005 Tables_in_test
4006 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
4007 SHOW TABLES;
4008 Tables_in_test
4009 t1
4010 SHOW CREATE TABLE t1;
4011 Table Create Table
4012 t1 CREATE TABLE `t1` (
4013 `c1` varbinary(15) NOT NULL,
4014 `c2` int NOT NULL,
4015 `c3` varbinary(20) NOT NULL,
4016 PRIMARY KEY (`c1`)
4017 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4018 ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
4019 SHOW TABLES;
4020 Tables_in_test
4021 t1
4022 SHOW CREATE TABLE t1;
4023 Table Create Table
4024 t1 CREATE TABLE `t1` (
4025 `c1` varbinary(15) NOT NULL,
4026 `c2` int NOT NULL,
4027 `c4` blob NOT NULL,
4028 `c3` varbinary(20) NOT NULL,
4029 PRIMARY KEY (`c1`)
4030 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4031 DROP TABLE t1;
4032 SHOW TABLES;
4033 Tables_in_test
4034 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
4035 SHOW TABLES;
4036 Tables_in_test
4037 t1
4038 SHOW CREATE TABLE t1;
4039 Table Create Table
4040 t1 CREATE TABLE `t1` (
4041 `c1` char(15) NOT NULL,
4042 `c2` int NOT NULL,
4043 `c3` char(20) DEFAULT NULL,
4044 PRIMARY KEY (`c1`)
4045 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4046 ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
4047 SHOW TABLES;
4048 Tables_in_test
4049 t1
4050 SHOW CREATE TABLE t1;
4051 Table Create Table
4052 t1 CREATE TABLE `t1` (
4053 `c1` char(15) NOT NULL,
4054 `c2` int NOT NULL,
4055 `c4` mediumblob,
4056 `c3` char(20) DEFAULT NULL,
4057 PRIMARY KEY (`c1`)
4058 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4059 DROP TABLE t1;
4060 SHOW TABLES;
4061 Tables_in_test
4062 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
4063 SHOW TABLES;
4064 Tables_in_test
4065 t1
4066 SHOW CREATE TABLE t1;
4067 Table Create Table
4068 t1 CREATE TABLE `t1` (
4069 `c1` varchar(15) NOT NULL,
4070 `c2` int NOT NULL,
4071 `c3` varchar(20) DEFAULT NULL,
4072 PRIMARY KEY (`c1`)
4073 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4074 ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
4075 SHOW TABLES;
4076 Tables_in_test
4077 t1
4078 SHOW CREATE TABLE t1;
4079 Table Create Table
4080 t1 CREATE TABLE `t1` (
4081 `c1` varchar(15) NOT NULL,
4082 `c2` int NOT NULL,
4083 `c4` mediumblob,
4084 `c3` varchar(20) DEFAULT NULL,
4085 PRIMARY KEY (`c1`)
4086 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4087 DROP TABLE t1;
4088 SHOW TABLES;
4089 Tables_in_test
4090 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
4091 SHOW TABLES;
4092 Tables_in_test
4093 t1
4094 SHOW CREATE TABLE t1;
4095 Table Create Table
4096 t1 CREATE TABLE `t1` (
4097 `c1` binary(15) NOT NULL,
4098 `c2` int NOT NULL,
4099 `c3` binary(20) DEFAULT NULL,
4100 PRIMARY KEY (`c1`)
4101 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4102 ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
4103 SHOW TABLES;
4104 Tables_in_test
4105 t1
4106 SHOW CREATE TABLE t1;
4107 Table Create Table
4108 t1 CREATE TABLE `t1` (
4109 `c1` binary(15) NOT NULL,
4110 `c2` int NOT NULL,
4111 `c4` mediumblob,
4112 `c3` binary(20) DEFAULT NULL,
4113 PRIMARY KEY (`c1`)
4114 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4115 DROP TABLE t1;
4116 SHOW TABLES;
4117 Tables_in_test
4118 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
4119 SHOW TABLES;
4120 Tables_in_test
4121 t1
4122 SHOW CREATE TABLE t1;
4123 Table Create Table
4124 t1 CREATE TABLE `t1` (
4125 `c1` varbinary(15) NOT NULL,
4126 `c2` int NOT NULL,
4127 `c3` varbinary(20) DEFAULT NULL,
4128 PRIMARY KEY (`c1`)
4129 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4130 ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
4131 SHOW TABLES;
4132 Tables_in_test
4133 t1
4134 SHOW CREATE TABLE t1;
4135 Table Create Table
4136 t1 CREATE TABLE `t1` (
4137 `c1` varbinary(15) NOT NULL,
4138 `c2` int NOT NULL,
4139 `c4` mediumblob,
4140 `c3` varbinary(20) DEFAULT NULL,
4141 PRIMARY KEY (`c1`)
4142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4143 DROP TABLE t1;
4144 SHOW TABLES;
4145 Tables_in_test
4146 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
4147 SHOW TABLES;
4148 Tables_in_test
4149 t1
4150 SHOW CREATE TABLE t1;
4151 Table Create Table
4152 t1 CREATE TABLE `t1` (
4153 `c1` char(15) NOT NULL,
4154 `c2` int NOT NULL,
4155 `c3` char(20) NOT NULL,
4156 PRIMARY KEY (`c1`)
4157 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4158 ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
4159 SHOW TABLES;
4160 Tables_in_test
4161 t1
4162 SHOW CREATE TABLE t1;
4163 Table Create Table
4164 t1 CREATE TABLE `t1` (
4165 `c1` char(15) NOT NULL,
4166 `c2` int NOT NULL,
4167 `c4` mediumblob NOT NULL,
4168 `c3` char(20) NOT NULL,
4169 PRIMARY KEY (`c1`)
4170 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4171 DROP TABLE t1;
4172 SHOW TABLES;
4173 Tables_in_test
4174 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
4175 SHOW TABLES;
4176 Tables_in_test
4177 t1
4178 SHOW CREATE TABLE t1;
4179 Table Create Table
4180 t1 CREATE TABLE `t1` (
4181 `c1` varchar(15) NOT NULL,
4182 `c2` int NOT NULL,
4183 `c3` varchar(20) NOT NULL,
4184 PRIMARY KEY (`c1`)
4185 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4186 ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
4187 SHOW TABLES;
4188 Tables_in_test
4189 t1
4190 SHOW CREATE TABLE t1;
4191 Table Create Table
4192 t1 CREATE TABLE `t1` (
4193 `c1` varchar(15) NOT NULL,
4194 `c2` int NOT NULL,
4195 `c4` mediumblob NOT NULL,
4196 `c3` varchar(20) NOT NULL,
4197 PRIMARY KEY (`c1`)
4198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4199 DROP TABLE t1;
4200 SHOW TABLES;
4201 Tables_in_test
4202 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
4203 SHOW TABLES;
4204 Tables_in_test
4205 t1
4206 SHOW CREATE TABLE t1;
4207 Table Create Table
4208 t1 CREATE TABLE `t1` (
4209 `c1` binary(15) NOT NULL,
4210 `c2` int NOT NULL,
4211 `c3` binary(20) NOT NULL,
4212 PRIMARY KEY (`c1`)
4213 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4214 ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
4215 SHOW TABLES;
4216 Tables_in_test
4217 t1
4218 SHOW CREATE TABLE t1;
4219 Table Create Table
4220 t1 CREATE TABLE `t1` (
4221 `c1` binary(15) NOT NULL,
4222 `c2` int NOT NULL,
4223 `c4` mediumblob NOT NULL,
4224 `c3` binary(20) NOT NULL,
4225 PRIMARY KEY (`c1`)
4226 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4227 DROP TABLE t1;
4228 SHOW TABLES;
4229 Tables_in_test
4230 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
4231 SHOW TABLES;
4232 Tables_in_test
4233 t1
4234 SHOW CREATE TABLE t1;
4235 Table Create Table
4236 t1 CREATE TABLE `t1` (
4237 `c1` varbinary(15) NOT NULL,
4238 `c2` int NOT NULL,
4239 `c3` varbinary(20) NOT NULL,
4240 PRIMARY KEY (`c1`)
4241 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4242 ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
4243 SHOW TABLES;
4244 Tables_in_test
4245 t1
4246 SHOW CREATE TABLE t1;
4247 Table Create Table
4248 t1 CREATE TABLE `t1` (
4249 `c1` varbinary(15) NOT NULL,
4250 `c2` int NOT NULL,
4251 `c4` mediumblob NOT NULL,
4252 `c3` varbinary(20) NOT NULL,
4253 PRIMARY KEY (`c1`)
4254 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4255 DROP TABLE t1;
4256 SHOW TABLES;
4257 Tables_in_test
4258 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
4259 SHOW TABLES;
4260 Tables_in_test
4261 t1
4262 SHOW CREATE TABLE t1;
4263 Table Create Table
4264 t1 CREATE TABLE `t1` (
4265 `c1` char(15) NOT NULL,
4266 `c2` int NOT NULL,
4267 `c3` char(20) DEFAULT NULL,
4268 PRIMARY KEY (`c1`)
4269 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4270 ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
4271 SHOW TABLES;
4272 Tables_in_test
4273 t1
4274 SHOW CREATE TABLE t1;
4275 Table Create Table
4276 t1 CREATE TABLE `t1` (
4277 `c1` char(15) NOT NULL,
4278 `c2` int NOT NULL,
4279 `c4` longblob,
4280 `c3` char(20) DEFAULT NULL,
4281 PRIMARY KEY (`c1`)
4282 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4283 DROP TABLE t1;
4284 SHOW TABLES;
4285 Tables_in_test
4286 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
4287 SHOW TABLES;
4288 Tables_in_test
4289 t1
4290 SHOW CREATE TABLE t1;
4291 Table Create Table
4292 t1 CREATE TABLE `t1` (
4293 `c1` varchar(15) NOT NULL,
4294 `c2` int NOT NULL,
4295 `c3` varchar(20) DEFAULT NULL,
4296 PRIMARY KEY (`c1`)
4297 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4298 ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
4299 SHOW TABLES;
4300 Tables_in_test
4301 t1
4302 SHOW CREATE TABLE t1;
4303 Table Create Table
4304 t1 CREATE TABLE `t1` (
4305 `c1` varchar(15) NOT NULL,
4306 `c2` int NOT NULL,
4307 `c4` longblob,
4308 `c3` varchar(20) DEFAULT NULL,
4309 PRIMARY KEY (`c1`)
4310 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4311 DROP TABLE t1;
4312 SHOW TABLES;
4313 Tables_in_test
4314 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
4315 SHOW TABLES;
4316 Tables_in_test
4317 t1
4318 SHOW CREATE TABLE t1;
4319 Table Create Table
4320 t1 CREATE TABLE `t1` (
4321 `c1` binary(15) NOT NULL,
4322 `c2` int NOT NULL,
4323 `c3` binary(20) DEFAULT NULL,
4324 PRIMARY KEY (`c1`)
4325 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4326 ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
4327 SHOW TABLES;
4328 Tables_in_test
4329 t1
4330 SHOW CREATE TABLE t1;
4331 Table Create Table
4332 t1 CREATE TABLE `t1` (
4333 `c1` binary(15) NOT NULL,
4334 `c2` int NOT NULL,
4335 `c4` longblob,
4336 `c3` binary(20) DEFAULT NULL,
4337 PRIMARY KEY (`c1`)
4338 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4339 DROP TABLE t1;
4340 SHOW TABLES;
4341 Tables_in_test
4342 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
4343 SHOW TABLES;
4344 Tables_in_test
4345 t1
4346 SHOW CREATE TABLE t1;
4347 Table Create Table
4348 t1 CREATE TABLE `t1` (
4349 `c1` varbinary(15) NOT NULL,
4350 `c2` int NOT NULL,
4351 `c3` varbinary(20) DEFAULT NULL,
4352 PRIMARY KEY (`c1`)
4353 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4354 ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
4355 SHOW TABLES;
4356 Tables_in_test
4357 t1
4358 SHOW CREATE TABLE t1;
4359 Table Create Table
4360 t1 CREATE TABLE `t1` (
4361 `c1` varbinary(15) NOT NULL,
4362 `c2` int NOT NULL,
4363 `c4` longblob,
4364 `c3` varbinary(20) DEFAULT NULL,
4365 PRIMARY KEY (`c1`)
4366 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4367 DROP TABLE t1;
4368 SHOW TABLES;
4369 Tables_in_test
4370 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
4371 SHOW TABLES;
4372 Tables_in_test
4373 t1
4374 SHOW CREATE TABLE t1;
4375 Table Create Table
4376 t1 CREATE TABLE `t1` (
4377 `c1` char(15) NOT NULL,
4378 `c2` int NOT NULL,
4379 `c3` char(20) NOT NULL,
4380 PRIMARY KEY (`c1`)
4381 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4382 ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
4383 SHOW TABLES;
4384 Tables_in_test
4385 t1
4386 SHOW CREATE TABLE t1;
4387 Table Create Table
4388 t1 CREATE TABLE `t1` (
4389 `c1` char(15) NOT NULL,
4390 `c2` int NOT NULL,
4391 `c4` longblob NOT NULL,
4392 `c3` char(20) NOT NULL,
4393 PRIMARY KEY (`c1`)
4394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4395 DROP TABLE t1;
4396 SHOW TABLES;
4397 Tables_in_test
4398 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
4399 SHOW TABLES;
4400 Tables_in_test
4401 t1
4402 SHOW CREATE TABLE t1;
4403 Table Create Table
4404 t1 CREATE TABLE `t1` (
4405 `c1` varchar(15) NOT NULL,
4406 `c2` int NOT NULL,
4407 `c3` varchar(20) NOT NULL,
4408 PRIMARY KEY (`c1`)
4409 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4410 ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
4411 SHOW TABLES;
4412 Tables_in_test
4413 t1
4414 SHOW CREATE TABLE t1;
4415 Table Create Table
4416 t1 CREATE TABLE `t1` (
4417 `c1` varchar(15) NOT NULL,
4418 `c2` int NOT NULL,
4419 `c4` longblob NOT NULL,
4420 `c3` varchar(20) NOT NULL,
4421 PRIMARY KEY (`c1`)
4422 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4423 DROP TABLE t1;
4424 SHOW TABLES;
4425 Tables_in_test
4426 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
4427 SHOW TABLES;
4428 Tables_in_test
4429 t1
4430 SHOW CREATE TABLE t1;
4431 Table Create Table
4432 t1 CREATE TABLE `t1` (
4433 `c1` binary(15) NOT NULL,
4434 `c2` int NOT NULL,
4435 `c3` binary(20) NOT NULL,
4436 PRIMARY KEY (`c1`)
4437 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4438 ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
4439 SHOW TABLES;
4440 Tables_in_test
4441 t1
4442 SHOW CREATE TABLE t1;
4443 Table Create Table
4444 t1 CREATE TABLE `t1` (
4445 `c1` binary(15) NOT NULL,
4446 `c2` int NOT NULL,
4447 `c4` longblob NOT NULL,
4448 `c3` binary(20) NOT NULL,
4449 PRIMARY KEY (`c1`)
4450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4451 DROP TABLE t1;
4452 SHOW TABLES;
4453 Tables_in_test
4454 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
4455 SHOW TABLES;
4456 Tables_in_test
4457 t1
4458 SHOW CREATE TABLE t1;
4459 Table Create Table
4460 t1 CREATE TABLE `t1` (
4461 `c1` varbinary(15) NOT NULL,
4462 `c2` int NOT NULL,
4463 `c3` varbinary(20) NOT NULL,
4464 PRIMARY KEY (`c1`)
4465 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4466 ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
4467 SHOW TABLES;
4468 Tables_in_test
4469 t1
4470 SHOW CREATE TABLE t1;
4471 Table Create Table
4472 t1 CREATE TABLE `t1` (
4473 `c1` varbinary(15) NOT NULL,
4474 `c2` int NOT NULL,
4475 `c4` longblob NOT NULL,
4476 `c3` varbinary(20) NOT NULL,
4477 PRIMARY KEY (`c1`)
4478 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4479 DROP TABLE t1;
4480 SHOW TABLES;
4481 Tables_in_test
4482 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
4483 SHOW TABLES;
4484 Tables_in_test
4485 t1
4486 SHOW CREATE TABLE t1;
4487 Table Create Table
4488 t1 CREATE TABLE `t1` (
4489 `c1` char(15) NOT NULL,
4490 `c2` int NOT NULL,
4491 `c3` char(20) DEFAULT NULL,
4492 PRIMARY KEY (`c1`)
4493 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4494 ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
4495 SHOW TABLES;
4496 Tables_in_test
4497 t1
4498 SHOW CREATE TABLE t1;
4499 Table Create Table
4500 t1 CREATE TABLE `t1` (
4501 `c1` char(15) NOT NULL,
4502 `c2` int NOT NULL,
4503 `c4` tinytext,
4504 `c3` char(20) DEFAULT NULL,
4505 PRIMARY KEY (`c1`)
4506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4507 DROP TABLE t1;
4508 SHOW TABLES;
4509 Tables_in_test
4510 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
4511 SHOW TABLES;
4512 Tables_in_test
4513 t1
4514 SHOW CREATE TABLE t1;
4515 Table Create Table
4516 t1 CREATE TABLE `t1` (
4517 `c1` varchar(15) NOT NULL,
4518 `c2` int NOT NULL,
4519 `c3` varchar(20) DEFAULT NULL,
4520 PRIMARY KEY (`c1`)
4521 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4522 ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
4523 SHOW TABLES;
4524 Tables_in_test
4525 t1
4526 SHOW CREATE TABLE t1;
4527 Table Create Table
4528 t1 CREATE TABLE `t1` (
4529 `c1` varchar(15) NOT NULL,
4530 `c2` int NOT NULL,
4531 `c4` tinytext,
4532 `c3` varchar(20) DEFAULT NULL,
4533 PRIMARY KEY (`c1`)
4534 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4535 DROP TABLE t1;
4536 SHOW TABLES;
4537 Tables_in_test
4538 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
4539 SHOW TABLES;
4540 Tables_in_test
4541 t1
4542 SHOW CREATE TABLE t1;
4543 Table Create Table
4544 t1 CREATE TABLE `t1` (
4545 `c1` binary(15) NOT NULL,
4546 `c2` int NOT NULL,
4547 `c3` binary(20) DEFAULT NULL,
4548 PRIMARY KEY (`c1`)
4549 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4550 ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
4551 SHOW TABLES;
4552 Tables_in_test
4553 t1
4554 SHOW CREATE TABLE t1;
4555 Table Create Table
4556 t1 CREATE TABLE `t1` (
4557 `c1` binary(15) NOT NULL,
4558 `c2` int NOT NULL,
4559 `c4` tinytext,
4560 `c3` binary(20) DEFAULT NULL,
4561 PRIMARY KEY (`c1`)
4562 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4563 DROP TABLE t1;
4564 SHOW TABLES;
4565 Tables_in_test
4566 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
4567 SHOW TABLES;
4568 Tables_in_test
4569 t1
4570 SHOW CREATE TABLE t1;
4571 Table Create Table
4572 t1 CREATE TABLE `t1` (
4573 `c1` varbinary(15) NOT NULL,
4574 `c2` int NOT NULL,
4575 `c3` varbinary(20) DEFAULT NULL,
4576 PRIMARY KEY (`c1`)
4577 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4578 ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
4579 SHOW TABLES;
4580 Tables_in_test
4581 t1
4582 SHOW CREATE TABLE t1;
4583 Table Create Table
4584 t1 CREATE TABLE `t1` (
4585 `c1` varbinary(15) NOT NULL,
4586 `c2` int NOT NULL,
4587 `c4` tinytext,
4588 `c3` varbinary(20) DEFAULT NULL,
4589 PRIMARY KEY (`c1`)
4590 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4591 DROP TABLE t1;
4592 SHOW TABLES;
4593 Tables_in_test
4594 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
4595 SHOW TABLES;
4596 Tables_in_test
4597 t1
4598 SHOW CREATE TABLE t1;
4599 Table Create Table
4600 t1 CREATE TABLE `t1` (
4601 `c1` char(15) NOT NULL,
4602 `c2` int NOT NULL,
4603 `c3` char(20) NOT NULL,
4604 PRIMARY KEY (`c1`)
4605 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4606 ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
4607 SHOW TABLES;
4608 Tables_in_test
4609 t1
4610 SHOW CREATE TABLE t1;
4611 Table Create Table
4612 t1 CREATE TABLE `t1` (
4613 `c1` char(15) NOT NULL,
4614 `c2` int NOT NULL,
4615 `c4` tinytext NOT NULL,
4616 `c3` char(20) NOT NULL,
4617 PRIMARY KEY (`c1`)
4618 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4619 DROP TABLE t1;
4620 SHOW TABLES;
4621 Tables_in_test
4622 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
4623 SHOW TABLES;
4624 Tables_in_test
4625 t1
4626 SHOW CREATE TABLE t1;
4627 Table Create Table
4628 t1 CREATE TABLE `t1` (
4629 `c1` varchar(15) NOT NULL,
4630 `c2` int NOT NULL,
4631 `c3` varchar(20) NOT NULL,
4632 PRIMARY KEY (`c1`)
4633 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4634 ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
4635 SHOW TABLES;
4636 Tables_in_test
4637 t1
4638 SHOW CREATE TABLE t1;
4639 Table Create Table
4640 t1 CREATE TABLE `t1` (
4641 `c1` varchar(15) NOT NULL,
4642 `c2` int NOT NULL,
4643 `c4` tinytext NOT NULL,
4644 `c3` varchar(20) NOT NULL,
4645 PRIMARY KEY (`c1`)
4646 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4647 DROP TABLE t1;
4648 SHOW TABLES;
4649 Tables_in_test
4650 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
4651 SHOW TABLES;
4652 Tables_in_test
4653 t1
4654 SHOW CREATE TABLE t1;
4655 Table Create Table
4656 t1 CREATE TABLE `t1` (
4657 `c1` binary(15) NOT NULL,
4658 `c2` int NOT NULL,
4659 `c3` binary(20) NOT NULL,
4660 PRIMARY KEY (`c1`)
4661 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4662 ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
4663 SHOW TABLES;
4664 Tables_in_test
4665 t1
4666 SHOW CREATE TABLE t1;
4667 Table Create Table
4668 t1 CREATE TABLE `t1` (
4669 `c1` binary(15) NOT NULL,
4670 `c2` int NOT NULL,
4671 `c4` tinytext NOT NULL,
4672 `c3` binary(20) NOT NULL,
4673 PRIMARY KEY (`c1`)
4674 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4675 DROP TABLE t1;
4676 SHOW TABLES;
4677 Tables_in_test
4678 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
4679 SHOW TABLES;
4680 Tables_in_test
4681 t1
4682 SHOW CREATE TABLE t1;
4683 Table Create Table
4684 t1 CREATE TABLE `t1` (
4685 `c1` varbinary(15) NOT NULL,
4686 `c2` int NOT NULL,
4687 `c3` varbinary(20) NOT NULL,
4688 PRIMARY KEY (`c1`)
4689 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4690 ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
4691 SHOW TABLES;
4692 Tables_in_test
4693 t1
4694 SHOW CREATE TABLE t1;
4695 Table Create Table
4696 t1 CREATE TABLE `t1` (
4697 `c1` varbinary(15) NOT NULL,
4698 `c2` int NOT NULL,
4699 `c4` tinytext NOT NULL,
4700 `c3` varbinary(20) NOT NULL,
4701 PRIMARY KEY (`c1`)
4702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4703 DROP TABLE t1;
4704 SHOW TABLES;
4705 Tables_in_test
4706 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
4707 SHOW TABLES;
4708 Tables_in_test
4709 t1
4710 SHOW CREATE TABLE t1;
4711 Table Create Table
4712 t1 CREATE TABLE `t1` (
4713 `c1` char(15) NOT NULL,
4714 `c2` int NOT NULL,
4715 `c3` char(20) DEFAULT NULL,
4716 PRIMARY KEY (`c1`)
4717 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4718 ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
4719 SHOW TABLES;
4720 Tables_in_test
4721 t1
4722 SHOW CREATE TABLE t1;
4723 Table Create Table
4724 t1 CREATE TABLE `t1` (
4725 `c1` char(15) NOT NULL,
4726 `c2` int NOT NULL,
4727 `c4` text,
4728 `c3` char(20) DEFAULT NULL,
4729 PRIMARY KEY (`c1`)
4730 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4731 DROP TABLE t1;
4732 SHOW TABLES;
4733 Tables_in_test
4734 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
4735 SHOW TABLES;
4736 Tables_in_test
4737 t1
4738 SHOW CREATE TABLE t1;
4739 Table Create Table
4740 t1 CREATE TABLE `t1` (
4741 `c1` varchar(15) NOT NULL,
4742 `c2` int NOT NULL,
4743 `c3` varchar(20) DEFAULT NULL,
4744 PRIMARY KEY (`c1`)
4745 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4746 ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
4747 SHOW TABLES;
4748 Tables_in_test
4749 t1
4750 SHOW CREATE TABLE t1;
4751 Table Create Table
4752 t1 CREATE TABLE `t1` (
4753 `c1` varchar(15) NOT NULL,
4754 `c2` int NOT NULL,
4755 `c4` text,
4756 `c3` varchar(20) DEFAULT NULL,
4757 PRIMARY KEY (`c1`)
4758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4759 DROP TABLE t1;
4760 SHOW TABLES;
4761 Tables_in_test
4762 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
4763 SHOW TABLES;
4764 Tables_in_test
4765 t1
4766 SHOW CREATE TABLE t1;
4767 Table Create Table
4768 t1 CREATE TABLE `t1` (
4769 `c1` binary(15) NOT NULL,
4770 `c2` int NOT NULL,
4771 `c3` binary(20) DEFAULT NULL,
4772 PRIMARY KEY (`c1`)
4773 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4774 ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
4775 SHOW TABLES;
4776 Tables_in_test
4777 t1
4778 SHOW CREATE TABLE t1;
4779 Table Create Table
4780 t1 CREATE TABLE `t1` (
4781 `c1` binary(15) NOT NULL,
4782 `c2` int NOT NULL,
4783 `c4` text,
4784 `c3` binary(20) DEFAULT NULL,
4785 PRIMARY KEY (`c1`)
4786 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4787 DROP TABLE t1;
4788 SHOW TABLES;
4789 Tables_in_test
4790 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
4791 SHOW TABLES;
4792 Tables_in_test
4793 t1
4794 SHOW CREATE TABLE t1;
4795 Table Create Table
4796 t1 CREATE TABLE `t1` (
4797 `c1` varbinary(15) NOT NULL,
4798 `c2` int NOT NULL,
4799 `c3` varbinary(20) DEFAULT NULL,
4800 PRIMARY KEY (`c1`)
4801 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4802 ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
4803 SHOW TABLES;
4804 Tables_in_test
4805 t1
4806 SHOW CREATE TABLE t1;
4807 Table Create Table
4808 t1 CREATE TABLE `t1` (
4809 `c1` varbinary(15) NOT NULL,
4810 `c2` int NOT NULL,
4811 `c4` text,
4812 `c3` varbinary(20) DEFAULT NULL,
4813 PRIMARY KEY (`c1`)
4814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4815 DROP TABLE t1;
4816 SHOW TABLES;
4817 Tables_in_test
4818 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
4819 SHOW TABLES;
4820 Tables_in_test
4821 t1
4822 SHOW CREATE TABLE t1;
4823 Table Create Table
4824 t1 CREATE TABLE `t1` (
4825 `c1` char(15) NOT NULL,
4826 `c2` int NOT NULL,
4827 `c3` char(20) NOT NULL,
4828 PRIMARY KEY (`c1`)
4829 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4830 ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
4831 SHOW TABLES;
4832 Tables_in_test
4833 t1
4834 SHOW CREATE TABLE t1;
4835 Table Create Table
4836 t1 CREATE TABLE `t1` (
4837 `c1` char(15) NOT NULL,
4838 `c2` int NOT NULL,
4839 `c4` text NOT NULL,
4840 `c3` char(20) NOT NULL,
4841 PRIMARY KEY (`c1`)
4842 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4843 DROP TABLE t1;
4844 SHOW TABLES;
4845 Tables_in_test
4846 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
4847 SHOW TABLES;
4848 Tables_in_test
4849 t1
4850 SHOW CREATE TABLE t1;
4851 Table Create Table
4852 t1 CREATE TABLE `t1` (
4853 `c1` varchar(15) NOT NULL,
4854 `c2` int NOT NULL,
4855 `c3` varchar(20) NOT NULL,
4856 PRIMARY KEY (`c1`)
4857 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4858 ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
4859 SHOW TABLES;
4860 Tables_in_test
4861 t1
4862 SHOW CREATE TABLE t1;
4863 Table Create Table
4864 t1 CREATE TABLE `t1` (
4865 `c1` varchar(15) NOT NULL,
4866 `c2` int NOT NULL,
4867 `c4` text NOT NULL,
4868 `c3` varchar(20) NOT NULL,
4869 PRIMARY KEY (`c1`)
4870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4871 DROP TABLE t1;
4872 SHOW TABLES;
4873 Tables_in_test
4874 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
4875 SHOW TABLES;
4876 Tables_in_test
4877 t1
4878 SHOW CREATE TABLE t1;
4879 Table Create Table
4880 t1 CREATE TABLE `t1` (
4881 `c1` binary(15) NOT NULL,
4882 `c2` int NOT NULL,
4883 `c3` binary(20) NOT NULL,
4884 PRIMARY KEY (`c1`)
4885 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4886 ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
4887 SHOW TABLES;
4888 Tables_in_test
4889 t1
4890 SHOW CREATE TABLE t1;
4891 Table Create Table
4892 t1 CREATE TABLE `t1` (
4893 `c1` binary(15) NOT NULL,
4894 `c2` int NOT NULL,
4895 `c4` text NOT NULL,
4896 `c3` binary(20) NOT NULL,
4897 PRIMARY KEY (`c1`)
4898 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4899 DROP TABLE t1;
4900 SHOW TABLES;
4901 Tables_in_test
4902 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
4903 SHOW TABLES;
4904 Tables_in_test
4905 t1
4906 SHOW CREATE TABLE t1;
4907 Table Create Table
4908 t1 CREATE TABLE `t1` (
4909 `c1` varbinary(15) NOT NULL,
4910 `c2` int NOT NULL,
4911 `c3` varbinary(20) NOT NULL,
4912 PRIMARY KEY (`c1`)
4913 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4914 ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
4915 SHOW TABLES;
4916 Tables_in_test
4917 t1
4918 SHOW CREATE TABLE t1;
4919 Table Create Table
4920 t1 CREATE TABLE `t1` (
4921 `c1` varbinary(15) NOT NULL,
4922 `c2` int NOT NULL,
4923 `c4` text NOT NULL,
4924 `c3` varbinary(20) NOT NULL,
4925 PRIMARY KEY (`c1`)
4926 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4927 DROP TABLE t1;
4928 SHOW TABLES;
4929 Tables_in_test
4930 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
4931 SHOW TABLES;
4932 Tables_in_test
4933 t1
4934 SHOW CREATE TABLE t1;
4935 Table Create Table
4936 t1 CREATE TABLE `t1` (
4937 `c1` char(15) NOT NULL,
4938 `c2` int NOT NULL,
4939 `c3` char(20) DEFAULT NULL,
4940 PRIMARY KEY (`c1`)
4941 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4942 ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
4943 SHOW TABLES;
4944 Tables_in_test
4945 t1
4946 SHOW CREATE TABLE t1;
4947 Table Create Table
4948 t1 CREATE TABLE `t1` (
4949 `c1` char(15) NOT NULL,
4950 `c2` int NOT NULL,
4951 `c4` mediumtext,
4952 `c3` char(20) DEFAULT NULL,
4953 PRIMARY KEY (`c1`)
4954 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4955 DROP TABLE t1;
4956 SHOW TABLES;
4957 Tables_in_test
4958 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
4959 SHOW TABLES;
4960 Tables_in_test
4961 t1
4962 SHOW CREATE TABLE t1;
4963 Table Create Table
4964 t1 CREATE TABLE `t1` (
4965 `c1` varchar(15) NOT NULL,
4966 `c2` int NOT NULL,
4967 `c3` varchar(20) DEFAULT NULL,
4968 PRIMARY KEY (`c1`)
4969 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4970 ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
4971 SHOW TABLES;
4972 Tables_in_test
4973 t1
4974 SHOW CREATE TABLE t1;
4975 Table Create Table
4976 t1 CREATE TABLE `t1` (
4977 `c1` varchar(15) NOT NULL,
4978 `c2` int NOT NULL,
4979 `c4` mediumtext,
4980 `c3` varchar(20) DEFAULT NULL,
4981 PRIMARY KEY (`c1`)
4982 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4983 DROP TABLE t1;
4984 SHOW TABLES;
4985 Tables_in_test
4986 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
4987 SHOW TABLES;
4988 Tables_in_test
4989 t1
4990 SHOW CREATE TABLE t1;
4991 Table Create Table
4992 t1 CREATE TABLE `t1` (
4993 `c1` binary(15) NOT NULL,
4994 `c2` int NOT NULL,
4995 `c3` binary(20) DEFAULT NULL,
4996 PRIMARY KEY (`c1`)
4997 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4998 ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
4999 SHOW TABLES;
5000 Tables_in_test
5001 t1
5002 SHOW CREATE TABLE t1;
5003 Table Create Table
5004 t1 CREATE TABLE `t1` (
5005 `c1` binary(15) NOT NULL,
5006 `c2` int NOT NULL,
5007 `c4` mediumtext,
5008 `c3` binary(20) DEFAULT NULL,
5009 PRIMARY KEY (`c1`)
5010 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5011 DROP TABLE t1;
5012 SHOW TABLES;
5013 Tables_in_test
5014 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
5015 SHOW TABLES;
5016 Tables_in_test
5017 t1
5018 SHOW CREATE TABLE t1;
5019 Table Create Table
5020 t1 CREATE TABLE `t1` (
5021 `c1` varbinary(15) NOT NULL,
5022 `c2` int NOT NULL,
5023 `c3` varbinary(20) DEFAULT NULL,
5024 PRIMARY KEY (`c1`)
5025 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5026 ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
5027 SHOW TABLES;
5028 Tables_in_test
5029 t1
5030 SHOW CREATE TABLE t1;
5031 Table Create Table
5032 t1 CREATE TABLE `t1` (
5033 `c1` varbinary(15) NOT NULL,
5034 `c2` int NOT NULL,
5035 `c4` mediumtext,
5036 `c3` varbinary(20) DEFAULT NULL,
5037 PRIMARY KEY (`c1`)
5038 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5039 DROP TABLE t1;
5040 SHOW TABLES;
5041 Tables_in_test
5042 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
5043 SHOW TABLES;
5044 Tables_in_test
5045 t1
5046 SHOW CREATE TABLE t1;
5047 Table Create Table
5048 t1 CREATE TABLE `t1` (
5049 `c1` char(15) NOT NULL,
5050 `c2` int NOT NULL,
5051 `c3` char(20) NOT NULL,
5052 PRIMARY KEY (`c1`)
5053 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5054 ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
5055 SHOW TABLES;
5056 Tables_in_test
5057 t1
5058 SHOW CREATE TABLE t1;
5059 Table Create Table
5060 t1 CREATE TABLE `t1` (
5061 `c1` char(15) NOT NULL,
5062 `c2` int NOT NULL,
5063 `c4` mediumtext NOT NULL,
5064 `c3` char(20) NOT NULL,
5065 PRIMARY KEY (`c1`)
5066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5067 DROP TABLE t1;
5068 SHOW TABLES;
5069 Tables_in_test
5070 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
5071 SHOW TABLES;
5072 Tables_in_test
5073 t1
5074 SHOW CREATE TABLE t1;
5075 Table Create Table
5076 t1 CREATE TABLE `t1` (
5077 `c1` varchar(15) NOT NULL,
5078 `c2` int NOT NULL,
5079 `c3` varchar(20) NOT NULL,
5080 PRIMARY KEY (`c1`)
5081 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5082 ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
5083 SHOW TABLES;
5084 Tables_in_test
5085 t1
5086 SHOW CREATE TABLE t1;
5087 Table Create Table
5088 t1 CREATE TABLE `t1` (
5089 `c1` varchar(15) NOT NULL,
5090 `c2` int NOT NULL,
5091 `c4` mediumtext NOT NULL,
5092 `c3` varchar(20) NOT NULL,
5093 PRIMARY KEY (`c1`)
5094 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5095 DROP TABLE t1;
5096 SHOW TABLES;
5097 Tables_in_test
5098 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
5099 SHOW TABLES;
5100 Tables_in_test
5101 t1
5102 SHOW CREATE TABLE t1;
5103 Table Create Table
5104 t1 CREATE TABLE `t1` (
5105 `c1` binary(15) NOT NULL,
5106 `c2` int NOT NULL,
5107 `c3` binary(20) NOT NULL,
5108 PRIMARY KEY (`c1`)
5109 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5110 ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
5111 SHOW TABLES;
5112 Tables_in_test
5113 t1
5114 SHOW CREATE TABLE t1;
5115 Table Create Table
5116 t1 CREATE TABLE `t1` (
5117 `c1` binary(15) NOT NULL,
5118 `c2` int NOT NULL,
5119 `c4` mediumtext NOT NULL,
5120 `c3` binary(20) NOT NULL,
5121 PRIMARY KEY (`c1`)
5122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5123 DROP TABLE t1;
5124 SHOW TABLES;
5125 Tables_in_test
5126 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
5127 SHOW TABLES;
5128 Tables_in_test
5129 t1
5130 SHOW CREATE TABLE t1;
5131 Table Create Table
5132 t1 CREATE TABLE `t1` (
5133 `c1` varbinary(15) NOT NULL,
5134 `c2` int NOT NULL,
5135 `c3` varbinary(20) NOT NULL,
5136 PRIMARY KEY (`c1`)
5137 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5138 ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
5139 SHOW TABLES;
5140 Tables_in_test
5141 t1
5142 SHOW CREATE TABLE t1;
5143 Table Create Table
5144 t1 CREATE TABLE `t1` (
5145 `c1` varbinary(15) NOT NULL,
5146 `c2` int NOT NULL,
5147 `c4` mediumtext NOT NULL,
5148 `c3` varbinary(20) NOT NULL,
5149 PRIMARY KEY (`c1`)
5150 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5151 DROP TABLE t1;
5152 SHOW TABLES;
5153 Tables_in_test
5154 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
5155 SHOW TABLES;
5156 Tables_in_test
5157 t1
5158 SHOW CREATE TABLE t1;
5159 Table Create Table
5160 t1 CREATE TABLE `t1` (
5161 `c1` char(15) NOT NULL,
5162 `c2` int NOT NULL,
5163 `c3` char(20) DEFAULT NULL,
5164 PRIMARY KEY (`c1`)
5165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5166 ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
5167 SHOW TABLES;
5168 Tables_in_test
5169 t1
5170 SHOW CREATE TABLE t1;
5171 Table Create Table
5172 t1 CREATE TABLE `t1` (
5173 `c1` char(15) NOT NULL,
5174 `c2` int NOT NULL,
5175 `c4` longtext,
5176 `c3` char(20) DEFAULT NULL,
5177 PRIMARY KEY (`c1`)
5178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5179 DROP TABLE t1;
5180 SHOW TABLES;
5181 Tables_in_test
5182 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
5183 SHOW TABLES;
5184 Tables_in_test
5185 t1
5186 SHOW CREATE TABLE t1;
5187 Table Create Table
5188 t1 CREATE TABLE `t1` (
5189 `c1` varchar(15) NOT NULL,
5190 `c2` int NOT NULL,
5191 `c3` varchar(20) DEFAULT NULL,
5192 PRIMARY KEY (`c1`)
5193 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5194 ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
5195 SHOW TABLES;
5196 Tables_in_test
5197 t1
5198 SHOW CREATE TABLE t1;
5199 Table Create Table
5200 t1 CREATE TABLE `t1` (
5201 `c1` varchar(15) NOT NULL,
5202 `c2` int NOT NULL,
5203 `c4` longtext,
5204 `c3` varchar(20) DEFAULT NULL,
5205 PRIMARY KEY (`c1`)
5206 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5207 DROP TABLE t1;
5208 SHOW TABLES;
5209 Tables_in_test
5210 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
5211 SHOW TABLES;
5212 Tables_in_test
5213 t1
5214 SHOW CREATE TABLE t1;
5215 Table Create Table
5216 t1 CREATE TABLE `t1` (
5217 `c1` binary(15) NOT NULL,
5218 `c2` int NOT NULL,
5219 `c3` binary(20) DEFAULT NULL,
5220 PRIMARY KEY (`c1`)
5221 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5222 ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
5223 SHOW TABLES;
5224 Tables_in_test
5225 t1
5226 SHOW CREATE TABLE t1;
5227 Table Create Table
5228 t1 CREATE TABLE `t1` (
5229 `c1` binary(15) NOT NULL,
5230 `c2` int NOT NULL,
5231 `c4` longtext,
5232 `c3` binary(20) DEFAULT NULL,
5233 PRIMARY KEY (`c1`)
5234 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5235 DROP TABLE t1;
5236 SHOW TABLES;
5237 Tables_in_test
5238 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
5239 SHOW TABLES;
5240 Tables_in_test
5241 t1
5242 SHOW CREATE TABLE t1;
5243 Table Create Table
5244 t1 CREATE TABLE `t1` (
5245 `c1` varbinary(15) NOT NULL,
5246 `c2` int NOT NULL,
5247 `c3` varbinary(20) DEFAULT NULL,
5248 PRIMARY KEY (`c1`)
5249 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5250 ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
5251 SHOW TABLES;
5252 Tables_in_test
5253 t1
5254 SHOW CREATE TABLE t1;
5255 Table Create Table
5256 t1 CREATE TABLE `t1` (
5257 `c1` varbinary(15) NOT NULL,
5258 `c2` int NOT NULL,
5259 `c4` longtext,
5260 `c3` varbinary(20) DEFAULT NULL,
5261 PRIMARY KEY (`c1`)
5262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5263 DROP TABLE t1;
5264 SHOW TABLES;
5265 Tables_in_test
5266 CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
5267 SHOW TABLES;
5268 Tables_in_test
5269 t1
5270 SHOW CREATE TABLE t1;
5271 Table Create Table
5272 t1 CREATE TABLE `t1` (
5273 `c1` char(15) NOT NULL,
5274 `c2` int NOT NULL,
5275 `c3` char(20) NOT NULL,
5276 PRIMARY KEY (`c1`)
5277 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5278 ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
5279 SHOW TABLES;
5280 Tables_in_test
5281 t1
5282 SHOW CREATE TABLE t1;
5283 Table Create Table
5284 t1 CREATE TABLE `t1` (
5285 `c1` char(15) NOT NULL,
5286 `c2` int NOT NULL,
5287 `c4` longtext NOT NULL,
5288 `c3` char(20) NOT NULL,
5289 PRIMARY KEY (`c1`)
5290 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5291 DROP TABLE t1;
5292 SHOW TABLES;
5293 Tables_in_test
5294 CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
5295 SHOW TABLES;
5296 Tables_in_test
5297 t1
5298 SHOW CREATE TABLE t1;
5299 Table Create Table
5300 t1 CREATE TABLE `t1` (
5301 `c1` varchar(15) NOT NULL,
5302 `c2` int NOT NULL,
5303 `c3` varchar(20) NOT NULL,
5304 PRIMARY KEY (`c1`)
5305 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5306 ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
5307 SHOW TABLES;
5308 Tables_in_test
5309 t1
5310 SHOW CREATE TABLE t1;
5311 Table Create Table
5312 t1 CREATE TABLE `t1` (
5313 `c1` varchar(15) NOT NULL,
5314 `c2` int NOT NULL,
5315 `c4` longtext NOT NULL,
5316 `c3` varchar(20) NOT NULL,
5317 PRIMARY KEY (`c1`)
5318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5319 DROP TABLE t1;
5320 SHOW TABLES;
5321 Tables_in_test
5322 CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
5323 SHOW TABLES;
5324 Tables_in_test
5325 t1
5326 SHOW CREATE TABLE t1;
5327 Table Create Table
5328 t1 CREATE TABLE `t1` (
5329 `c1` binary(15) NOT NULL,
5330 `c2` int NOT NULL,
5331 `c3` binary(20) NOT NULL,
5332 PRIMARY KEY (`c1`)
5333 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5334 ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
5335 SHOW TABLES;
5336 Tables_in_test
5337 t1
5338 SHOW CREATE TABLE t1;
5339 Table Create Table
5340 t1 CREATE TABLE `t1` (
5341 `c1` binary(15) NOT NULL,
5342 `c2` int NOT NULL,
5343 `c4` longtext NOT NULL,
5344 `c3` binary(20) NOT NULL,
5345 PRIMARY KEY (`c1`)
5346 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5347 DROP TABLE t1;
5348 SHOW TABLES;
5349 Tables_in_test
5350 CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
5351 SHOW TABLES;
5352 Tables_in_test
5353 t1
5354 SHOW CREATE TABLE t1;
5355 Table Create Table
5356 t1 CREATE TABLE `t1` (
5357 `c1` varbinary(15) NOT NULL,
5358 `c2` int NOT NULL,
5359 `c3` varbinary(20) NOT NULL,
5360 PRIMARY KEY (`c1`)
5361 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5362 ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
5363 SHOW TABLES;
5364 Tables_in_test
5365 t1
5366 SHOW CREATE TABLE t1;
5367 Table Create Table
5368 t1 CREATE TABLE `t1` (
5369 `c1` varbinary(15) NOT NULL,
5370 `c2` int NOT NULL,
5371 `c4` longtext NOT NULL,
5372 `c3` varbinary(20) NOT NULL,
5373 PRIMARY KEY (`c1`)
5374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5375 DROP TABLE t1;
5376 SHOW TABLES;
5377 Tables_in_test