Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Fix
-
10.4(EOL), 10.5
-
None
-
ALL - but found on CentOS Linux release 7.4.1708 (Core)
Description
In 10.3 this statement works:
select id1 from t1 for update |
union
|
select id2 from t2 for update |
But in 10.4 it gives this error:
ERROR 1064 (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 id2 from t2 for update' at line 2
|
If I use parenthesis it works:
(select id1 from t1 for update) union (select id2 from t2 for update); |
Attachments
Issue Links
- relates to
-
MDEV-29537 Creation of view with UNION and SELECT ... FOR UPDATE in definition is failed with error
- Closed