lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Wellner Bou <>
Subject Unexpected search results with date range queries and OR
Date Wed, 24 Jul 2013 15:29:37 GMT
Dear Solr-list,

We are experimenting an unexpected behaviour of solr using date range
queries combined with OR. The use case is (reduced to this simple
example): We want to get all content which does not have the offTime
field defined or, if the offTime field is defined, it should be in the

1) This query gives 1776 results: *
2) This query gives 707 results: (NOT offTime:[* TO *])
3) This query gives 1304 results: (offTime:[2013-07-24T14:35:46.319Z TO *])

Query 2 and 3 should not overlap at all, as 3) assumes something in
the field, any date from now on. And 2) searches all content whithout
any value in this field, is this correct?

Combining these two query with OR I would expect to get 1304+707
results, but comining them I get 1304 results. Not more. This is the
union query:

(offTime:[2013-07-24T14:35:46.319Z TO *]) OR (NOT offTime:[* TO *])

I tried this with additional filters as well to reduce the number of
items, and it seems that query 3) is overriding query 2) always, even
if query 2) returns much more results than query 3). I can reproduce
this, when adding such a filter:

Query 2) 118 results
Query 3) 1 result
Query 2) OR Query 3): 1 result

Are we doing something wrong?

Thank you and kind regards

View raw message