MySQL Bugs: #21962: connector 1.0.7 problem with SQL_BIG

Bug #21962	connector 1.0.7 problem with SQL_BIG_SELECTS
Submitted:	1 Sep 2006 8:33	Modified:	1 Sep 2006 15:14
Reporter:	Brayan Johnes	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	1.0.7	OS:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

Description:
My problem is the same as here:
http://bugs.mysql.com/bug.php?id=11427

When i use MySQL Query Browser - version 1.1.20
no error appear and the query goes OK. It returns what is need to.

But when i call the same query from VB code with Connector/Net 1.0.7
an exeption appear with an Error 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"

MySQL version - MySQL 4.1.21-community-nt

How to repeat:
Here is the query:
SELECT game.*, t1.name AS team1, t2.name AS team2  FROM  (SELECT id, DAY(gt) AS dd, MONTH(gt) AS mm, st, st_code, st_id  FROM ls_s_game  WHERE gt < DATE_ADD( (SELECT MAX(DATE(gt)) FROM ls_s_game WHERE gt < DATE_ADD(CURRENT_DATE(),INTERVAL 1 DAY) AND l_id = 92),INTERVAL 1 DAY) AND gt > (SELECT MAX(DATE(gt)) FROM ls_s_game WHERE gt < DATE_ADD(CURRENT_DATE(),INTERVAL 1 DAY) AND l_id = 92)  AND l_id = 92 ORDER BY gt DESC LIMIT 12) game, ls_s_team t1, ls_s_team t2  WHERE (game.id = t1.s_game_id AND t1.home = 1) AND (game.id = t2.s_game_id AND t2.home = 0)

I will attache the DBs

Looks like a duplicate of bug #20023
Please test with connection pooling disabled

yes with pooling=false it is working
ok I will not attache DB then