[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533602#comment-14533602 ]
Chun Chang commented on DRILL-2914: ----------------------------------- When this bug is fixed, please move the following mondrian tests from failing to passing as part of the verification: Advanced/Passing/mondrian/query5866.q Advanced/Passing/mondrian/query5839.q Advanced/Passing/mondrian/query5846.q Advanced/Passing/mondrian/query536.q Advanced/Passing/mondrian/query5842.q Advanced/Passing/mondrian/query534.q > regression: Mondrian query534.q, drill give wrong result > -------------------------------------------------------- > > Key: DRILL-2914 > URL: https://issues.apache.org/jira/browse/DRILL-2914 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.9.0 > Reporter: Chun Chang > Assignee: Sean Hsuan-Yi Chu > Priority: Critical > Fix For: 1.0.0 > > Attachments: customer > > > #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. > {code} > SELECT gender2.gender AS c0 > FROM (SELECT * > FROM customer) AS gender2 > GROUP BY gender2.gender > ORDER BY gender2.gender ASC nulls last; > {code} > Correct result from postgres: > {code} > 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) > {code} > Wrong result from drill: > {code} > 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 | > +------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)