diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-11-27 17:46:20 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-11-27 17:46:20 +0100 |
| commit | effed09bd7d8081704eaa017060da84c32e3bf29 (patch) | |
| tree | 9dd712312526cdbac1ab622efcdfc28e3fce965a /mysql-test/r/group_min_max.result | |
| parent | 7189f09aa6d434fc889cb6d819e97c09f8cc0bcf (diff) | |
| parent | 12e60c4989ce0214da88faad7c08d2f046885327 (diff) | |
| download | mariadb-git-effed09bd7d8081704eaa017060da84c32e3bf29.tar.gz | |
5.3->5.5 merge
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 047ae5e1307..f3457c43e00 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 |