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

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

    XMLWordPrintable

Details

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

    Description

      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)

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: