Sergey Nuyanzin created CALCITE-7026:
----------------------------------------
Summary: Validation of snapshot for join of CTEs fails with NPE
Key: CALCITE-7026
URL: https://issues.apache.org/jira/browse/CALCITE-7026
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Sergey Nuyanzin
To reproduce
in {{SqlValidatorTest#testTemporalTable}} add
{code:java}
sql("with t1 as (select stream * from orders), t2 as (select * from
products_temporal)\n"
+ "select * from t1 left join t2\n"
+ "for system_time as of CURRENT_TIMESTAMP\n"
+ "on t1.productid = t2.productid").ok();
{code}
if fails as
{noformat}
java.lang.NullPointerException: ns.getTable() for
org.apache.calcite.sql.validate.IdentifierNamespace@28b34c55
at java.util.Objects.requireNonNull(Objects.java:290)
at
org.apache.calcite.sql.validate.SqlNonNullableAccessors.getTable(SqlNonNullableAccessors.java:94)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSnapshot(SqlValidatorImpl.java:5882)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1202)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3634)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3740)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3622)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4127)
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
