Query DSL: Wrong result on bool filter with 'must' and 'should' clauses #2979
Assignees
Labels
Comments
ghost
assigned 
|
This is a bug. I will fix it soon. |
Closed
martijnvg
added a commit
to martijnvg/elasticsearch
that referenced
this issue
May 3, 2013
… match the must or must_not clause a match again. Relates to elastic#2979
martijnvg
added a commit
that referenced
this issue
May 3, 2013
… match the must or must_not clause a match again. Relates to #2979
martijnvg
added a commit
that referenced
this issue
May 3, 2013
… match the must or must_not clause a match again. Relates to #2979
martijnvg
added a commit
to martijnvg/elasticsearch
that referenced
this issue
May 3, 2013
… match the must or must_not clause a match again. Relates to elastic#2979
mute
pushed a commit
to mute/elasticsearch
that referenced
this issue
Jul 29, 2015
… match the must or must_not clause a match again. Relates to elastic#2979
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ES version is 0.90.0 (from deb package). Count of products in test - 667 (333 in stock and 334 out of stock). 50 products was added less than a month ago (37 in stock and 13 out of stock). One product (in stock) have a "Hot Offer" label.
So, my first query (search_type = count):
{ "query": { "match_all": {} }, "filter": { "bool": { "should": [ {"term": {"hotOffer": true}}, {"range": {"created": {"from": "2013-04-02"}}} ] } } }The result is 51 hits. It's correct result.
Now add a
'must'clause to'bool'filter:{ "query": { "match_all": {} }, "filter": { "bool": { "must": { "term": {"inStock": true} }, "should": [ {"term": {"hotOffer": true}}, {"range": {"created": {"from": "2013-04-02"}}} ] } } }The result is 332 hits. It's wrong result (should be 38).
Remove
'range'filter from'should'clause:{ "query": { "match_all": {} }, "filter": { "bool": { "must": { "term": {"inStock": true} }, "should": [ {"term": {"hotOffer": true}} ] } } }The result is 319 hits. It's wrong result, again (should be 1).
If a
'bool'filter replace by a combination of'and'and'or'filters then all is OK.{ "query": { "match_all": {} }, "filter": { "and": [ {"term": {"inStock": true}}, { "or": [ {"term": {"hotOffer": true}}, {"range": {"created": {"from": "2013-04-02"}}} ] } ] } }The result is 38 hits.
It seems that if both clause (
mustandshould) are inboolfilter then results are incorrect. In 0.20.6 all works fine.The text was updated successfully, but these errors were encountered: