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

Osisoft Translator - Wrong pushdown of LENGTH function

    Details

      Description

      The LENGTH function is pushed down to Osisoft PI as-is, but fails on the datasource with

      com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 0:4294967295] Function name 'length' is invalid.
      

      This seems to be a mistake in PI OLEDB Enterprise 2016 User Guide, as this document mentions on page 32 that LENGTH is an alias for LEN.

      However, since LEN actually works, I suggest changing the pushdown in teiid as a workaround.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                asmigala Andrej Smigala
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: