diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-11-29 14:51:22 +0100 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-11-29 14:51:22 +0100 |
| commit | 50c5e11258dcfbbd88beac97d9732145a5e5023f (patch) | |
| tree | a3cdfefeb01968bd2c10d22790bb528b5fea6469 /mysql-test/r/group_min_max.result | |
| parent | 3e0d5bc27aa88da7539d996efc3a15636d5c4bda (diff) | |
| download | mariadb-git-50c5e11258dcfbbd88beac97d9732145a5e5023f.tar.gz | |
func_in.result, group_min_max.result:
merged 5.0 testcases
mysql-test/r/func_in.result:
merged 5.0 testcases
mysql-test/r/group_min_max.result:
merged 5.0 testcases
Diffstat (limited to 'mysql-test/r/group_min_max.result')
| -rw-r--r-- | mysql-test/r/group_min_max.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/group_min_max.result b/mysql-test/r/group_min_max.result index 8c1ac4f1bcd..dcaf249e9c4 100644 --- a/mysql-test/r/group_min_max.result +++ b/mysql-test/r/group_min_max.result @@ -2246,7 +2246,7 @@ EXPLAIN SELECT 1 FROM t1 AS t1_outer WHERE EXISTS (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 index -2 SUBQUERY t1 index NULL a 10 NULL 8 Using index +2 SUBQUERY t1 index NULL a 10 NULL 15 Using index EXPLAIN SELECT 1 FROM t1 AS t1_outer WHERE (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2) > 12; id select_type table type possible_keys key key_len ref rows Extra @@ -2256,7 +2256,7 @@ 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 8 Using index +2 DEPENDENT SUBQUERY t1 index NULL a 10 NULL 15 Using index 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 |