You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/03/03 20:09:18 UTC

[jira] [Commented] (CALCITE-304) Support ' + ' operator

    [ https://issues.apache.org/jira/browse/CALCITE-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15178390#comment-15178390 ] 

Julian Hyde commented on CALCITE-304:
-------------------------------------

Added "dialect" label. We would support DATE + INTEGER only in Oracle compatibility mode.

> Support '<DATE> + <INTEGER>' operator
> -------------------------------------
>
>                 Key: CALCITE-304
>                 URL: https://issues.apache.org/jira/browse/CALCITE-304
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>              Labels: dialect
>
> We should support '<DATE> + <INTEGER>' operator. I'm not sure whether it is standard SQL, but it occurs in TPC-DS (query 72).
> Note that {{d + n}} is equivalent to {{d + interval n day}} if {{n}} is a constant.



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