Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Description
Test:
CREATE TABLE t1 (i INT); |
create view v1 as SELECT 1 FROM t1 |
UNION
|
SELECT 1 FROM DUAL WHERE 1 GROUP BY 1 HAVING 1 ORDER BY 1 |
FOR UPDATE; |
select * from v1; |
drop view v1; |
Expected result:
1
|
1
|
Actual result:
query 'select * from v1' failed: ER_PARSE_ERROR (1064): 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 'order by 1' at line 1 |
Attachments
Issue Links
- is part of
-
MDEV-27691 make working view-protocol
- Open
- relates to
-
MDEV-23203 SELECT FOR UPDATE with UNION should not need parenthesis
- Closed