Vertica and DB2 translators use incorrect push down of WEEK function -------------------------------------------------------------------- Key: TEIID-4003 URL: https://issues.jboss.org/browse/TEIID-4003 Project: Teiid Issue Type: Bug Components: JDBC Connector Reporter: Andrej Šmigala Assignee: Steven Hawkins Fix For: 9.0, 8.12.5, 8.13.2 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) {code:sql} select week(datevalue) from source.largea where intkey = 365 {code} to return 54, when the correct value is 52.