Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t5
6 SHOW CREATE TABLE t5;
7 Table Create Table
8 t5 CREATE TABLE `t5` (
9 `c1` int NOT NULL,
10 `c2` char(10) DEFAULT 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 t5 ADD c4 CHAR(20) NULL AFTER c2;
15 SHOW TABLES;
16 Tables_in_test
17 t5
18 SHOW CREATE TABLE t5;
19 Table Create Table
20 t5 CREATE TABLE `t5` (
21 `c1` int NOT NULL,
22 `c2` char(10) DEFAULT NULL,
23 `c4` char(20) 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 t5;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL);
31 SHOW TABLES;
32 Tables_in_test
33 t5
34 SHOW CREATE TABLE t5;
35 Table Create Table
36 t5 CREATE TABLE `t5` (
37 `c1` int NOT NULL,
38 `c2` varchar(10) DEFAULT 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 t5 ADD c4 CHAR(20) NULL AFTER c2;
43 SHOW TABLES;
44 Tables_in_test
45 t5
46 SHOW CREATE TABLE t5;
47 Table Create Table
48 t5 CREATE TABLE `t5` (
49 `c1` int NOT NULL,
50 `c2` varchar(10) DEFAULT NULL,
51 `c4` char(20) 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 t5;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL);
59 SHOW TABLES;
60 Tables_in_test
61 t5
62 SHOW CREATE TABLE t5;
63 Table Create Table
64 t5 CREATE TABLE `t5` (
65 `c1` int NOT NULL,
66 `c2` binary(10) DEFAULT 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 t5 ADD c4 CHAR(20) NULL AFTER c2;
71 SHOW TABLES;
72 Tables_in_test
73 t5
74 SHOW CREATE TABLE t5;
75 Table Create Table
76 t5 CREATE TABLE `t5` (
77 `c1` int NOT NULL,
78 `c2` binary(10) DEFAULT NULL,
79 `c4` char(20) 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 t5;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t5
90 SHOW CREATE TABLE t5;
91 Table Create Table
92 t5 CREATE TABLE `t5` (
93 `c1` int NOT NULL,
94 `c2` varbinary(10) DEFAULT 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 t5 ADD c4 CHAR(20) NULL AFTER c2;
99 SHOW TABLES;
100 Tables_in_test
101 t5
102 SHOW CREATE TABLE t5;
103 Table Create Table
104 t5 CREATE TABLE `t5` (
105 `c1` int NOT NULL,
106 `c2` varbinary(10) DEFAULT NULL,
107 `c4` char(20) 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 t5;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL);
115 SHOW TABLES;
116 Tables_in_test
117 t5
118 SHOW CREATE TABLE t5;
119 Table Create Table
120 t5 CREATE TABLE `t5` (
121 `c1` int NOT NULL,
122 `c2` char(10) 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 t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
127 SHOW TABLES;
128 Tables_in_test
129 t5
130 SHOW CREATE TABLE t5;
131 Table Create Table
132 t5 CREATE TABLE `t5` (
133 `c1` int NOT NULL,
134 `c2` char(10) NOT NULL,
135 `c4` char(20) 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 t5;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL);
143 SHOW TABLES;
144 Tables_in_test
145 t5
146 SHOW CREATE TABLE t5;
147 Table Create Table
148 t5 CREATE TABLE `t5` (
149 `c1` int NOT NULL,
150 `c2` varchar(10) 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 t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
155 SHOW TABLES;
156 Tables_in_test
157 t5
158 SHOW CREATE TABLE t5;
159 Table Create Table
160 t5 CREATE TABLE `t5` (
161 `c1` int NOT NULL,
162 `c2` varchar(10) NOT NULL,
163 `c4` char(20) 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 t5;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL);
171 SHOW TABLES;
172 Tables_in_test
173 t5
174 SHOW CREATE TABLE t5;
175 Table Create Table
176 t5 CREATE TABLE `t5` (
177 `c1` int NOT NULL,
178 `c2` binary(10) 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 t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
183 SHOW TABLES;
184 Tables_in_test
185 t5
186 SHOW CREATE TABLE t5;
187 Table Create Table
188 t5 CREATE TABLE `t5` (
189 `c1` int NOT NULL,
190 `c2` binary(10) NOT NULL,
191 `c4` char(20) 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 t5;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL);
199 SHOW TABLES;
200 Tables_in_test
201 t5
202 SHOW CREATE TABLE t5;
203 Table Create Table
204 t5 CREATE TABLE `t5` (
205 `c1` int NOT NULL,
206 `c2` varbinary(10) 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 t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
211 SHOW TABLES;
212 Tables_in_test
213 t5
214 SHOW CREATE TABLE t5;
215 Table Create Table
216 t5 CREATE TABLE `t5` (
217 `c1` int NOT NULL,
218 `c2` varbinary(10) NOT NULL,
219 `c4` char(20) 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 t5;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL);
227 SHOW TABLES;
228 Tables_in_test
229 t5
230 SHOW CREATE TABLE t5;
231 Table Create Table
232 t5 CREATE TABLE `t5` (
233 `c1` int NOT NULL,
234 `c2` char(10) DEFAULT 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 t5 ADD c4 VARCHAR(20) NULL AFTER c2;
239 SHOW TABLES;
240 Tables_in_test
241 t5
242 SHOW CREATE TABLE t5;
243 Table Create Table
244 t5 CREATE TABLE `t5` (
245 `c1` int NOT NULL,
246 `c2` char(10) DEFAULT NULL,
247 `c4` varchar(20) 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 t5;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t5
258 SHOW CREATE TABLE t5;
259 Table Create Table
260 t5 CREATE TABLE `t5` (
261 `c1` int NOT NULL,
262 `c2` varchar(10) DEFAULT 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 t5 ADD c4 VARCHAR(20) NULL AFTER c2;
267 SHOW TABLES;
268 Tables_in_test
269 t5
270 SHOW CREATE TABLE t5;
271 Table Create Table
272 t5 CREATE TABLE `t5` (
273 `c1` int NOT NULL,
274 `c2` varchar(10) DEFAULT NULL,
275 `c4` varchar(20) 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 t5;
280 SHOW TABLES;
281 Tables_in_test
282 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL);
283 SHOW TABLES;
284 Tables_in_test
285 t5
286 SHOW CREATE TABLE t5;
287 Table Create Table
288 t5 CREATE TABLE `t5` (
289 `c1` int NOT NULL,
290 `c2` binary(10) DEFAULT 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 t5 ADD c4 VARCHAR(20) NULL AFTER c2;
295 SHOW TABLES;
296 Tables_in_test
297 t5
298 SHOW CREATE TABLE t5;
299 Table Create Table
300 t5 CREATE TABLE `t5` (
301 `c1` int NOT NULL,
302 `c2` binary(10) DEFAULT NULL,
303 `c4` varchar(20) 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 t5;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL);
311 SHOW TABLES;
312 Tables_in_test
313 t5
314 SHOW CREATE TABLE t5;
315 Table Create Table
316 t5 CREATE TABLE `t5` (
317 `c1` int NOT NULL,
318 `c2` varbinary(10) DEFAULT 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 t5 ADD c4 VARCHAR(20) NULL AFTER c2;
323 SHOW TABLES;
324 Tables_in_test
325 t5
326 SHOW CREATE TABLE t5;
327 Table Create Table
328 t5 CREATE TABLE `t5` (
329 `c1` int NOT NULL,
330 `c2` varbinary(10) DEFAULT NULL,
331 `c4` varchar(20) 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 t5;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL);
339 SHOW TABLES;
340 Tables_in_test
341 t5
342 SHOW CREATE TABLE t5;
343 Table Create Table
344 t5 CREATE TABLE `t5` (
345 `c1` int NOT NULL,
346 `c2` char(10) 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 t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
351 SHOW TABLES;
352 Tables_in_test
353 t5
354 SHOW CREATE TABLE t5;
355 Table Create Table
356 t5 CREATE TABLE `t5` (
357 `c1` int NOT NULL,
358 `c2` char(10) NOT NULL,
359 `c4` varchar(20) 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 t5;
364 SHOW TABLES;
365 Tables_in_test
366 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL);
367 SHOW TABLES;
368 Tables_in_test
369 t5
370 SHOW CREATE TABLE t5;
371 Table Create Table
372 t5 CREATE TABLE `t5` (
373 `c1` int NOT NULL,
374 `c2` varchar(10) 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 t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
379 SHOW TABLES;
380 Tables_in_test
381 t5
382 SHOW CREATE TABLE t5;
383 Table Create Table
384 t5 CREATE TABLE `t5` (
385 `c1` int NOT NULL,
386 `c2` varchar(10) NOT NULL,
387 `c4` varchar(20) 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 t5;
392 SHOW TABLES;
393 Tables_in_test
394 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL);
395 SHOW TABLES;
396 Tables_in_test
397 t5
398 SHOW CREATE TABLE t5;
399 Table Create Table
400 t5 CREATE TABLE `t5` (
401 `c1` int NOT NULL,
402 `c2` binary(10) 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 t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
407 SHOW TABLES;
408 Tables_in_test
409 t5
410 SHOW CREATE TABLE t5;
411 Table Create Table
412 t5 CREATE TABLE `t5` (
413 `c1` int NOT NULL,
414 `c2` binary(10) NOT NULL,
415 `c4` varchar(20) 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 t5;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL);
423 SHOW TABLES;
424 Tables_in_test
425 t5
426 SHOW CREATE TABLE t5;
427 Table Create Table
428 t5 CREATE TABLE `t5` (
429 `c1` int NOT NULL,
430 `c2` varbinary(10) 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 t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
435 SHOW TABLES;
436 Tables_in_test
437 t5
438 SHOW CREATE TABLE t5;
439 Table Create Table
440 t5 CREATE TABLE `t5` (
441 `c1` int NOT NULL,
442 `c2` varbinary(10) NOT NULL,
443 `c4` varchar(20) 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 t5;
448 SHOW TABLES;
449 Tables_in_test
450 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL);
451 SHOW TABLES;
452 Tables_in_test
453 t5
454 SHOW CREATE TABLE t5;
455 Table Create Table
456 t5 CREATE TABLE `t5` (
457 `c1` int NOT NULL,
458 `c2` char(10) DEFAULT 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 t5 ADD c4 BINARY(20) NULL AFTER c2;
463 SHOW TABLES;
464 Tables_in_test
465 t5
466 SHOW CREATE TABLE t5;
467 Table Create Table
468 t5 CREATE TABLE `t5` (
469 `c1` int NOT NULL,
470 `c2` char(10) DEFAULT NULL,
471 `c4` binary(20) 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 t5;
476 SHOW TABLES;
477 Tables_in_test
478 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL);
479 SHOW TABLES;
480 Tables_in_test
481 t5
482 SHOW CREATE TABLE t5;
483 Table Create Table
484 t5 CREATE TABLE `t5` (
485 `c1` int NOT NULL,
486 `c2` varchar(10) DEFAULT 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 t5 ADD c4 BINARY(20) NULL AFTER c2;
491 SHOW TABLES;
492 Tables_in_test
493 t5
494 SHOW CREATE TABLE t5;
495 Table Create Table
496 t5 CREATE TABLE `t5` (
497 `c1` int NOT NULL,
498 `c2` varchar(10) DEFAULT NULL,
499 `c4` binary(20) 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 t5;
504 SHOW TABLES;
505 Tables_in_test
506 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL);
507 SHOW TABLES;
508 Tables_in_test
509 t5
510 SHOW CREATE TABLE t5;
511 Table Create Table
512 t5 CREATE TABLE `t5` (
513 `c1` int NOT NULL,
514 `c2` binary(10) DEFAULT 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 t5 ADD c4 BINARY(20) NULL AFTER c2;
519 SHOW TABLES;
520 Tables_in_test
521 t5
522 SHOW CREATE TABLE t5;
523 Table Create Table
524 t5 CREATE TABLE `t5` (
525 `c1` int NOT NULL,
526 `c2` binary(10) DEFAULT NULL,
527 `c4` binary(20) 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 t5;
532 SHOW TABLES;
533 Tables_in_test
534 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL);
535 SHOW TABLES;
536 Tables_in_test
537 t5
538 SHOW CREATE TABLE t5;
539 Table Create Table
540 t5 CREATE TABLE `t5` (
541 `c1` int NOT NULL,
542 `c2` varbinary(10) DEFAULT 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 t5 ADD c4 BINARY(20) NULL AFTER c2;
547 SHOW TABLES;
548 Tables_in_test
549 t5
550 SHOW CREATE TABLE t5;
551 Table Create Table
552 t5 CREATE TABLE `t5` (
553 `c1` int NOT NULL,
554 `c2` varbinary(10) DEFAULT NULL,
555 `c4` binary(20) 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 t5;
560 SHOW TABLES;
561 Tables_in_test
562 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL);
563 SHOW TABLES;
564 Tables_in_test
565 t5
566 SHOW CREATE TABLE t5;
567 Table Create Table
568 t5 CREATE TABLE `t5` (
569 `c1` int NOT NULL,
570 `c2` char(10) 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 t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
575 SHOW TABLES;
576 Tables_in_test
577 t5
578 SHOW CREATE TABLE t5;
579 Table Create Table
580 t5 CREATE TABLE `t5` (
581 `c1` int NOT NULL,
582 `c2` char(10) NOT NULL,
583 `c4` binary(20) 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 t5;
588 SHOW TABLES;
589 Tables_in_test
590 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL);
591 SHOW TABLES;
592 Tables_in_test
593 t5
594 SHOW CREATE TABLE t5;
595 Table Create Table
596 t5 CREATE TABLE `t5` (
597 `c1` int NOT NULL,
598 `c2` varchar(10) 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 t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
603 SHOW TABLES;
604 Tables_in_test
605 t5
606 SHOW CREATE TABLE t5;
607 Table Create Table
608 t5 CREATE TABLE `t5` (
609 `c1` int NOT NULL,
610 `c2` varchar(10) NOT NULL,
611 `c4` binary(20) 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 t5;
616 SHOW TABLES;
617 Tables_in_test
618 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL);
619 SHOW TABLES;
620 Tables_in_test
621 t5
622 SHOW CREATE TABLE t5;
623 Table Create Table
624 t5 CREATE TABLE `t5` (
625 `c1` int NOT NULL,
626 `c2` binary(10) 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 t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
631 SHOW TABLES;
632 Tables_in_test
633 t5
634 SHOW CREATE TABLE t5;
635 Table Create Table
636 t5 CREATE TABLE `t5` (
637 `c1` int NOT NULL,
638 `c2` binary(10) NOT NULL,
639 `c4` binary(20) 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 t5;
644 SHOW TABLES;
645 Tables_in_test
646 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL);
647 SHOW TABLES;
648 Tables_in_test
649 t5
650 SHOW CREATE TABLE t5;
651 Table Create Table
652 t5 CREATE TABLE `t5` (
653 `c1` int NOT NULL,
654 `c2` varbinary(10) 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 t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
659 SHOW TABLES;
660 Tables_in_test
661 t5
662 SHOW CREATE TABLE t5;
663 Table Create Table
664 t5 CREATE TABLE `t5` (
665 `c1` int NOT NULL,
666 `c2` varbinary(10) NOT NULL,
667 `c4` binary(20) 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 t5;
672 SHOW TABLES;
673 Tables_in_test
674 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL);
675 SHOW TABLES;
676 Tables_in_test
677 t5
678 SHOW CREATE TABLE t5;
679 Table Create Table
680 t5 CREATE TABLE `t5` (
681 `c1` int NOT NULL,
682 `c2` char(10) DEFAULT 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 t5 ADD c4 VARBINARY(20) NULL AFTER c2;
687 SHOW TABLES;
688 Tables_in_test
689 t5
690 SHOW CREATE TABLE t5;
691 Table Create Table
692 t5 CREATE TABLE `t5` (
693 `c1` int NOT NULL,
694 `c2` char(10) DEFAULT NULL,
695 `c4` varbinary(20) 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 t5;
700 SHOW TABLES;
701 Tables_in_test
702 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL);
703 SHOW TABLES;
704 Tables_in_test
705 t5
706 SHOW CREATE TABLE t5;
707 Table Create Table
708 t5 CREATE TABLE `t5` (
709 `c1` int NOT NULL,
710 `c2` varchar(10) DEFAULT 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 t5 ADD c4 VARBINARY(20) NULL AFTER c2;
715 SHOW TABLES;
716 Tables_in_test
717 t5
718 SHOW CREATE TABLE t5;
719 Table Create Table
720 t5 CREATE TABLE `t5` (
721 `c1` int NOT NULL,
722 `c2` varchar(10) DEFAULT NULL,
723 `c4` varbinary(20) 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 t5;
728 SHOW TABLES;
729 Tables_in_test
730 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL);
731 SHOW TABLES;
732 Tables_in_test
733 t5
734 SHOW CREATE TABLE t5;
735 Table Create Table
736 t5 CREATE TABLE `t5` (
737 `c1` int NOT NULL,
738 `c2` binary(10) DEFAULT 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 t5 ADD c4 VARBINARY(20) NULL AFTER c2;
743 SHOW TABLES;
744 Tables_in_test
745 t5
746 SHOW CREATE TABLE t5;
747 Table Create Table
748 t5 CREATE TABLE `t5` (
749 `c1` int NOT NULL,
750 `c2` binary(10) DEFAULT NULL,
751 `c4` varbinary(20) 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 t5;
756 SHOW TABLES;
757 Tables_in_test
758 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL);
759 SHOW TABLES;
760 Tables_in_test
761 t5
762 SHOW CREATE TABLE t5;
763 Table Create Table
764 t5 CREATE TABLE `t5` (
765 `c1` int NOT NULL,
766 `c2` varbinary(10) DEFAULT 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 t5 ADD c4 VARBINARY(20) NULL AFTER c2;
771 SHOW TABLES;
772 Tables_in_test
773 t5
774 SHOW CREATE TABLE t5;
775 Table Create Table
776 t5 CREATE TABLE `t5` (
777 `c1` int NOT NULL,
778 `c2` varbinary(10) DEFAULT NULL,
779 `c4` varbinary(20) 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 t5;
784 SHOW TABLES;
785 Tables_in_test
786 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL);
787 SHOW TABLES;
788 Tables_in_test
789 t5
790 SHOW CREATE TABLE t5;
791 Table Create Table
792 t5 CREATE TABLE `t5` (
793 `c1` int NOT NULL,
794 `c2` char(10) 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 t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
799 SHOW TABLES;
800 Tables_in_test
801 t5
802 SHOW CREATE TABLE t5;
803 Table Create Table
804 t5 CREATE TABLE `t5` (
805 `c1` int NOT NULL,
806 `c2` char(10) NOT NULL,
807 `c4` varbinary(20) 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 t5;
812 SHOW TABLES;
813 Tables_in_test
814 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL);
815 SHOW TABLES;
816 Tables_in_test
817 t5
818 SHOW CREATE TABLE t5;
819 Table Create Table
820 t5 CREATE TABLE `t5` (
821 `c1` int NOT NULL,
822 `c2` varchar(10) 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 t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
827 SHOW TABLES;
828 Tables_in_test
829 t5
830 SHOW CREATE TABLE t5;
831 Table Create Table
832 t5 CREATE TABLE `t5` (
833 `c1` int NOT NULL,
834 `c2` varchar(10) NOT NULL,
835 `c4` varbinary(20) 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 t5;
840 SHOW TABLES;
841 Tables_in_test
842 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL);
843 SHOW TABLES;
844 Tables_in_test
845 t5
846 SHOW CREATE TABLE t5;
847 Table Create Table
848 t5 CREATE TABLE `t5` (
849 `c1` int NOT NULL,
850 `c2` binary(10) 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 t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
855 SHOW TABLES;
856 Tables_in_test
857 t5
858 SHOW CREATE TABLE t5;
859 Table Create Table
860 t5 CREATE TABLE `t5` (
861 `c1` int NOT NULL,
862 `c2` binary(10) NOT NULL,
863 `c4` varbinary(20) 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 t5;
868 SHOW TABLES;
869 Tables_in_test
870 CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL);
871 SHOW TABLES;
872 Tables_in_test
873 t5
874 SHOW CREATE TABLE t5;
875 Table Create Table
876 t5 CREATE TABLE `t5` (
877 `c1` int NOT NULL,
878 `c2` varbinary(10) 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 t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
883 SHOW TABLES;
884 Tables_in_test
885 t5
886 SHOW CREATE TABLE t5;
887 Table Create Table
888 t5 CREATE TABLE `t5` (
889 `c1` int NOT NULL,
890 `c2` varbinary(10) NOT NULL,
891 `c4` varbinary(20) 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 t5;
896 SHOW TABLES;
897 Tables_in_test