[jira] [Created] (CALCITE-7149) Constant TIMESTAMPADD expression causes assertion failure in validator

[Mihai Budiu (Jira)]

Mihai Budiu created CALCITE-7149:
------------------------------------

             Summary: 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


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)