Bug #77465 Exception due to invalid correlated query reference
Submitted: 24 Jun 2015 0:57 Modified: 25 Jul 2015 5:38
Reporter: Ryan Griffith (OCA) Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.9.6 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[24 Jun 2015 0:57] Ryan Griffith
Description:
My LINQ query which worked in Entity Framework 6.1.1 does not work in the latest version of Entity Framework. (I'm unclear at which version the LINQ query no longer functions).

I've confirmed this is related to the expression produced by EF, not because of a regression of MySQL's connector.

How to repeat:
I intend to update this ticket with some DDL scripts + a Linq query to repeat, however, I will include the output SQL from both of these statements in hopes that they might help determine where the issue is in EF.
[24 Jun 2015 1:12] Ryan Griffith
The output SQL for a non-working query in the latest version of Entity Framework (6.1.3)

Attachment: not_working.txt (text/plain), 2.88 KiB.

[24 Jun 2015 1:12] Ryan Griffith
The output SQL for a working query in Entity Framework 6.1.1

Attachment: working.txt (text/plain), 2.57 KiB.

[25 Jun 2015 5:38] Chiranjeevi Battula
Hello  Ryan Griffith,

Thank you for the bug report.
Could you please provide repeatable test case (exact create table statements, model, context class, etc.) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[26 Jul 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".