This section documents all changes and bugfixes that have been applied since the last MySQL Enterprise Server and MySQL Community Server release (5.0.86). 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 http://www.mysql.com/products/enterprise/advisors.html.
In binary installations of MySQL, the supplied
binary-configure script would start and
configure MySQL, even when command help was requested with the
--help command-line option. The
--help option, if provided, no longer starts
and installs the server.
statements were not included in the output of
Database-level character sets were not always honored by the
replication SQL thread. This could cause data inserted on the
LOAD DATA to be
replicated using the wrong character set.
API: The fix for Bug #24507 could lead in some cases to client application failures due to a race condition. Now the server waits for the “dummy” thread to return before exiting, thus making sure that only one thread can initialize the POSIX threads library. (Bug #42850)
On Mac OS X or Windows, sending a
signal to the server or an asynchronous flush (triggered by
flush_time) caused the server
Solaris binary packages now are compiled with
-g0 rather than
EXPLAIN caused a server crash for
certain valid queries.
When creating a new instance on Windows using
mysqld-nt and the
--install parameter, the value of the service
would be set incorrectly, resulting in a failure to start the
CONCAT_WS() could return
incorrect results due to an argument buffer also being used as a
The server crashed when re-using outer column references in correlated subqueries when the enclosing query used a temp table. (Bug #46791)
An attempt to create a table with the same name as an existing view could cause a server crash. (Bug #46384)
A memory leak occurred when
EXPLAIN encountered a malformed
When re-installing MySQL on Windows on a server that has a data
directory from a previous MySQL installation, the installer
failed to identify the existence of the installation and the
password configured for the
Client flags were incorrectly initialized for the embedded
server, causing several tests in the
suite to fail.
A test for stack growth failed on some platforms, leading to server crashes. (Bug #42213)
References: See also Bug #62856.
The server used the wrong lock type (always
TL_READ instead of
TL_READ_NO_INSERT when appropriate) for
tables used in subqueries of
UPDATE statements. This led in
some cases to replication failure because statements were
written in the wrong order to the binary log.
myisamchk performed parameter value casting at startup that generated unnecessary warning messages. (Bug #33785)
When building MySQL on Windows from source, the
WITH_BERKELEY_STORAGE_ENGINE option would
fail to configure
BDB support correctly.
Changing the size of a key buffer that is under heavy use could
cause a server crash. The fix partially removes the limitation
LOAD INDEX INTO
CACHE fails unless all indexes in a table have the
same block size. Now the statement fails only if
LEAVES is specified.