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

Osisoft Translator - Teiid pushes cast from Boolean to Single/Double

    XMLWordPrintable

    Details

      Description

      Osisoft PI does not support conversion from Boolean to Single or Double, however, query such as

      select cast(booleanvalue as float) from Source.smalla
      

      is pushed as

      SELECT cast(g_0.BooleanValue AS Single) AS c_0 FROM dvqe..SmallA AS g_0
      

      which results in

      com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 1:14] Cannot cast 'Boolean' to 'Single'.
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                asmigala Andrej Šmigala
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: