| Bug #10228 | MAX_JOIN_SIZE error on a query working with CorLabs | ||
|---|---|---|---|
| Submitted: | 28 Apr 2005 7:45 | Modified: | 28 Apr 2005 8:03 |
| Reporter: | StuFF mc | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | Connector / NET | Severity: | S1 (Critical) |
| Version: | MySql 5.0.4 - Con 1.0.4 - .NET 2.0.40607 | OS: | Server FedCore rel1 - Client XP |
| Assigned to: | CPU Architecture: | Any | |
[28 Apr 2005 8:03]
Hartmut Holzgraefe
so CorLabs seems to set those settings mentionend in the error message without telling please note that MAX_JOIN_SIZE is about rows *examined*, not rows returned
Description: I'm calling a VIEW in a MySqlDataAdapter, which returns 186 records, and I get this nice message: "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". I did the same query, same code (just changed the Using) with the CorLab components and it works. How to repeat: MyDataAdapter = New MySqlDataAdapter("SELECT * FROM vMyView", MyConnection) MyDataAdapter.Fill(MyDataSet.Tables(TableList(3))) Suggested fix: Suggested fix: Fix it ! ;)