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

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

    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: