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 a 64Bit

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 garantueed more

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, you

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
* 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' limitations I

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 got a clue? I

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 select *

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)...? RB URL:

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-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

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. -Original Message- From

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 a little spooky if were '42

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. URL: http://www.mysql.com/information/crash-me.php -- Roger

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 Fuller I

Re: Maximum JOINED tables

2002-06-05 Thread Sabine Richter
:[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 the maximum number of tables MySQL permits to be JOINed in a single SELECT

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 statement.

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. URL: