[MCOL-625] MariaDB 10.2 WF Implement IGNORE/RESPECT NULLS in front end Created: 2017-03-15 Updated: 2022-11-05 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.1.0 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | David Hall (Inactive) | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 1 |
| Labels: | 10.2 | ||
| Issue Links: |
|
||||||||
| Description |
|
Some Windows Functions such as LEAD and LAG have an optional Parameter for IGNORE or RESPECT NULLS. Columnstore 1.0 supports this parameter. |
| Comments |
| Comment by David Hall (Inactive) [ 2017-03-15 ] |
|
It appears that the columnstore backend is coded to support this, but as far as I can tell, it's never been tested. The 10.1 frontend also appears to have support, but it syntaxes when this parameter is added. There are no tests in the regression suite for IGNORE or RESPECT NULLS. |
| Comment by Dipti Joshi (Inactive) [ 2017-04-19 ] |
|
dleeyh Do you have test for IGNORE/RESPECT NULLS ? |
| Comment by Daniel Lee (Inactive) [ 2017-04-19 ] |
|
No, I don't. |
| 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 Todd Stoffel (Inactive) [ 2022-11-05 ] |
|
This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket. |