Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1232649

Summary: Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Elias <felias>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED DUPLICATE QA Contact: Filip Elias <felias>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
DV 6.2 ER2
Last Closed: 2015-07-06 12:37:29 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1238869    
Bug Blocks:    
Attachments:
Description Flags
Server log none

Description Filip Elias 2015-06-17 08:56:05 UTC
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)

Comment 1 Van Halbert 2015-06-26 18:47:11 UTC
Unable to get the solution implemented.  More research has to be done.

Will look to get it in for post ER3 build.

Comment 2 Van Halbert 2015-07-02 21:05:50 UTC
This issue has now been logged with JDG to determine why hot rod client is failing.

Comment 3 Van Halbert 2015-07-06 12:37:29 UTC

*** This bug has been marked as a duplicate of bug 1232282 ***

Comment 4 JBoss JIRA Server 2015-07-29 19:05:37 UTC
Van Halbert <vhalbert> updated the status of jira TEIID-3539 to Resolved

Comment 5 JBoss JIRA Server 2015-10-11 14:18:28 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3539 to Closed