Bug 1312264 - Vertica and DB2 translators use incorrect push down of WEEK function
Summary: Vertica and DB2 translators use incorrect push down of WEEK function
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ER1
: 6.3.0
Assignee: Van Halbert
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-02-26 09:25 UTC by Andrej Smigala
Modified: 2016-08-24 11:49 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-24 11:49:54 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4003 0 Major Resolved Vertica and DB2 translators use incorrect push down of WEEK function 2016-04-20 12:34:40 UTC

Description Andrej Smigala 2016-02-26 09:25:29 UTC 
TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour.

The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set.

This results in the query (the datevalue in question is 2000-12-31)

select week(datevalue) from source.largea where intkey = 365

to return 54, when the correct value is 52.
Comment 2 JBoss JIRA Server 2016-02-26 15:40:54 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4003 to Resolved
Comment 3 Van Halbert 2016-03-09 15:52:49 UTC 
Included in ER1.2 build.
Note You need to log in before you can comment on or make changes to this bug.