[IGNITE-13754] .NET: LINQ provider emits incorrect table alias for queries with JOIN and GROUP BY combined

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.10
• Component/s: platforms
• Labels: .NET
• Release Note: .NET: Fix LINQ to SQL translation for queries with JOIN and GROUP BY combined
• Assignee: Pavel Tupitsyn
• Reporter: Pavel Tupitsyn
• Created: 25/Nov/20 06:48
• Updated: 21/Jan/21 18:50
• Resolved: 12/Jan/21 10:54

Description

See the attached reproducer. Generated SQL is:

select _T0.MEETINGID, max (_T0.AttachmentDate)  from USERSCHEMA.MEETING as _T0 inner join USERSCHEMA.MEETINGATTACHMENT as _T1 on (_T1.MEETINGID = _T0.MEETINGID) group by (_T0.MEETINGID)

_T0.AttachmentDate should be _T1.AttachmentDate here.

Issue Links

• links to: GitHub Pull Request #8638
• links to: StackOverflow: Apache Ignite Group By Linq Query Issue