diff options
author | unknown <bell@sanja.is.com.ua> | 2004-12-13 01:21:14 +0200 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2004-12-13 01:21:14 +0200 |
commit | a9457c573df0ce1b7505ee735140322badd628c0 (patch) | |
tree | ec81972a8b779540978b1b4f80daf0a9564935d6 /mysql-test/r/subselect.result | |
parent | 3ce0df59372a3598ae39423e35bab877459693ad (diff) | |
download | mariadb-git-a9457c573df0ce1b7505ee735140322badd628c0.tar.gz |
fixed optimized SOME subquery
mysql-test/r/subselect.result:
correct results of SOME subquery
sql/item_cmpfunc.cc:
some comments added
fixed optimized SOME subquery
Diffstat (limited to 'mysql-test/r/subselect.result')
-rw-r--r-- | mysql-test/r/subselect.result | 6 |
1 files changed, 0 insertions, 6 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 9c52b25a577..fc23331ad7b 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -1490,9 +1490,6 @@ Warnings: Note 1003 select test.t3.a AS `a` from test.t3 where <not>((test.t3.a < (select max(test.t2.b) from test.t2))) select * from t3 where a >= some (select b from t2); a -6 -7 -3 explain extended select * from t3 where a >= some (select b from t2); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t3 ALL NULL NULL NULL NULL 3 Using where @@ -1512,9 +1509,6 @@ Warnings: Note 1003 select test.t3.a AS `a` from test.t3 where <not>((test.t3.a < <max>(select test.t2.b AS `b` from test.t2 group by test.t2.b))) select * from t3 where a >= some (select b from t2 group by 1); a -6 -7 -3 explain extended select * from t3 where a >= some (select b from t2 group by 1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t3 ALL NULL NULL NULL NULL 3 Using where |