diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_add_string_middle2.result')
| -rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_add_string_middle2.result | 512 |
1 files changed, 256 insertions, 256 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_add_string_middle2.result b/mysql-test/suite/engines/funcs/r/ta_add_string_middle2.result index 593090236fe..4829892354f 100644 --- a/mysql-test/suite/engines/funcs/r/ta_add_string_middle2.result +++ b/mysql-test/suite/engines/funcs/r/ta_add_string_middle2.result @@ -10,7 +10,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -23,7 +23,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -38,7 +38,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -51,7 +51,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -66,7 +66,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -79,7 +79,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -94,7 +94,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -107,7 +107,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -122,7 +122,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -135,7 +135,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -150,7 +150,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -163,7 +163,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -178,7 +178,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -191,7 +191,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -206,7 +206,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -219,7 +219,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -234,7 +234,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -247,7 +247,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -262,7 +262,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -275,7 +275,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -290,7 +290,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -303,7 +303,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -318,7 +318,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -331,7 +331,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -346,7 +346,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -359,7 +359,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -374,7 +374,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -387,7 +387,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -402,7 +402,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -415,7 +415,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -430,7 +430,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -443,7 +443,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) DEFAULT NULL, `c3` char(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -458,7 +458,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -471,7 +471,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -486,7 +486,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -499,7 +499,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -514,7 +514,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -527,7 +527,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -542,7 +542,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -555,7 +555,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -570,7 +570,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -583,7 +583,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -598,7 +598,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -611,7 +611,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -626,7 +626,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -639,7 +639,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -654,7 +654,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -667,7 +667,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -682,7 +682,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -695,7 +695,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -710,7 +710,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -723,7 +723,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -738,7 +738,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -751,7 +751,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -766,7 +766,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -779,7 +779,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -794,7 +794,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -807,7 +807,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -822,7 +822,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -835,7 +835,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -850,7 +850,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -863,7 +863,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -878,7 +878,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -891,7 +891,7 @@ t5 CREATE TABLE `t5` ( `c4` char(5) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -906,7 +906,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -919,7 +919,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -934,7 +934,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -947,7 +947,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -962,7 +962,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -975,7 +975,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -990,7 +990,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1003,7 +1003,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1018,7 +1018,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1031,7 +1031,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1046,7 +1046,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1059,7 +1059,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1074,7 +1074,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1087,7 +1087,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1102,7 +1102,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1115,7 +1115,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1130,7 +1130,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1143,7 +1143,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1158,7 +1158,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1171,7 +1171,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1186,7 +1186,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1199,7 +1199,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1214,7 +1214,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1227,7 +1227,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1242,7 +1242,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1255,7 +1255,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1270,7 +1270,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1283,7 +1283,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1298,7 +1298,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1311,7 +1311,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1326,7 +1326,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1339,7 +1339,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) DEFAULT NULL, `c3` varchar(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1354,7 +1354,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1367,7 +1367,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1382,7 +1382,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1395,7 +1395,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1410,7 +1410,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1423,7 +1423,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1438,7 +1438,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1451,7 +1451,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1466,7 +1466,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1479,7 +1479,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1494,7 +1494,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1507,7 +1507,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1522,7 +1522,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1535,7 +1535,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1550,7 +1550,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1563,7 +1563,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1578,7 +1578,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1591,7 +1591,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1606,7 +1606,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1619,7 +1619,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1634,7 +1634,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1647,7 +1647,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1662,7 +1662,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1675,7 +1675,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1690,7 +1690,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1703,7 +1703,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1718,7 +1718,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1731,7 +1731,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1746,7 +1746,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1759,7 +1759,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1774,7 +1774,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1787,7 +1787,7 @@ t5 CREATE TABLE `t5` ( `c4` varchar(5) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1802,7 +1802,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1815,7 +1815,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1830,7 +1830,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1843,7 +1843,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1858,7 +1858,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1871,7 +1871,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1886,7 +1886,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1899,7 +1899,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1914,7 +1914,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1927,7 +1927,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1942,7 +1942,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1955,7 +1955,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1970,7 +1970,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -1983,7 +1983,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -1998,7 +1998,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2011,7 +2011,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2026,7 +2026,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2039,7 +2039,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2054,7 +2054,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2067,7 +2067,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2082,7 +2082,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2095,7 +2095,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2110,7 +2110,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2123,7 +2123,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2138,7 +2138,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2151,7 +2151,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2166,7 +2166,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2179,7 +2179,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2194,7 +2194,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2207,7 +2207,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2222,7 +2222,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2235,7 +2235,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) DEFAULT NULL, `c3` binary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2250,7 +2250,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2263,7 +2263,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2278,7 +2278,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2291,7 +2291,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2306,7 +2306,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2319,7 +2319,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2334,7 +2334,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2347,7 +2347,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2362,7 +2362,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2375,7 +2375,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2390,7 +2390,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2403,7 +2403,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2418,7 +2418,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2431,7 +2431,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2446,7 +2446,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2459,7 +2459,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2474,7 +2474,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2487,7 +2487,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2502,7 +2502,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2515,7 +2515,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2530,7 +2530,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2543,7 +2543,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2558,7 +2558,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2571,7 +2571,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2586,7 +2586,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2599,7 +2599,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2614,7 +2614,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2627,7 +2627,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2642,7 +2642,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2655,7 +2655,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2670,7 +2670,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2683,7 +2683,7 @@ t5 CREATE TABLE `t5` ( `c4` binary(5) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2698,7 +2698,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2711,7 +2711,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2726,7 +2726,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2739,7 +2739,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2754,7 +2754,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2767,7 +2767,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2782,7 +2782,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2795,7 +2795,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2810,7 +2810,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2823,7 +2823,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2838,7 +2838,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2851,7 +2851,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2866,7 +2866,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2879,7 +2879,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2894,7 +2894,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2907,7 +2907,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2922,7 +2922,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2935,7 +2935,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2950,7 +2950,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2963,7 +2963,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -2978,7 +2978,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -2991,7 +2991,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3006,7 +3006,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3019,7 +3019,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3034,7 +3034,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3047,7 +3047,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3062,7 +3062,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3075,7 +3075,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3090,7 +3090,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3103,7 +3103,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3118,7 +3118,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3131,7 +3131,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) DEFAULT NULL, `c3` varbinary(10) DEFAULT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3146,7 +3146,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3159,7 +3159,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3174,7 +3174,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3187,7 +3187,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3202,7 +3202,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3215,7 +3215,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3230,7 +3230,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3243,7 +3243,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3258,7 +3258,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3271,7 +3271,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3286,7 +3286,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3299,7 +3299,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3314,7 +3314,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3327,7 +3327,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3342,7 +3342,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3355,7 +3355,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3370,7 +3370,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3383,7 +3383,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3398,7 +3398,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3411,7 +3411,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3426,7 +3426,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3439,7 +3439,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3454,7 +3454,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3467,7 +3467,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3482,7 +3482,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3495,7 +3495,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3510,7 +3510,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3523,7 +3523,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3538,7 +3538,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3551,7 +3551,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test @@ -3566,7 +3566,7 @@ t5 CREATE TABLE `t5` ( `c2` int(11) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2; SHOW TABLES; Tables_in_test @@ -3579,7 +3579,7 @@ t5 CREATE TABLE `t5` ( `c4` varbinary(5) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t5; SHOW TABLES; Tables_in_test |