Mihai Budiu created CALCITE-7305:
------------------------------------
Summary: 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
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)
