Alan-Jowett / CoPilot-For-Consensus / 22000597690

78%

push

github

fix: replace Cosmos DB composite ORDER BY with simple single-field sort (#1170)

The IS_DEFINED() composite ORDER BY pattern requires a composite index
that Cosmos DB cannot build for system functions, causing BadRequest errors
on the per-collection summaries container (no composite indexes defined).

Use simple single-field ORDER BY which works with the default /* range
index. Align InMemory store to match Cosmos DB native NULL sort behavior
(NULLs-first) and document this as the canonical cross-backend contract.

- Cosmos: simple ORDER BY c.field {order} (NULLs sort first natively)
- InMemory: remove two-phase NULLs-last sort, use simple sort (NULLs first)
- Mongo: document behavioral difference in comment
- Interface: document NULLs-first contract in DocumentStore docstring
- Integration test: cover NULL/missing sort field edge case

Fixes #1169

Signed-off-by: Alan Jowett <alanjo@microsoft.com>

1 of 2 new or added lines in 2 files covered. (50.0%)

8786 of 11290 relevant lines covered (77.82%)

0.87 hits per line