Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
Description
GROUP BY expressions are ignored unless the query also contains an aggregate expression.
To reproduce you can execute the following query on the aggregate_test_100 data set.
SELECT c2 FROM aggregate_test_100 GROUP BY c2
Expected:
1
2
3
4
5
Actual:
2
5
...98 more rows...
The order of the expected isn't necessarily correct since the query doesn't contain an ORDER BY expression.
Attachments
Issue Links
- links to