[CALCITE-3575] IndexOutOfBoundsException when converting sql to rel

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.18.0, 1.19.0, 1.20.0, 1.21.0
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: 小黑一点都不黑
• Created: 06/Dec/19 06:29
• Updated: 06/Mar/20 04:34
• Resolved: 12/Dec/19 13:32

Description

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? 

Issue Links

• relates to: CALCITE-3571 RelBuilder#shouldMergeProject throws an exception for JOIN with complex conditions
• links to: GitHub Pull Request #1646