azure-cosmos-db-emulator-docker
azure-cosmos-db-emulator-docker copied to clipboard
Emulator "per-query JOIN" limit is 5, but the live service supports 10
As published on official docs, and confirmed by our usage of CosmosDB, the per-query limit for JOINs is 10
: https://learn.microsoft.com/en-us/azure/cosmos-db/concepts-limits#sql-query-limits
However, the emulator appears to only support a max of 5
joins per-query:
Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: ; Reason: ({"errors":[{"severity":"Error","location":{"start":0,"end":1371},"code":"SC3002","message":"The SQL query exceeded the maximum number of joins. The allowed limit is 5."}]});
This means we cannot test/emulate our product code locally in this scenario.