[
https://issues.apache.org/jira/browse/PHOENIX-3440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15645505#comment-15645505
]
Eric Lomore commented on PHOENIX-3440:
--------------------------------------
[~maryannxue], what do you think about this? Based on what I've read, this is
fully intended by Calcite. Could we could add some logic to handle casting of
types in order to support this?
> Calcite has specific requirements for date and datetime operations
> ------------------------------------------------------------------
>
> 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 numerous
> failures in phoenix test cases.
> Just a few of many:
> testDateSubtractExpressionMetaData1
> testDateSubtractExpressionMetaData2
> testDateSubtractExpressionMetaData3
> testDateAdditionExpressionMetaData1
> testDateAdditionExpressionMetaData2
> testTwoDateSubtractExpressionMetaData
> These tests fail due to the difference in support.
> Summary of acceptable operations from the various exception codes:
> {code}
> Supported form(s):
> '<NUMERIC> - <NUMERIC>'
> '<NUMERIC> + <NUMERIC>'
> '<DATETIME_INTERVAL> - <DATETIME_INTERVAL>'
> '<DATETIME_INTERVAL> + <DATETIME_INTERVAL>'
> '<DATETIME> - <DATETIME_INTERVAL>'
> '<DATETIME> + <DATETIME_INTERVAL>'
> {code}
> Some of the incompatibilities thrown:
> {code}
> '<NULL> - <DATE>'
> '<NULL> + <DATE>'
> <INTEGER> + <DATE>
> <DATE> - <DECIMAL(2, 1)>
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
