[Cosmos DB] "sortedRanges" exception when querying Unique Key IN list

[krisnik]

Describe the bug

We are using queryItems method to run a SQL query and query multiple items from Cosmos DB

public <T> CosmosPagedIterable<T> queryItems(SqlQuerySpec querySpec, CosmosQueryRequestOptions options, Class<T> classType) {
        return this.getCosmosPagedIterable(this.asyncContainer.queryItems(querySpec, options, classType));
    }

The SQL Query that we have had is as follows

WHERE c.id IN ("opendes:at:slb-osdu-dev-sis-internal-hqtechlog--A52C-4031-99D1---124CBB92-8C80-4668-BB48-1329C5FE241-0","opendes:at:slb-osdu-dev-sis-internal-hqtechlog--A52C-4031-99D1---124CBB92-8C80-4668-BB48-1329C5FE241-1")

Here id is the partition key. The partition key is hashed based on the first 100 bytes. We haven't migrated to 2k bytes partition hashing yet.

To Reproduce

The above Where clause query with IN keyword consistently reproduces the issue.

Expected behavior
The query items API should successfully fetch the records.

Actual behavior
Exception thrown from RoutingMapProviderHelper -> throw new IllegalArgumentException("sortedRanges");

Environment summary
SDK Version: com.azure:azure-cosmos:4.7.1
Java JDK version: 1.8
OS Version (e.g. Windows, Linux, MacOSX) N/A

Additional context
Similar issue was reported for C# SDK - Azure/azure-cosmos-dotnet-v3#833

Information Checklist
Kindly make sure that you have added all the following information above and checkoff the required fields otherwise we will treat the issuer as an incomplete report

• Bug Description Added
• Repro Steps Added
• Setup information Added

[kushagraThapar]

@mbhaskar - can you please look at this bug / feature request ?

[krisnik]

@joshfree / @mbhaskar - What would be the date for release of the April Milestone?

[mbhaskar]

@krisnik This fix should be in by April end and would be included in the following release.