diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-09-20 10:36:20 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-09-20 10:36:20 +0400 |
| commit | 2f88bd2da26abd30b027308aedc30989c039d518 (patch) | |
| tree | 46154ab8b7b906727cf9c0832aa05b5017eb02fd /mysql-test/main/subselect.result | |
| parent | b9dea911bf8e3d4d8fc57ce3ef15ab0e2ab4d076 (diff) | |
| download | mariadb-git-2f88bd2da26abd30b027308aedc30989c039d518.tar.gz | |
MDEV-20634 Report disallowed subquery errors as such (instead of parse error)
Diffstat (limited to 'mysql-test/main/subselect.result')
| -rw-r--r-- | mysql-test/main/subselect.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/subselect.result b/mysql-test/main/subselect.result index ae75f5f354e..f2836d36c80 100644 --- a/mysql-test/main/subselect.result +++ b/mysql-test/main/subselect.result @@ -83,7 +83,7 @@ SELECT 1 FROM (SELECT 1 as a) b WHERE 1 IN (SELECT (SELECT a)); select (SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE(1)); 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 'PROCEDURE ANALYSE(1))' at line 1 SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE((SELECT 1)); -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 'SELECT 1))' at line 1 +ERROR 42000: PROCEDURE does not support subqueries or stored functions SELECT (SELECT 1) as a FROM (SELECT 1) b WHERE (SELECT a) IS NULL; ERROR 42S22: Unknown column 'a' in 'field list' SELECT (SELECT 1) as a FROM (SELECT 1) b WHERE (SELECT a) IS NOT NULL; @@ -1133,7 +1133,7 @@ ERROR 42S02: Table 'test.t1' doesn't exist CREATE TABLE t1 (a int, KEY(a)); HANDLER t1 OPEN; HANDLER t1 READ a=((SELECT 1)); -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 'SELECT 1))' at line 1 +ERROR 42000: HANDLER..READ does not support subqueries or stored functions HANDLER t1 CLOSE; drop table t1; create table t1 (a int); |