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)