[MDEV-9724] Window functions: Frame Exclusion support Created: 2016-03-14 Updated: 2016-04-14 Resolved: 2016-03-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer - Window functions |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Sergei Petrunia | Assignee: | Sergei Petrunia |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
SQL standard supports EXCLUDE clause within window frame definition. We currently have it in sql_yacc.yy. The statement is parsed, but ignored:
The question is - should we implement frame exclusion? It doesn't seem to be supported by anybody:
If we decide not to support Frame Exclusion, we should disable it in the parser so that it doesn't confuse anybody. |
| Comments |
| Comment by Sergei Petrunia [ 2016-03-15 ] |
|
Made a decision on the optimizer call: we will not support frame exclusion (at least for the first version). The parts of the grammar should remain, but attempt to specify any exclusion clause will cause a "Not supported" or a "not implemented" error (check what error code/message we have) |
| Comment by Sergei Petrunia [ 2016-03-17 ] |
|
Pushed to the feature tree. |