You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "duan xiong (Jira)" <ji...@apache.org> on 2021/08/21 02:35:00 UTC

[jira] [Created] (CALCITE-4748) duplicate columnName in grouping sets get the wrong result

duan xiong created CALCITE-4748:
-----------------------------------

             Summary: duplicate columnName in grouping sets get the wrong result
                 Key: CALCITE-4748
                 URL: https://issues.apache.org/jira/browse/CALCITE-4748
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.27.0
            Reporter: duan xiong
            Assignee: duan xiong


When run SQL1:
{code:java}
select prod_id from foodmart.sales_fact_1997 as s group by grouping sets(prod_id,prod_id){code}
and SQL2:
{code:java}
select prod_id from foodmart.sales_fact_1997 as s group by grouping sets(prod_id){code}
get the SAME result. This is wrong. SQL1 return result's number = SQL2 return result*2 number



--
This message was sent by Atlassian Jira
(v8.3.4#803005)