[IGNITE-23345] Calcite engine. Correlated nested loop LEFT join failure

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.14
• Fix Version/s: 2.17
• Labels: calcite ignite-2 ise
• Release Note: SQL Calcite: Fixed correlated nested loop LEFT join failure
• Ignite Flags: Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 02/Oct/24 18:56
• Updated: 04/Oct/24 06:23
• Resolved: 04/Oct/24 06:23

Description

Some combination of left/right inputs size can lead to failure of correlated nested loop LEFT join:

Caused by: java.lang.AssertionError: null
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.CorrelatedNestedLoopJoinNode.request(CorrelatedNestedLoopJoinNode.java:130)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.FilterNode.filter(FilterNode.java:135)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.FilterNode.push(FilterNode.java:82)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.CorrelatedNestedLoopJoinNode.join(CorrelatedNestedLoopJoinNode.java:434)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.CorrelatedNestedLoopJoinNode.onEndRight(CorrelatedNestedLoopJoinNode.java:372)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.CorrelatedNestedLoopJoinNode.endRight(CorrelatedNestedLoopJoinNode.java:255)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.CorrelatedNestedLoopJoinNode$2.end(CorrelatedNestedLoopJoinNode.java:182)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.ScanNode.processNextBatch(ScanNode.java:185)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.ScanNode.push(ScanNode.java:145)

Root cause is described at related IGNITE-21722 ticket for AI3

Issue Links

• relates to: IGNITE-21722 Sql. NPE in correlated nested loop join
• links to: PullHub Request #11565