[
https://issues.apache.org/jira/browse/CALCITE-7530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18081227#comment-18081227
]
Sergey Nuyanzin commented on CALCITE-7530:
------------------------------------------
Thank you for the review [~mbudiu]
> 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
> Priority: Major
> Labels: pull-request-available
>
> 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)
