summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_mat.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/subselect_mat.result')
-rw-r--r--mysql-test/main/subselect_mat.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/subselect_mat.result b/mysql-test/main/subselect_mat.result
index d7384dda165..271b3c18a30 100644
--- a/mysql-test/main/subselect_mat.result
+++ b/mysql-test/main/subselect_mat.result
@@ -173,7 +173,7 @@ t2i_c CREATE TABLE `t2i_c` (
KEY `it2i1` (`b1`),
KEY `it2i2` (`b2`),
KEY `it2i3` (`b1`,`b2`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
explain extended
select * from t1 where (a1, a2) in (select b1, max(b2) from t2i_c group by b1);
id select_type table type possible_keys key key_len ref rows filtered Extra