Query with VALUE COUNT(1) does not work

[jvalkeejarvi]

Following query does not work.

SELECT VALUE COUNT(1) FROM c

Cosmos SDK uses queries with VALUE COUNT(1) when using CountAsync method with an IQueryable.

[christopheranderson]

Do you happen to have the exception you received when you tried this and it didn't work?

[jvalkeejarvi]

I get the following error when using Cosmos explorer in browser: Exception while reading from stream Cosmos query text: SELECT VALUE COUNT(1) FROM c -> SELECT COUNT(1) FROM %s AS c

[xgerman]

We don't support that flavor of aggregation yet. Stay tuned...

[RichMercer]

Unfortunately this is the flavour of aggregation you get from LINQ to NoSql translation, so my code still won't work with the current build. :(

[jvalkeejarvi]

What is the situation with this issue? This is a really bad blocker as Cosmos SDK uses this kind of COUNT query.

[Pacopb-itx]

Hi! I am also having this issue with the cosmos vnext emulator. Is there any expected date for this feature?

[xgerman]

We will investigate if there is an easy fix not involving the query engine (see https://github.com/Azure/azure-cosmos-db-emulator-docker/discussions/200) We will keep you posted.

[lionelc]

@RichMercer @jvalkeejarvi @Pacopb-itx We added support to this query style in our last release https://github.com/Azure/azure-cosmos-db-emulator-docker/releases/tag/EN20250612 . Please let us know if you have further issues (reopen this issue or open another one).

[xgerman]

We published a fix and will close this issue. Please reopen if you have still problems