diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-05-23 10:54:09 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2016-05-23 10:54:09 +0400 |
| commit | 4c0e2960d458cb437d4aa06d9193f5576c027448 (patch) | |
| tree | acafeca39279554d7be71af4de35cb43c8fc80e7 /mysql-test/r/subselect.result | |
| parent | a999acf26ecbe815f9b10780153384bea7840a03 (diff) | |
| download | mariadb-git-4c0e2960d458cb437d4aa06d9193f5576c027448.tar.gz | |
MDEV-10051 Fix subselect to return a syntax error instead of "Incorrect usage of UNION and LIMIT"
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 974c60d381d..c973bbe11d5 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -1056,7 +1056,7 @@ create table t1 (a float); select 10.5 IN (SELECT * from t1 LIMIT 1); ERROR 42000: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' select 10.5 IN (SELECT * from t1 LIMIT 1 UNION SELECT 1.5); -ERROR HY000: Incorrect usage of UNION and LIMIT +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UNION SELECT 1.5)' at line 1 select 10.5 IN (SELECT * from t1 UNION SELECT 1.5 LIMIT 1); ERROR 42000: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' drop table t1; |