Andrej Šmigala created TEIID-5194: ------------------------------------- Summary: Osisoft translator - MAX and MIN on boolean column cause an error Key: TEIID-5194 URL: https://issues.jboss.org/browse/TEIID-5194 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.x-6.4 Reporter: Andrej Šmigala Assignee: Steven Hawkins Running a query such as {code:sql} SELECT MAX(BooleanValue) FROM BQT1.SmallA {code} fails with the following exception: {noformat} 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 {noformat} 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) -- This message was sent by Atlassian JIRA (v7.5.0#75005)