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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.12.11.6_4, 10.1
    • 8.12.11.6_4
    • JDBC Connector
    • None

      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'.

              rhn-engineering-rareddy Ramesh Reddy
              asmigala@redhat.com Andrej Smigala
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: