Merge remote-tracking branch 'origin/10.4' into 10.5

1 files changed, 60 insertions, 60 deletions

diff --git a/mysql-test/suite/engines/funcs/r/ai_init_alter_table.result b/mysql-test/suite/engines/funcs/r/ai_init_alter_table.result
index 5ae1c4b7b64..dc3166f8bf1 100644
--- a/mysql-test/suite/engines/funcs/r/ai_init_alter_table.result
+++ b/mysql-test/suite/engines/funcs/r/ai_init_alter_table.result
@@ -6,7 +6,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -25,7 +25,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(6) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -44,7 +44,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -63,7 +63,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -82,7 +82,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -101,7 +101,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -120,7 +120,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -139,7 +139,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(6) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -158,7 +158,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -177,7 +177,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -196,7 +196,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -215,7 +215,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -234,7 +234,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(4) AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -253,7 +253,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(6) AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -272,7 +272,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(9) AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -291,7 +291,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -310,7 +310,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -329,7 +329,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -348,7 +348,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -367,7 +367,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(6) NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -386,7 +386,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -405,7 +405,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -424,7 +424,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -443,7 +443,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -462,7 +462,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -481,7 +481,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(6) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -500,7 +500,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -519,7 +519,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -538,7 +538,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -557,7 +557,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -576,7 +576,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -595,7 +595,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -614,7 +614,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -633,7 +633,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -652,7 +652,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -671,7 +671,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -690,7 +690,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -709,7 +709,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -728,7 +728,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -747,7 +747,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -766,7 +766,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -785,7 +785,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -804,7 +804,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(3) unsigned AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -823,7 +823,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(5) unsigned AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -842,7 +842,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(8) unsigned AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -861,7 +861,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -880,7 +880,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -899,7 +899,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) unsigned AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -918,7 +918,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -937,7 +937,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -956,7 +956,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -975,7 +975,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -994,7 +994,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1013,7 +1013,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1032,7 +1032,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1051,7 +1051,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1070,7 +1070,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1089,7 +1089,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1108,7 +1108,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
@@ -1127,7 +1127,7 @@ Table	Create Table
 t1	CREATE TABLE `t1` (
   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);
 INSERT INTO t1 VALUES(null);