[MDEV-9753] Window functions: reject window frame definition where it is not allowed Created: 2016-03-17  Updated: 2016-04-14  Resolved: 2016-03-18

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - Window functions
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergei Petrunia Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-6115 window functions as in the SQL standard Closed

 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.

 Comments   
Comment by Sergei Petrunia [ 2016-03-18 ]

Fixed by:

commit a197c6bb68d77a0ec73b28d1e6473022ea6b1ae0

Prohibit using window functions of some types with
window frames in full accordance with the SQL standard.

Generated at Thu Feb 08 07:37:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.