]
RH Bugzilla Integration updated TEIID-5320:
-------------------------------------------
Bugzilla References:
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....