List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:June 6 2002 2:18pm
Subject:Re: RE: Maximum JOINED tables
View as plain text  
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
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Maximum JOINED tablesArthur Fuller5 Jun
  • Re: Maximum JOINED tablesRoger Baklund5 Jun
RE: Maximum JOINED tablesWalt Weaver5 Jun
  • RE: Maximum JOINED tablesAndrew Hazen5 Jun
RE: Maximum JOINED tablesWalt Weaver5 Jun
RE: Maximum JOINED tablesWalt Weaver5 Jun
  • Re: Maximum JOINED tablesSabine Richter5 Jun
    • Re: Maximum JOINED tablesDan Nelson5 Jun
  • Re: Maximum JOINED tablesRoger Baklund5 Jun
    • Re: Maximum JOINED tablesHarald Fuchs6 Jun
      • RE: Maximum JOINED tablesRoger Baklund6 Jun
        • Re: RE: Maximum JOINED tablesVictoria Reznichenko6 Jun
          • Re: Maximum JOINED tablesRoger Baklund6 Jun
            • Re: Maximum JOINED tablesBenjamin Pflugmann7 Jun
              • Re: Maximum JOINED tablesRoger Baklund7 Jun
                • Re: Re: Maximum JOINED tablesVictoria Reznichenko7 Jun
                  • Re: Maximum JOINED tablesRoger Baklund7 Jun
                • Re: Maximum JOINED tablesBenjamin Pflugmann7 Jun
                  • Re: Maximum JOINED tablesRoger Baklund8 Jun
                    • Not using indexes???Jon Frisby8 Jun
                      • Re: Not using indexes???Erv Young8 Jun
                      • Re: Not using indexes???bvyas38 Jun
                        • RE: Not using indexes???Jon Frisby8 Jun
                          • Re: Not using indexes???Benjamin Pflugmann8 Jun
                            • Re: Not using indexes???Erv Young10 Jun
                            • RE: Not using indexes???Jon Frisby10 Jun
                              • php+mysql+multiple lines qrycristian ditoiu10 Jun
                                • Re: php+mysql+multiple lines qryBrent Baisley10 Jun
                                  • Re: php+mysql+multiple lines qrycristian ditoiu10 Jun