Bug 1238869

Summary: Cannot perform IS [NOT] NULL search on non-string columns
Product: [JBoss] JBoss Data Grid 6 Reporter: Van Halbert <vhalbert>
Component: Infinispan, ServerAssignee: Tristan Tarrant <ttarrant>
Status: NEW --- QA Contact: Martin Gencur <mgencur>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.4.0CC: jdg-bugs
Target Milestone: ---   
Target Release: 6.6.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 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: 1256889    
Bug Blocks: 1232649    

Comment 5 Van Halbert 2015-07-02 21:46:14 UTC
The following are 3 columns that were queried but didn't work:

- timeValue is Null

- booleanvalue Is Not Null

- intKey Is Not Null



The following is the 1 query that did work:

- stringNum Is Not Null

Comment 6 Adrian Nistor 2015-08-18 12:47:41 UTC
The indexing and querying is implemented via Hibernate Search which sits on top of Lucene. Lucene has no concept of null. Null is emulated by Hibernate Search by using a special (non-null) string marker value (the dreaded null token), but this only works for strings; for other types this fails silently. This limitation cannot be solved with Lucene 3.6 and 4. A better approach might be possible with 5.