diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_3part_string_to_pk.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_3part_string_to_pk.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_3part_string_to_pk.result b/mysql-test/suite/engines/funcs/r/ta_3part_string_to_pk.result index 71afc5695d2..0e62a37fd59 100644 --- a/mysql-test/suite/engines/funcs/r/ta_3part_string_to_pk.result +++ b/mysql-test/suite/engines/funcs/r/ta_3part_string_to_pk.result @@ -9,7 +9,7 @@ t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, `c2` char(20) NOT NULL, `c3` char(10) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); SHOW TABLES; Tables_in_test @@ -21,7 +21,7 @@ t1 CREATE TABLE `t1` ( `c2` char(20) NOT NULL, `c3` char(10) NOT NULL, PRIMARY KEY (`c1`,`c2`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -35,7 +35,7 @@ t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, `c2` varchar(20) NOT NULL, `c3` varchar(10) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); SHOW TABLES; Tables_in_test @@ -47,7 +47,7 @@ t1 CREATE TABLE `t1` ( `c2` varchar(20) NOT NULL, `c3` varchar(10) NOT NULL, PRIMARY KEY (`c1`,`c2`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -61,7 +61,7 @@ t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, `c2` binary(20) NOT NULL, `c3` binary(10) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); SHOW TABLES; Tables_in_test @@ -73,7 +73,7 @@ t1 CREATE TABLE `t1` ( `c2` binary(20) NOT NULL, `c3` binary(10) NOT NULL, PRIMARY KEY (`c1`,`c2`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -87,7 +87,7 @@ t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, `c2` varbinary(20) NOT NULL, `c3` varbinary(10) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); SHOW TABLES; Tables_in_test @@ -99,7 +99,7 @@ t1 CREATE TABLE `t1` ( `c2` varbinary(20) NOT NULL, `c3` varbinary(10) NOT NULL, PRIMARY KEY (`c1`,`c2`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test |