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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: