[jira] [Created] (CALCITE-7530) FOR SYSTEM_TIME AS OF on CTE causes NPE while validation

[Sergey Nuyanzin (Jira)]

Sergey Nuyanzin created CALCITE-7530:
----------------------------------------

             Summary: FOR SYSTEM_TIME AS OF on CTE causes NPE while validation
                 Key: CALCITE-7530
                 URL: https://issues.apache.org/jira/browse/CALCITE-7530
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sergey Nuyanzin
            Assignee: Sergey Nuyanzin


Example to repro
{code:java}
  @Test void testSnapshotOnCteOverTemporalTable() {
    final String sql ="with cte as (select * from products_temporal)\n" +
        "select * from cte for system_time as of\n" +
        "   TIMESTAMP '2026-01-01 00:00:00'";
    sql(sql).ok();
  }
{code}

fails with NPE
{noformat}
java.lang.NullPointerException: ns.getTable() for 
org.apache.calcite.sql.validate.IdentifierNamespace@51c11c73
        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:5999)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1290)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3732)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4245)
        at 
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62)
        at 
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96)
{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)