Bug 1312264

Summary:	Vertica and DB2 translators use incorrect push down of WEEK function
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Andrej Smigala <asmigala>
Component:	Teiid	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Andrej Smigala <asmigala>
Severity:	high	Docs Contact:
Priority:	medium
Version:	6.3.0	CC:	aszczucz, blafond, jolee, mbaluch, thauser, vhalbert
Target Milestone:	ER1
Target Release:	6.3.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-08-24 11:49:54 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.