[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3589: Labels: pull-request-available (was: ) > 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 >Assignee: bingfeng.guo >Priority: Critical > Labels: pull-request-available > Attachments: 屏幕快照 2019-12-12 下午5.56.24.png > > > 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 SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} > {color:#ff8b00} FROM TEST_KYLIN_FACT{color} > {color:#ff8b00} GROUP BY SELLER_ID + 1 + 1{color} > {color:#172b4d}after > org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{color} > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] bingfeng.guo updated CALCITE-3589: -- Attachment: 屏幕快照 2019-12-12 下午5.56.24.png > 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 > Attachments: 屏幕快照 2019-12-12 下午5.56.24.png > > > 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 SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} > {color:#ff8b00} FROM TEST_KYLIN_FACT{color} > {color:#ff8b00} GROUP BY SELLER_ID + 1 + 1{color} > {color:#172b4d}after > org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{color} > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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 SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} {color:#ff8b00} FROM TEST_KYLIN_FACT{color} {color:#ff8b00} GROUP BY SELLER_ID + 1 + 1{color} {color:#172b4d}after org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{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} {color:#172b4d}屏幕快照 2019-12-12 下午5.56.24.png{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 SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} > {color:#ff8b00} FROM TEST_KYLIN_FACT{color} > {color:#ff8b00} GROUP BY SELLER_ID + 1 + 1{color} > {color:#172b4d}after > org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{color} > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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} 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 MY_ID + 1 AS MY_ID, sum(PRICE){color} {color:#ff8b00}FROM tableA{color} {color:#ff8b00}GROUP BY MY_ID + 1{color} {color:#ff8b00}will {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} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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 MY_ID + 1 AS MY_ID, sum(PRICE){color} {color:#ff8b00}FROM tableA{color} {color:#ff8b00}GROUP BY MY_ID + 1{color} {color:#ff8b00}will {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 > > 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 MY_ID + 1 AS MY_ID, sum(PRICE){color} > {color:#ff8b00}FROM tableA{color} > {color:#ff8b00}GROUP BY MY_ID + 1{color} > {color:#ff8b00}will {color} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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}sql 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)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] bingfeng.guo updated CALCITE-3589: -- Priority: Critical (was: Minor) > 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}sql 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)
[jira] [Updated] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT
[ 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}sql 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:#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: Minor > > {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}sql 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)