1 files changed, 20 insertions, 20 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_column_primary_key_number.result b/mysql-test/suite/engines/funcs/r/tc_column_primary_key_number.result
index 16337051d2d..f01e18283f6 100644
--- a/mysql-test/suite/engines/funcs/r/tc_column_primary_key_number.result
+++ b/mysql-test/suite/engines/funcs/r/tc_column_primary_key_number.result
@@ -8,7 +8,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` bit(1) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -21,7 +21,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` tinyint(4) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -34,7 +34,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` smallint(6) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -47,7 +47,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` mediumint(9) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -60,7 +60,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` int(11) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -73,7 +73,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` int(11) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -86,7 +86,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` bigint(20) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -99,7 +99,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` decimal(10,0) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -112,7 +112,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` decimal(10,0) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -125,7 +125,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` decimal(10,0) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -138,7 +138,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` decimal(10,0) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -151,7 +151,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` double NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -164,7 +164,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` double NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -177,7 +177,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` double NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -190,7 +190,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` float NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -203,7 +203,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` date NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -216,7 +216,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` time NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -229,7 +229,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -242,7 +242,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` datetime NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test
@@ -255,7 +255,7 @@ Table	Create Table
 t9	CREATE TABLE `t9` (
   `c1` year(4) NOT NULL,
   PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
 DROP TABLE t9;
 SHOW TABLES;
 Tables_in_test