[
https://issues.apache.org/jira/browse/CALCITE-4913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17452937#comment-17452937
]
Stamatis Zampetakis commented on CALCITE-4913:
----------------------------------------------
Thanks for the PR [~korlov], in order to facilitate the review can you put in
the description the SQL query, the respective (problematic) plan? If it causes
wrong results then please include expected and actual results. It would be good
also to add a test in sub-query.iq or another similar place to ensure that the
query actually runs and produces the expected results.
> Correlated variables in a select list are not deduplicated
> ----------------------------------------------------------
>
> Key: CALCITE-4913
> URL: https://issues.apache.org/jira/browse/CALCITE-4913
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.28.0
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
>
> Currently, the deduplication of correlated variables ain't done for
> correlates in select list. Looks like the root cause here is same as for
> CALCITE-4673, but, unfortunately, suggested patch has addressed only the
> particular problem with a table function. It would be great to provide a more
> gereric fix.
> Besides, the project rel doesn't expose any correlated variables that should
> be set by this node
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
