Created attachment 1039813 [details] Server log If I use IS NULL or IS NOT NULL operator for non-string column, the server will throw the following exception: 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)
Unable to get the solution implemented. More research has to be done. Will look to get it in for post ER3 build.
This issue has now been logged with JDG to determine why hot rod client is failing.
*** This bug has been marked as a duplicate of bug 1232282 ***
Van Halbert <vhalbert> updated the status of jira TEIID-3539 to Resolved
Steven Hawkins <shawkins> updated the status of jira TEIID-3539 to Closed