[jira] [Updated] (DRILL-2914) regression: Mondrian query534.q, drill give wrong result
[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2914: - Attachment: DRILL-2914.1.patch > 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: DRILL-2914.1.patch, 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)
[jira] [Updated] (DRILL-2914) regression: Mondrian query534.q, drill give wrong result
[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2914: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > 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)
[jira] [Updated] (DRILL-2914) regression: Mondrian query534.q, drill give wrong result
[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau updated DRILL-2914: -- Fix Version/s: 1.0.0 > 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: Jinfeng Ni >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)
[jira] [Updated] (DRILL-2914) regression: Mondrian query534.q, drill give wrong result
[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2914: --- Assignee: Jinfeng Ni (was: Chris Westin) > 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: Jinfeng Ni >Priority: Critical > 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)
[jira] [Updated] (DRILL-2914) regression: Mondrian query534.q, drill give wrong result
[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2914: --- Component/s: (was: Execution - Relational Operators) Query Planning & Optimization > 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: Chris Westin >Priority: Critical > 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)
[jira] [Updated] (DRILL-2914) regression: Mondrian query534.q, drill give wrong result
[ https://issues.apache.org/jira/browse/DRILL-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-2914: -- Attachment: customer > 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: Execution - Relational Operators >Affects Versions: 0.9.0 >Reporter: Chun Chang >Assignee: Chris Westin >Priority: Critical > 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)