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

Osisoft Translator - Casting to bigdecimal results in NULL value

    Details

      Description

      Casting any value obtained from an Osisoft PI datasource results in NULL, regardless of the original value.
      E.g. a query such as

      select cast(stringnum as bigdecimal), cast(intnum as bigdecimal), cast(shortvalue as bigdecimal) from Source.smalla
      

      returns result set full of NULLs.

      The SOURCE SRC COMMAND in teiid-command.log for this query is however

      SELECT g_0.StringNum, g_0.IntNum, g_0.ShortValue FROM dvqe..SmallA AS g_0
      

      i.e. the cast is not pushed down (as Osisoft doesn't support bigdecimal datatype).

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: