Re: Query Optimizer bug!?

Hi!

Sorry for the delayed responce, but I have been on vacation...


>>>>> "Sinisa" == Sinisa Milivojevic writes:

>>
>> Hi!
>>
>> Can you please try the aobve with 4.0.2 as I have checked and keys are
>> now mapped to an 8 bit integer, which means that the above limitation
>> should have been removed.
>>

Sinisa> Sorry, I meant 8 byte integer.

Sorry, but the above is not true; MySQL 4.0.2 is still using a 'long'
(32 bit on 32 bit systems and 64 bit on 64 bit systems) as bit map for
keys. This means that the max number of keys in MySQL is 32.

(It can be changed to 64 by changing the MAX_KEYS defined to 64 and
change the typedef to ulonglong)

Regards,
Monty
CTO of MySQL AB



------------------------------------------------------------ ---------
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 bugs-thread12284@lists.mysql.com
To unsubscribe, e-mail