[
https://issues.apache.org/jira/browse/CALCITE-3575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16989463#comment-16989463
]
小黑一点都不黑 commented on CALCITE-3575:
----------------------------------
本质上是下推优化少做了一些事，导致计算 join 右表中字段的偏移的时候算错了，右表的偏移等于 left 的 字段数，这个例子中应该是4（左边子查询有 4
列），但是这个下推优化会让这里得出错误的值，这个错误值是 emps 表的字段数。
> JOIN pushDownJoinConditions BUG
> -------------------------------
>
> Key: CALCITE-3575
> URL: https://issues.apache.org/jira/browse/CALCITE-3575
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.18.0, 1.19.0, 1.20.0, 1.21.0
> Reporter: 小黑一点都不黑
> Priority: Critical
> Attachments: image-2019-12-06-14-30-26-738.png
>
>
> In the case, a join statement with equal condition and left is expression
> instead of column, will fire the bug. the reason is pushDownJoinConditions
> method does't add left project node to SqlToRelConverter.leaves。
> My english is poor, did I make myself clear?
> !image-2019-12-06-14-30-26-738.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
