Re: Maximum JOINED tables

2002-06-07 Thread Roger Baklund
* Benjamin Pflugmann > On Fri 2002-06-07 at 11:43:38 +0200, [EMAIL PROTECTED] wrote: > [...] > > However, I think my question is valid... I don't think it is a > good idea to > > limit the number of joins based on the processor architecture, and this > > makes me wonder what other 'strange' limita

Re: Maximum JOINED tables

2002-06-07 Thread Benjamin Pflugmann
Hi. On Fri 2002-06-07 at 11:43:38 +0200, [EMAIL PROTECTED] wrote: [...] > However, I think my question is valid... I don't think it is a good idea to > limit the number of joins based on the processor architecture, and this > makes me wonder what other 'strange' limitations I might find in mysql.

Re: Maximum JOINED tables

2002-06-07 Thread Roger Baklund
* Victoria Reznichenko > RB> mysql is considered to be platform independant, and I suppose > RB> MySQL AB is trying to keep it that way...? > > Roger, MySQL is platform independent. I did not say it was not... :) > It works on any platform with > the same data, but if the architecture is 64 bit,

Re: Re: Maximum JOINED tables

2002-06-07 Thread Victoria Reznichenko
Roger, Friday, June 07, 2002, 12:43:38 PM, you wrote: RB> * Benjamin Pflugmann >> On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote: >> [...] >> >> > But... is this the only feature of mysql which is dependant on the >> > processor architecture? >> >> See it the other way: You are not

Re: Maximum JOINED tables

2002-06-07 Thread Roger Baklund
* Benjamin Pflugmann > On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote: > [...] > > > But... is this the only feature of mysql which is dependant on the > > processor architecture? > > See it the other way: You are not garantueed more than 31 tables in a > join. If you happen to have

Re: Maximum JOINED tables

2002-06-06 Thread Benjamin Pflugmann
Hi. On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote: [...] > But... is this the only feature of mysql which is dependant on the > processor architecture? See it the other way: You are not garantueed more than 31 tables in a join. If you happen to have a 64Bit architecture, you can

Re: Maximum JOINED tables

2002-06-06 Thread Roger Baklund
* Victoria Reznichenko [...] > RB> So... is the crashme report wrong? Or was the limit really 32 > RB> in 3.22.39, got lowered to 31 in later versions (like 3.23.30- > RB> gamma), raised to 63 in version 3.23.39, and then lowered to > RB> 31 again (at least in versions 3.23.47 and 4.0.1)...? > > R

Re: RE: Maximum JOINED tables

2002-06-06 Thread Victoria Reznichenko
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

RE: Maximum JOINED tables

2002-06-06 Thread Roger Baklund
* Harald Fuchs > In article <[EMAIL PROTECTED]>, > "Roger Baklund" <[EMAIL PROTECTED]> writes: > > > Yes... that is strange. There could be a bug in the crashme > > report, or the limit may have been lowered after 3.23.39, but > > neither of those seems very likely (to me, anyway)... anyone > > go

Re: Maximum JOINED tables

2002-06-05 Thread Roger Baklund
* Arthur Fuller > > I have searched the manual without success. I want to know the maximum > > number of tables MySQL permits to be JOINed in a single SELECT > > statement. * Roger Baklund > According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39. > > http://www.mysql.com/information/crash-me

Re: Maximum JOINED tables

2002-06-05 Thread Dan Nelson
In the last episode (Jun 05), Sabine Richter said: > "Weaver, Walt" wrote: > > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > > * Arthur Fuller > > > I have searched the manual without success. I want to know the > > > maximum number of tables MySQL permits to be JOINed in a single > > > SELECT

Re: Maximum JOINED tables

2002-06-05 Thread Sabine Richter
-Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 05, 2002 10:19 AM > To: mysql mailing list > Cc: Arthur Fuller > Subject: Re: Maximum JOINED tables > > * Arthur Fuller > > I have searched the manual without success. I want to know

RE: Maximum JOINED tables

2002-06-05 Thread Weaver, Walt
Hmmm... we're running 3.23.47 here and have run into a 32 table join limit... --Walt -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 10:19 AM To: mysql mailing list Cc: Arthur Fuller Subject: Re: Maximum JOINED tables * Arthur F

Re: Maximum JOINED tables

2002-06-05 Thread Roger Baklund
* Arthur Fuller > I have searched the manual without success. I want to know the maximum > number of tables MySQL permits to be JOINed in a single SELECT statement. According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39. http://www.mysql.com/information/crash-me.php > -- Roger --

RE: Maximum JOINED tables

2002-06-05 Thread Weaver, Walt
Yup, it'd be the answer to everything. :>) -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 10:00 AM To: Weaver, Walt; 'Arthur Fuller'; 'mysql mailing list' Subject: RE: Maximum JOINED tables Would have been

RE: Maximum JOINED tables

2002-06-05 Thread Andrew Hazen
Would have been a little spooky if were '42'! :) Andrew Hazen -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 11:51 AM To: 'Arthur Fuller'; mysql mailing list Subject: RE: Maximum JOINED tables 32. -Origin

RE: Maximum JOINED tables

2002-06-05 Thread Weaver, Walt
32. -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 9:48 AM To: mysql mailing list Subject: Maximum JOINED tables I have searched the manual without success. I want to know the maximum number of tables MySQL permits to be JOINed in a sing