Bug #70239 SQL generated throw now a MySQL Error, Field Extent1.stateId not found in where
Submitted: 4 Sep 2013 9:56 Modified: 5 Sep 2013 15:47
Reporter: Steve Mettraux Email Updates:
Status: Duplicate Impact on me:
Category:Connector / NET Severity:S1 (Critical)
Version:6.7.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: bug linq

[4 Sep 2013 9:56] Steve Mettraux
Since we have installed the new 6.7.4 some of our linq commands doesn't work anymore, for exemple : 

Dim positionRef = myDbContext.positions.Where(Function(F) f.customerId= cId And f.puceId = 0 And f.date_ >= thisDate And (f.stateId = 6 Or f.stateId = 7)).OrderBy(Function(F) f.date_).FirstOrDefault

It seems that the "(f.stateId = 6 Or f.stateId = 7)" creates a subquery and a reference is missing. It seems that a lot of improvement for performance has been made in the last version. Maybe a little glitch appeared.

How to repeat:
Create a LINQ query with some AND and an ( OR ).

Suggested fix:
Correct this.
[5 Sep 2013 15:47] Fernando Gonzalez.Sanchez
This is a duplicate of http://bugs.mysql.com/bug.php?id=69751 which has been already fixed and released, see notes for details.