summaryrefslogtreecommitdiff
path: root/mysql-test/main/set_statement.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/set_statement.result')
-rw-r--r--mysql-test/main/set_statement.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/set_statement.result b/mysql-test/main/set_statement.result
index 9e9d7e8c74e..b4ccaa1efd9 100644
--- a/mysql-test/main/set_statement.result
+++ b/mysql-test/main/set_statement.result
@@ -1011,7 +1011,7 @@ SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL
-) ENGINE=MEMORY DEFAULT CHARSET=latin1
+) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
select @@default_storage_engine;
@@default_storage_engine
MyISAM
@@ -1021,7 +1021,7 @@ SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
drop table t1;
SET @@default_storage_engine=@save_dfs;
SET STATEMENT keycache1.key_buffer_size=1024 FOR SELECT 1;
@@ -1229,7 +1229,7 @@ SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` varchar(3) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
# Create the table t1 with the same definition as it used before
# using regular statement execution mode.
@@ -1240,7 +1240,7 @@ SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` varchar(3) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
#
# MDEV-29074 GET_BIT variables crash in SET STATEMENT