* 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 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.
Me too, running 3.23.30-gamma on w2k:
mysql> desc select * from
-> tab1 t1,tab1 t2,tab1 t3,tab1 t4...
ERROR 1116: Too many tables. MySQL can only use 31 tables in a join
So... is the crashme report wrong? Or was the limit really 32 in 3.22.39,
got lowered to 31 in later versions (like 3.23.30-gamma), raised to 63 in
version 3.23.39, and then lowered to 31 again (at least in versions 3.23.47
and 4.0.1)...?
<URL: http://www.mysql.com/crashme >
(Select both mysql versions, submit, and search for "tables in join" on the
result page.)
--
Roger
---------------------------------------------------------------------
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
