[IGNITE-15603] Calcite. NPE on subquery returning multiple results.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite
• Assignee: Vladimir Steshin
• Reporter: Evgeny Stanilovsky
• Created: 27/Sep/21 06:28
• Updated: 28/Feb/22 09:47
• Resolved: 25/Nov/21 05:58

Description

statement ok
CREATE TABLE integers(i INTEGER)

statement ok
INSERT INTO integers VALUES (1), (2), (3), (NULL)

query II
SELECT i, (SELECT 42+i1.i FROM integers) AS j FROM integers i1 ORDER BY i;
----
NULL	NULL
1	43
2	44
3	45

statement ok
CREATE TABLE integers(i INTEGER)

statement ok
INSERT INTO integers VALUES (1), (2), (3), (NULL)

# aggregate with correlation in final projection
query II
SELECT i, (SELECT MIN(i)+i1.i FROM integers) FROM integers i1 ORDER BY i;
----
NULL	NULL
1	2
2	3
3	4

 Error occurred during execution: java.lang.NullPointerException
	at o.a.i.i.processors.query.calcite.exec.ArrayRowHandler.get(ArrayRowHandler.java:36)
	at o.a.i.i.processors.query.calcite.exec.ArrayRowHandler.get(ArrayRowHandler.java:27)
	at SC.execute(Unknown Source)
	at o.a.i.i.processors.query.calcite.exec.exp.ExpressionFactoryImpl$ProjectImpl.apply(ExpressionFactoryImpl.java:473)
	at o.a.i.i.processors.query.calcite.exec.TableScan$IteratorImpl.advance(TableScan.java:273)
	at o.a.i.i.processors.query.calcite.exec.TableScan$IteratorImpl.hasNextX(TableScan.java:221)

/subquery/scalar/test_correlated_subquery.test[_ignore]
/subquery/scalar/test_correlated_aggregate_subquery.test[_ignore]
/subquery/scalar/test_many_correlated_columns.test[_ignore]

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• relates to: IGNITE-15982 Calcite engine. Correlates passes through table spools
• links to: GitHub Pull Request #9593
• links to: GitHub Pull Request #9606