Functionality Added or Changed
Improved handling of the configuration variables
NoOfPagesToDiskAfterRestartTUP should result
in noticeably faster startup times for MySQL Cluster.
mysqldump now dumps triggers for each dumped
table. This can be suppressed with the
Added support of where clause for queries with
Maximum size of stored procedures increased from 64k to 4Gb. (Bug #11602)
message to indicate that, while the stack is not completely
full, more stack space is required.
SHOW CHARACTER SET and
INFORMATION_SCHEMA now properly report the
Latin1 character set as
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).
Added an optimization that avoids key access with
NULL keys for the
ref method when used in outer
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)
ALTER TABLE when
sql_mode = 'TRADITIONAL' gave rise to an
invalid error message.
SELECT SQL_CACHE queries in a stored
procedure causes error and client hang.
LONG system variables may return
incorrect value when retrieved with a
SELECT for certain values.
SELECT @@local... returned
@@session... in the column header.
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
Character data truncated when GBK characters
Two threads could potentially initialize different characters sets and overwrite each other. (Bug #12109)
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.
Added checks to prevent error when allocating memory when there was insufficient memory available. (Bug #7003)
InnoDB: Do not flush after each write, not
even before setting up the doublewrite buffer. Flushing can be
extremely slow on some systems.
Prepared statements were not being written to the Slow Query log. (Bug #9968)
Calling the C API function
mysql_stmt_fetch() after all
rows of a result set were exhausted would return an error
Creation of the
mysql group account failed
during the RPM installation.
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
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
ABS() output by a
negative number would return incorrect results.
big5 strings were not being stored in
GROUP_CONCAT() sometimes returned
a result with a different collation from that of its arguments.
Incorrect error message displayed if user attempted to create a
table in a nonexisting database using
Updated dependency list for RPM builds to include missing
dependencies such as
NULL columns in the format expected by MySQL.
UNIQUE VARCHAR column would be
MUL in table descriptions.
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.
A delayed insert that would duplicate an existing record crashed the server instead. (Bug #12226)
TABLES WITH READ LOCK would cause the
mysql client to hang.