[teiid-issues] [JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327
Ivan Semenov (JIRA)
issues at jboss.org
Thu Jul 19 06:17:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ivan Semenov reopened TEIID-5419:
---------------------------------
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)
More information about the teiid-issues
mailing list