[IGNITE-16228] Calcite engine. SetOp execution node cannot be rewinded

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 28/Dec/21 14:56
• Updated: 04/Mar/22 12:53
• Resolved: 29/Dec/21 06:31

Description

Reproducer:

executeSql("CREATE TABLE test(i INTEGER)");
executeSql("INSERT INTO test VALUES (1), (2)");
assertQuery("SELECT (SELECT test.i EXCEPT SELECT 0) FROM test")
    .returns(1)
    .returns(2)
    .check();

Throws:

Caused by: java.lang.IndexOutOfBoundsException: Index: 2, Size: 2
    at java.util.ArrayList.rangeCheck(ArrayList.java:657)
    at java.util.ArrayList.get(ArrayList.java:433)
    at org.apache.ignite.internal.processors.query.calcite.exec.rel.AbstractSetOpNode.request(AbstractSetOpNode.java:76)

Issue Links

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