[DRILL-2914] regression: Mondrian query534.q, drill give wrong result

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 1.0.0
• Component/s: Query Planning & Optimization
• Assignee: Chun Chang
• Reporter: Chun Chang
• Created: 30/Apr/15 00:14
• Updated: 13/May/15 01:23
• Resolved: 09/May/15 17:04

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       |
+------------+

Issue Links

• is depended upon by: DRILL-1927 Aggregation or Group-By on a CASE expression with IN subquery fails