summaryrefslogtreecommitdiff
path: root/mysql-test/r/group_min_max.result
diff options
context:
space:
mode:
authorunknown <timour@askmonty.org>2011-11-09 15:36:25 +0200
committerunknown <timour@askmonty.org>2011-11-09 15:36:25 +0200
commit511459bd143262a9f154048d3bd87d8cb5239e52 (patch)
treee5891f132ba37a5ae011652c05a193f64d81ba5b /mysql-test/r/group_min_max.result
parent250bc599bf584ea057edd3de0a4cb0420bc92951 (diff)
downloadmariadb-git-511459bd143262a9f154048d3bd87d8cb5239e52.tar.gz
Enable subquery materialization=ON by default.
Diffstat (limited to 'mysql-test/r/group_min_max.result')
-rw-r--r--mysql-test/r/group_min_max.result5
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/r/group_min_max.result b/mysql-test/r/group_min_max.result
index 76bd6d70e4c..56bfcf6c71c 100644
--- a/mysql-test/r/group_min_max.result
+++ b/mysql-test/r/group_min_max.result
@@ -2401,8 +2401,9 @@ id select_type table type possible_keys key key_len ref rows Extra
EXPLAIN SELECT 1 FROM t1 AS t1_outer WHERE
a IN (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2);
id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY t1_outer index NULL a 10 NULL 15 Using where; Using index
-2 DEPENDENT SUBQUERY t1 index NULL a 10 NULL 1 Using index
+1 PRIMARY <subquery2> ALL distinct_key NULL NULL NULL 8 Using where
+1 PRIMARY t1_outer ref a a 5 <subquery2>.max(b) 2 Using index
+2 SUBQUERY t1 range NULL a 5 NULL 8 Using index for group-by
EXPLAIN SELECT 1 FROM t1 AS t1_outer GROUP BY a HAVING
a > (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2);
id select_type table type possible_keys key key_len ref rows Extra