diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-05-04 10:57:14 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-05-04 10:57:14 +0300 |
| commit | ad06c4c08ee5bc9258dfce3455aabe39747d4875 (patch) | |
| tree | 4ce958e6ff6f3d0cbac9a4870233fcf80ea461bf /mysql-test/r/subselect.result | |
| parent | 8e8ece72eb0530bee9b200d92ba14a143cd1dec9 (diff) | |
| parent | 0ad4e1b2a6f4919afbfc43a7cd71e828e3aeb74a (diff) | |
| download | mariadb-git-ad06c4c08ee5bc9258dfce3455aabe39747d4875.tar.gz | |
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into magare.gmz:/home/kgeorge/mysql/autopush/B27807-5.0-opt
sql/sql_select.cc:
Auto merged
mysql-test/r/subselect.result:
merge to 5.0-opt
mysql-test/t/subselect.test:
merge to 5.0-opt
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 06ff23b32b7..2e82d948edb 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -4034,4 +4034,11 @@ SUM( (SELECT AVG( (SELECT COUNT(*) FROM t1 t HAVING XXA < 12) ) FROM t2) ) FROM t1; ERROR HY000: Invalid use of group function DROP TABLE t1,t2; +CREATE TABLE t1 (a int, b int, KEY (a)); +INSERT INTO t1 VALUES (1,1),(2,1); +EXPLAIN SELECT 1 FROM t1 WHERE a = (SELECT COUNT(*) FROM t1 GROUP BY b); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t1 ref a a 5 const 1 Using where; Using index +2 SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +DROP TABLE t1; End of 5.0 tests. |