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 Fix For: 9.0, 8.12.5, 8.13.5 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}