Query: Exception when using OrderBy and navigation ("A column has been specified more than once in the order by list")

[maumar]

QueryNavigationsTest -> Collection_select_nav_prop_first_or_default_then_nav_prop_nested_with_orderby throws

            AssertQuery<Customer, Order, string>(
                (cs, os) => cs.Where(e => e.CustomerID.StartsWith("A"))
                    .Select(c => os.OrderBy(o => o.CustomerID).FirstOrDefault(oo =>oo.CustomerID == "ALFKI").Customer.City));

Exception:
System.Data.SqlClient.SqlException : A column has been specified more than once in the order by list. Columns in the order by list must be unique.

query plan:

TRACKED: False
(QueryContext queryContext) => IEnumerable<string> _Select(
    source: IEnumerable<ValueBuffer> _ShapedQuery(
        queryContext: queryContext, 
        shaperCommandContext: SelectExpression: 
            SELECT 1
            FROM [Customers] AS [e]
            WHERE [e].[CustomerID] LIKE N'A' + N'%'
        , 
        shaper: ValueBufferShaper
    )
    , 
    selector: (ValueBuffer e) => string FirstOrDefault(
        source: IEnumerable<string> _Select(
            source: IEnumerable<TransparentIdentifier<TransparentIdentifier<Order, IEnumerable<Customer>>, Customer>> _SelectMany(
                source: IEnumerable<TransparentIdentifier<Order, IEnumerable<Customer>>> _GroupJoin(
                    queryContext: (RelationalQueryContext) queryContext, 
                    source: IEnumerable<ValueBuffer> _Query(
                        queryContext: queryContext, 
                        shaperCommandContext: SelectExpression: 
                            SELECT [o].[OrderID], [o].[CustomerID], [o].[EmployeeID], [o].[OrderDate], [o.Customer].[CustomerID], [o.Customer].[Address], [o.Customer].[City], [o.Customer].[CompanyName], [o.Customer].[ContactName], [o.Customer].[ContactTitle], [o.Customer].[Country], [o.Customer].[Fax], [o.Customer].[Phone], [o.Customer].[PostalCode], [o.Customer].[Region]
                            FROM [Orders] AS [o]
                            LEFT JOIN [Customers] AS [o.Customer] ON [o].[CustomerID] = [o.Customer].[CustomerID]
                            WHERE [o].[CustomerID] = N'ALFKI'
                            ORDER BY [o].[CustomerID], [o].[CustomerID]
                        , 
                        queryIndex: default(System.Nullable`1[System.Int32])
                    )
                    , 
                    outerShaper: BufferedEntityShaper<Order>, 
                    innerShaper: BufferedOffsetEntityShaper<Customer>, 
                    innerKeySelector: (Customer o.Customer) => string GetValue(
                        queryContext: queryContext, 
                        entity: o.Customer, 
                        property: CustomerID
                    )
                    , 
                    resultSelector: (Order o | IEnumerable<Customer> o.Customer_group) => TransparentIdentifier<Order, IEnumerable<Customer>> CreateTransparentIdentifier(
                        outer: o, 
                        inner: o.Customer_group
                    )
                    , 
                    outerGroupJoinInclude: default(Internal.GroupJoinInclude), 
                    innerGroupJoinInclude: default(Internal.GroupJoinInclude)
                )
                , 
                collectionSelector: (TransparentIdentifier<Order, IEnumerable<Customer>> t0) => IEnumerable<Customer> DefaultIfEmpty(
                    source: t0.Inner
                )
                , 
                resultSelector: (TransparentIdentifier<Order, IEnumerable<Customer>> t0 | Customer o.Customer) => TransparentIdentifier<TransparentIdentifier<Order, IEnumerable<Customer>>, Customer> CreateTransparentIdentifier(
                    outer: t0, 
                    inner: o.Customer
                )
            )
            , 
            selector: (TransparentIdentifier<TransparentIdentifier<Order, IEnumerable<Customer>>, Customer> t1) => t1.Inner.City
        )
    )
)