Bug #70941 | Invalid SQL query when eager loading two nested collections | ||
---|---|---|---|
Submitted: | 18 Nov 2013 15:49 | Modified: | 20 Feb 2015 3:12 |
Reporter: | Youssef Abidi | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / NET | Severity: | S2 (Serious) |
Version: | OS: | Any | |
Assigned to: | Gabriela Martinez Sanchez | CPU Architecture: | Any |
[18 Nov 2013 15:49]
Youssef Abidi
[18 Nov 2013 15:54]
Youssef Abidi
Visual Studio 2012 Solution to repeat the issue (Build to restore packages using NuGet and change connection string in Model.cs)
Attachment: TestEagerLoadingBug.zip (application/octet-stream, text), 460.69 KiB.
[8 Jan 2014 20:38]
Fernando Gonzalez.Sanchez
Ok, I got back to this one, confirmed SQL query is wrong. Youssef, thanks for the bug report, working on a fix (also noticed in some configurations the order table won't be created because is not issued with quotes and it's a keyword, will fix that too). Regards.
[20 Feb 2015 3:12]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Connector/Net 6.7.7 release, and here's the changelog entry: Loading two nested collections could be reported as an invalid SQL query as MySQL Connector/Net only generated a partial query. Thank you for the bug report.