[
https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17505138#comment-17505138
]
Julian Hyde commented on CALCITE-4512:
--------------------------------------
There's a related behavior. Postgres throws if you reference an alias from
GROUP BY and that alias is also the name of more than one column:
{code}
select length(ename) as deptno, count(*) from emp, dept group by deptno;
ERROR: column reference "deptno" is ambiguous Position: 66
{code}
As part of the fix, we should add a similar test.
[~yanjing.wang], What is the PR? I just checked 2408 and it's empty.
Can you also work on the Jira subject. Capitalize keywords, and describe the
case more precisely.
> group by expression has argument name same with select list item alias,
> causes validation error
> -----------------------------------------------------------------------------------------------
>
> Key: CALCITE-4512
> URL: https://issues.apache.org/jira/browse/CALCITE-4512
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.26.0
> Environment: jvm: open-jdk8
> Reporter: yanjing.wang
> Priority: Major
> Labels: pull-request-available
> Time Spent: 2h 20m
> Remaining Estimate: 0h
>
> String sql = "select replace(name, 'a', 'b') as name from users group by
> replace(name, 'a', 'b')";
>
> when group by expression has argument name same with select list item alias,
> the group by argument will be expanded to select list item when sql
> conformance supports 'groupByAlias', so the above sql will be expanded to
> String sql = "select replace(name, 'a', 'b') as name from users group by
> replace(replace(name, 'a', 'b'), 'a', 'b')";
>
> this is unexpected.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
