[MCOL-1036] doesn't support IDB-2022: ORDER BY column not in DISTINCT list. Created: 2017-11-16 Updated: 2023-10-25 Resolved: 2023-10-25 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MDB Plugin |
| Affects Version/s: | None |
| Fix Version/s: | 23.10 |
| Type: | New Feature | Priority: | Major |
| Reporter: | hiller1 | Assignee: | Kirill Perov |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | ColumnStore Compatibility Improvements |
| Description |
|
MariaDB [test]> select distinct apply_time from test ORDER BY id limit 1; |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2017-11-16 ] |
|
MariaDB ColumnStore is a columnar orientated storage engine instead of row orientated. `id` isn't referenced in the query so that column isn't accessed and there is no data for it to process. It therefore cannot execute an ORDER BY on that column. Whereas if it was row orientated that column would be available in the intermediate results. |
| Comment by David Thompson (Inactive) [ 2017-11-17 ] |
|
Re-opening as this is valid SQL, we don't support today but i think it's reasonable to consider this as a future improvement. |