[
https://issues.apache.org/jira/browse/CALCITE-3575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16989459#comment-16989459
]
小黑一点都不黑 commented on CALCITE-3575:
----------------------------------
你好像也是中国人，我直接讲中文了哈。用 example module 就能复现。参考
[https://calcite.apache.org/docs/tutorial.html] 这里，在 sqlline 中执行 select * from
(select deptno, empno, name, city from emps) a join depts b on a.deptno + 20 =
b.deptno; 这条语句就会报错。关键在于on 后面的 a.deptno + 20。
> 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)
