[MCOL-644] MariaDB 10.2 WF Add RANGE BETWEEN with date values Created: 2017-03-28 Updated: 2023-07-02 Resolved: 2023-07-02 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| 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: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
The Columnstore engine supports RANGE with date values. MariaDB 10.2 does not. Most Window Functions can take a RANGE BETWEEN phrase with dates as the the range. There are a number of formats. Also, a RANGE phrase with wording like RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) should work with a date column function. Currently the MariaDB 10.2 front end does not support this. |
| Comments |
| Comment by Dipti Joshi (Inactive) [ 2017-04-19 ] |
|
For supported syntax of MariaDB ColumnStore window functions see https://mariadb.com/kb/en/mariadb/columnstore-window-functions/ |
| Comment by David Hall (Inactive) [ 2019-07-11 ] |
|
Tested today. Still blocked by MDEV-9727 |
| Comment by Todd Stoffel (Inactive) [ 2023-07-02 ] |
|
The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket. |