Azure-cosmos-dotnet-v2: Linq implementation generates wrong query for an ORDER BY following a SELECT

Created on 15 Apr 2017 · 8Comments · Source: Azure/azure-cosmos-dotnet-v2

There appears to be a bug in the Linq implementation when generating a query containing an ORDER BY following a SELECT.

class Container<T>
{
    public System.Guid id { get; set; }
    public string Key { get; set; }
    public T Content { get; set; }
}

public class Content
{
    public string Version { get; set; }
}

var content = client.CreateDocumentQuery<Container<Content>>(collection.DocumentsLink)
    .Where(container => container.Key == "MyKey")
    .Select(container => container.Content)
    .OrderBy(content => content.Version);

This generates the following query, returning zero results.
SELECT VALUE root["Content"] FROM root WHERE (root["Key"] = "MyKey") ORDER BY root["Version"] ASC

The following query returns results as expected.
SELECT VALUE root["Content"] FROM root WHERE (root["Key"] = "MyKey") ORDER BY root["Content"]["Version"] ASC

investigating

Source