Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
10.2.4-1, 10.2.4-2
Description
These queries:
SELECT 1 AS UNBOUNDED;
|
SELECT 1 AS PRECEDING;
|
SELECT 1 AS FOLLOWING;
|
SELECT 1 AS TIES;
|
SELECT 1 AS OTHERS;
|
SELECT 1 FROM EXCLUDE;
|
return a syntax 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 'UNBOUNDED' at line 1
|
This is wrong. According to the standard, these keywords must be non-reserved.
All these queries worked fine in 10.1. So this is a regression.
This query correctly fails:
SELECT 1 FROM WINDOW;
|
as WINDOW is a reserved keyword, according to the standard.
Attachments
Issue Links
- relates to
-
MDEV-11878 Shift/reduce conflict in window_spec clause: OVER (rows ...)
- Closed