[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
bingfeng.guo updated CALCITE-3589: ---------------------------------- Description: error occurs conditions (all three conditions must be met): * conformance = LENIENT * The alias of the expression in select is the same as the column name of the column used in the expression * group by or having use the above expression {color:#172b4d}a simple example is as follows:{color} {color:#ff8b00}SELECT SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} {color:#ff8b00}FROM TEST_KYLIN_FACT{color} {color:#ff8b00}GROUP BY SELLER_ID + 1{color} {color:#172b4d}will change to {color} {color:#ff8b00}SELECT `TEST_KYLIN_FACT`.`SELLER_ID` + 1 AS `SELLER_ID`, SUM(`PRICE`) FROM `DEFAULT`.`TEST_KYLIN_FACT` AS `TEST_KYLIN_FACT` GROUP BY `TEST_KYLIN_FACT`.`SELLER_ID` + 1 + 1{color} {color:#172b4d}after org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{color} {color:#172b4d}屏幕快照 2019-12-12 下午5.56.24.png{color} was: error occurs conditions (all three conditions must be met): * conformance = LENIENT * The alias of the expression in select is the same as the column name of the column used in the expression * group by or having use the above expression {color:#172b4d}a simple example is as follows:{color} {color:#ff8b00}SELECT SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} {color:#ff8b00}FROM TEST_KYLIN_FACT{color} {color:#ff8b00}GROUP BY SELLER_ID + 1{color} {color:#172b4d}will change to {color} {color:#ff8b00}SELECT `TEST_KYLIN_FACT`.`SELLER_ID` + 1 AS `SELLER_ID`, SUM(`PRICE`) FROM `DEFAULT`.`TEST_KYLIN_FACT` AS `TEST_KYLIN_FACT` GROUP BY `TEST_KYLIN_FACT`.`SELLER_ID` + 1 + 1{color} {color:#172b4d}after org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{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 > > error occurs conditions (all three conditions must be met): > * conformance = LENIENT > * The alias of the expression in select is the same as the column name of > the column used in the expression > * group by or having use the above expression > {color:#172b4d}a simple example is as follows:{color} > {color:#ff8b00}SELECT SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} > {color:#ff8b00}FROM TEST_KYLIN_FACT{color} > {color:#ff8b00}GROUP BY SELLER_ID + 1{color} > > {color:#172b4d}will change to {color} > {color:#ff8b00}SELECT `TEST_KYLIN_FACT`.`SELLER_ID` + 1 AS `SELLER_ID`, > SUM(`PRICE`) > FROM `DEFAULT`.`TEST_KYLIN_FACT` AS `TEST_KYLIN_FACT` > GROUP BY `TEST_KYLIN_FACT`.`SELLER_ID` + 1 + 1{color} > {color:#172b4d}after > org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{color} > {color:#172b4d}屏幕快照 2019-12-12 下午5.56.24.png{color} > -- This message was sent by Atlassian Jira (v8.3.4#803005)