1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 CHAR(10) NULL);
9 `c1` char(10) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
11 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
17 t5 CREATE TABLE `t5` (
18 `c1` char(10) DEFAULT NULL,
19 `c2` char(20) DEFAULT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
24 CREATE TABLE t5(c1 VARCHAR(10) NULL);
30 t5 CREATE TABLE `t5` (
31 `c1` varchar(10) DEFAULT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
33 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
39 t5 CREATE TABLE `t5` (
40 `c1` varchar(10) DEFAULT NULL,
41 `c2` char(20) DEFAULT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
46 CREATE TABLE t5(c1 BINARY(10) NULL);
52 t5 CREATE TABLE `t5` (
53 `c1` binary(10) DEFAULT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
55 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
61 t5 CREATE TABLE `t5` (
62 `c1` binary(10) DEFAULT NULL,
63 `c2` char(20) DEFAULT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
68 CREATE TABLE t5(c1 VARBINARY(10) NULL);
74 t5 CREATE TABLE `t5` (
75 `c1` varbinary(10) DEFAULT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
77 ALTER TABLE t5 ADD c2 CHAR(20) NULL ;
83 t5 CREATE TABLE `t5` (
84 `c1` varbinary(10) DEFAULT NULL,
85 `c2` char(20) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
90 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
96 t5 CREATE TABLE `t5` (
97 `c1` char(10) NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
99 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
103 SHOW CREATE TABLE t5;
105 t5 CREATE TABLE `t5` (
106 `c1` char(10) NOT NULL,
107 `c2` char(20) NOT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
112 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
116 SHOW CREATE TABLE t5;
118 t5 CREATE TABLE `t5` (
119 `c1` varchar(10) NOT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
121 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
125 SHOW CREATE TABLE t5;
127 t5 CREATE TABLE `t5` (
128 `c1` varchar(10) NOT NULL,
129 `c2` char(20) NOT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
134 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
138 SHOW CREATE TABLE t5;
140 t5 CREATE TABLE `t5` (
141 `c1` binary(10) NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
143 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
147 SHOW CREATE TABLE t5;
149 t5 CREATE TABLE `t5` (
150 `c1` binary(10) NOT NULL,
151 `c2` char(20) NOT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
156 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
160 SHOW CREATE TABLE t5;
162 t5 CREATE TABLE `t5` (
163 `c1` varbinary(10) NOT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
165 ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL ;
169 SHOW CREATE TABLE t5;
171 t5 CREATE TABLE `t5` (
172 `c1` varbinary(10) NOT NULL,
173 `c2` char(20) NOT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
178 CREATE TABLE t5(c1 CHAR(10) NULL);
182 SHOW CREATE TABLE t5;
184 t5 CREATE TABLE `t5` (
185 `c1` char(10) DEFAULT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
187 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
191 SHOW CREATE TABLE t5;
193 t5 CREATE TABLE `t5` (
194 `c1` char(10) DEFAULT NULL,
195 `c2` varchar(20) DEFAULT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
200 CREATE TABLE t5(c1 VARCHAR(10) NULL);
204 SHOW CREATE TABLE t5;
206 t5 CREATE TABLE `t5` (
207 `c1` varchar(10) DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
209 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
213 SHOW CREATE TABLE t5;
215 t5 CREATE TABLE `t5` (
216 `c1` varchar(10) DEFAULT NULL,
217 `c2` varchar(20) DEFAULT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
222 CREATE TABLE t5(c1 BINARY(10) NULL);
226 SHOW CREATE TABLE t5;
228 t5 CREATE TABLE `t5` (
229 `c1` binary(10) DEFAULT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
231 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
235 SHOW CREATE TABLE t5;
237 t5 CREATE TABLE `t5` (
238 `c1` binary(10) DEFAULT NULL,
239 `c2` varchar(20) DEFAULT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
244 CREATE TABLE t5(c1 VARBINARY(10) NULL);
248 SHOW CREATE TABLE t5;
250 t5 CREATE TABLE `t5` (
251 `c1` varbinary(10) DEFAULT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
253 ALTER TABLE t5 ADD c2 VARCHAR(20) NULL ;
257 SHOW CREATE TABLE t5;
259 t5 CREATE TABLE `t5` (
260 `c1` varbinary(10) DEFAULT NULL,
261 `c2` varchar(20) DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
266 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
270 SHOW CREATE TABLE t5;
272 t5 CREATE TABLE `t5` (
273 `c1` char(10) NOT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
275 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
279 SHOW CREATE TABLE t5;
281 t5 CREATE TABLE `t5` (
282 `c1` char(10) NOT NULL,
283 `c2` varchar(20) NOT NULL
284 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
288 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
292 SHOW CREATE TABLE t5;
294 t5 CREATE TABLE `t5` (
295 `c1` varchar(10) NOT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
297 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
301 SHOW CREATE TABLE t5;
303 t5 CREATE TABLE `t5` (
304 `c1` varchar(10) NOT NULL,
305 `c2` varchar(20) NOT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
310 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
314 SHOW CREATE TABLE t5;
316 t5 CREATE TABLE `t5` (
317 `c1` binary(10) NOT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
319 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
323 SHOW CREATE TABLE t5;
325 t5 CREATE TABLE `t5` (
326 `c1` binary(10) NOT NULL,
327 `c2` varchar(20) NOT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
332 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
336 SHOW CREATE TABLE t5;
338 t5 CREATE TABLE `t5` (
339 `c1` varbinary(10) NOT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
341 ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL ;
345 SHOW CREATE TABLE t5;
347 t5 CREATE TABLE `t5` (
348 `c1` varbinary(10) NOT NULL,
349 `c2` varchar(20) NOT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
354 CREATE TABLE t5(c1 CHAR(10) NULL);
358 SHOW CREATE TABLE t5;
360 t5 CREATE TABLE `t5` (
361 `c1` char(10) DEFAULT NULL
362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
363 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
367 SHOW CREATE TABLE t5;
369 t5 CREATE TABLE `t5` (
370 `c1` char(10) DEFAULT NULL,
371 `c2` binary(20) DEFAULT NULL
372 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
376 CREATE TABLE t5(c1 VARCHAR(10) NULL);
380 SHOW CREATE TABLE t5;
382 t5 CREATE TABLE `t5` (
383 `c1` varchar(10) DEFAULT NULL
384 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
385 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
389 SHOW CREATE TABLE t5;
391 t5 CREATE TABLE `t5` (
392 `c1` varchar(10) DEFAULT NULL,
393 `c2` binary(20) DEFAULT NULL
394 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
398 CREATE TABLE t5(c1 BINARY(10) NULL);
402 SHOW CREATE TABLE t5;
404 t5 CREATE TABLE `t5` (
405 `c1` binary(10) DEFAULT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
407 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
411 SHOW CREATE TABLE t5;
413 t5 CREATE TABLE `t5` (
414 `c1` binary(10) DEFAULT NULL,
415 `c2` binary(20) DEFAULT NULL
416 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
420 CREATE TABLE t5(c1 VARBINARY(10) NULL);
424 SHOW CREATE TABLE t5;
426 t5 CREATE TABLE `t5` (
427 `c1` varbinary(10) DEFAULT NULL
428 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
429 ALTER TABLE t5 ADD c2 BINARY(20) NULL ;
433 SHOW CREATE TABLE t5;
435 t5 CREATE TABLE `t5` (
436 `c1` varbinary(10) DEFAULT NULL,
437 `c2` binary(20) DEFAULT NULL
438 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
442 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
446 SHOW CREATE TABLE t5;
448 t5 CREATE TABLE `t5` (
449 `c1` char(10) NOT NULL
450 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
451 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
455 SHOW CREATE TABLE t5;
457 t5 CREATE TABLE `t5` (
458 `c1` char(10) NOT NULL,
459 `c2` binary(20) NOT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
464 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
468 SHOW CREATE TABLE t5;
470 t5 CREATE TABLE `t5` (
471 `c1` varchar(10) NOT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
473 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
477 SHOW CREATE TABLE t5;
479 t5 CREATE TABLE `t5` (
480 `c1` varchar(10) NOT NULL,
481 `c2` binary(20) NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
486 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
490 SHOW CREATE TABLE t5;
492 t5 CREATE TABLE `t5` (
493 `c1` binary(10) NOT NULL
494 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
495 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
499 SHOW CREATE TABLE t5;
501 t5 CREATE TABLE `t5` (
502 `c1` binary(10) NOT NULL,
503 `c2` binary(20) NOT NULL
504 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
508 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
512 SHOW CREATE TABLE t5;
514 t5 CREATE TABLE `t5` (
515 `c1` varbinary(10) NOT NULL
516 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
517 ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL ;
521 SHOW CREATE TABLE t5;
523 t5 CREATE TABLE `t5` (
524 `c1` varbinary(10) NOT NULL,
525 `c2` binary(20) NOT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
530 CREATE TABLE t5(c1 CHAR(10) NULL);
534 SHOW CREATE TABLE t5;
536 t5 CREATE TABLE `t5` (
537 `c1` char(10) DEFAULT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
539 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
543 SHOW CREATE TABLE t5;
545 t5 CREATE TABLE `t5` (
546 `c1` char(10) DEFAULT NULL,
547 `c2` varbinary(20) DEFAULT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
552 CREATE TABLE t5(c1 VARCHAR(10) NULL);
556 SHOW CREATE TABLE t5;
558 t5 CREATE TABLE `t5` (
559 `c1` varchar(10) DEFAULT NULL
560 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
561 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
565 SHOW CREATE TABLE t5;
567 t5 CREATE TABLE `t5` (
568 `c1` varchar(10) DEFAULT NULL,
569 `c2` varbinary(20) DEFAULT NULL
570 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
574 CREATE TABLE t5(c1 BINARY(10) NULL);
578 SHOW CREATE TABLE t5;
580 t5 CREATE TABLE `t5` (
581 `c1` binary(10) DEFAULT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
583 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
587 SHOW CREATE TABLE t5;
589 t5 CREATE TABLE `t5` (
590 `c1` binary(10) DEFAULT NULL,
591 `c2` varbinary(20) DEFAULT NULL
592 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
596 CREATE TABLE t5(c1 VARBINARY(10) NULL);
600 SHOW CREATE TABLE t5;
602 t5 CREATE TABLE `t5` (
603 `c1` varbinary(10) DEFAULT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
605 ALTER TABLE t5 ADD c2 VARBINARY(20) NULL ;
609 SHOW CREATE TABLE t5;
611 t5 CREATE TABLE `t5` (
612 `c1` varbinary(10) DEFAULT NULL,
613 `c2` varbinary(20) DEFAULT NULL
614 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
618 CREATE TABLE t5(c1 CHAR(10) NOT NULL);
622 SHOW CREATE TABLE t5;
624 t5 CREATE TABLE `t5` (
625 `c1` char(10) NOT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
627 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
631 SHOW CREATE TABLE t5;
633 t5 CREATE TABLE `t5` (
634 `c1` char(10) NOT NULL,
635 `c2` varbinary(20) NOT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
640 CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
644 SHOW CREATE TABLE t5;
646 t5 CREATE TABLE `t5` (
647 `c1` varchar(10) NOT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
649 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
653 SHOW CREATE TABLE t5;
655 t5 CREATE TABLE `t5` (
656 `c1` varchar(10) NOT NULL,
657 `c2` varbinary(20) NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
662 CREATE TABLE t5(c1 BINARY(10) NOT NULL);
666 SHOW CREATE TABLE t5;
668 t5 CREATE TABLE `t5` (
669 `c1` binary(10) NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
671 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
675 SHOW CREATE TABLE t5;
677 t5 CREATE TABLE `t5` (
678 `c1` binary(10) NOT NULL,
679 `c2` varbinary(20) NOT NULL
680 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
684 CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
688 SHOW CREATE TABLE t5;
690 t5 CREATE TABLE `t5` (
691 `c1` varbinary(10) NOT NULL
692 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
693 ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL ;
697 SHOW CREATE TABLE t5;
699 t5 CREATE TABLE `t5` (
700 `c1` varbinary(10) NOT NULL,
701 `c2` varbinary(20) NOT NULL
702 ) ENGINE=ENGINE DEFAULT CHARSET=latin1