Bug #68513 | Error in LINQ to Entities query when using Distinct().Count() | ||
---|---|---|---|
Submitted: | 27 Feb 2013 23:11 | Modified: | 28 Jun 2013 2:17 |
Reporter: | Fernando Gonzalez.Sanchez | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / NET | Severity: | S2 (Serious) |
Version: | OS: | Any | |
Assigned to: | Fernando Gonzalez.Sanchez | CPU Architecture: | Any |
[27 Feb 2013 23:11]
Fernando Gonzalez.Sanchez
[2 Apr 2013 22:18]
Heinz Meissl
I have the very similar exception "Unknown column 'Extent1.AddressBookId' in 'on clause'" and a similar stack trace. My query joins three tables over two relationships (m:n) and uses any(). I'm using EntityFramework 5.0 and MySQL Connection/Net 6.6.5.
[3 Jun 2013 18:29]
Fernando Gonzalez.Sanchez
Hi Heinz, Thanks for your feedback, can you provide a concrete sample? This bug is specific to Distinct().Count(). Regards.
[28 Jun 2013 2:17]
Philip Olson
Fixed as of the upcoming Connector/Net 6.5.7, 6.6.6, and 6.7.4 releases, and here's the changelog entry: The "LINQ" query would return the error "An error of "Unknown column 'Distinct1.nCdSite' in 'where clause'" when using "Distinct().Count()". Thank you for the bug report.