Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
-
None
Description
MariaDB [test]> select distinct apply_time from test ORDER BY id limit 1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2022: ORDER BY column not in DISTINCT list.
Attachments
Activity
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.
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.