[
https://issues.apache.org/jira/browse/CALCITE-7149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18017726#comment-18017726
]
Mihai Budiu commented on CALCITE-7149:
--------------------------------------
I will merge a solution which rejects such queries.
> 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)
