[jira] [Commented] (CALCITE-4512) GROUP BY expression with argument name same with SELECT field and alias causes validation error

["Andrei Sereda (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17549503#comment-17549503 ] 

Andrei Sereda commented on CALCITE-4512:
----------------------------------------

Hello,

Please let me know if you want this issue to be included in the next Calcite release 1.31.

If so, do you think it can be resolved in 1-2 weeks ?

Our goal is to create an RC mid-June.

Thanks.

> 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.26.0
>         Environment: jvm: open-jdk8
>            Reporter: yanjing.wang
>            Assignee: yanjing.wang
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.31.0
>
>          Time Spent: 2.5h
>  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.7#820007)