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

Osisoft translator - MAX and MIN on boolean column cause an error

XMLWordPrintable

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

      Running a query such as 

      SELECT MAX(BooleanValue) FROM BQT1.SmallA

      fails with the following exception:

      java.lang.ClassCastException: java.lang.Byte cannot be cast to java.lang.Boolean
        at com.osisoft.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:407)
        at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBoolean(WrappedResultSet.java:594)
        ... 22 more

      Same issue occurs when using MIN.

      Running an equivalent query directly against the Osisoft PI datasource returns the correct result, with the return type being int8 (i.e. byte)

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

                Created:
                Updated:
                Resolved: