diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_column_primary_key_number.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/tc_column_primary_key_number.result | 40 |
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 |