[
https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16993712#comment-16993712
]
Julian Hyde commented on CALCITE-3589:
--------------------------------------
What does postgresql do with a similar query? Group by the underlying column,
or the expression, or give an error?
Can you change the description to indicate that the case is grouping by an
expression on an alias.
> 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)
