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

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

    Details

      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)

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: