Evgeny Stanilovsky created IGNITE-15603:
-------------------------------------------
Summary: Calcite. NPE on subquery returning multiple results.
Key: IGNITE-15603
URL: https://issues.apache.org/jira/browse/IGNITE-15603
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Evgeny Stanilovsky
{noformat}
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
{noformat}
{noformat}
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)
{noformat}
{noformat}
/subquery/scalar/test_correlated_subquery.test[_ignore]
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
