Query: invalid sql (duplicate order by columns in the list) for query with select anonymous type, order by and group by the same property

[maumar]

query:

var query = ctx.OrderDetails.Select(od => new { od, customer = od.Order.CustomerID }).OrderBy(e => e.customer).GroupBy(e => e.customer, elementSelector: e => e.od).Select(e => e);
var result = query.ToList();

sql:

SELECT [od].[OrderID], [od].[ProductID], [od].[Discount], [od].[Quantity], [od].[UnitPrice], [od.Order].[CustomerID] AS [customer]
FROM [Order Details] AS [od]
INNER JOIN [Orders] AS [od.Order] ON [od].[OrderID] = [od.Order].[OrderID]
ORDER BY [od.Order].[CustomerID], [customer]

[divega]

As per the discussion in triage, removing the proposed-punt label for this. IIRC, we said this is likely going to be fixed for 3.0.

[smitpatel]

Duplicate of #17068