Facet distribution count vs actual documents count

[elyor0701]

hi, everybody. I had some trouble with filtering documents by array of objects.

I have document with field structure like that:

.

First request

Req:
{ "q": "", "filter": "subcategories.num_id=62 AND is_available=available", "limit": 1, "offset": 0, "attributesToRetrieve": [ "name", "num_id", "attributes.id" ], "facets": [ "attributes.id" ] }

Resp:
{ "facetDistribution": { "attributes.id": { ... "07d17edc-c4a2-411b-bcdc-13a660fed706": 1 ... } } }

Second Request

Req:
{ "q": "", "filter": "subcategories.num_id=62 AND is_available=available AND attributes.id=07d17edc-c4a2-411b-bcdc-13a660fed706", "limit": 1, "offset": 0, "attributesToRetrieve": [ "name", "num_id", "attributes.id" ], "facets": [ "attributes.id" ] }

Resp:
{ "estimatedTotalHits": 5, "facetDistribution": { "attributes.id": { "07d17edc-c4a2-411b-bcdc-13a660fed706": 4 } } }

3 different documents count, how is this possible?

PS: pkgVersion: 1.6.2

[ManyTheFish]

Hello @elyor0701,
I'm not sure I understood your case,
By default, Meilisearch isn't exhaustive. However, instead of using "limit": 1, "offset": 0, you may try to use page and hitsPerPage.
This may solve your issue,
Let me know if it worked!
See you

[elyor0701]

I apologize for the inaccuracy of the question.

Pay attention to the ID attribute in the first request and in the second. In the first request there is a filter X, then in the response I receive multiple documents and in facetDistribution for the attributes {"07d17edc-c4a2-411b-bcdc-13a660fed706": 1}. This means that if I change the filter to X AND attributes.id = 07d17edc-c4a2-411b-bcdc-13a660fed706, then estimatedTotalHits should be equal to 1, but I get a different value.

[ManyTheFish]

@elyor0701,
Ok, I got it.
But could you please retry using page and hitPerPage instead of offset and limit? If it's a bug, it would help me know its source. 😄
I would probably need a subset of your data to reproduce the bug on my side, or at least similar data reproducing the case.

[elyor0701]

@ManyTheFish,
You can check it from this dump file
20240326-075103607.zip

First request:
{ "q": "", "filter": "", "page": 1, "hitsPerPage": 5, "attributesToRetrieve": [ "name", "num_id", "attributes.id" ], "sort": [ "created_at:desc" ], "facets": [ "attributes.id" ] }

Second request:
{ "q": "", "filter": "attributes.id=3193c155-d6f0-4b81-9211-4c85467cccc9", "page": 1, "hitsPerPage": 5, "attributesToRetrieve": [ "name", "num_id", "attributes.id" ], "sort": [ "created_at:desc" ], "facets": [ "attributes.id" ] }

I get the same result with page and hitsPerPage too 😄

[ManyTheFish]

Thank you @elyor0701,
We will investigate on our side. 😄