1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 BIT NULL);
9 `c1` bit(1) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
11 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
17 t5 CREATE TABLE `t5` (
18 `c1` bit(1) DEFAULT NULL,
19 `c2` char(5) DEFAULT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
24 CREATE TABLE t5(c1 TINYINT NULL);
30 t5 CREATE TABLE `t5` (
31 `c1` tinyint(4) DEFAULT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
33 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
39 t5 CREATE TABLE `t5` (
40 `c1` tinyint(4) DEFAULT NULL,
41 `c2` char(5) DEFAULT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
46 CREATE TABLE t5(c1 SMALLINT NULL);
52 t5 CREATE TABLE `t5` (
53 `c1` smallint(6) DEFAULT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
55 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
61 t5 CREATE TABLE `t5` (
62 `c1` smallint(6) DEFAULT NULL,
63 `c2` char(5) DEFAULT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
68 CREATE TABLE t5(c1 MEDIUMINT NULL);
74 t5 CREATE TABLE `t5` (
75 `c1` mediumint(9) DEFAULT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
77 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
83 t5 CREATE TABLE `t5` (
84 `c1` mediumint(9) DEFAULT NULL,
85 `c2` char(5) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
90 CREATE TABLE t5(c1 INT NULL);
96 t5 CREATE TABLE `t5` (
97 `c1` int(11) DEFAULT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
99 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
103 SHOW CREATE TABLE t5;
105 t5 CREATE TABLE `t5` (
106 `c1` int(11) DEFAULT NULL,
107 `c2` char(5) DEFAULT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
112 CREATE TABLE t5(c1 INTEGER NULL);
116 SHOW CREATE TABLE t5;
118 t5 CREATE TABLE `t5` (
119 `c1` int(11) DEFAULT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
121 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
125 SHOW CREATE TABLE t5;
127 t5 CREATE TABLE `t5` (
128 `c1` int(11) DEFAULT NULL,
129 `c2` char(5) DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
134 CREATE TABLE t5(c1 BIGINT NULL);
138 SHOW CREATE TABLE t5;
140 t5 CREATE TABLE `t5` (
141 `c1` bigint(20) DEFAULT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
143 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
147 SHOW CREATE TABLE t5;
149 t5 CREATE TABLE `t5` (
150 `c1` bigint(20) DEFAULT NULL,
151 `c2` char(5) DEFAULT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
156 CREATE TABLE t5(c1 REAL NULL);
160 SHOW CREATE TABLE t5;
162 t5 CREATE TABLE `t5` (
163 `c1` double DEFAULT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
165 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
169 SHOW CREATE TABLE t5;
171 t5 CREATE TABLE `t5` (
172 `c1` double DEFAULT NULL,
173 `c2` char(5) DEFAULT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
178 CREATE TABLE t5(c1 DOUBLE NULL);
182 SHOW CREATE TABLE t5;
184 t5 CREATE TABLE `t5` (
185 `c1` double DEFAULT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
187 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
191 SHOW CREATE TABLE t5;
193 t5 CREATE TABLE `t5` (
194 `c1` double DEFAULT NULL,
195 `c2` char(5) DEFAULT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
200 CREATE TABLE t5(c1 FLOAT NULL);
204 SHOW CREATE TABLE t5;
206 t5 CREATE TABLE `t5` (
207 `c1` float DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
209 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
213 SHOW CREATE TABLE t5;
215 t5 CREATE TABLE `t5` (
216 `c1` float DEFAULT NULL,
217 `c2` char(5) DEFAULT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
222 CREATE TABLE t5(c1 DECIMAL NULL);
226 SHOW CREATE TABLE t5;
228 t5 CREATE TABLE `t5` (
229 `c1` decimal(10,0) DEFAULT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
231 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
235 SHOW CREATE TABLE t5;
237 t5 CREATE TABLE `t5` (
238 `c1` decimal(10,0) DEFAULT NULL,
239 `c2` char(5) DEFAULT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
244 CREATE TABLE t5(c1 NUMERIC NULL);
248 SHOW CREATE TABLE t5;
250 t5 CREATE TABLE `t5` (
251 `c1` decimal(10,0) DEFAULT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
253 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
257 SHOW CREATE TABLE t5;
259 t5 CREATE TABLE `t5` (
260 `c1` decimal(10,0) DEFAULT NULL,
261 `c2` char(5) DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
266 CREATE TABLE t5(c1 DATE NULL);
270 SHOW CREATE TABLE t5;
272 t5 CREATE TABLE `t5` (
273 `c1` date DEFAULT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
275 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
279 SHOW CREATE TABLE t5;
281 t5 CREATE TABLE `t5` (
282 `c1` date DEFAULT NULL,
283 `c2` char(5) DEFAULT NULL
284 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
288 CREATE TABLE t5(c1 TIME NULL);
292 SHOW CREATE TABLE t5;
294 t5 CREATE TABLE `t5` (
295 `c1` time DEFAULT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
297 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
301 SHOW CREATE TABLE t5;
303 t5 CREATE TABLE `t5` (
304 `c1` time DEFAULT NULL,
305 `c2` char(5) DEFAULT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
310 CREATE TABLE t5(c1 TIMESTAMP NULL);
314 SHOW CREATE TABLE t5;
316 t5 CREATE TABLE `t5` (
317 `c1` timestamp NULL DEFAULT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
319 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
323 SHOW CREATE TABLE t5;
325 t5 CREATE TABLE `t5` (
326 `c1` timestamp NULL DEFAULT NULL,
327 `c2` char(5) DEFAULT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
332 CREATE TABLE t5(c1 YEAR NULL);
336 SHOW CREATE TABLE t5;
338 t5 CREATE TABLE `t5` (
339 `c1` year(4) DEFAULT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
341 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
345 SHOW CREATE TABLE t5;
347 t5 CREATE TABLE `t5` (
348 `c1` year(4) DEFAULT NULL,
349 `c2` char(5) DEFAULT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
354 CREATE TABLE t5(c1 TINYBLOB NULL);
358 SHOW CREATE TABLE t5;
360 t5 CREATE TABLE `t5` (
362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
363 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
367 SHOW CREATE TABLE t5;
369 t5 CREATE TABLE `t5` (
371 `c2` char(5) DEFAULT NULL
372 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
376 CREATE TABLE t5(c1 BLOB NULL);
380 SHOW CREATE TABLE t5;
382 t5 CREATE TABLE `t5` (
384 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
385 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
389 SHOW CREATE TABLE t5;
391 t5 CREATE TABLE `t5` (
393 `c2` char(5) DEFAULT NULL
394 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
398 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
402 SHOW CREATE TABLE t5;
404 t5 CREATE TABLE `t5` (
406 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
407 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
411 SHOW CREATE TABLE t5;
413 t5 CREATE TABLE `t5` (
415 `c2` char(5) DEFAULT NULL
416 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
420 CREATE TABLE t5(c1 LONGBLOB NULL);
424 SHOW CREATE TABLE t5;
426 t5 CREATE TABLE `t5` (
428 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
429 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
433 SHOW CREATE TABLE t5;
435 t5 CREATE TABLE `t5` (
437 `c2` char(5) DEFAULT NULL
438 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
442 CREATE TABLE t5(c1 TINYTEXT NULL);
446 SHOW CREATE TABLE t5;
448 t5 CREATE TABLE `t5` (
450 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
451 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
455 SHOW CREATE TABLE t5;
457 t5 CREATE TABLE `t5` (
459 `c2` char(5) DEFAULT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
464 CREATE TABLE t5(c1 TEXT NULL);
468 SHOW CREATE TABLE t5;
470 t5 CREATE TABLE `t5` (
472 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
473 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
477 SHOW CREATE TABLE t5;
479 t5 CREATE TABLE `t5` (
481 `c2` char(5) DEFAULT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
486 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
490 SHOW CREATE TABLE t5;
492 t5 CREATE TABLE `t5` (
494 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
495 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
499 SHOW CREATE TABLE t5;
501 t5 CREATE TABLE `t5` (
503 `c2` char(5) DEFAULT NULL
504 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
508 CREATE TABLE t5(c1 LONGTEXT NULL);
512 SHOW CREATE TABLE t5;
514 t5 CREATE TABLE `t5` (
516 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
517 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
521 SHOW CREATE TABLE t5;
523 t5 CREATE TABLE `t5` (
525 `c2` char(5) DEFAULT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
530 CREATE TABLE t5(c1 BIT NOT NULL);
534 SHOW CREATE TABLE t5;
536 t5 CREATE TABLE `t5` (
538 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
539 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
543 SHOW CREATE TABLE t5;
545 t5 CREATE TABLE `t5` (
546 `c1` bit(1) NOT NULL,
547 `c2` char(5) NOT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
552 CREATE TABLE t5(c1 TINYINT NOT NULL);
556 SHOW CREATE TABLE t5;
558 t5 CREATE TABLE `t5` (
559 `c1` tinyint(4) NOT NULL
560 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
561 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
565 SHOW CREATE TABLE t5;
567 t5 CREATE TABLE `t5` (
568 `c1` tinyint(4) NOT NULL,
569 `c2` char(5) NOT NULL
570 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
574 CREATE TABLE t5(c1 SMALLINT NOT NULL);
578 SHOW CREATE TABLE t5;
580 t5 CREATE TABLE `t5` (
581 `c1` smallint(6) NOT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
583 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
587 SHOW CREATE TABLE t5;
589 t5 CREATE TABLE `t5` (
590 `c1` smallint(6) NOT NULL,
591 `c2` char(5) NOT NULL
592 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
596 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
600 SHOW CREATE TABLE t5;
602 t5 CREATE TABLE `t5` (
603 `c1` mediumint(9) NOT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
605 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
609 SHOW CREATE TABLE t5;
611 t5 CREATE TABLE `t5` (
612 `c1` mediumint(9) NOT NULL,
613 `c2` char(5) NOT NULL
614 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
618 CREATE TABLE t5(c1 INT NOT NULL);
622 SHOW CREATE TABLE t5;
624 t5 CREATE TABLE `t5` (
625 `c1` int(11) NOT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
627 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
631 SHOW CREATE TABLE t5;
633 t5 CREATE TABLE `t5` (
634 `c1` int(11) NOT NULL,
635 `c2` char(5) NOT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
640 CREATE TABLE t5(c1 INTEGER NOT NULL);
644 SHOW CREATE TABLE t5;
646 t5 CREATE TABLE `t5` (
647 `c1` int(11) NOT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
649 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
653 SHOW CREATE TABLE t5;
655 t5 CREATE TABLE `t5` (
656 `c1` int(11) NOT NULL,
657 `c2` char(5) NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
662 CREATE TABLE t5(c1 BIGINT NOT NULL);
666 SHOW CREATE TABLE t5;
668 t5 CREATE TABLE `t5` (
669 `c1` bigint(20) NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
671 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
675 SHOW CREATE TABLE t5;
677 t5 CREATE TABLE `t5` (
678 `c1` bigint(20) NOT NULL,
679 `c2` char(5) NOT NULL
680 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
684 CREATE TABLE t5(c1 REAL NOT NULL);
688 SHOW CREATE TABLE t5;
690 t5 CREATE TABLE `t5` (
692 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
693 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
697 SHOW CREATE TABLE t5;
699 t5 CREATE TABLE `t5` (
700 `c1` double NOT NULL,
701 `c2` char(5) NOT NULL
702 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
706 CREATE TABLE t5(c1 DOUBLE NOT NULL);
710 SHOW CREATE TABLE t5;
712 t5 CREATE TABLE `t5` (
714 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
715 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
719 SHOW CREATE TABLE t5;
721 t5 CREATE TABLE `t5` (
722 `c1` double NOT NULL,
723 `c2` char(5) NOT NULL
724 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
728 CREATE TABLE t5(c1 FLOAT NOT NULL);
732 SHOW CREATE TABLE t5;
734 t5 CREATE TABLE `t5` (
736 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
737 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
741 SHOW CREATE TABLE t5;
743 t5 CREATE TABLE `t5` (
745 `c2` char(5) NOT NULL
746 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
750 CREATE TABLE t5(c1 DECIMAL NOT NULL);
754 SHOW CREATE TABLE t5;
756 t5 CREATE TABLE `t5` (
757 `c1` decimal(10,0) NOT NULL
758 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
759 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
763 SHOW CREATE TABLE t5;
765 t5 CREATE TABLE `t5` (
766 `c1` decimal(10,0) NOT NULL,
767 `c2` char(5) NOT NULL
768 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
772 CREATE TABLE t5(c1 NUMERIC NOT NULL);
776 SHOW CREATE TABLE t5;
778 t5 CREATE TABLE `t5` (
779 `c1` decimal(10,0) NOT NULL
780 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
781 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
785 SHOW CREATE TABLE t5;
787 t5 CREATE TABLE `t5` (
788 `c1` decimal(10,0) NOT NULL,
789 `c2` char(5) NOT NULL
790 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
794 CREATE TABLE t5(c1 DATE NOT NULL);
798 SHOW CREATE TABLE t5;
800 t5 CREATE TABLE `t5` (
802 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
803 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
807 SHOW CREATE TABLE t5;
809 t5 CREATE TABLE `t5` (
811 `c2` char(5) NOT NULL
812 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
816 CREATE TABLE t5(c1 TIME NOT NULL);
820 SHOW CREATE TABLE t5;
822 t5 CREATE TABLE `t5` (
824 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
825 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
829 SHOW CREATE TABLE t5;
831 t5 CREATE TABLE `t5` (
833 `c2` char(5) NOT NULL
834 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
838 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
842 SHOW CREATE TABLE t5;
844 t5 CREATE TABLE `t5` (
845 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
846 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
847 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
851 SHOW CREATE TABLE t5;
853 t5 CREATE TABLE `t5` (
854 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
855 `c2` char(5) NOT NULL
856 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
860 CREATE TABLE t5(c1 YEAR NOT NULL);
864 SHOW CREATE TABLE t5;
866 t5 CREATE TABLE `t5` (
867 `c1` year(4) NOT NULL
868 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
869 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
873 SHOW CREATE TABLE t5;
875 t5 CREATE TABLE `t5` (
876 `c1` year(4) NOT NULL,
877 `c2` char(5) NOT NULL
878 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
882 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
886 SHOW CREATE TABLE t5;
888 t5 CREATE TABLE `t5` (
889 `c1` tinyblob NOT NULL
890 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
891 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
895 SHOW CREATE TABLE t5;
897 t5 CREATE TABLE `t5` (
898 `c1` tinyblob NOT NULL,
899 `c2` char(5) NOT NULL
900 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
904 CREATE TABLE t5(c1 BLOB NOT NULL);
908 SHOW CREATE TABLE t5;
910 t5 CREATE TABLE `t5` (
912 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
913 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
917 SHOW CREATE TABLE t5;
919 t5 CREATE TABLE `t5` (
921 `c2` char(5) NOT NULL
922 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
926 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
930 SHOW CREATE TABLE t5;
932 t5 CREATE TABLE `t5` (
933 `c1` mediumblob NOT NULL
934 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
935 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
939 SHOW CREATE TABLE t5;
941 t5 CREATE TABLE `t5` (
942 `c1` mediumblob NOT NULL,
943 `c2` char(5) NOT NULL
944 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
948 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
952 SHOW CREATE TABLE t5;
954 t5 CREATE TABLE `t5` (
955 `c1` longblob NOT NULL
956 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
957 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
961 SHOW CREATE TABLE t5;
963 t5 CREATE TABLE `t5` (
964 `c1` longblob NOT NULL,
965 `c2` char(5) NOT NULL
966 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
970 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
974 SHOW CREATE TABLE t5;
976 t5 CREATE TABLE `t5` (
977 `c1` tinytext NOT NULL
978 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
979 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
983 SHOW CREATE TABLE t5;
985 t5 CREATE TABLE `t5` (
986 `c1` tinytext NOT NULL,
987 `c2` char(5) NOT NULL
988 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
992 CREATE TABLE t5(c1 TEXT NOT NULL);
996 SHOW CREATE TABLE t5;
998 t5 CREATE TABLE `t5` (
1000 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1001 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
1005 SHOW CREATE TABLE t5;
1007 t5 CREATE TABLE `t5` (
1009 `c2` char(5) NOT NULL
1010 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1014 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
1018 SHOW CREATE TABLE t5;
1020 t5 CREATE TABLE `t5` (
1021 `c1` mediumtext NOT NULL
1022 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1023 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
1027 SHOW CREATE TABLE t5;
1029 t5 CREATE TABLE `t5` (
1030 `c1` mediumtext NOT NULL,
1031 `c2` char(5) NOT NULL
1032 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1036 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
1040 SHOW CREATE TABLE t5;
1042 t5 CREATE TABLE `t5` (
1043 `c1` longtext NOT NULL
1044 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1045 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
1049 SHOW CREATE TABLE t5;
1051 t5 CREATE TABLE `t5` (
1052 `c1` longtext NOT NULL,
1053 `c2` char(5) NOT NULL
1054 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1058 CREATE TABLE t5(c1 BIT NULL);
1062 SHOW CREATE TABLE t5;
1064 t5 CREATE TABLE `t5` (
1065 `c1` bit(1) DEFAULT NULL
1066 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1067 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1071 SHOW CREATE TABLE t5;
1073 t5 CREATE TABLE `t5` (
1074 `c1` bit(1) DEFAULT NULL,
1075 `c2` varchar(5) DEFAULT NULL
1076 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1080 CREATE TABLE t5(c1 TINYINT NULL);
1084 SHOW CREATE TABLE t5;
1086 t5 CREATE TABLE `t5` (
1087 `c1` tinyint(4) DEFAULT NULL
1088 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1089 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1093 SHOW CREATE TABLE t5;
1095 t5 CREATE TABLE `t5` (
1096 `c1` tinyint(4) DEFAULT NULL,
1097 `c2` varchar(5) DEFAULT NULL
1098 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1102 CREATE TABLE t5(c1 SMALLINT NULL);
1106 SHOW CREATE TABLE t5;
1108 t5 CREATE TABLE `t5` (
1109 `c1` smallint(6) DEFAULT NULL
1110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1111 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1115 SHOW CREATE TABLE t5;
1117 t5 CREATE TABLE `t5` (
1118 `c1` smallint(6) DEFAULT NULL,
1119 `c2` varchar(5) DEFAULT NULL
1120 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1124 CREATE TABLE t5(c1 MEDIUMINT NULL);
1128 SHOW CREATE TABLE t5;
1130 t5 CREATE TABLE `t5` (
1131 `c1` mediumint(9) DEFAULT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1133 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1137 SHOW CREATE TABLE t5;
1139 t5 CREATE TABLE `t5` (
1140 `c1` mediumint(9) DEFAULT NULL,
1141 `c2` varchar(5) DEFAULT NULL
1142 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1146 CREATE TABLE t5(c1 INT NULL);
1150 SHOW CREATE TABLE t5;
1152 t5 CREATE TABLE `t5` (
1153 `c1` int(11) DEFAULT NULL
1154 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1155 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1159 SHOW CREATE TABLE t5;
1161 t5 CREATE TABLE `t5` (
1162 `c1` int(11) DEFAULT NULL,
1163 `c2` varchar(5) DEFAULT NULL
1164 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1168 CREATE TABLE t5(c1 INTEGER NULL);
1172 SHOW CREATE TABLE t5;
1174 t5 CREATE TABLE `t5` (
1175 `c1` int(11) DEFAULT NULL
1176 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1177 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1181 SHOW CREATE TABLE t5;
1183 t5 CREATE TABLE `t5` (
1184 `c1` int(11) DEFAULT NULL,
1185 `c2` varchar(5) DEFAULT NULL
1186 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1190 CREATE TABLE t5(c1 BIGINT NULL);
1194 SHOW CREATE TABLE t5;
1196 t5 CREATE TABLE `t5` (
1197 `c1` bigint(20) DEFAULT NULL
1198 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1199 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1203 SHOW CREATE TABLE t5;
1205 t5 CREATE TABLE `t5` (
1206 `c1` bigint(20) DEFAULT NULL,
1207 `c2` varchar(5) DEFAULT NULL
1208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1212 CREATE TABLE t5(c1 REAL NULL);
1216 SHOW CREATE TABLE t5;
1218 t5 CREATE TABLE `t5` (
1219 `c1` double DEFAULT NULL
1220 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1221 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1225 SHOW CREATE TABLE t5;
1227 t5 CREATE TABLE `t5` (
1228 `c1` double DEFAULT NULL,
1229 `c2` varchar(5) DEFAULT NULL
1230 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1234 CREATE TABLE t5(c1 DOUBLE NULL);
1238 SHOW CREATE TABLE t5;
1240 t5 CREATE TABLE `t5` (
1241 `c1` double DEFAULT NULL
1242 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1243 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1247 SHOW CREATE TABLE t5;
1249 t5 CREATE TABLE `t5` (
1250 `c1` double DEFAULT NULL,
1251 `c2` varchar(5) DEFAULT NULL
1252 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1256 CREATE TABLE t5(c1 FLOAT NULL);
1260 SHOW CREATE TABLE t5;
1262 t5 CREATE TABLE `t5` (
1263 `c1` float DEFAULT NULL
1264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1265 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1269 SHOW CREATE TABLE t5;
1271 t5 CREATE TABLE `t5` (
1272 `c1` float DEFAULT NULL,
1273 `c2` varchar(5) DEFAULT NULL
1274 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1278 CREATE TABLE t5(c1 DECIMAL NULL);
1282 SHOW CREATE TABLE t5;
1284 t5 CREATE TABLE `t5` (
1285 `c1` decimal(10,0) DEFAULT NULL
1286 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1287 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1291 SHOW CREATE TABLE t5;
1293 t5 CREATE TABLE `t5` (
1294 `c1` decimal(10,0) DEFAULT NULL,
1295 `c2` varchar(5) DEFAULT NULL
1296 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1300 CREATE TABLE t5(c1 NUMERIC NULL);
1304 SHOW CREATE TABLE t5;
1306 t5 CREATE TABLE `t5` (
1307 `c1` decimal(10,0) DEFAULT NULL
1308 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1309 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1313 SHOW CREATE TABLE t5;
1315 t5 CREATE TABLE `t5` (
1316 `c1` decimal(10,0) DEFAULT NULL,
1317 `c2` varchar(5) DEFAULT NULL
1318 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1322 CREATE TABLE t5(c1 DATE NULL);
1326 SHOW CREATE TABLE t5;
1328 t5 CREATE TABLE `t5` (
1329 `c1` date DEFAULT NULL
1330 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1331 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1335 SHOW CREATE TABLE t5;
1337 t5 CREATE TABLE `t5` (
1338 `c1` date DEFAULT NULL,
1339 `c2` varchar(5) DEFAULT NULL
1340 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1344 CREATE TABLE t5(c1 TIME NULL);
1348 SHOW CREATE TABLE t5;
1350 t5 CREATE TABLE `t5` (
1351 `c1` time DEFAULT NULL
1352 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1353 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1357 SHOW CREATE TABLE t5;
1359 t5 CREATE TABLE `t5` (
1360 `c1` time DEFAULT NULL,
1361 `c2` varchar(5) DEFAULT NULL
1362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1366 CREATE TABLE t5(c1 TIMESTAMP NULL);
1370 SHOW CREATE TABLE t5;
1372 t5 CREATE TABLE `t5` (
1373 `c1` timestamp NULL DEFAULT NULL
1374 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1375 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1379 SHOW CREATE TABLE t5;
1381 t5 CREATE TABLE `t5` (
1382 `c1` timestamp NULL DEFAULT NULL,
1383 `c2` varchar(5) DEFAULT NULL
1384 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1388 CREATE TABLE t5(c1 YEAR NULL);
1392 SHOW CREATE TABLE t5;
1394 t5 CREATE TABLE `t5` (
1395 `c1` year(4) DEFAULT NULL
1396 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1397 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1401 SHOW CREATE TABLE t5;
1403 t5 CREATE TABLE `t5` (
1404 `c1` year(4) DEFAULT NULL,
1405 `c2` varchar(5) DEFAULT NULL
1406 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1410 CREATE TABLE t5(c1 TINYBLOB NULL);
1414 SHOW CREATE TABLE t5;
1416 t5 CREATE TABLE `t5` (
1418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1419 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1423 SHOW CREATE TABLE t5;
1425 t5 CREATE TABLE `t5` (
1427 `c2` varchar(5) DEFAULT NULL
1428 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1432 CREATE TABLE t5(c1 BLOB NULL);
1436 SHOW CREATE TABLE t5;
1438 t5 CREATE TABLE `t5` (
1440 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1441 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1445 SHOW CREATE TABLE t5;
1447 t5 CREATE TABLE `t5` (
1449 `c2` varchar(5) DEFAULT NULL
1450 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1454 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
1458 SHOW CREATE TABLE t5;
1460 t5 CREATE TABLE `t5` (
1462 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1463 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1467 SHOW CREATE TABLE t5;
1469 t5 CREATE TABLE `t5` (
1471 `c2` varchar(5) DEFAULT NULL
1472 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1476 CREATE TABLE t5(c1 LONGBLOB NULL);
1480 SHOW CREATE TABLE t5;
1482 t5 CREATE TABLE `t5` (
1484 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1485 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1489 SHOW CREATE TABLE t5;
1491 t5 CREATE TABLE `t5` (
1493 `c2` varchar(5) DEFAULT NULL
1494 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1498 CREATE TABLE t5(c1 TINYTEXT NULL);
1502 SHOW CREATE TABLE t5;
1504 t5 CREATE TABLE `t5` (
1506 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1507 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1511 SHOW CREATE TABLE t5;
1513 t5 CREATE TABLE `t5` (
1515 `c2` varchar(5) DEFAULT NULL
1516 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1520 CREATE TABLE t5(c1 TEXT NULL);
1524 SHOW CREATE TABLE t5;
1526 t5 CREATE TABLE `t5` (
1528 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1529 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1533 SHOW CREATE TABLE t5;
1535 t5 CREATE TABLE `t5` (
1537 `c2` varchar(5) DEFAULT NULL
1538 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1542 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
1546 SHOW CREATE TABLE t5;
1548 t5 CREATE TABLE `t5` (
1550 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1551 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1555 SHOW CREATE TABLE t5;
1557 t5 CREATE TABLE `t5` (
1559 `c2` varchar(5) DEFAULT NULL
1560 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1564 CREATE TABLE t5(c1 LONGTEXT NULL);
1568 SHOW CREATE TABLE t5;
1570 t5 CREATE TABLE `t5` (
1572 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1573 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
1577 SHOW CREATE TABLE t5;
1579 t5 CREATE TABLE `t5` (
1581 `c2` varchar(5) DEFAULT NULL
1582 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1586 CREATE TABLE t5(c1 BIT NOT NULL);
1590 SHOW CREATE TABLE t5;
1592 t5 CREATE TABLE `t5` (
1593 `c1` bit(1) NOT NULL
1594 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1595 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1599 SHOW CREATE TABLE t5;
1601 t5 CREATE TABLE `t5` (
1602 `c1` bit(1) NOT NULL,
1603 `c2` varchar(5) NOT NULL
1604 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1608 CREATE TABLE t5(c1 TINYINT NOT NULL);
1612 SHOW CREATE TABLE t5;
1614 t5 CREATE TABLE `t5` (
1615 `c1` tinyint(4) NOT NULL
1616 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1617 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1621 SHOW CREATE TABLE t5;
1623 t5 CREATE TABLE `t5` (
1624 `c1` tinyint(4) NOT NULL,
1625 `c2` varchar(5) NOT NULL
1626 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1630 CREATE TABLE t5(c1 SMALLINT NOT NULL);
1634 SHOW CREATE TABLE t5;
1636 t5 CREATE TABLE `t5` (
1637 `c1` smallint(6) NOT NULL
1638 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1639 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1643 SHOW CREATE TABLE t5;
1645 t5 CREATE TABLE `t5` (
1646 `c1` smallint(6) NOT NULL,
1647 `c2` varchar(5) NOT NULL
1648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1652 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
1656 SHOW CREATE TABLE t5;
1658 t5 CREATE TABLE `t5` (
1659 `c1` mediumint(9) NOT NULL
1660 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1661 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1665 SHOW CREATE TABLE t5;
1667 t5 CREATE TABLE `t5` (
1668 `c1` mediumint(9) NOT NULL,
1669 `c2` varchar(5) NOT NULL
1670 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1674 CREATE TABLE t5(c1 INT NOT NULL);
1678 SHOW CREATE TABLE t5;
1680 t5 CREATE TABLE `t5` (
1681 `c1` int(11) NOT NULL
1682 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1683 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1687 SHOW CREATE TABLE t5;
1689 t5 CREATE TABLE `t5` (
1690 `c1` int(11) NOT NULL,
1691 `c2` varchar(5) NOT NULL
1692 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1696 CREATE TABLE t5(c1 INTEGER NOT NULL);
1700 SHOW CREATE TABLE t5;
1702 t5 CREATE TABLE `t5` (
1703 `c1` int(11) NOT NULL
1704 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1705 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1709 SHOW CREATE TABLE t5;
1711 t5 CREATE TABLE `t5` (
1712 `c1` int(11) NOT NULL,
1713 `c2` varchar(5) NOT NULL
1714 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1718 CREATE TABLE t5(c1 BIGINT NOT NULL);
1722 SHOW CREATE TABLE t5;
1724 t5 CREATE TABLE `t5` (
1725 `c1` bigint(20) NOT NULL
1726 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1727 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1731 SHOW CREATE TABLE t5;
1733 t5 CREATE TABLE `t5` (
1734 `c1` bigint(20) NOT NULL,
1735 `c2` varchar(5) NOT NULL
1736 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1740 CREATE TABLE t5(c1 REAL NOT NULL);
1744 SHOW CREATE TABLE t5;
1746 t5 CREATE TABLE `t5` (
1747 `c1` double NOT NULL
1748 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1749 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1753 SHOW CREATE TABLE t5;
1755 t5 CREATE TABLE `t5` (
1756 `c1` double NOT NULL,
1757 `c2` varchar(5) NOT NULL
1758 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1762 CREATE TABLE t5(c1 DOUBLE NOT NULL);
1766 SHOW CREATE TABLE t5;
1768 t5 CREATE TABLE `t5` (
1769 `c1` double NOT NULL
1770 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1771 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1775 SHOW CREATE TABLE t5;
1777 t5 CREATE TABLE `t5` (
1778 `c1` double NOT NULL,
1779 `c2` varchar(5) NOT NULL
1780 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1784 CREATE TABLE t5(c1 FLOAT NOT NULL);
1788 SHOW CREATE TABLE t5;
1790 t5 CREATE TABLE `t5` (
1792 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1793 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1797 SHOW CREATE TABLE t5;
1799 t5 CREATE TABLE `t5` (
1800 `c1` float NOT NULL,
1801 `c2` varchar(5) NOT NULL
1802 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1806 CREATE TABLE t5(c1 DECIMAL NOT NULL);
1810 SHOW CREATE TABLE t5;
1812 t5 CREATE TABLE `t5` (
1813 `c1` decimal(10,0) NOT NULL
1814 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1815 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1819 SHOW CREATE TABLE t5;
1821 t5 CREATE TABLE `t5` (
1822 `c1` decimal(10,0) NOT NULL,
1823 `c2` varchar(5) NOT NULL
1824 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1828 CREATE TABLE t5(c1 NUMERIC NOT NULL);
1832 SHOW CREATE TABLE t5;
1834 t5 CREATE TABLE `t5` (
1835 `c1` decimal(10,0) NOT NULL
1836 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1837 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1841 SHOW CREATE TABLE t5;
1843 t5 CREATE TABLE `t5` (
1844 `c1` decimal(10,0) NOT NULL,
1845 `c2` varchar(5) NOT NULL
1846 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1850 CREATE TABLE t5(c1 DATE NOT NULL);
1854 SHOW CREATE TABLE t5;
1856 t5 CREATE TABLE `t5` (
1858 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1859 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1863 SHOW CREATE TABLE t5;
1865 t5 CREATE TABLE `t5` (
1867 `c2` varchar(5) NOT NULL
1868 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1872 CREATE TABLE t5(c1 TIME NOT NULL);
1876 SHOW CREATE TABLE t5;
1878 t5 CREATE TABLE `t5` (
1880 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1881 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1885 SHOW CREATE TABLE t5;
1887 t5 CREATE TABLE `t5` (
1889 `c2` varchar(5) NOT NULL
1890 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1894 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
1898 SHOW CREATE TABLE t5;
1900 t5 CREATE TABLE `t5` (
1901 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
1902 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1903 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1907 SHOW CREATE TABLE t5;
1909 t5 CREATE TABLE `t5` (
1910 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1911 `c2` varchar(5) NOT NULL
1912 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1916 CREATE TABLE t5(c1 YEAR NOT NULL);
1920 SHOW CREATE TABLE t5;
1922 t5 CREATE TABLE `t5` (
1923 `c1` year(4) NOT NULL
1924 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1925 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1929 SHOW CREATE TABLE t5;
1931 t5 CREATE TABLE `t5` (
1932 `c1` year(4) NOT NULL,
1933 `c2` varchar(5) NOT NULL
1934 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1938 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
1942 SHOW CREATE TABLE t5;
1944 t5 CREATE TABLE `t5` (
1945 `c1` tinyblob NOT NULL
1946 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1947 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1951 SHOW CREATE TABLE t5;
1953 t5 CREATE TABLE `t5` (
1954 `c1` tinyblob NOT NULL,
1955 `c2` varchar(5) NOT NULL
1956 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1960 CREATE TABLE t5(c1 BLOB NOT NULL);
1964 SHOW CREATE TABLE t5;
1966 t5 CREATE TABLE `t5` (
1968 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1969 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1973 SHOW CREATE TABLE t5;
1975 t5 CREATE TABLE `t5` (
1977 `c2` varchar(5) NOT NULL
1978 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1982 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
1986 SHOW CREATE TABLE t5;
1988 t5 CREATE TABLE `t5` (
1989 `c1` mediumblob NOT NULL
1990 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1991 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
1995 SHOW CREATE TABLE t5;
1997 t5 CREATE TABLE `t5` (
1998 `c1` mediumblob NOT NULL,
1999 `c2` varchar(5) NOT NULL
2000 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2004 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
2008 SHOW CREATE TABLE t5;
2010 t5 CREATE TABLE `t5` (
2011 `c1` longblob NOT NULL
2012 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2013 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
2017 SHOW CREATE TABLE t5;
2019 t5 CREATE TABLE `t5` (
2020 `c1` longblob NOT NULL,
2021 `c2` varchar(5) NOT NULL
2022 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2026 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
2030 SHOW CREATE TABLE t5;
2032 t5 CREATE TABLE `t5` (
2033 `c1` tinytext NOT NULL
2034 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2035 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
2039 SHOW CREATE TABLE t5;
2041 t5 CREATE TABLE `t5` (
2042 `c1` tinytext NOT NULL,
2043 `c2` varchar(5) NOT NULL
2044 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2048 CREATE TABLE t5(c1 TEXT NOT NULL);
2052 SHOW CREATE TABLE t5;
2054 t5 CREATE TABLE `t5` (
2056 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2057 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
2061 SHOW CREATE TABLE t5;
2063 t5 CREATE TABLE `t5` (
2065 `c2` varchar(5) NOT NULL
2066 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2070 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
2074 SHOW CREATE TABLE t5;
2076 t5 CREATE TABLE `t5` (
2077 `c1` mediumtext NOT NULL
2078 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2079 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
2083 SHOW CREATE TABLE t5;
2085 t5 CREATE TABLE `t5` (
2086 `c1` mediumtext NOT NULL,
2087 `c2` varchar(5) NOT NULL
2088 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2092 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
2096 SHOW CREATE TABLE t5;
2098 t5 CREATE TABLE `t5` (
2099 `c1` longtext NOT NULL
2100 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2101 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
2105 SHOW CREATE TABLE t5;
2107 t5 CREATE TABLE `t5` (
2108 `c1` longtext NOT NULL,
2109 `c2` varchar(5) NOT NULL
2110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2114 CREATE TABLE t5(c1 BIT NULL);
2118 SHOW CREATE TABLE t5;
2120 t5 CREATE TABLE `t5` (
2121 `c1` bit(1) DEFAULT NULL
2122 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2123 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2127 SHOW CREATE TABLE t5;
2129 t5 CREATE TABLE `t5` (
2130 `c1` bit(1) DEFAULT NULL,
2131 `c2` binary(5) DEFAULT NULL
2132 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2136 CREATE TABLE t5(c1 TINYINT NULL);
2140 SHOW CREATE TABLE t5;
2142 t5 CREATE TABLE `t5` (
2143 `c1` tinyint(4) DEFAULT NULL
2144 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2145 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2149 SHOW CREATE TABLE t5;
2151 t5 CREATE TABLE `t5` (
2152 `c1` tinyint(4) DEFAULT NULL,
2153 `c2` binary(5) DEFAULT NULL
2154 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2158 CREATE TABLE t5(c1 SMALLINT NULL);
2162 SHOW CREATE TABLE t5;
2164 t5 CREATE TABLE `t5` (
2165 `c1` smallint(6) DEFAULT NULL
2166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2167 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2171 SHOW CREATE TABLE t5;
2173 t5 CREATE TABLE `t5` (
2174 `c1` smallint(6) DEFAULT NULL,
2175 `c2` binary(5) DEFAULT NULL
2176 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2180 CREATE TABLE t5(c1 MEDIUMINT NULL);
2184 SHOW CREATE TABLE t5;
2186 t5 CREATE TABLE `t5` (
2187 `c1` mediumint(9) DEFAULT NULL
2188 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2189 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2193 SHOW CREATE TABLE t5;
2195 t5 CREATE TABLE `t5` (
2196 `c1` mediumint(9) DEFAULT NULL,
2197 `c2` binary(5) DEFAULT NULL
2198 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2202 CREATE TABLE t5(c1 INT NULL);
2206 SHOW CREATE TABLE t5;
2208 t5 CREATE TABLE `t5` (
2209 `c1` int(11) DEFAULT NULL
2210 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2211 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2215 SHOW CREATE TABLE t5;
2217 t5 CREATE TABLE `t5` (
2218 `c1` int(11) DEFAULT NULL,
2219 `c2` binary(5) DEFAULT NULL
2220 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2224 CREATE TABLE t5(c1 INTEGER NULL);
2228 SHOW CREATE TABLE t5;
2230 t5 CREATE TABLE `t5` (
2231 `c1` int(11) DEFAULT NULL
2232 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2233 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2237 SHOW CREATE TABLE t5;
2239 t5 CREATE TABLE `t5` (
2240 `c1` int(11) DEFAULT NULL,
2241 `c2` binary(5) DEFAULT NULL
2242 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2246 CREATE TABLE t5(c1 BIGINT NULL);
2250 SHOW CREATE TABLE t5;
2252 t5 CREATE TABLE `t5` (
2253 `c1` bigint(20) DEFAULT NULL
2254 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2255 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2259 SHOW CREATE TABLE t5;
2261 t5 CREATE TABLE `t5` (
2262 `c1` bigint(20) DEFAULT NULL,
2263 `c2` binary(5) DEFAULT NULL
2264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2268 CREATE TABLE t5(c1 REAL NULL);
2272 SHOW CREATE TABLE t5;
2274 t5 CREATE TABLE `t5` (
2275 `c1` double DEFAULT NULL
2276 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2277 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2281 SHOW CREATE TABLE t5;
2283 t5 CREATE TABLE `t5` (
2284 `c1` double DEFAULT NULL,
2285 `c2` binary(5) DEFAULT NULL
2286 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2290 CREATE TABLE t5(c1 DOUBLE NULL);
2294 SHOW CREATE TABLE t5;
2296 t5 CREATE TABLE `t5` (
2297 `c1` double DEFAULT NULL
2298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2299 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2303 SHOW CREATE TABLE t5;
2305 t5 CREATE TABLE `t5` (
2306 `c1` double DEFAULT NULL,
2307 `c2` binary(5) DEFAULT NULL
2308 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2312 CREATE TABLE t5(c1 FLOAT NULL);
2316 SHOW CREATE TABLE t5;
2318 t5 CREATE TABLE `t5` (
2319 `c1` float DEFAULT NULL
2320 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2321 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2325 SHOW CREATE TABLE t5;
2327 t5 CREATE TABLE `t5` (
2328 `c1` float DEFAULT NULL,
2329 `c2` binary(5) DEFAULT NULL
2330 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2334 CREATE TABLE t5(c1 DECIMAL NULL);
2338 SHOW CREATE TABLE t5;
2340 t5 CREATE TABLE `t5` (
2341 `c1` decimal(10,0) DEFAULT NULL
2342 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2343 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2347 SHOW CREATE TABLE t5;
2349 t5 CREATE TABLE `t5` (
2350 `c1` decimal(10,0) DEFAULT NULL,
2351 `c2` binary(5) DEFAULT NULL
2352 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2356 CREATE TABLE t5(c1 NUMERIC NULL);
2360 SHOW CREATE TABLE t5;
2362 t5 CREATE TABLE `t5` (
2363 `c1` decimal(10,0) DEFAULT NULL
2364 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2365 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2369 SHOW CREATE TABLE t5;
2371 t5 CREATE TABLE `t5` (
2372 `c1` decimal(10,0) DEFAULT NULL,
2373 `c2` binary(5) DEFAULT NULL
2374 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2378 CREATE TABLE t5(c1 DATE NULL);
2382 SHOW CREATE TABLE t5;
2384 t5 CREATE TABLE `t5` (
2385 `c1` date DEFAULT NULL
2386 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2387 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2391 SHOW CREATE TABLE t5;
2393 t5 CREATE TABLE `t5` (
2394 `c1` date DEFAULT NULL,
2395 `c2` binary(5) DEFAULT NULL
2396 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2400 CREATE TABLE t5(c1 TIME NULL);
2404 SHOW CREATE TABLE t5;
2406 t5 CREATE TABLE `t5` (
2407 `c1` time DEFAULT NULL
2408 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2409 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2413 SHOW CREATE TABLE t5;
2415 t5 CREATE TABLE `t5` (
2416 `c1` time DEFAULT NULL,
2417 `c2` binary(5) DEFAULT NULL
2418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2422 CREATE TABLE t5(c1 TIMESTAMP NULL);
2426 SHOW CREATE TABLE t5;
2428 t5 CREATE TABLE `t5` (
2429 `c1` timestamp NULL DEFAULT NULL
2430 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2431 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2435 SHOW CREATE TABLE t5;
2437 t5 CREATE TABLE `t5` (
2438 `c1` timestamp NULL DEFAULT NULL,
2439 `c2` binary(5) DEFAULT NULL
2440 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2444 CREATE TABLE t5(c1 YEAR NULL);
2448 SHOW CREATE TABLE t5;
2450 t5 CREATE TABLE `t5` (
2451 `c1` year(4) DEFAULT NULL
2452 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2453 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2457 SHOW CREATE TABLE t5;
2459 t5 CREATE TABLE `t5` (
2460 `c1` year(4) DEFAULT NULL,
2461 `c2` binary(5) DEFAULT NULL
2462 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2466 CREATE TABLE t5(c1 TINYBLOB NULL);
2470 SHOW CREATE TABLE t5;
2472 t5 CREATE TABLE `t5` (
2474 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2475 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2479 SHOW CREATE TABLE t5;
2481 t5 CREATE TABLE `t5` (
2483 `c2` binary(5) DEFAULT NULL
2484 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2488 CREATE TABLE t5(c1 BLOB NULL);
2492 SHOW CREATE TABLE t5;
2494 t5 CREATE TABLE `t5` (
2496 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2497 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2501 SHOW CREATE TABLE t5;
2503 t5 CREATE TABLE `t5` (
2505 `c2` binary(5) DEFAULT NULL
2506 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2510 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
2514 SHOW CREATE TABLE t5;
2516 t5 CREATE TABLE `t5` (
2518 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2519 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2523 SHOW CREATE TABLE t5;
2525 t5 CREATE TABLE `t5` (
2527 `c2` binary(5) DEFAULT NULL
2528 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2532 CREATE TABLE t5(c1 LONGBLOB NULL);
2536 SHOW CREATE TABLE t5;
2538 t5 CREATE TABLE `t5` (
2540 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2541 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2545 SHOW CREATE TABLE t5;
2547 t5 CREATE TABLE `t5` (
2549 `c2` binary(5) DEFAULT NULL
2550 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2554 CREATE TABLE t5(c1 TINYTEXT NULL);
2558 SHOW CREATE TABLE t5;
2560 t5 CREATE TABLE `t5` (
2562 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2563 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2567 SHOW CREATE TABLE t5;
2569 t5 CREATE TABLE `t5` (
2571 `c2` binary(5) DEFAULT NULL
2572 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2576 CREATE TABLE t5(c1 TEXT NULL);
2580 SHOW CREATE TABLE t5;
2582 t5 CREATE TABLE `t5` (
2584 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2585 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2589 SHOW CREATE TABLE t5;
2591 t5 CREATE TABLE `t5` (
2593 `c2` binary(5) DEFAULT NULL
2594 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2598 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
2602 SHOW CREATE TABLE t5;
2604 t5 CREATE TABLE `t5` (
2606 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2607 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2611 SHOW CREATE TABLE t5;
2613 t5 CREATE TABLE `t5` (
2615 `c2` binary(5) DEFAULT NULL
2616 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2620 CREATE TABLE t5(c1 LONGTEXT NULL);
2624 SHOW CREATE TABLE t5;
2626 t5 CREATE TABLE `t5` (
2628 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2629 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
2633 SHOW CREATE TABLE t5;
2635 t5 CREATE TABLE `t5` (
2637 `c2` binary(5) DEFAULT NULL
2638 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2642 CREATE TABLE t5(c1 BIT NOT NULL);
2646 SHOW CREATE TABLE t5;
2648 t5 CREATE TABLE `t5` (
2649 `c1` bit(1) NOT NULL
2650 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2651 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2655 SHOW CREATE TABLE t5;
2657 t5 CREATE TABLE `t5` (
2658 `c1` bit(1) NOT NULL,
2659 `c2` binary(5) NOT NULL
2660 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2664 CREATE TABLE t5(c1 TINYINT NOT NULL);
2668 SHOW CREATE TABLE t5;
2670 t5 CREATE TABLE `t5` (
2671 `c1` tinyint(4) NOT NULL
2672 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2673 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2677 SHOW CREATE TABLE t5;
2679 t5 CREATE TABLE `t5` (
2680 `c1` tinyint(4) NOT NULL,
2681 `c2` binary(5) NOT NULL
2682 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2686 CREATE TABLE t5(c1 SMALLINT NOT NULL);
2690 SHOW CREATE TABLE t5;
2692 t5 CREATE TABLE `t5` (
2693 `c1` smallint(6) NOT NULL
2694 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2695 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2699 SHOW CREATE TABLE t5;
2701 t5 CREATE TABLE `t5` (
2702 `c1` smallint(6) NOT NULL,
2703 `c2` binary(5) NOT NULL
2704 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2708 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
2712 SHOW CREATE TABLE t5;
2714 t5 CREATE TABLE `t5` (
2715 `c1` mediumint(9) NOT NULL
2716 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2717 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2721 SHOW CREATE TABLE t5;
2723 t5 CREATE TABLE `t5` (
2724 `c1` mediumint(9) NOT NULL,
2725 `c2` binary(5) NOT NULL
2726 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2730 CREATE TABLE t5(c1 INT NOT NULL);
2734 SHOW CREATE TABLE t5;
2736 t5 CREATE TABLE `t5` (
2737 `c1` int(11) NOT NULL
2738 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2739 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2743 SHOW CREATE TABLE t5;
2745 t5 CREATE TABLE `t5` (
2746 `c1` int(11) NOT NULL,
2747 `c2` binary(5) NOT NULL
2748 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2752 CREATE TABLE t5(c1 INTEGER NOT NULL);
2756 SHOW CREATE TABLE t5;
2758 t5 CREATE TABLE `t5` (
2759 `c1` int(11) NOT NULL
2760 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2761 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2765 SHOW CREATE TABLE t5;
2767 t5 CREATE TABLE `t5` (
2768 `c1` int(11) NOT NULL,
2769 `c2` binary(5) NOT NULL
2770 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2774 CREATE TABLE t5(c1 BIGINT NOT NULL);
2778 SHOW CREATE TABLE t5;
2780 t5 CREATE TABLE `t5` (
2781 `c1` bigint(20) NOT NULL
2782 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2783 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2787 SHOW CREATE TABLE t5;
2789 t5 CREATE TABLE `t5` (
2790 `c1` bigint(20) NOT NULL,
2791 `c2` binary(5) NOT NULL
2792 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2796 CREATE TABLE t5(c1 REAL NOT NULL);
2800 SHOW CREATE TABLE t5;
2802 t5 CREATE TABLE `t5` (
2803 `c1` double NOT NULL
2804 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2805 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2809 SHOW CREATE TABLE t5;
2811 t5 CREATE TABLE `t5` (
2812 `c1` double NOT NULL,
2813 `c2` binary(5) NOT NULL
2814 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2818 CREATE TABLE t5(c1 DOUBLE NOT NULL);
2822 SHOW CREATE TABLE t5;
2824 t5 CREATE TABLE `t5` (
2825 `c1` double NOT NULL
2826 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2827 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2831 SHOW CREATE TABLE t5;
2833 t5 CREATE TABLE `t5` (
2834 `c1` double NOT NULL,
2835 `c2` binary(5) NOT NULL
2836 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2840 CREATE TABLE t5(c1 FLOAT NOT NULL);
2844 SHOW CREATE TABLE t5;
2846 t5 CREATE TABLE `t5` (
2848 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2849 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2853 SHOW CREATE TABLE t5;
2855 t5 CREATE TABLE `t5` (
2856 `c1` float NOT NULL,
2857 `c2` binary(5) NOT NULL
2858 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2862 CREATE TABLE t5(c1 DECIMAL NOT NULL);
2866 SHOW CREATE TABLE t5;
2868 t5 CREATE TABLE `t5` (
2869 `c1` decimal(10,0) NOT NULL
2870 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2871 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2875 SHOW CREATE TABLE t5;
2877 t5 CREATE TABLE `t5` (
2878 `c1` decimal(10,0) NOT NULL,
2879 `c2` binary(5) NOT NULL
2880 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2884 CREATE TABLE t5(c1 NUMERIC NOT NULL);
2888 SHOW CREATE TABLE t5;
2890 t5 CREATE TABLE `t5` (
2891 `c1` decimal(10,0) NOT NULL
2892 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2893 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2897 SHOW CREATE TABLE t5;
2899 t5 CREATE TABLE `t5` (
2900 `c1` decimal(10,0) NOT NULL,
2901 `c2` binary(5) NOT NULL
2902 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2906 CREATE TABLE t5(c1 DATE NOT NULL);
2910 SHOW CREATE TABLE t5;
2912 t5 CREATE TABLE `t5` (
2914 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2915 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2919 SHOW CREATE TABLE t5;
2921 t5 CREATE TABLE `t5` (
2923 `c2` binary(5) NOT NULL
2924 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2928 CREATE TABLE t5(c1 TIME NOT NULL);
2932 SHOW CREATE TABLE t5;
2934 t5 CREATE TABLE `t5` (
2936 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2937 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2941 SHOW CREATE TABLE t5;
2943 t5 CREATE TABLE `t5` (
2945 `c2` binary(5) NOT NULL
2946 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2950 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
2954 SHOW CREATE TABLE t5;
2956 t5 CREATE TABLE `t5` (
2957 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
2958 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2959 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2963 SHOW CREATE TABLE t5;
2965 t5 CREATE TABLE `t5` (
2966 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2967 `c2` binary(5) NOT NULL
2968 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2972 CREATE TABLE t5(c1 YEAR NOT NULL);
2976 SHOW CREATE TABLE t5;
2978 t5 CREATE TABLE `t5` (
2979 `c1` year(4) NOT NULL
2980 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2981 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
2985 SHOW CREATE TABLE t5;
2987 t5 CREATE TABLE `t5` (
2988 `c1` year(4) NOT NULL,
2989 `c2` binary(5) NOT NULL
2990 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2994 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
2998 SHOW CREATE TABLE t5;
3000 t5 CREATE TABLE `t5` (
3001 `c1` tinyblob NOT NULL
3002 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3003 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3007 SHOW CREATE TABLE t5;
3009 t5 CREATE TABLE `t5` (
3010 `c1` tinyblob NOT NULL,
3011 `c2` binary(5) NOT NULL
3012 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3016 CREATE TABLE t5(c1 BLOB NOT NULL);
3020 SHOW CREATE TABLE t5;
3022 t5 CREATE TABLE `t5` (
3024 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3025 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3029 SHOW CREATE TABLE t5;
3031 t5 CREATE TABLE `t5` (
3033 `c2` binary(5) NOT NULL
3034 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3038 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
3042 SHOW CREATE TABLE t5;
3044 t5 CREATE TABLE `t5` (
3045 `c1` mediumblob NOT NULL
3046 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3047 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3051 SHOW CREATE TABLE t5;
3053 t5 CREATE TABLE `t5` (
3054 `c1` mediumblob NOT NULL,
3055 `c2` binary(5) NOT NULL
3056 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3060 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
3064 SHOW CREATE TABLE t5;
3066 t5 CREATE TABLE `t5` (
3067 `c1` longblob NOT NULL
3068 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3069 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3073 SHOW CREATE TABLE t5;
3075 t5 CREATE TABLE `t5` (
3076 `c1` longblob NOT NULL,
3077 `c2` binary(5) NOT NULL
3078 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3082 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
3086 SHOW CREATE TABLE t5;
3088 t5 CREATE TABLE `t5` (
3089 `c1` tinytext NOT NULL
3090 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3091 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3095 SHOW CREATE TABLE t5;
3097 t5 CREATE TABLE `t5` (
3098 `c1` tinytext NOT NULL,
3099 `c2` binary(5) NOT NULL
3100 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3104 CREATE TABLE t5(c1 TEXT NOT NULL);
3108 SHOW CREATE TABLE t5;
3110 t5 CREATE TABLE `t5` (
3112 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3113 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3117 SHOW CREATE TABLE t5;
3119 t5 CREATE TABLE `t5` (
3121 `c2` binary(5) NOT NULL
3122 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3126 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
3130 SHOW CREATE TABLE t5;
3132 t5 CREATE TABLE `t5` (
3133 `c1` mediumtext NOT NULL
3134 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3135 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3139 SHOW CREATE TABLE t5;
3141 t5 CREATE TABLE `t5` (
3142 `c1` mediumtext NOT NULL,
3143 `c2` binary(5) NOT NULL
3144 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3148 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
3152 SHOW CREATE TABLE t5;
3154 t5 CREATE TABLE `t5` (
3155 `c1` longtext NOT NULL
3156 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3157 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
3161 SHOW CREATE TABLE t5;
3163 t5 CREATE TABLE `t5` (
3164 `c1` longtext NOT NULL,
3165 `c2` binary(5) NOT NULL
3166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3170 CREATE TABLE t5(c1 BIT NULL);
3174 SHOW CREATE TABLE t5;
3176 t5 CREATE TABLE `t5` (
3177 `c1` bit(1) DEFAULT NULL
3178 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3179 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3183 SHOW CREATE TABLE t5;
3185 t5 CREATE TABLE `t5` (
3186 `c1` bit(1) DEFAULT NULL,
3187 `c2` varbinary(5) DEFAULT NULL
3188 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3192 CREATE TABLE t5(c1 TINYINT NULL);
3196 SHOW CREATE TABLE t5;
3198 t5 CREATE TABLE `t5` (
3199 `c1` tinyint(4) DEFAULT NULL
3200 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3201 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3205 SHOW CREATE TABLE t5;
3207 t5 CREATE TABLE `t5` (
3208 `c1` tinyint(4) DEFAULT NULL,
3209 `c2` varbinary(5) DEFAULT NULL
3210 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3214 CREATE TABLE t5(c1 SMALLINT NULL);
3218 SHOW CREATE TABLE t5;
3220 t5 CREATE TABLE `t5` (
3221 `c1` smallint(6) DEFAULT NULL
3222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3223 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3227 SHOW CREATE TABLE t5;
3229 t5 CREATE TABLE `t5` (
3230 `c1` smallint(6) DEFAULT NULL,
3231 `c2` varbinary(5) DEFAULT NULL
3232 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3236 CREATE TABLE t5(c1 MEDIUMINT NULL);
3240 SHOW CREATE TABLE t5;
3242 t5 CREATE TABLE `t5` (
3243 `c1` mediumint(9) DEFAULT NULL
3244 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3245 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3249 SHOW CREATE TABLE t5;
3251 t5 CREATE TABLE `t5` (
3252 `c1` mediumint(9) DEFAULT NULL,
3253 `c2` varbinary(5) DEFAULT NULL
3254 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3258 CREATE TABLE t5(c1 INT NULL);
3262 SHOW CREATE TABLE t5;
3264 t5 CREATE TABLE `t5` (
3265 `c1` int(11) DEFAULT NULL
3266 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3267 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3271 SHOW CREATE TABLE t5;
3273 t5 CREATE TABLE `t5` (
3274 `c1` int(11) DEFAULT NULL,
3275 `c2` varbinary(5) DEFAULT NULL
3276 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3280 CREATE TABLE t5(c1 INTEGER NULL);
3284 SHOW CREATE TABLE t5;
3286 t5 CREATE TABLE `t5` (
3287 `c1` int(11) DEFAULT NULL
3288 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3289 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3293 SHOW CREATE TABLE t5;
3295 t5 CREATE TABLE `t5` (
3296 `c1` int(11) DEFAULT NULL,
3297 `c2` varbinary(5) DEFAULT NULL
3298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3302 CREATE TABLE t5(c1 BIGINT NULL);
3306 SHOW CREATE TABLE t5;
3308 t5 CREATE TABLE `t5` (
3309 `c1` bigint(20) DEFAULT NULL
3310 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3311 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3315 SHOW CREATE TABLE t5;
3317 t5 CREATE TABLE `t5` (
3318 `c1` bigint(20) DEFAULT NULL,
3319 `c2` varbinary(5) DEFAULT NULL
3320 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3324 CREATE TABLE t5(c1 REAL NULL);
3328 SHOW CREATE TABLE t5;
3330 t5 CREATE TABLE `t5` (
3331 `c1` double DEFAULT NULL
3332 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3333 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3337 SHOW CREATE TABLE t5;
3339 t5 CREATE TABLE `t5` (
3340 `c1` double DEFAULT NULL,
3341 `c2` varbinary(5) DEFAULT NULL
3342 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3346 CREATE TABLE t5(c1 DOUBLE NULL);
3350 SHOW CREATE TABLE t5;
3352 t5 CREATE TABLE `t5` (
3353 `c1` double DEFAULT NULL
3354 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3355 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3359 SHOW CREATE TABLE t5;
3361 t5 CREATE TABLE `t5` (
3362 `c1` double DEFAULT NULL,
3363 `c2` varbinary(5) DEFAULT NULL
3364 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3368 CREATE TABLE t5(c1 FLOAT NULL);
3372 SHOW CREATE TABLE t5;
3374 t5 CREATE TABLE `t5` (
3375 `c1` float DEFAULT NULL
3376 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3377 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3381 SHOW CREATE TABLE t5;
3383 t5 CREATE TABLE `t5` (
3384 `c1` float DEFAULT NULL,
3385 `c2` varbinary(5) DEFAULT NULL
3386 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3390 CREATE TABLE t5(c1 DECIMAL NULL);
3394 SHOW CREATE TABLE t5;
3396 t5 CREATE TABLE `t5` (
3397 `c1` decimal(10,0) DEFAULT NULL
3398 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3399 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3403 SHOW CREATE TABLE t5;
3405 t5 CREATE TABLE `t5` (
3406 `c1` decimal(10,0) DEFAULT NULL,
3407 `c2` varbinary(5) DEFAULT NULL
3408 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3412 CREATE TABLE t5(c1 NUMERIC NULL);
3416 SHOW CREATE TABLE t5;
3418 t5 CREATE TABLE `t5` (
3419 `c1` decimal(10,0) DEFAULT NULL
3420 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3421 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3425 SHOW CREATE TABLE t5;
3427 t5 CREATE TABLE `t5` (
3428 `c1` decimal(10,0) DEFAULT NULL,
3429 `c2` varbinary(5) DEFAULT NULL
3430 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3434 CREATE TABLE t5(c1 DATE NULL);
3438 SHOW CREATE TABLE t5;
3440 t5 CREATE TABLE `t5` (
3441 `c1` date DEFAULT NULL
3442 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3443 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3447 SHOW CREATE TABLE t5;
3449 t5 CREATE TABLE `t5` (
3450 `c1` date DEFAULT NULL,
3451 `c2` varbinary(5) DEFAULT NULL
3452 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3456 CREATE TABLE t5(c1 TIME NULL);
3460 SHOW CREATE TABLE t5;
3462 t5 CREATE TABLE `t5` (
3463 `c1` time DEFAULT NULL
3464 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3465 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3469 SHOW CREATE TABLE t5;
3471 t5 CREATE TABLE `t5` (
3472 `c1` time DEFAULT NULL,
3473 `c2` varbinary(5) DEFAULT NULL
3474 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3478 CREATE TABLE t5(c1 TIMESTAMP NULL);
3482 SHOW CREATE TABLE t5;
3484 t5 CREATE TABLE `t5` (
3485 `c1` timestamp NULL DEFAULT NULL
3486 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3487 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3491 SHOW CREATE TABLE t5;
3493 t5 CREATE TABLE `t5` (
3494 `c1` timestamp NULL DEFAULT NULL,
3495 `c2` varbinary(5) DEFAULT NULL
3496 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3500 CREATE TABLE t5(c1 YEAR NULL);
3504 SHOW CREATE TABLE t5;
3506 t5 CREATE TABLE `t5` (
3507 `c1` year(4) DEFAULT NULL
3508 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3509 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3513 SHOW CREATE TABLE t5;
3515 t5 CREATE TABLE `t5` (
3516 `c1` year(4) DEFAULT NULL,
3517 `c2` varbinary(5) DEFAULT NULL
3518 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3522 CREATE TABLE t5(c1 TINYBLOB NULL);
3526 SHOW CREATE TABLE t5;
3528 t5 CREATE TABLE `t5` (
3530 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3531 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3535 SHOW CREATE TABLE t5;
3537 t5 CREATE TABLE `t5` (
3539 `c2` varbinary(5) DEFAULT NULL
3540 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3544 CREATE TABLE t5(c1 BLOB NULL);
3548 SHOW CREATE TABLE t5;
3550 t5 CREATE TABLE `t5` (
3552 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3553 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3557 SHOW CREATE TABLE t5;
3559 t5 CREATE TABLE `t5` (
3561 `c2` varbinary(5) DEFAULT NULL
3562 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3566 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
3570 SHOW CREATE TABLE t5;
3572 t5 CREATE TABLE `t5` (
3574 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3575 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3579 SHOW CREATE TABLE t5;
3581 t5 CREATE TABLE `t5` (
3583 `c2` varbinary(5) DEFAULT NULL
3584 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3588 CREATE TABLE t5(c1 LONGBLOB NULL);
3592 SHOW CREATE TABLE t5;
3594 t5 CREATE TABLE `t5` (
3596 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3597 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3601 SHOW CREATE TABLE t5;
3603 t5 CREATE TABLE `t5` (
3605 `c2` varbinary(5) DEFAULT NULL
3606 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3610 CREATE TABLE t5(c1 TINYTEXT NULL);
3614 SHOW CREATE TABLE t5;
3616 t5 CREATE TABLE `t5` (
3618 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3619 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3623 SHOW CREATE TABLE t5;
3625 t5 CREATE TABLE `t5` (
3627 `c2` varbinary(5) DEFAULT NULL
3628 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3632 CREATE TABLE t5(c1 TEXT NULL);
3636 SHOW CREATE TABLE t5;
3638 t5 CREATE TABLE `t5` (
3640 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3641 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3645 SHOW CREATE TABLE t5;
3647 t5 CREATE TABLE `t5` (
3649 `c2` varbinary(5) DEFAULT NULL
3650 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3654 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
3658 SHOW CREATE TABLE t5;
3660 t5 CREATE TABLE `t5` (
3662 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3663 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3667 SHOW CREATE TABLE t5;
3669 t5 CREATE TABLE `t5` (
3671 `c2` varbinary(5) DEFAULT NULL
3672 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3676 CREATE TABLE t5(c1 LONGTEXT NULL);
3680 SHOW CREATE TABLE t5;
3682 t5 CREATE TABLE `t5` (
3684 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3685 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
3689 SHOW CREATE TABLE t5;
3691 t5 CREATE TABLE `t5` (
3693 `c2` varbinary(5) DEFAULT NULL
3694 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3698 CREATE TABLE t5(c1 BIT NOT NULL);
3702 SHOW CREATE TABLE t5;
3704 t5 CREATE TABLE `t5` (
3705 `c1` bit(1) NOT NULL
3706 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3707 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3711 SHOW CREATE TABLE t5;
3713 t5 CREATE TABLE `t5` (
3714 `c1` bit(1) NOT NULL,
3715 `c2` varbinary(5) NOT NULL
3716 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3720 CREATE TABLE t5(c1 TINYINT NOT NULL);
3724 SHOW CREATE TABLE t5;
3726 t5 CREATE TABLE `t5` (
3727 `c1` tinyint(4) NOT NULL
3728 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3729 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3733 SHOW CREATE TABLE t5;
3735 t5 CREATE TABLE `t5` (
3736 `c1` tinyint(4) NOT NULL,
3737 `c2` varbinary(5) NOT NULL
3738 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3742 CREATE TABLE t5(c1 SMALLINT NOT NULL);
3746 SHOW CREATE TABLE t5;
3748 t5 CREATE TABLE `t5` (
3749 `c1` smallint(6) NOT NULL
3750 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3751 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3755 SHOW CREATE TABLE t5;
3757 t5 CREATE TABLE `t5` (
3758 `c1` smallint(6) NOT NULL,
3759 `c2` varbinary(5) NOT NULL
3760 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3764 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
3768 SHOW CREATE TABLE t5;
3770 t5 CREATE TABLE `t5` (
3771 `c1` mediumint(9) NOT NULL
3772 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3773 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3777 SHOW CREATE TABLE t5;
3779 t5 CREATE TABLE `t5` (
3780 `c1` mediumint(9) NOT NULL,
3781 `c2` varbinary(5) NOT NULL
3782 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3786 CREATE TABLE t5(c1 INT NOT NULL);
3790 SHOW CREATE TABLE t5;
3792 t5 CREATE TABLE `t5` (
3793 `c1` int(11) NOT NULL
3794 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3795 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3799 SHOW CREATE TABLE t5;
3801 t5 CREATE TABLE `t5` (
3802 `c1` int(11) NOT NULL,
3803 `c2` varbinary(5) NOT NULL
3804 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3808 CREATE TABLE t5(c1 INTEGER NOT NULL);
3812 SHOW CREATE TABLE t5;
3814 t5 CREATE TABLE `t5` (
3815 `c1` int(11) NOT NULL
3816 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3817 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3821 SHOW CREATE TABLE t5;
3823 t5 CREATE TABLE `t5` (
3824 `c1` int(11) NOT NULL,
3825 `c2` varbinary(5) NOT NULL
3826 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3830 CREATE TABLE t5(c1 BIGINT NOT NULL);
3834 SHOW CREATE TABLE t5;
3836 t5 CREATE TABLE `t5` (
3837 `c1` bigint(20) NOT NULL
3838 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3839 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3843 SHOW CREATE TABLE t5;
3845 t5 CREATE TABLE `t5` (
3846 `c1` bigint(20) NOT NULL,
3847 `c2` varbinary(5) NOT NULL
3848 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3852 CREATE TABLE t5(c1 REAL NOT NULL);
3856 SHOW CREATE TABLE t5;
3858 t5 CREATE TABLE `t5` (
3859 `c1` double NOT NULL
3860 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3861 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3865 SHOW CREATE TABLE t5;
3867 t5 CREATE TABLE `t5` (
3868 `c1` double NOT NULL,
3869 `c2` varbinary(5) NOT NULL
3870 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3874 CREATE TABLE t5(c1 DOUBLE NOT NULL);
3878 SHOW CREATE TABLE t5;
3880 t5 CREATE TABLE `t5` (
3881 `c1` double NOT NULL
3882 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3883 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3887 SHOW CREATE TABLE t5;
3889 t5 CREATE TABLE `t5` (
3890 `c1` double NOT NULL,
3891 `c2` varbinary(5) NOT NULL
3892 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3896 CREATE TABLE t5(c1 FLOAT NOT NULL);
3900 SHOW CREATE TABLE t5;
3902 t5 CREATE TABLE `t5` (
3904 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3905 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3909 SHOW CREATE TABLE t5;
3911 t5 CREATE TABLE `t5` (
3912 `c1` float NOT NULL,
3913 `c2` varbinary(5) NOT NULL
3914 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3918 CREATE TABLE t5(c1 DECIMAL NOT NULL);
3922 SHOW CREATE TABLE t5;
3924 t5 CREATE TABLE `t5` (
3925 `c1` decimal(10,0) NOT NULL
3926 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3927 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3931 SHOW CREATE TABLE t5;
3933 t5 CREATE TABLE `t5` (
3934 `c1` decimal(10,0) NOT NULL,
3935 `c2` varbinary(5) NOT NULL
3936 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3940 CREATE TABLE t5(c1 NUMERIC NOT NULL);
3944 SHOW CREATE TABLE t5;
3946 t5 CREATE TABLE `t5` (
3947 `c1` decimal(10,0) NOT NULL
3948 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3949 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3953 SHOW CREATE TABLE t5;
3955 t5 CREATE TABLE `t5` (
3956 `c1` decimal(10,0) NOT NULL,
3957 `c2` varbinary(5) NOT NULL
3958 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3962 CREATE TABLE t5(c1 DATE NOT NULL);
3966 SHOW CREATE TABLE t5;
3968 t5 CREATE TABLE `t5` (
3970 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3971 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3975 SHOW CREATE TABLE t5;
3977 t5 CREATE TABLE `t5` (
3979 `c2` varbinary(5) NOT NULL
3980 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3984 CREATE TABLE t5(c1 TIME NOT NULL);
3988 SHOW CREATE TABLE t5;
3990 t5 CREATE TABLE `t5` (
3992 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3993 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
3997 SHOW CREATE TABLE t5;
3999 t5 CREATE TABLE `t5` (
4001 `c2` varbinary(5) NOT NULL
4002 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4006 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
4010 SHOW CREATE TABLE t5;
4012 t5 CREATE TABLE `t5` (
4013 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
4014 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4015 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4019 SHOW CREATE TABLE t5;
4021 t5 CREATE TABLE `t5` (
4022 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4023 `c2` varbinary(5) NOT NULL
4024 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4028 CREATE TABLE t5(c1 YEAR NOT NULL);
4032 SHOW CREATE TABLE t5;
4034 t5 CREATE TABLE `t5` (
4035 `c1` year(4) NOT NULL
4036 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4037 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4041 SHOW CREATE TABLE t5;
4043 t5 CREATE TABLE `t5` (
4044 `c1` year(4) NOT NULL,
4045 `c2` varbinary(5) NOT NULL
4046 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4050 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
4054 SHOW CREATE TABLE t5;
4056 t5 CREATE TABLE `t5` (
4057 `c1` tinyblob NOT NULL
4058 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4059 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4063 SHOW CREATE TABLE t5;
4065 t5 CREATE TABLE `t5` (
4066 `c1` tinyblob NOT NULL,
4067 `c2` varbinary(5) NOT NULL
4068 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4072 CREATE TABLE t5(c1 BLOB NOT NULL);
4076 SHOW CREATE TABLE t5;
4078 t5 CREATE TABLE `t5` (
4080 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4081 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4085 SHOW CREATE TABLE t5;
4087 t5 CREATE TABLE `t5` (
4089 `c2` varbinary(5) NOT NULL
4090 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4094 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
4098 SHOW CREATE TABLE t5;
4100 t5 CREATE TABLE `t5` (
4101 `c1` mediumblob NOT NULL
4102 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4103 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4107 SHOW CREATE TABLE t5;
4109 t5 CREATE TABLE `t5` (
4110 `c1` mediumblob NOT NULL,
4111 `c2` varbinary(5) NOT NULL
4112 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4116 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
4120 SHOW CREATE TABLE t5;
4122 t5 CREATE TABLE `t5` (
4123 `c1` longblob NOT NULL
4124 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4125 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4129 SHOW CREATE TABLE t5;
4131 t5 CREATE TABLE `t5` (
4132 `c1` longblob NOT NULL,
4133 `c2` varbinary(5) NOT NULL
4134 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4138 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
4142 SHOW CREATE TABLE t5;
4144 t5 CREATE TABLE `t5` (
4145 `c1` tinytext NOT NULL
4146 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4147 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4151 SHOW CREATE TABLE t5;
4153 t5 CREATE TABLE `t5` (
4154 `c1` tinytext NOT NULL,
4155 `c2` varbinary(5) NOT NULL
4156 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4160 CREATE TABLE t5(c1 TEXT NOT NULL);
4164 SHOW CREATE TABLE t5;
4166 t5 CREATE TABLE `t5` (
4168 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4169 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4173 SHOW CREATE TABLE t5;
4175 t5 CREATE TABLE `t5` (
4177 `c2` varbinary(5) NOT NULL
4178 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4182 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
4186 SHOW CREATE TABLE t5;
4188 t5 CREATE TABLE `t5` (
4189 `c1` mediumtext NOT NULL
4190 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4191 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4195 SHOW CREATE TABLE t5;
4197 t5 CREATE TABLE `t5` (
4198 `c1` mediumtext NOT NULL,
4199 `c2` varbinary(5) NOT NULL
4200 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4204 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
4208 SHOW CREATE TABLE t5;
4210 t5 CREATE TABLE `t5` (
4211 `c1` longtext NOT NULL
4212 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4213 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
4217 SHOW CREATE TABLE t5;
4219 t5 CREATE TABLE `t5` (
4220 `c1` longtext NOT NULL,
4221 `c2` varbinary(5) NOT NULL
4222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1