diff options
author | Igor Babaev <igor@askmonty.org> | 2019-09-20 09:03:38 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2019-09-23 09:57:37 -0700 |
commit | b44171428ab2ea25db82f7cd27349e67812e4921 (patch) | |
tree | 15508ccee1f052305f1fe8b421e9dbf69f8df6e8 /mysql-test/main/parser.result | |
parent | e3da362c037af95a85d3054243a4c9a039ceb4b4 (diff) | |
download | mariadb-git-b44171428ab2ea25db82f7cd27349e67812e4921.tar.gz |
MDEV-19956 Queries with subqueries containing UNION are not parsed
Shift-Reduce conflicts prevented parsing some queries with subqueries that
used set operations when the subqueries occurred in expressions or in IN
predicands.
The grammar rules for query expression were transformed in order to avoid
these conflicts. New grammar rules employ an idea taken from MySQL 8.0.
Diffstat (limited to 'mysql-test/main/parser.result')
-rw-r--r-- | mysql-test/main/parser.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/parser.result b/mysql-test/main/parser.result index 2b4a0bb7163..b39f496e3db 100644 --- a/mysql-test/main/parser.result +++ b/mysql-test/main/parser.result @@ -1776,7 +1776,7 @@ End of 10.3 tests # create table t1 (a int); (select * from t1) for update; -ERROR HY000: Incorrect usage of lock options and SELECT in brackets +a (select * from t1) union (select * from t1) for update; ERROR HY000: Incorrect usage of lock options and SELECT in brackets (select * from t1 for update); |