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

SAP IQ translator wrong pushdown of dateadd function

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: