Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Discovered this in MDEV-9740:
The standard, section 6.10, <window function>.
syntax rules says:
7) b) The window framing clause of WDX shall not be present.
Trying
select rank() over (order by a rows between 1 preceding and 1 following) from ten;
|
MariaDB: ok (framing ignored)
PG: Ok (framing ignored)
Oracle: ORA-00907: missing right parenthesis
MS SQL: The function 'rank' may not have a window frame.
I think, it is better to follow the standard and return an error, then to accept the frame definition and then silently ignore it.
Attachments
Issue Links
- is part of
-
MDEV-6115 window functions as in the SQL standard
- Closed