* 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
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
* 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
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...
* 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
* 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
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 *
* 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:
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
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
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
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
* 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
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
:[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
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.
* 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:
17 matches
Mail list logo