Query: GroupBy aggregate failure when key property is also part of Elementselector

[smitpatel]

        [ConditionalFact]
        public virtual void GroupBy_Key_element_clash()
        {
            AssertQuery<Order>(
                os => os.GroupBy(o => o.OrderID, o => new { o.OrderID, o.OrderDate })
                        .Select(g => new
                        {
                            g.Key,
                            Avg = g.Average(e => e.OrderID),
                            Max = g.Max(o => o.OrderDate)
                        }));
        }

[ajcvickers]

@smitpatel @anpete @maumar Let's discuss this one again in triage tomorrow with specific focus on risk for patching. /cc @divega

[ajcvickers]

Re-triage: We are not going to patch this because there is some risk in the fix and there is a good workaround: remove the o => new { o.OrderID, o.OrderDate } projection, since with translation to the server it will result in the same query being generated and the same data being returned.

[ConditionalFact]
        public virtual void GroupBy_Key_element_clash()
        {
            AssertQuery<Order>(
                os => os.GroupBy(o => o.OrderID)
                        .Select(g => new
                        {
                            g.Key,
                            Avg = g.Average(e => e.OrderID),
                            Max = g.Max(o => o.OrderDate)
                        }));
        }