[
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)
