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