[
https://issues.apache.org/jira/browse/OPTIQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated OPTIQ-304:
------------------------------
Description:
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.
was:
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 [code]d + n[/code] is equivalent to [code]d + interval n day[/code]
if n is a constant.
> Support '<DATE> + <INTEGER>' operator
> -------------------------------------
>
> Key: OPTIQ-304
> URL: https://issues.apache.org/jira/browse/OPTIQ-304
> Project: optiq
> Issue Type: Bug
> Reporter: Julian Hyde
>
> 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.2#6252)
