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
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Andrew Hutchings [ linuxjedi ] |
| Component/s | Connector [ 13801 ] | |
| Fix Version/s | N/A [ 22302 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
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.
| Resolution | Not a Bug [ 6 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Epic Link |
|
| Rank | Ranked higher |
| Rank | Ranked higher |
| Fix Version/s | 1.5 [ 22800 ] | |
| Fix Version/s | N/A [ 22302 ] |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Team | ColumnStore Team |
| Rank | Ranked higher |
| Fix Version/s | 5.6.1 [ 25031 ] | |
| Fix Version/s | 1.5 [ 22800 ] |
| Rank | Ranked higher |
| Rank | Ranked lower |
| Rank | Ranked higher |
| Assignee | Andrew Hutchings [ linuxjedi ] | David Hall [ david.hall ] |
| Fix Version/s | 6.1 [ 25201 ] | |
| Fix Version/s | 5.6.1 [ 25031 ] |
| Rank | Ranked higher |
| Fix Version/s | 6.1.1 [ 25600 ] | |
| Fix Version/s | 6.1 [ 25201 ] |
| Fix Version/s | 6.5.1 [ 25801 ] | |
| Fix Version/s | 6.1.1 [ 25600 ] |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Issue Type | Bug [ 1 ] | New Feature [ 2 ] |
| Fix Version/s | 7.1.1 [ 26904 ] | |
| Fix Version/s | 6.3.1 [ 25801 ] |
| Rank | Ranked lower |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Fix Version/s | 22.08.3 [ 28456 ] | |
| Fix Version/s | 22.08.3 [ 28456 ] | |
| Fix Version/s | 22.08 [ 26904 ] |
| Fix Version/s | 22.11.01 [ 28458 ] | |
| Fix Version/s | 22.08.3 [ 28456 ] |
| Rank | Ranked higher |
| Fix Version/s | 23.02 [ 28209 ] | |
| Fix Version/s | 23.03.1 [ 28458 ] |
| Assignee | David Hall [ david.hall ] | alexey vorovich [ JIRAUSER48263 ] |
| Rank | Ranked higher |
| Fix Version/s | 23.08 [ 28540 ] | |
| Fix Version/s | 23.02 [ 28209 ] |
| Assignee | alexey vorovich [ JIRAUSER48263 ] | Todd Stoffel [ toddstoffel ] |
| Assignee | Todd Stoffel [ toddstoffel ] | Kirill Perov [ JIRAUSER51446 ] |
| Resolution | Won't Fix [ 2 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Fix Version/s | 23.10.0 [ 29422 ] |
| Fix Version/s | 23.10 [ 28540 ] |
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.