[ https://issues.apache.org/jira/browse/IGNITE-13772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stanilovsky Evgeny updated IGNITE-13772: ---------------------------------------- Description: Such kind of requests can rise NPE: {code:java} 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 {code} {code:java} 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) {code} additionally failed *testFullOuterJoin*: {code:java} 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) {code} was: Such kind of requests can rise NPE: {code:java} 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 {code} {code:java} 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) {code} > Calcite bug. RightJoin can fail with NPE. > ----------------------------------------- > > Key: IGNITE-13772 > URL: https://issues.apache.org/jira/browse/IGNITE-13772 > Project: Ignite > Issue Type: Improvement > Components: sql > Affects Versions: 2.9 > Reporter: Stanilovsky Evgeny > Assignee: Stanilovsky Evgeny > Priority: Major > Labels: calcite > > Such kind of requests can rise NPE: > {code:java} > 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 > {code} > {code:java} > 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) > {code} > additionally failed *testFullOuterJoin*: > {code:java} > 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) > {code} > -- This message was sent by Atlassian Jira (v8.3.4#803005)