[jira] [Created] (DRILL-5637) Date arith using literals SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created DRILL-5637:
---------------------------------

             Summary: Date arith using literals SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes
                 Key: DRILL-5637
                 URL: https://issues.apache.org/jira/browse/DRILL-5637
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10
            Reporter: N Campbell


Use any file with one row in it.

Submit the following statement to Drill which is performing interval arith on a date using literals.

select DATE '2000-01-29' +  INTERVAL -'1' YEAR from dfs.certp.TVERSION

Error: SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(TIMESTAMP(0) NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(DATE NOT NULL EXPR$0) NOT NULL
rel:
LogicalProject(EXPR$0=[DATETIME_PLUS(2000-01-29, -12)])
  LogicalTableScan(table=[[dfs, certp, TVERSION]])




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)