MAX_JOIN_SIZE error. 4.0 v 4.1

I have a query that worked just fine in Mysql 3.x and 4.0. It no longer works in 4.1. I receive the 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 error My max_join_size is set at the

Re: MAX_JOIN_SIZE error. 4.0 v 4.1

Brett Harvey [EMAIL PROTECTED] wrote on 03/10/2005 01:24:54 PM: I have a query that worked just fine in Mysql 3.x and 4.0. It no longer works in 4.1. I receive the The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET

Re: MAX_JOIN_SIZE error. 4.0 v 4.1

Hi! On Mar 10, Brett Harvey wrote: I have a query that worked just fine in Mysql 3.x and 4.0. It no longer works in 4.1. I receive the 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