Roger, Thursday, June 06, 2002, 12:08:13 PM, you wrote: >> I just tried a multiple self join on 4.0.1 and got the following >> >> DBD::mysql::st execute failed: Too many tables. MySQL can only >> use 31 tables in a join at ./x2.pl line 47.
RB> Me too, running 3.23.30-gamma on w2k: mysql>> desc select * from RB> -> tab1 t1,tab1 t2,tab1 t3,tab1 t4... RB> ERROR 1116: Too many tables. MySQL can only use 31 tables in a join RB> So... is the crashme report wrong? Or was the limit really 32 in 3.22.39, RB> got lowered to 31 in later versions (like 3.23.30-gamma), raised to 63 in RB> version 3.23.39, and then lowered to 31 again (at least in versions 3.23.47 RB> and 4.0.1)...? RB> <URL: http://www.mysql.com/crashme > RB> (Select both mysql versions, submit, and search for "tables in join" on the RB> result page.) If you have 32 bit CPU you can use 31 tables in join. 63 tables with 64 bit CPU. RB> -- RB> Roger -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php