[MDEV-12984] support IGNORE/RESPECT NULLS for window functions Created: 2017-06-02 Updated: 2020-08-10 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Optimizer - Window functions |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | David Thompson (Inactive) | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 3 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
The lead and lag window functions support an extra clause IGNORE / RESPECT NULLS at the end. IGNORE NULLS means to exclude window entries that evaluate to null while the default behavior RESPECT NULLS would include them. Syntax is i believe for example NTH_VALUE(col1) IGNORE NULLS OVER (..) |
| Comments |
| Comment by nathan aschoff [ 2017-12-14 ] |
|
It would be great to have this supported as it is impeding upgrades from 1.0 to 1.1. |
| Comment by Yitzchak [ 2020-08-10 ] |
|
Note that mysql has chosen to successfully parse both "IGNORE NULLS" and "RESPECT NULLS", but throw an error if "IGNORE NULLS" is specified. |