Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5320

SAP IQ translator wrong pushdown of dateadd function

XMLWordPrintable

      SAP IQ translator's pushdown of DATEADD function is wrong.

      The function DATEADD has following signature in SAP IQ:

      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

              rhn-engineering-shawkins Steven Hawkins
              jstastny@redhat.com Jan Stastny
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: