[
https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17895193#comment-17895193
]
yanjing.wang commented on CALCITE-4512:
---------------------------------------
Hello [~julianhyde] , I apologize for the interruption, but I wanted to check
if you are currently reviewing this PR. If you are unavailable, would it be
possible for us to merge it in the meantime? If any issues arise, we can
address them by creating another PR to fix them. Thank you!
> GROUP BY expression with argument name same with SELECT field and 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.37.0
> Environment: jvm: open-jdk11
> Reporter: yanjing.wang
> Assignee: yanjing.wang
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.39.0
>
> Time Spent: 3h
> Remaining Estimate: 0h
>
> {code:java}
> String sql = "select replace(name, 'a', 'b') as name from users group by
> replace(name, 'a', 'b')";
> {code}
>
> 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
> {code:java}
> String sql = "select replace(name, 'a', 'b') as name from users group by
> replace(replace(name, 'a', 'b'), 'a', 'b')";
> {code}
>
> this is unexpected.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
