[MDEV-12981] lead and lag don't support defaults Created: 2017-06-02 Updated: 2017-08-26 |
|
| 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: | 5 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
ColumnStore and other database vendor implementations support a default parameter for the lead and lag window functions. The standard syntax is: where the optional default is the value returned should the offset be outside of the window frame. If unspecified then NULL is used. |
| Comments |
| Comment by Daniel Bartholomew [ 2017-08-26 ] |
|
MySQL 8.0.2 DMR supports the default option to LEAD/LAG window functions, so this is needed to maintain syntax compatibility. |