[
https://issues.apache.org/jira/browse/CALCITE-1632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-1632.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.12.0
Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d8c4d73f.
> Return types of datetime + interval
> -----------------------------------
>
> Key: CALCITE-1632
> URL: https://issues.apache.org/jira/browse/CALCITE-1632
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: 1.12.0
>
>
> Per the SQL standard, the return type of "datetime + interval" is the same as
> the type of "datetime". (Postgres, for instance, always widens the result to
> TIMESTAMP; this is wrong.)
> Also, when adding or subtracting to a TIME value, make sure the result stays
> within the range 00:00:00..23:59:59.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
