* 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: http://www.mysql.com/crashme > > > RB> (Select both mysql versions, submit, and search for "tables > RB> in join" on the result page.) > > If you have 32 bit CPU you can use 31 tables in join. 63 tables with > 64 bit CPU.
ok... thanks. :) But... is this the only feature of mysql which is dependant on the processor architecture? I'm kind of nervous about this, because I'm currently working on a 'very normalized' database schema, and it is possible I will need more than 31 tables in a single select... including multiple joins to the same tables, of course. It would be very bad if my design turned out to be 64-bit dependant... -- 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