Query - not contains seems to have a limit of 124, can we do better or bug?

[Arnii]

We have a query in our app that needs to exclude a lot of documents (by ID) from the query. We do this as follows:
query.AndAlso().Not.ContainsAny(x => x.Id, exludedDocuments);
which works great, but if that list gets too large it seems to not work at all.
(and that excludedDocuments list comes from another document, so it's different everytime)

I tried myself by querying in Raven Studio using not id() in and a whole lot of Id's, the limit seems to be 124 documents, more than 124 seems to ignore the "not contains" completely. I attached a video of me testing in Raven Studio.

2021-10-26.15-24-10.mp4

Are we doing something wrong/inefficient or could this be a bug?

[ppekrol]

This could be related to changes made here: https://issues.hibernatingrhinos.com/issue/RavenDB-17206
Or is another variation of that issue.

Could you send us a full repro maybe so we can investigate this faster?

[Arnii]

Sorry, the video is the best repro we have so far and currently do not have the time for further testing, but that issue you sent is exactly what we're dealing with! Sorry for the double post. I see it has already been fixed for a future version, so I'm happy!

[garayx]

you can try to install the nightly and check if your query works
https://hibernatingrhinos.com/builds?product=RavenDB&version=5.1&channel=Nightly&pageNr=1

[garayx]

Hi

Sorry I didn't see that the fix is already included in the RavenDB version that you are using, can you send us a failing test or sample project that reproduce the issue ?

[garayx]

Hi

We have a reproduce for this issue, and will fix it shorty
https://issues.hibernatingrhinos.com/issue/RavenDB-17423

[Arnii]

Thank you for the repro. We didn't have the time yet to create a proper full repro

[arekpalinski]

PR: #12984