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" > error > > My max_join_size is set at the default 4294967295. It appears that > is also the max, correct? When I set it lower, it goes lower. When I > set it higher it reverts to max_join_size=4294967295. > > I've simplified the fields being returned for this example. Many more > fields are returned. Additionally, in this case, only one record is > being found. However, in most cases, one hundred or so are being > returned. > > What, if anything, can I do? As I mentioned, it worked fine in Mysql > 3.x and 4.0. It's not functioning in Mysql 4.1
You can submit a bugreport at http://bugs.mysql.com/ (but please provide a *readable* EXPLAIN output, using "mysql -t") Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
