Bug #60433 Visual Studio 2011 cannot generate the model .edmx ERROR.
Submitted: 11 Mar 2011 17:18 Modified: 11 Apr 2011 17:25
Reporter: Aldo Marsilio Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:6.3.3 OS:Microsoft Windows (XP service Pack3)
Assigned to: CPU Architecture:Any
Tags: SQL_MAX_JOIN_SIZE=#

[11 Mar 2011 17:18] Aldo Marsilio
Description:
I'm using Visual Studio 2010 Ultimate Edition with Connector/Net 6.3.3.
I'm trying to let Visual Studio generate a model .edmx file but I get this error just after I hit the "Update model from database" button 

-------
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
-------

How to repeat:
Just open visual Studio, try to use a database Mysql remotely (i.e. installed on another server), add the reference as you would do with a normal program that would connect to a db and voila'.... the error will come...

Suggested fix:
I don't know.
[11 Mar 2011 17:25] Valeriy Kravchuk
Please, connect to the same MySQL server with mysql command line tool (or any other tool that allows to execute SQL) and get the results of:

show variables like '%max_join%';
show variables like 'sql_big%';
[11 Apr 2011 23: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".