[MCOL-4646] Support SELECT..OFFSET..FETCH..WITH TIES syntax introduced by SQL2008 Created: 2021-03-29 Updated: 2023-12-15 |
|
| Status: | Confirmed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr, MDB Plugin |
| Affects Version/s: | 6.1.1 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | Roman | Assignee: | Max Mether |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
SQL2008 introduces a new syntax that extends the functionality of SELECT..LIMIT..OFFSET.
WITH TIES tells the engine to return additional rows that tie for the last place accordith with the ORDER BY clause used. |