[
https://issues.apache.org/jira/browse/CALCITE-4287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruben Q L resolved CALCITE-4287.
--------------------------------
Resolution: Fixed
Fixed via
https://github.com/apache/calcite/commit/c84dd53414ddb20fcd0817dd1f064812546e6acc
Thanks for the patch [~fan_li_ya]!
> AggregateJoinRemoveRule and ProjectJoinRemoveRule are not fired if the last
> column of the join's left input is referenced
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-4287
> URL: https://issues.apache.org/jira/browse/CALCITE-4287
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Liya Fan
> Assignee: Liya Fan
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.26.0
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> In some rules (e.g. {{AggregateJoinRemoveRule#onMatch)}}, the logic of
> checking if the aggregate references any columns from the other side is
> incorrect.
> For example, given an aggregate on a left join, the logic checks if the
> aggregate references any columns from the right side. If the aggregate
> happens to references the last column of the left input, the current
> implementation will make a wrong decision to skip the rule match.
> This will miss opportunities of simplifying the plan.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
