diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_string_to_pk.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_string_to_pk.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_string_to_pk.result b/mysql-test/suite/engines/funcs/r/ta_string_to_pk.result index 885c5e63efd..c99554b5ac0 100644 --- a/mysql-test/suite/engines/funcs/r/ta_string_to_pk.result +++ b/mysql-test/suite/engines/funcs/r/ta_string_to_pk.result @@ -7,7 +7,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1); SHOW TABLES; Tables_in_test @@ -17,7 +17,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -29,7 +29,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1); SHOW TABLES; Tables_in_test @@ -39,7 +39,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -51,7 +51,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1); SHOW TABLES; Tables_in_test @@ -61,7 +61,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -73,7 +73,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 ADD PRIMARY KEY (c1); SHOW TABLES; Tables_in_test @@ -83,7 +83,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test |