[teiid-issues] [JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327
[
https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin...
]
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)