You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2025/08/28 22:00:00 UTC
[jira] [Updated] (CALCITE-7149) Constant TIMESTAMPADD expression causes assertion failure in validator
[ https://issues.apache.org/jira/browse/CALCITE-7149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-7149:
------------------------------------
Labels: pull-request-available (was: )
> Constant TIMESTAMPADD expression causes assertion failure in validator
> ----------------------------------------------------------------------
>
> Key: CALCITE-7149
> URL: https://issues.apache.org/jira/browse/CALCITE-7149
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
>
> The following test in SqlToRelConverterTest causes an assertion failure:
> {code:java}
> sql("SELECT TIMESTAMPADD(DOY, 2, TIMESTAMP '2020-06-21 14:23:44.123')").ok();
> {code}
> stack trace:
> {code:java}
> java.lang.AssertionError: Conversion to relational algebra failed to preserve datatypes:
> validated type:
> RecordType(TIMESTAMP(3) NOT NULL EXPR$0) NOT NULL
> converted type:
> RecordType(TIMESTAMP(3) EXPR$0) NOT NULL
> rel:
> LogicalValues(tuples=[[{ null }]])
> at org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:524)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:643)
> at org.apache.calcite.sql.test.AbstractSqlTester.convertSqlToRel2(AbstractSqlTester.java:570)
> at org.apache.calcite.sql.test.AbstractSqlTester.assertSqlConvertsTo(AbstractSqlTester.java:511)
> at org.apache.calcite.sql.test.AbstractSqlTester.assertConvertsTo(AbstractSqlTester.java:489)
> at org.apache.calcite.test.SqlToRelFixture.convertsTo(SqlToRelFixture.java:106)
> at org.apache.calcite.test.SqlToRelFixture.ok(SqlToRelFixture.java:94)
> at org.apache.calcite.test.SqlToRelConverterTest.testTimestampAdd(SqlToRelConverterTest.java:1278)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)