summaryrefslogtreecommitdiff
path: root/mysql-test/suite/maria
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2022-09-14 19:01:26 +0400
committerAlexander Barkov <bar@mariadb.com>2022-09-14 19:01:26 +0400
commitb65ffe156acf0a571300c7506bd2a45ceec07fe6 (patch)
treeeebdf0b07847bc324b218a158abc0ab61484cc45 /mysql-test/suite/maria
parentfe844c16b6cbd67386d1b9fc1cb9e5a656bbb885 (diff)
downloadmariadb-git-b65ffe156acf0a571300c7506bd2a45ceec07fe6.tar.gz
A cleanup for MDEV-29446 Change SHOW CREATE TABLE to display default collation
Recording test results according to MDEV-29446 changes: mysql-test/suite/maria/max_length.result
Diffstat (limited to 'mysql-test/suite/maria')
-rw-r--r--mysql-test/suite/maria/max_length.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/maria/max_length.result b/mysql-test/suite/maria/max_length.result
index 53e02fb710e..163256b14af 100644
--- a/mysql-test/suite/maria/max_length.result
+++ b/mysql-test/suite/maria/max_length.result
@@ -10,7 +10,7 @@ t1 CREATE TABLE `t1` (
`v` varchar(2000) DEFAULT NULL,
`b` blob DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=Aria DEFAULT CHARSET=latin1 MAX_ROWS=2 PAGE_CHECKSUM=1 ROW_FORMAT=PAGE
+) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci MAX_ROWS=2 PAGE_CHECKSUM=1 ROW_FORMAT=PAGE
show create table t2;
Table Create Table
t2 CREATE TABLE `t2` (
@@ -19,7 +19,7 @@ t2 CREATE TABLE `t2` (
`b` blob DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `v` (`v`)
-) ENGINE=Aria DEFAULT CHARSET=latin1 MAX_ROWS=20000000 PAGE_CHECKSUM=1 ROW_FORMAT=PAGE
+) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci MAX_ROWS=20000000 PAGE_CHECKSUM=1 ROW_FORMAT=PAGE
lock tables t1 write,t2 write;
show table status like "t_";
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary