[IGNITE-13772] Calcite bug. RightJoin can fail with NPE.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.9
• Component/s: sql
• Labels: calcite
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 28/Nov/20 14:38
• Updated: 06/Aug/21 15:26
• Resolved: 10/Dec/20 16:32

Description

Such kind of requests can rise NPE:

SELECT TABLE_F041_04_01_011.A, TABLE_F041_04_01_012.A FROM TABLE_F041_04_01_011 RIGHT JOIN TABLE_F041_04_01_012 ON TABLE_F041_04_01_011.A = TABLE_F041_04_01_012.A

Caused by: java.lang.NullPointerException
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode$RightJoin.join(NestedLoopJoinNode.java:528)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode.endLeft(NestedLoopJoinNode.java:203)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode.access$100(NestedLoopJoinNode.java:35)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode$1.end(NestedLoopJoinNode.java:125)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:317)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:213)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:180)
	at org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:222)
	at org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.lambda$init$3(ExchangeServiceImpl.java:148)
	at org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:276)
	at org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.lambda$onMessage$0(MessageServiceImpl.java:256)

additionally failed testFullOuterJoin:

Caused by: java.lang.NullPointerException
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode$FullOuterJoin.join(NestedLoopJoinNode.java:660)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode.endLeft(NestedLoopJoinNode.java:203)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode.access$100(NestedLoopJoinNode.java:35)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode$1.end(NestedLoopJoinNode.java:125)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.ScanNode.push(ScanNode.java:138)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.ScanNode.doPush(ScanNode.java:75)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #8511
• links to: GitHub Pull Request #8518