Dear MySQL users,
MySQL Community Server 5.0.82, a new version of the popular Open Source
Database Management System, has been released. This and future releases
in the MySQL Community Server 5.0 series share version numbers with
their MySQL Enterprise Server counterparts.
The release is now available in source and binary form for a number of
platforms from our download pages at
and mirror sites. Note that not all mirror sites may be up to date at
this point in time, so if you can't find this version on some mirror,
please try again later or choose another download site.
We welcome and appreciate your feedback, bug reports, bug fixes,
Please note that we have dropped support for AIX 5.2 as of April 30th
as the platform has reached vendor EOL, and this is the first release
of MySQL 5.0 which does not include binaries for that platform.
This section documents all changes and bugfixes that have been
applied since the last MySQL Community Server release (5.0.81).
If you would like to receive more fine-grained and personalized
update alerts about fixes that are relevant to the version and
features you use, please consider subscribing to MySQL Enterprise
(a commercial MySQL offering). For more details please see
* Replication: Restarting the replication slave --- either by
using STOP SLAVE plus START SLAVE, or by restarting the slave
mysqld process --- could sometimes cause the slave to crash
when using a debug version of the server.
* Replication: Killing the thread executing a DDL statement,
after it had finished its execution but before it had written
the binlog event, caused the error code in the binlog event to
be set (incorrectly) to ER_SERVER_SHUTDOWN or
ER_QUERY_INTERRUPTED, which caused replication to fail.
See also Bug#27571: http://bugs.mysql.com/27571,
* Replication: Column aliases used inside subqueries were ignored
in the binary log. (Bug#35515: http://bugs.mysql.com/35515)
* Replication: The statements DROP PROCEDURE IF EXISTS and DROP
FUNCTION IF EXISTS were not written to the binary log if the
procedure or function to be dropped did not exist.
See also Bug#25705: http://bugs.mysql.com/25705.
* Use of HANDLER statements with INFORMATION_SCHEMA tables
caused a server crash. Now HANDLER is prohibited with such
tables. (Bug#44151: http://bugs.mysql.com/44151)
* myisamchk could display a negative Max keyfile length value.
* On Windows, a server crash occurred for attempts to insert a
floating-point value into a CHAR column with a maximum length
less than the converted floating-point value length.
* UNION of floating-point numbers did unnecessary rounding.
* Certain statements might open a table and then wait for an
impending global read lock without noticing whether they hold
a table being waiting for by the global read lock, causing a
hang. Affected statements are SELECT ... FOR UPDATE, LOCK
TABLES ... WRITE, TRUNCATE TABLE, and LOAD DATA INFILE.
* The InnoDB btr_search_drop_page_hash_when_freed() function had
a race condition. (Bug#42279: http://bugs.mysql.com/42279)
* Compressing a table with the myisampack utility caused the
server to produce Valgrind warnings when it opened the table.
* For a MyISAM table with DELAY_KEY_WRITE enabled, the index
file could be corrupted without the table being marked as
crashed if the server was killed.
* Multiple-table UPDATE statements did not properly activate
triggers. (Bug#39953: http://bugs.mysql.com/39953)
* An UPDATE statement that updated a column using the same
DES_ENCRYPT() value for each row actually updated different
rows with different values.
* For shared-memory connections, the read and write methods did
not properly handle asynchronous close events, which could
lead to the client locking up waiting for a server response.
For example, a call to mysql_real_query() would block forever
on the client side if the executed statement was aborted on
the server side. Thanks to Armin Schöffmann for the bug report
and patch. (Bug#33899: http://bugs.mysql.com/33899)
* CHECKSUM TABLE was not killable with KILL QUERY.
* myisamchk and myisampack were not being linked with the
library that enabled support for * filename pattern expansion.
* COMMIT did not delete savepoints if there were no changes in
the transaction. (Bug#26288: http://bugs.mysql.com/26288)
* Several memory allocation functions were not being checked for
out-of-memory return values.
Karen Langford, MySQL Release Engineer
Database Group, Sun Microsystem Inc.
|• MySQL Community Server 5.0.82 has been released||Karen Langford||28 May|