diff options
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; |