diff options
| author | unknown <timour@askmonty.org> | 2011-11-09 15:36:25 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-11-09 15:36:25 +0200 |
| commit | 511459bd143262a9f154048d3bd87d8cb5239e52 (patch) | |
| tree | e5891f132ba37a5ae011652c05a193f64d81ba5b /mysql-test/r/group_min_max.result | |
| parent | 250bc599bf584ea057edd3de0a4cb0420bc92951 (diff) | |
| download | mariadb-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.result | 5 |
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 |