[jira] [Created] (PHOENIX-3440) Calcite doesn't allow numbers to be subtracted from dates

["Eric Lomore (JIRA)" <ji...@apache.org>]

Eric Lomore created PHOENIX-3440:
------------------------------------

             Summary: Calcite doesn't allow numbers to be subtracted from dates
                 Key: PHOENIX-3440
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3440
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Eric Lomore
            Priority: Minor


This popped up just today in the Calcite mailing list, and I noticed some test failures in Phoenix due to it.

testDateSubtractExpressionMetaData1
testDateSubtractExpressionMetaData1
testDateSubtractExpressionMetaData1

These tests fail due to the difference in support.

Summary of the exception:
{code}
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot apply '-' to arguments of type '<DATE> - <DECIMAL(2, 1)>'. 
Supported form(s): 
'<NUMERIC> - <NUMERIC>'
'<DATETIME_INTERVAL> - <DATETIME_INTERVAL>'
'<DATETIME> - <DATETIME_INTERVAL>'
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)