Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
0.9.0
-
None
Description
#Wed Apr 29 14:39:22 EDT 2015
git.commit.id.abbrev=f5b0f49
Running mondrian tests and noticed several regressions. This one is related to group by with select * subquery.
SELECT gender2.gender AS c0 FROM (SELECT * FROM customer) AS gender2 GROUP BY gender2.gender ORDER BY gender2.gender ASC nulls last;
Correct result from postgres:
foodmart=# select gender2.gender as c0 from (SELECT * FROM customer) as gender2 group by gender2.gender order by gender2.gender ASC NULLS LAST; c0 ---- F M (2 rows)
Wrong result from drill:
0: jdbc:drill:schema=dfs.drillTestDirAdvanced> select gender2.gender as c0 from (SELECT * FROM customer) as gender2 group by gender2.gender order by gender2.gender ASC NULLS LAST;
+------------+
| c0 |
+------------+
| null |
+------------+
Attachments
Attachments
Issue Links
- is depended upon by
-
DRILL-1927 Aggregation or Group-By on a CASE expression with IN subquery fails
- Resolved