summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_sj2_mat.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2022-09-02 17:32:14 +0400
committerAlexander Barkov <bar@mariadb.com>2022-09-12 22:10:39 +0400
commitf1544424de2b8c9d1c3faefbbdd15543db7dfd12 (patch)
treeebac7186e67915f333a5e9fec2e801ae45c8eccc /mysql-test/main/subselect_sj2_mat.result
parent667df98c3e0f32d391af4eb65c618043720b6a2f (diff)
downloadmariadb-git-f1544424de2b8c9d1c3faefbbdd15543db7dfd12.tar.gz
MDEV-29446 Change SHOW CREATE TABLE to display default collation
Diffstat (limited to 'mysql-test/main/subselect_sj2_mat.result')
-rw-r--r--mysql-test/main/subselect_sj2_mat.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/subselect_sj2_mat.result b/mysql-test/main/subselect_sj2_mat.result
index ab3e4652deb..71ba9c1a735 100644
--- a/mysql-test/main/subselect_sj2_mat.result
+++ b/mysql-test/main/subselect_sj2_mat.result
@@ -710,7 +710,7 @@ t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `a` (`a`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
set @a=0;
create table t3 as select * from t2 limit 0;
insert into t3 select @a:=@a+1, t2.a from t2, t0;