Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns ---------------------------------------------------------------------------------------- Key: TEIID-3539 URL: https://issues.jboss.org/browse/TEIID-3539 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1.6_2 Reporter: Filip Elias Assignee: Van Halbert Fix For: 8.7.1.6_2, 8.12 Attachments: server.log If I use IS NULL or IS NOT NULL operator for non-string column, the server will throw the following exception: {code} 10:42:34,100 ERROR [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue151) Connector worker process failed for atomic-request=1LH0VEAxBj0U.40.0.30: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[176] returned server error (status=0x85): org.hibernate.search.SearchException: Cannot create numeric range query for field byteNum, since from and to values are null at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298) at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88) at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74) at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:56) at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:57) at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:24) at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:50) at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:72) at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:62) at org.teiid.translator.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:112) {code}