[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
bingfeng.guo updated CALCITE-3589: ---------------------------------- Description: {color:#172b4d}When conformance is set to LENIENT, and the alias of the select expression is the same as the table name in the expression, and the expression appears in group by, ,a SqlValidatorException will occur。{color} {color:#172b4d}a simple example is as follows:{color} {color:#ff8b00}SELECT MY_ID + 1 AS MY_ID, sum(PRICE){color} {color:#ff8b00}FROM tableA{color} {color:#ff8b00}GROUP BY MY_ID + 1{color} was: {color:#172b4d}When conformance is set to LENIENT, and the alias of the select expression is the same as the table name in the expression, and the expression appears in group by, a SqlValidatorException will occur。{color} {color:#172b4d}a simple example is as follows:{color} {color:#ff8b00}SELECT MY_ID + 1 AS MY_ID, sum(PRICE){color} {color:#ff8b00}FROM tableA{color} {color:#ff8b00}GROUP BY MY_ID + 1{color} > SqlValidatorException when conformation is set to LENIENT > --------------------------------------------------------- > > Key: CALCITE-3589 > URL: https://issues.apache.org/jira/browse/CALCITE-3589 > Project: Calcite > Issue Type: Bug > Reporter: bingfeng.guo > Priority: Critical > > {color:#172b4d}When conformance is set to LENIENT, and the alias of the > select expression is the same as the table name in the expression, and the > expression appears in group by, ,a SqlValidatorException will occur。{color} > {color:#172b4d}a simple example is as follows:{color} > {color:#ff8b00}SELECT MY_ID + 1 AS MY_ID, sum(PRICE){color} > {color:#ff8b00}FROM tableA{color} > {color:#ff8b00}GROUP BY MY_ID + 1{color} -- This message was sent by Atlassian Jira (v8.3.4#803005)