group_date.sql
[MCOL-1483] Group by fails on view with Columnstore engine Created: 2018-06-19 Updated: 2023-10-25 Resolved: 2023-10-25 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | PrimProc |
| Affects Version/s: | 1.1.3-2, 1.1.7 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Minor |
| Reporter: | Bryn Edwards | Assignee: | Roman |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
group_date.sql
|
| Description |
|
Hi, The attached SQL shows a select statement that only produces the following error when executed on a view of a table using the columnstore engine: ERROR 1815 (HY000) at line 23: Internal error: IDB-2021: 'dt' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be in I came across this while using Metabase as this is how it produces aggregate queries. |