[teiid-issues] [JBoss JIRA] (TEIID-5320) SAP IQ translator wrong pushdown of dateadd function

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5320.
-----------------------------------
    Fix Version/s: 10.3
                   10.2.1
       Resolution: Done


Updated the modify to output the part as a literal or as a keyword.

> 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
>             Fix For: 10.3, 10.2.1
>
>
> 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.dc38159.1600/doc/html/san1277395118633.html



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)