diff options
| author | bell@sanja.is.com.ua <> | 2004-12-13 01:21:14 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-12-13 01:21:14 +0200 |
| commit | f65403cd75674f64523936d5f74aa108ec362cb4 (patch) | |
| tree | ec81972a8b779540978b1b4f80daf0a9564935d6 /mysql-test/r/subselect.result | |
| parent | b9abf25a555ff44c7ecbfde7d0c7052e8a65a414 (diff) | |
| download | mariadb-git-f65403cd75674f64523936d5f74aa108ec362cb4.tar.gz | |
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 |