diff options
| author | bell@sanja.is.com.ua <> | 2002-12-23 18:25:25 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2002-12-23 18:25:25 +0200 |
| commit | 50481ebfb644aeaa66591f5d5691aef9274daaf8 (patch) | |
| tree | a59613aab53ba560959260b913bc8a6306fca3f1 /mysql-test/r/subselect.result | |
| parent | bd925bbc74c9cded3b4de616e012288e14f5edc8 (diff) | |
| download | mariadb-git-50481ebfb644aeaa66591f5d5691aef9274daaf8.tar.gz | |
LIMIT is prohibited in IN/ALL/ANY/SOME
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 493768ece4a..f12e0396694 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -32,7 +32,7 @@ a 1 SELECT 1 FROM (SELECT (SELECT a) b) c; Unknown column 'a' in 'field list' -SELECT * FROM (SELECT 1 as id) b WHERE id IN (SELECT * FROM (SELECT 1 as id) c ORDER BY id LIMIT 1); +SELECT * FROM (SELECT 1 as id) b WHERE id IN (SELECT * FROM (SELECT 1 as id) c ORDER BY id); id 1 SELECT * FROM (SELECT 1) a WHERE 1 IN (SELECT 1,1); @@ -705,3 +705,9 @@ select 10.5 > ANY (SELECT * from t); 10.5 > ANY (SELECT * from t) 1 drop table t; +create table t (a float); +select 10.5 IN (SELECT * from t LIMIT 1); +This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' +select 10.5 IN (SELECT * from t LIMIT 1 UNION SELECT 1.5); +This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' +drop table t; |