Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.2.1
-
Component/s: Optimizer - Window functions
-
Labels:None
-
Sprint:10.2.0-9, 10.2.0-10, 10.2.0-11
Description
Study (and fix) the interplay between window functions and other SQL constructs, like ORDER BY ... LIMIT, DISTINCT, etc.
Known things:
- LIMIT should be applied AFTER the window functions are computed (that is, window function computation should see rows that are cut off by LIMIT)
- DISTINCT must not be converted into GROUP BY when window functions are present
- need to check window functions inside derived table and/or union. Item_window_func::update_field() is not implemented, is this ok?
Attachments
Issue Links
- is part of
-
MDEV-6115 window functions as in the SQL standard
-
- Closed
-