[teiid-issues] [JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

[Ivan Semenov (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13608004#comment-13608004 ] 

Ivan Semenov edited comment on TEIID-5419 at 7/19/18 8:15 AM:
--------------------------------------------------------------

I'm not sure if this is completely resolved
{code:sql}
select hire_date, timestampadd(SQL_TSI_QUARTER, 2, hire_date) from HR.employees where employee_id = 100
{code}
hire_date here is "2003-06-*17* 00:00:00.0"
while timestampadd(SQL_TSI_QUARTER, 2, hire_date) renders "2003-12-*16* 00:00:00.0"
i.e. 1 day less than 6 months' difference


was (Author: isemenov):
I'm not sure this is completely resolved
{code:sql}
select hire_date, timestampadd(SQL_TSI_QUARTER, 2, hire_date) from HR.employees where employee_id = 100
{code}
hire_date here is "2003-06-*17* 00:00:00.0"
while timestampadd(SQL_TSI_QUARTER, 2, hire_date) renders "2003-12-*16* 00:00:00.0"
i.e. 1 day less than 6 months difference

>  timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327
> --------------------------------------------------------------------
>
>                 Key: TEIID-5419
>                 URL: https://issues.jboss.org/browse/TEIID-5419
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 10.3
>         Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) 
>            Reporter: Ivan Semenov
>            Assignee: Steven Hawkins
>             Fix For: 11.1, 11.0.1, 10.3.3
>
>
> After adding support for timestampadd() pushdown to Oracle in TEIID-5327 -  Oracle is throwing errors for some pushed queries



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)