Functionality Added or Changed
Improved handling of the configuration variables
NoOfPagesToDiskAfterRestartTUP should result
in noticeably faster startup times for MySQL Cluster.
Added an optimization that avoids key access with
NULL keys for the
ref method when used in outer
Added support of where clause for queries with
Maximum size of stored procedures increased from 64k to 4Gb. (Bug #11602)
SHOW CHARACTER SET and
INFORMATION_SCHEMA now properly report the
Latin1 character set as
message to indicate that, while the stack is not completely
full, more stack space is required.
mysqldump now dumps triggers for each dumped
table. This can be suppressed with the
Added error message for users who attempt
CREATE TABLE ...
LIKE and specify a nontable in the
Security improvement: Applied a patch that addresses a potential
zlib data vulnerability that could result in
an application crash. This only affects the binaries for
platforms that are linked statically against the bundled zlib
(most notably Microsoft Windows and HP-UX).
MySQL Cluster: The MySQL Cluster backup log was invalid where the number of Cluster nodes was not equal to a power of 2. (Bug #11675)
Creation of the
mysql group account failed
during the RPM installation.
Updated dependency list for RPM builds to include missing
dependencies such as
A delayed insert that would duplicate an existing record crashed the server instead. (Bug #12226)
NULL columns in the format expected by MySQL.
Information about a trigger was not displayed in the output of
SELECT ... FROM INFORMATION_SCHEMA.TRIGGERS
when the selected database was
INFORMATION_SCHEMA, prior to the trigger's
InnoDB: Do not flush after each write, not
even before setting up the doublewrite buffer. Flushing can be
extremely slow on some systems.
Two threads could potentially initialize different characters sets and overwrite each other. (Bug #12109)
big5 strings were not being stored in
Character data truncated when GBK characters
ALTER TABLE when
sql_mode = 'TRADITIONAL' gave rise to an
invalid error message.
TABLES WITH READ LOCK would cause the
mysql client to hang.
mysql_install_db used static
localhost value in
GRANT tables even when server
host name is not
localhost, such as
localhost.localdomain. This change is applied
to version 5.0.10b on Windows.
SELECT "A\\" LIKE "A\\";
fail when using
SET NAMES utf8;.
Attempting to repair a table having a full-text index on a
column containing words whose length exceeded 21 characters and
greater than 1 would crash the server.
ABS() output by a
negative number would return incorrect results.
UNIQUE VARCHAR column would be
MUL in table descriptions.
DDL statements are now permitted in stored procedures if the
procedure is not invoked from a stored function or a trigger.
This fix also resolves a problem where a
TEMPORARY statement created by one stored
routine was inaccessible to another routine invoked during the
Calling the C API function
mysql_stmt_fetch() after all
rows of a result set were exhausted would return an error
SELECT @@local... returned
@@session... in the column header.
Incorrect error message displayed if user attempted to create a
table in a nonexisting database using
LONG system variables may return
incorrect value when retrieved with a
SELECT for certain values.
GROUP_CONCAT() sometimes returned
a result with a different collation from that of its arguments.
Prepared statements were not being written to the Slow Query log. (Bug #9968)
The value of
capped by the unrelated
In stored procedures, a cursor that fetched an empty string into
a variable would set the variable to
Added checks to prevent error when allocating memory when there was insufficient memory available. (Bug #7003)
SELECT SQL_CACHE queries in a stored
procedure causes error and client hang.