Search stats gives 0 for totalCount about ravendb HOT 9 CLOSED

Hi there,

I do not think that .Search(args, out var stats) method is from our API. You would have to check from where it is and what is the implementation there.

Usually in our API to achieve this, you have to do:

        var query = session
            .Advanced.AsyncDocumentQuery<JobIndex.Result, JobIndex>()
            .Statistics(out var stats);
            .Search(...);

from ravendb.

yeah, I've tried this both ways. They give the same results, even though the same query works in nodejs.

from ravendb.

Can you create a failing test maybe? https://ravendb.net/docs/article-page/6.0/csharp/start/test-driver
I've tried reproducing this without any luck.

What Client API & Server version are you using?

from ravendb.

Hmm,

We have made a fix that will be in 6.0.1 that might be related to your scenario: #17486

Can you try installing latest 6.0.1 nightly Client API from here https://myget.org/feed/ravendb/package/nuget/RavenDB.Client ?

from ravendb.

Hey @ppekrol - we're still on 5.4.103 - did this bug affect the 5.x tree also?

from ravendb.

After investigating the issue further, it seems that LongTotalResults = 0 when in fact TotalResults = 4 (in my particular query).

I would have expected the two to be equal?

from ravendb.

@georgiosd Can you share the database and the query?

from ravendb.

@grisha-kotler sent a db and query from traffic watch to [email protected] - seems to be an interaction with facets (query + facets, lazy). It works ok if I remove the facets.

from ravendb.

@georgiosd the issue is fixed here

from ravendb.