summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result16
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result b/mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result
index 2e3cf0be94a..bbbf02d9d74 100644
--- a/mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result
+++ b/mysql-test/suite/engines/funcs/r/ta_drop_pk_string.result
@@ -8,7 +8,7 @@ Table Create Table
t9 CREATE TABLE `t9` (
`c1` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t9 DROP PRIMARY KEY;
SHOW TABLES;
Tables_in_test
@@ -17,7 +17,7 @@ SHOW CREATE TABLE t9;
Table Create Table
t9 CREATE TABLE `t9` (
`c1` char(20) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t9;
SHOW TABLES;
Tables_in_test
@@ -30,7 +30,7 @@ Table Create Table
t9 CREATE TABLE `t9` (
`c1` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t9 DROP PRIMARY KEY;
SHOW TABLES;
Tables_in_test
@@ -39,7 +39,7 @@ SHOW CREATE TABLE t9;
Table Create Table
t9 CREATE TABLE `t9` (
`c1` varchar(20) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t9;
SHOW TABLES;
Tables_in_test
@@ -52,7 +52,7 @@ Table Create Table
t9 CREATE TABLE `t9` (
`c1` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t9 DROP PRIMARY KEY;
SHOW TABLES;
Tables_in_test
@@ -61,7 +61,7 @@ SHOW CREATE TABLE t9;
Table Create Table
t9 CREATE TABLE `t9` (
`c1` binary(20) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t9;
SHOW TABLES;
Tables_in_test
@@ -74,7 +74,7 @@ Table Create Table
t9 CREATE TABLE `t9` (
`c1` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t9 DROP PRIMARY KEY;
SHOW TABLES;
Tables_in_test
@@ -83,7 +83,7 @@ SHOW CREATE TABLE t9;
Table Create Table
t9 CREATE TABLE `t9` (
`c1` varbinary(20) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t9;
SHOW TABLES;
Tables_in_test