Jan Stastny created TEIID-4223: ---------------------------------- Summary: Hana translator: incorrect pushdown of QUARTER function Key: TEIID-4223 URL: https://issues.jboss.org/browse/TEIID-4223 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Jan Stastny Assignee: Steven Hawkins Teiid's QUARTER function returns integer. SAP HANA's QUARTER function returns string in form: {code:plain} 2000-Q1 {code} So the function either shouldn't be pushed down, or it has to be pushed down together with some substring method wrapping it: {code:sql} SUBSTR_REGEXPR('[[:digit:]]{4}\-Q([[:digit:]]{1})' IN quarter(datevalue) GROUP 1) {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)