[
https://issues.apache.org/jira/browse/CALCITE-2614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16644242#comment-16644242
]
James Duong commented on CALCITE-2614:
--------------------------------------
I'm open to moving this into RexSimplify.
Adding interval literals shows up in popular benchmarks like TPCH (or TPCDS). I
haven't seen the integer literal arithmetic show up in these tools.
> Converting datetime_plus to timestampadd should be done recursively
> -------------------------------------------------------------------
>
> Key: CALCITE-2614
> URL: https://issues.apache.org/jira/browse/CALCITE-2614
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: James Duong
> Assignee: Julian Hyde
> Priority: Major
>
> The method in RexUtil convertDatetimePlusToTimestampAdd() should handle the
> case where the timestamp operand is another call to Datetime_plus. (eg SELECT
> <date_column> - interval '1' hour - interval '1' hour)
> This can be impemented by having the datetime operand accept the same visitor.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
