diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-12-25 12:03:08 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-12-25 12:03:08 +0200 |
| commit | d765d3f37b961e8a83e0c56365de27303d3a986b (patch) | |
| tree | 938031e244a6fbe846a514dbadd9b37df59d9bdb /mysql-test | |
| parent | e10a32679096459ee0695d07cd4ae210e21ba227 (diff) | |
| download | mariadb-git-d765d3f37b961e8a83e0c56365de27303d3a986b.tar.gz | |
check of LIMIT in row IN subquery (SCRUM related)
mysql-test/r/subselect.result:
test of LIMIT in row IN subquery
mysql-test/t/subselect.test:
test of LIMIT in row IN subquery
sql/item_subselect.cc:
check of LIMIT in row IN subquery
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 6411bf2a3bc..ec0de79cbef 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -809,4 +809,6 @@ NULL select ROW(1, 1, 'a') IN (select b,a,c from t where c='b' or c='a'); ROW(1, 1, 'a') IN (select b,a,c from t where c='b' or c='a') 1 +select ROW(1, 1, 'a') IN (select b,a,c from t limit 2); +This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' drop table if exists t; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index cd4baacdacb..c77fc33f0ea 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -454,4 +454,6 @@ select ROW(1, 1, 'a') IN (select b,a,c from t where a is not null); select ROW(1, 1, 'a') IN (select a,b,c from t where c='b' or c='a'); select ROW(1, 2, 'a') IN (select a,b,c from t where c='b' or c='a'); select ROW(1, 1, 'a') IN (select b,a,c from t where c='b' or c='a'); +-- error 1235 +select ROW(1, 1, 'a') IN (select b,a,c from t limit 2); drop table if exists t; |