You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2021/11/29 13:23:00 UTC
[jira] [Commented] (IGNITE-15603) Calcite. NPE on subquery returning multiple results.
[ https://issues.apache.org/jira/browse/IGNITE-15603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17450445#comment-17450445 ]
Aleksey Plekhanov commented on IGNITE-15603:
--------------------------------------------
I've unignored corresponding script tests (PR 9606), merged to sql-calcite branch too.
> 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
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: calcite, calcite3-required, ignite-3
> Time Spent: 4.5h
> Remaining Estimate: 0h
>
> {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}
> 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
> {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]
> /subquery/scalar/test_correlated_aggregate_subquery.test[_ignore]
> /subquery/scalar/test_many_correlated_columns.test[_ignore]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)