Hibernate Community • View topic - Records with null values in a field should not be returned

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

Records with null values in a field should not be returned

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

seemarich

Post subject: Records with null values in a field should not be returned

Posted: Thu Jun 11, 2009 12:23 am

Beginner

Joined: Tue Feb 03, 2009 12:29 pm
Posts: 49

hi,

We have a certain field in our DB which may contain null values. As we all know, null values are not indexed. One of the search criteria is that the records which have null value for this particular field should not be returned. Keeping marker values in the DB instead of null might not be possible. Is there any other way to perform this check?

Thanks,
Seema

Top

hardy.ferentschik

Post subject: Re: Records with null values in a field should not be returned

Posted: Thu Jun 11, 2009 2:39 am

Hibernate Team

Joined: Thu Apr 05, 2007 5:52 am
Posts: 1689
Location: Sweden

This Jira issue might be relevant for you - http://opensource.atlassian.com/project ... SEARCH-115 It discusses the possibility to index null values and the problems it would introduce.

Independent of this issue you can always handle your case with a custom bridge, provided that you can guarantee that you won't get any ambiguities in your data.

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum