Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
1.1.3-2, 1.1.7
-
None
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
cluded in the GROUP BY clause.
I came across this while using Metabase as this is how it produces aggregate queries.