Last week I uploaded MySQL
5.0.51a-1 to Debian unstable. Usually not worth a separate blog entry, but in this release I included the patch for MySQL bug
#4541, which was opened more than three years ago. The problem results in an error like this, e.g. when migrating a database from latin1 to utf8:
Specified key was too long; max key length is 1000 bytes
The
patch from Ingo Strüwing now included in Debian raises the maximum key length to 4005 bytes or 1001 UTF-8 characters. It will not go into the official MySQL source repositories because it results in bigger buffers and as such increases memory footprint and decreases performance. See the bugreport for further details.
Update: After some criticism from MySQL (see comments) I decided to disable the patch in the default builds with the next upload, but still ship it in the source package.