diff options
author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-03-29 19:20:33 +0300 |
---|---|---|
committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-03-29 19:20:33 +0300 |
commit | 4430048ee8084e0fcef144e64ab89b59f8e31a71 (patch) | |
tree | 2f2c49df3046e161d3bb656bcbed5926b5296947 /mysql-test/r/subselect3.result | |
parent | 456cc52e9c2d981cf7094a6864cd3bef43e8cf1a (diff) | |
parent | 08d9d182f235126c935ba27d4455eb77312521ff (diff) | |
download | mariadb-git-4430048ee8084e0fcef144e64ab89b59f8e31a71.tar.gz |
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into magare.gmz:/home/kgeorge/mysql/autopush/B26815-5.0-opt
sql/item_sum.cc:
Auto merged
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/subselect3.result')
-rw-r--r-- | mysql-test/r/subselect3.result | 6 |
1 files changed, 0 insertions, 6 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 6a7a601ccf9..96a3ee00a59 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -661,12 +661,6 @@ SELECT * FROM t1 GROUP by t1.a HAVING (MAX(t1.b) > (SELECT MAX(t2.b) FROM t2 WHERE t2.c < t1.c HAVING MAX(t2.b+t1.a) < 10)); a b c -SELECT a, AVG(b), (SELECT t.c FROM t1 AS t WHERE t1.a=t.a AND t.b=AVG(t1.b)) -AS test FROM t1 GROUP BY a; -a AVG(b) test -1 4.0000 NULL -2 2.0000 k -3 2.5000 NULL SELECT a,b,c FROM t1 WHERE b in (9,3,4) ORDER BY b,c; a b c 1 3 c |