Jan Stastny created TEIID-5320: ---------------------------------- Summary: SAP IQ translator wrong pushdown of dateadd function Key: TEIID-5320 URL: https://issues.jboss.org/browse/TEIID-5320 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.13.6_4 Reporter: Jan Stastny Assignee: Steven Hawkins SAP IQ translator's pushdown of DATEADD function is wrong. The function DATEADD has following signature in SAP IQ: bq. DATEADD ( date-part, numeric-expression, date-expression ) the date-part is of type Date Part, see (1). Teiid is currently pushing DATEADD function with date-part argument as string, which causes an error. It should be Date Part identifier, e.g. instead of 'DAY', it should be DAY. (1) http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.... -- This message was sent by Atlassian JIRA (v7.5.0#75005)