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