Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 CHAR(10) NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t5
6 SHOW CREATE TABLE t5;
7 Table Create Table
8 t5 CREATE TABLE `t5` (
9 `c1` char(10) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
12 SHOW TABLES;
13 Tables_in_test
14 t5
15 SHOW CREATE TABLE t5;
16 Table Create Table
17 t5 CREATE TABLE `t5` (
18 `c1` char(10) DEFAULT NULL,
19 `c2` char(20) DEFAULT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t5;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t5(c1 VARCHAR(10) NULL);
25 SHOW TABLES;
26 Tables_in_test
27 t5
28 SHOW CREATE TABLE t5;
29 Table Create Table
30 t5 CREATE TABLE `t5` (
31 `c1` varchar(10) DEFAULT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
34 SHOW TABLES;
35 Tables_in_test
36 t5
37 SHOW CREATE TABLE t5;
38 Table Create Table
39 t5 CREATE TABLE `t5` (
40 `c1` varchar(10) DEFAULT NULL,
41 `c2` char(20) DEFAULT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t5;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t5(c1 BINARY(10) NULL);
47 SHOW TABLES;
48 Tables_in_test
49 t5
50 SHOW CREATE TABLE t5;
51 Table Create Table
52 t5 CREATE TABLE `t5` (
53 `c1` binary(10) DEFAULT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
56 SHOW TABLES;
57 Tables_in_test
58 t5
59 SHOW CREATE TABLE t5;
60 Table Create Table
61 t5 CREATE TABLE `t5` (
62 `c1` binary(10) DEFAULT NULL,
63 `c2` char(20) DEFAULT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t5;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t5(c1 VARBINARY(10) NULL);
69 SHOW TABLES;
70 Tables_in_test
71 t5
72 SHOW CREATE TABLE t5;
73 Table Create Table
74 t5 CREATE TABLE `t5` (
75 `c1` varbinary(10) DEFAULT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
78 SHOW TABLES;
79 Tables_in_test
80 t5
81 SHOW CREATE TABLE t5;
82 Table Create Table
83 t5 CREATE TABLE `t5` (
84 `c1` varbinary(10) DEFAULT NULL,
85 `c2` char(20) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t5;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
91 SHOW TABLES;
92 Tables_in_test
93 t5
94 SHOW CREATE TABLE t5;
95 Table Create Table
96 t5 CREATE TABLE `t5` (
97 `c1` char(10) NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
100 SHOW TABLES;
101 Tables_in_test
102 t5
103 SHOW CREATE TABLE t5;
104 Table Create Table
105 t5 CREATE TABLE `t5` (
106 `c1` char(10) NOT NULL,
107 `c2` char(20) NOT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t5;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
113 SHOW TABLES;
114 Tables_in_test
115 t5
116 SHOW CREATE TABLE t5;
117 Table Create Table
118 t5 CREATE TABLE `t5` (
119 `c1` varchar(10) NOT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
122 SHOW TABLES;
123 Tables_in_test
124 t5
125 SHOW CREATE TABLE t5;
126 Table Create Table
127 t5 CREATE TABLE `t5` (
128 `c1` varchar(10) NOT NULL,
129 `c2` char(20) NOT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t5;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
135 SHOW TABLES;
136 Tables_in_test
137 t5
138 SHOW CREATE TABLE t5;
139 Table Create Table
140 t5 CREATE TABLE `t5` (
141 `c1` binary(10) NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
144 SHOW TABLES;
145 Tables_in_test
146 t5
147 SHOW CREATE TABLE t5;
148 Table Create Table
149 t5 CREATE TABLE `t5` (
150 `c1` binary(10) NOT NULL,
151 `c2` char(20) NOT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t5;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
157 SHOW TABLES;
158 Tables_in_test
159 t5
160 SHOW CREATE TABLE t5;
161 Table Create Table
162 t5 CREATE TABLE `t5` (
163 `c1` varbinary(10) NOT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
165 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
166 SHOW TABLES;
167 Tables_in_test
168 t5
169 SHOW CREATE TABLE t5;
170 Table Create Table
171 t5 CREATE TABLE `t5` (
172 `c1` varbinary(10) NOT NULL,
173 `c2` char(20) NOT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t5;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t5(c1 CHAR(10) NULL);
179 SHOW TABLES;
180 Tables_in_test
181 t5
182 SHOW CREATE TABLE t5;
183 Table Create Table
184 t5 CREATE TABLE `t5` (
185 `c1` char(10) DEFAULT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
187 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
188 SHOW TABLES;
189 Tables_in_test
190 t5
191 SHOW CREATE TABLE t5;
192 Table Create Table
193 t5 CREATE TABLE `t5` (
194 `c1` char(10) DEFAULT NULL,
195 `c2` varchar(20) DEFAULT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t5;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t5(c1 VARCHAR(10) NULL);
201 SHOW TABLES;
202 Tables_in_test
203 t5
204 SHOW CREATE TABLE t5;
205 Table Create Table
206 t5 CREATE TABLE `t5` (
207 `c1` varchar(10) DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
210 SHOW TABLES;
211 Tables_in_test
212 t5
213 SHOW CREATE TABLE t5;
214 Table Create Table
215 t5 CREATE TABLE `t5` (
216 `c1` varchar(10) DEFAULT NULL,
217 `c2` varchar(20) DEFAULT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t5;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t5(c1 BINARY(10) NULL);
223 SHOW TABLES;
224 Tables_in_test
225 t5
226 SHOW CREATE TABLE t5;
227 Table Create Table
228 t5 CREATE TABLE `t5` (
229 `c1` binary(10) DEFAULT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
232 SHOW TABLES;
233 Tables_in_test
234 t5
235 SHOW CREATE TABLE t5;
236 Table Create Table
237 t5 CREATE TABLE `t5` (
238 `c1` binary(10) DEFAULT NULL,
239 `c2` varchar(20) DEFAULT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t5;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t5(c1 VARBINARY(10) NULL);
245 SHOW TABLES;
246 Tables_in_test
247 t5
248 SHOW CREATE TABLE t5;
249 Table Create Table
250 t5 CREATE TABLE `t5` (
251 `c1` varbinary(10) DEFAULT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
254 SHOW TABLES;
255 Tables_in_test
256 t5
257 SHOW CREATE TABLE t5;
258 Table Create Table
259 t5 CREATE TABLE `t5` (
260 `c1` varbinary(10) DEFAULT NULL,
261 `c2` varchar(20) DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t5;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
267 SHOW TABLES;
268 Tables_in_test
269 t5
270 SHOW CREATE TABLE t5;
271 Table Create Table
272 t5 CREATE TABLE `t5` (
273 `c1` char(10) NOT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
276 SHOW TABLES;
277 Tables_in_test
278 t5
279 SHOW CREATE TABLE t5;
280 Table Create Table
281 t5 CREATE TABLE `t5` (
282 `c1` char(10) NOT NULL,
283 `c2` varchar(20) NOT NULL
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t5;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
289 SHOW TABLES;
290 Tables_in_test
291 t5
292 SHOW CREATE TABLE t5;
293 Table Create Table
294 t5 CREATE TABLE `t5` (
295 `c1` varchar(10) NOT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
298 SHOW TABLES;
299 Tables_in_test
300 t5
301 SHOW CREATE TABLE t5;
302 Table Create Table
303 t5 CREATE TABLE `t5` (
304 `c1` varchar(10) NOT NULL,
305 `c2` varchar(20) NOT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t5;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t5(c1 BINARY(10) NOT 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` binary(10) NOT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
320 SHOW TABLES;
321 Tables_in_test
322 t5
323 SHOW CREATE TABLE t5;
324 Table Create Table
325 t5 CREATE TABLE `t5` (
326 `c1` binary(10) NOT NULL,
327 `c2` varchar(20) NOT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t5;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
333 SHOW TABLES;
334 Tables_in_test
335 t5
336 SHOW CREATE TABLE t5;
337 Table Create Table
338 t5 CREATE TABLE `t5` (
339 `c1` varbinary(10) NOT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
341 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
342 SHOW TABLES;
343 Tables_in_test
344 t5
345 SHOW CREATE TABLE t5;
346 Table Create Table
347 t5 CREATE TABLE `t5` (
348 `c1` varbinary(10) NOT NULL,
349 `c2` varchar(20) NOT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t5;
352 SHOW TABLES;
353 Tables_in_test
354 CREATE TABLE t5(c1 CHAR(10) NULL);
355 SHOW TABLES;
356 Tables_in_test
357 t5
358 SHOW CREATE TABLE t5;
359 Table Create Table
360 t5 CREATE TABLE `t5` (
361 `c1` char(10) DEFAULT NULL
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
364 SHOW TABLES;
365 Tables_in_test
366 t5
367 SHOW CREATE TABLE t5;
368 Table Create Table
369 t5 CREATE TABLE `t5` (
370 `c1` char(10) DEFAULT NULL,
371 `c2` binary(20) DEFAULT NULL
372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
373 DROP TABLE t5;
374 SHOW TABLES;
375 Tables_in_test
376 CREATE TABLE t5(c1 VARCHAR(10) NULL);
377 SHOW TABLES;
378 Tables_in_test
379 t5
380 SHOW CREATE TABLE t5;
381 Table Create Table
382 t5 CREATE TABLE `t5` (
383 `c1` varchar(10) DEFAULT NULL
384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
385 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
386 SHOW TABLES;
387 Tables_in_test
388 t5
389 SHOW CREATE TABLE t5;
390 Table Create Table
391 t5 CREATE TABLE `t5` (
392 `c1` varchar(10) DEFAULT NULL,
393 `c2` binary(20) DEFAULT NULL
394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
395 DROP TABLE t5;
396 SHOW TABLES;
397 Tables_in_test
398 CREATE TABLE t5(c1 BINARY(10) NULL);
399 SHOW TABLES;
400 Tables_in_test
401 t5
402 SHOW CREATE TABLE t5;
403 Table Create Table
404 t5 CREATE TABLE `t5` (
405 `c1` binary(10) DEFAULT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
407 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
408 SHOW TABLES;
409 Tables_in_test
410 t5
411 SHOW CREATE TABLE t5;
412 Table Create Table
413 t5 CREATE TABLE `t5` (
414 `c1` binary(10) DEFAULT NULL,
415 `c2` binary(20) DEFAULT NULL
416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
417 DROP TABLE t5;
418 SHOW TABLES;
419 Tables_in_test
420 CREATE TABLE t5(c1 VARBINARY(10) NULL);
421 SHOW TABLES;
422 Tables_in_test
423 t5
424 SHOW CREATE TABLE t5;
425 Table Create Table
426 t5 CREATE TABLE `t5` (
427 `c1` varbinary(10) DEFAULT NULL
428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
429 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
430 SHOW TABLES;
431 Tables_in_test
432 t5
433 SHOW CREATE TABLE t5;
434 Table Create Table
435 t5 CREATE TABLE `t5` (
436 `c1` varbinary(10) DEFAULT NULL,
437 `c2` binary(20) DEFAULT NULL
438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 DROP TABLE t5;
440 SHOW TABLES;
441 Tables_in_test
442 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
443 SHOW TABLES;
444 Tables_in_test
445 t5
446 SHOW CREATE TABLE t5;
447 Table Create Table
448 t5 CREATE TABLE `t5` (
449 `c1` char(10) NOT NULL
450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
451 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
452 SHOW TABLES;
453 Tables_in_test
454 t5
455 SHOW CREATE TABLE t5;
456 Table Create Table
457 t5 CREATE TABLE `t5` (
458 `c1` char(10) NOT NULL,
459 `c2` binary(20) NOT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
461 DROP TABLE t5;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
465 SHOW TABLES;
466 Tables_in_test
467 t5
468 SHOW CREATE TABLE t5;
469 Table Create Table
470 t5 CREATE TABLE `t5` (
471 `c1` varchar(10) NOT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
473 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
474 SHOW TABLES;
475 Tables_in_test
476 t5
477 SHOW CREATE TABLE t5;
478 Table Create Table
479 t5 CREATE TABLE `t5` (
480 `c1` varchar(10) NOT NULL,
481 `c2` binary(20) NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t5;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
487 SHOW TABLES;
488 Tables_in_test
489 t5
490 SHOW CREATE TABLE t5;
491 Table Create Table
492 t5 CREATE TABLE `t5` (
493 `c1` binary(10) NOT NULL
494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
495 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
496 SHOW TABLES;
497 Tables_in_test
498 t5
499 SHOW CREATE TABLE t5;
500 Table Create Table
501 t5 CREATE TABLE `t5` (
502 `c1` binary(10) NOT NULL,
503 `c2` binary(20) NOT NULL
504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 DROP TABLE t5;
506 SHOW TABLES;
507 Tables_in_test
508 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
509 SHOW TABLES;
510 Tables_in_test
511 t5
512 SHOW CREATE TABLE t5;
513 Table Create Table
514 t5 CREATE TABLE `t5` (
515 `c1` varbinary(10) NOT NULL
516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
517 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
518 SHOW TABLES;
519 Tables_in_test
520 t5
521 SHOW CREATE TABLE t5;
522 Table Create Table
523 t5 CREATE TABLE `t5` (
524 `c1` varbinary(10) NOT NULL,
525 `c2` binary(20) NOT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
527 DROP TABLE t5;
528 SHOW TABLES;
529 Tables_in_test
530 CREATE TABLE t5(c1 CHAR(10) NULL);
531 SHOW TABLES;
532 Tables_in_test
533 t5
534 SHOW CREATE TABLE t5;
535 Table Create Table
536 t5 CREATE TABLE `t5` (
537 `c1` char(10) DEFAULT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
539 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
540 SHOW TABLES;
541 Tables_in_test
542 t5
543 SHOW CREATE TABLE t5;
544 Table Create Table
545 t5 CREATE TABLE `t5` (
546 `c1` char(10) DEFAULT NULL,
547 `c2` varbinary(20) DEFAULT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
549 DROP TABLE t5;
550 SHOW TABLES;
551 Tables_in_test
552 CREATE TABLE t5(c1 VARCHAR(10) NULL);
553 SHOW TABLES;
554 Tables_in_test
555 t5
556 SHOW CREATE TABLE t5;
557 Table Create Table
558 t5 CREATE TABLE `t5` (
559 `c1` varchar(10) DEFAULT NULL
560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
561 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
562 SHOW TABLES;
563 Tables_in_test
564 t5
565 SHOW CREATE TABLE t5;
566 Table Create Table
567 t5 CREATE TABLE `t5` (
568 `c1` varchar(10) DEFAULT NULL,
569 `c2` varbinary(20) DEFAULT NULL
570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
571 DROP TABLE t5;
572 SHOW TABLES;
573 Tables_in_test
574 CREATE TABLE t5(c1 BINARY(10) NULL);
575 SHOW TABLES;
576 Tables_in_test
577 t5
578 SHOW CREATE TABLE t5;
579 Table Create Table
580 t5 CREATE TABLE `t5` (
581 `c1` binary(10) DEFAULT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
583 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
584 SHOW TABLES;
585 Tables_in_test
586 t5
587 SHOW CREATE TABLE t5;
588 Table Create Table
589 t5 CREATE TABLE `t5` (
590 `c1` binary(10) DEFAULT NULL,
591 `c2` varbinary(20) DEFAULT NULL
592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
593 DROP TABLE t5;
594 SHOW TABLES;
595 Tables_in_test
596 CREATE TABLE t5(c1 VARBINARY(10) NULL);
597 SHOW TABLES;
598 Tables_in_test
599 t5
600 SHOW CREATE TABLE t5;
601 Table Create Table
602 t5 CREATE TABLE `t5` (
603 `c1` varbinary(10) DEFAULT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
605 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
606 SHOW TABLES;
607 Tables_in_test
608 t5
609 SHOW CREATE TABLE t5;
610 Table Create Table
611 t5 CREATE TABLE `t5` (
612 `c1` varbinary(10) DEFAULT NULL,
613 `c2` varbinary(20) DEFAULT NULL
614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
615 DROP TABLE t5;
616 SHOW TABLES;
617 Tables_in_test
618 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
619 SHOW TABLES;
620 Tables_in_test
621 t5
622 SHOW CREATE TABLE t5;
623 Table Create Table
624 t5 CREATE TABLE `t5` (
625 `c1` char(10) NOT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
628 SHOW TABLES;
629 Tables_in_test
630 t5
631 SHOW CREATE TABLE t5;
632 Table Create Table
633 t5 CREATE TABLE `t5` (
634 `c1` char(10) NOT NULL,
635 `c2` varbinary(20) NOT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
637 DROP TABLE t5;
638 SHOW TABLES;
639 Tables_in_test
640 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
641 SHOW TABLES;
642 Tables_in_test
643 t5
644 SHOW CREATE TABLE t5;
645 Table Create Table
646 t5 CREATE TABLE `t5` (
647 `c1` varchar(10) NOT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
649 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
650 SHOW TABLES;
651 Tables_in_test
652 t5
653 SHOW CREATE TABLE t5;
654 Table Create Table
655 t5 CREATE TABLE `t5` (
656 `c1` varchar(10) NOT NULL,
657 `c2` varbinary(20) NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
659 DROP TABLE t5;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
663 SHOW TABLES;
664 Tables_in_test
665 t5
666 SHOW CREATE TABLE t5;
667 Table Create Table
668 t5 CREATE TABLE `t5` (
669 `c1` binary(10) NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
671 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
672 SHOW TABLES;
673 Tables_in_test
674 t5
675 SHOW CREATE TABLE t5;
676 Table Create Table
677 t5 CREATE TABLE `t5` (
678 `c1` binary(10) NOT NULL,
679 `c2` varbinary(20) NOT NULL
680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
681 DROP TABLE t5;
682 SHOW TABLES;
683 Tables_in_test
684 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
685 SHOW TABLES;
686 Tables_in_test
687 t5
688 SHOW CREATE TABLE t5;
689 Table Create Table
690 t5 CREATE TABLE `t5` (
691 `c1` varbinary(10) NOT NULL
692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
693 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
694 SHOW TABLES;
695 Tables_in_test
696 t5
697 SHOW CREATE TABLE t5;
698 Table Create Table
699 t5 CREATE TABLE `t5` (
700 `c1` varbinary(10) NOT NULL,
701 `c2` varbinary(20) NOT NULL
702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
703 DROP TABLE t5;
704 SHOW TABLES;
705 Tables_in_test