summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect3.result
diff options
context:
space:
mode:
authorunknown <gkodinov/kgeorge@magare.gmz>2007-03-28 12:09:30 +0300
committerunknown <gkodinov/kgeorge@magare.gmz>2007-03-28 12:09:30 +0300
commit04dc7c88309c270bb8607a2a195bb93aeccb4988 (patch)
treef80706bd219645ba5458c65bfaaf78b1dd922687 /mysql-test/r/subselect3.result
parent6e93d2939df73eceb8b39e0c2e08e96fb4c764d2 (diff)
downloadmariadb-git-04dc7c88309c270bb8607a2a195bb93aeccb4988.tar.gz
disabled a test reuturning wrong result (reported separately)
Diffstat (limited to 'mysql-test/r/subselect3.result')
-rw-r--r--mysql-test/r/subselect3.result6
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