Re: deleting from an InnoDB table with a composite PK > 500 chars crashes mysqld

hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Hi! Heikki> Ok, I found that in unireg.h MAX_KEY_LENGTH is defined as 500, and that is Heikki> used, for example, in the opt_range.cc PARAM struct as the key value buffer Heikki> size. A memory overrun will happen if a key l

Re: deleting from an InnoDB table with a composite PK > 500 chars crashes mysqld

Hi! Ok, I found that in unireg.h MAX_KEY_LENGTH is defined as 500, and that is used, for example, in the opt_range.cc PARAM struct as the key value buffer size. A memory overrun will happen if a key length is > 500 bytes. InnoDB allows keys up 3500 bytes in size. Fix: change MAX_KEY_LENGTH in u

Re: deleting from an InnoDB table with a composite PK > 500 chars crashes mysqld

Hi! I was able to repeat this in our computer. mysqld crashes inside the MySQL code. It did not crash if the primary key length was < 500 bytes. This looks like a memory overrun bug. I have forwarded this bug report for Monty to check. Regards, Heikki Tuuri Innobase Oy --- Order commercial MySQ