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
• Status: Duplicate
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: 6.7.4
• OS: Any
• CPU Architecture: Any
• Tags: bug linq

[4 Sep 2013 9:56] Steve Mettraux

Description:
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.