[
https://issues.apache.org/jira/browse/CALCITE-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7305:
------------------------------------
Labels: pull-request-available (was: )
> Subqueries in ASOF JOIN MATCH_CONDITION cause an assertion failure
> ------------------------------------------------------------------
>
> Key: CALCITE-7305
> URL: https://issues.apache.org/jira/browse/CALCITE-7305
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.41.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
>
> The following test fails with an assertion failure:
> {code:java}
> WITH T1(id, intt) as (VALUES(1, 0)),
> T2(id, intt) AS (VALUES(1, 0)),
> T3(id) AS (VALUES(1))
> SELECT t1.id, t2.intt
> FROM T1 LEFT ASOF JOIN T2
> MATCH_CONDITION (t2.intt IN (SELECT id FROM T3))
> ON t1.id = t2.id {code}
> exception:
> {code:java}
> java.lang.NullPointerException: no SELECT scope for SELECT `ID`
> FROM `T3`
> at java.base/java.util.Objects.requireNonNull(Objects.java:360)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.getScope(SqlValidatorImpl.java:1224)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.getSelectScope(SqlValidatorImpl.java:1238)
> at
> org.apache.calcite.sql.validate.DelegatingScope.getOperandScope(DelegatingScope.java:237)
> at
> org.apache.calcite.sql.validate.SqlScopedShuttle.visit(SqlScopedShuttle.java:52)
> at
> org.apache.calcite.sql.validate.SqlScopedShuttle.visit(SqlScopedShuttle.java:37)
> at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:175) {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
