summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sql_sequence/create.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sql_sequence/create.result')
-rw-r--r--mysql-test/suite/sql_sequence/create.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/sql_sequence/create.result b/mysql-test/suite/sql_sequence/create.result
index add23c1ad2d..9326d7016c9 100644
--- a/mysql-test/suite/sql_sequence/create.result
+++ b/mysql-test/suite/sql_sequence/create.result
@@ -587,7 +587,7 @@ s CREATE TABLE `s` (
`cache` bigint(21) NOT NULL,
`cycle` tinyint(1) unsigned NOT NULL,
`round` bigint(21) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
show create table s2;
Table Create Table
s2 CREATE TABLE `s2` (
@@ -599,7 +599,7 @@ s2 CREATE TABLE `s2` (
`cache` bigint(21) NOT NULL,
`cycle` tinyint(1) unsigned NOT NULL,
`round` bigint(21) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
show create sequence s;
ERROR 42S02: 'test.s' is not a SEQUENCE
show create sequence s2;
@@ -615,7 +615,7 @@ show create table s;
Table Create Table
s CREATE TEMPORARY TABLE `s` (
`i` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
drop table s;
create or replace sequence s;
create temporary sequence s;