This is a new Beta development release, fixing recently discovered bugs.
This Beta release, as any other pre-production release, should not be installed on production level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any software beta release. Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version.
This section documents all changes and bug fixes that have been applied since the last official MySQL release. 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).
Functionality Added or Changed
This was done to resolve the following interrelated issues:
The server could abort or deadlock for
INSERT DELAYED statements for
which another insert was performed implicitly (for example,
using a stored function that inserted a row).
A trigger using an
DELAYED caused the error INSERT DELAYED
can't be used with table ... because it is locked with LOCK
TABLES although the target table was not
INSERT DELAYED into a table
BEFORE INSERT or
INSERT trigger gave an incorrect
NEW pseudocolumn value and caused the
server to deadlock or abort.
References: See also Bug #20497, Bug #21714.
Formerly, restoring a cluster backup made on a MySQL 5.0 Cluster
to a 5.1 cluster using a 5.1 version of
ndb_restore did not resize
VARCHAR columns as might be
expected; now, the default behavior of
ndb_restore in such cases is to resize the
VARCHAR columns. This changed
default behavior can be overridden using the
when invoking ndb_restore.
A new status variable,
indicates the number of calls to stored procedures.
The data type used for the
column of the following
tables has been changed to
For more information, see The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables, and The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables.
References: See also Bug #26994.
Security Fix: UDFs are supposed to be loadable only from the plugin directory, but this restriction was not being enforced. (Bug #28341)
Security Fix: Use of a view could enable a user to gain update privileges for tables in other databases. (Bug #27878, CVE-2007-3782)
When an API node sent more than 1024 signals in a single batch,
NDB would process only the first
1024 of these, and then hang.
A delay in obtaining
AUTO_INCREMENT IDs could
lead to excess temporary errors.
Local checkpoint files relating to dropped
NDB tables were not removed.
MySQL Cluster: Multiple operations involving deletes followed by reads were not handled correctly.
This issue could also affect MySQL Cluster Replication.
Repeated insertion of data generated by
NDB tables could eventually lead to
failure of the cluster.
MySQL Cluster: Restarting a data node caused SQL nodes to log repeatedly and unnecessarily the status of the event buffer, causing a memory leak of approximately 4 MB for each mysqld process each time this occurred.
(This issue was known to occur in MySQL 5.1.16 and later only.) (Bug #27292)
ndb_mgmd failed silently when the cluster
configuration file contained invalid
ndb_connectstring did not appear in the
MySQL Cluster: A failure to release internal resources following an error could lead to problems with single user mode. (Bug #25818)
MySQL Cluster: DDL operations were not supported on a partially started cluster. (Bug #24631)
Disk Data: Extremely large inserts into Disk Data tables could lead to data node failure in some circumstances. (Bug #27942)
In a multi-operation transaction, a delete operation followed by
the insertion of an implicit
NULL failed to
overwrite an existing value.
ALTER TABLE statements that
worked in MySQL 5.0 did not work in 5.1.
mysql_upgrade failed if certain SQL modes were set. Now it sets the mode itself to avoid this problem. (Bug #28401)
A query with a
NOT IN subquery predicate
could cause a crash when the left operand of the predicate
A buffer overflow could occur when using
DECIMAL columns on Windows
libmysql.dll could not be dynamically loaded
Grouping queries with correlated subqueries in
WHERE conditions could produce incorrect
EXPLAIN for a query on an empty
table immediately after its creation could result in a server
DATETIME column value
with a user variable yielded incorrect results.
Portability problems caused by use of
When dumping procedures, mysqldump
output that restored the session variable
sql_mode without first
capturing it. When dumping routines, mysqldump
set nor retrieved the value of
InnoDB, in some rare cases the optimizer
preferred a more expensive
ref access to a less
expensive range access.
It was not possible to use the value
–9223372036854775808 (that is,
–MAXVALUE + 1) when specifying a
The server could hang for
INSERT IGNORE ... ON
DUPLICATE KEY UPDATE if an update failed.
The second execution of a prepared statement from a
UNION query with
BY RAND() caused the server to crash. This problem
could also occur when invoking a stored procedure containing
such a query.
Views ignored precision for
Changes to some system variables should invalidate statements in the query cache, but invalidation did not happen. (Bug #27792)
MIN() on an indexed
column that contained only
NULL values caused
NULL to be returned for other result columns.
TEXT local variable in a
stored routine in an expression such as
an incorrect result.
The error message for error number
not report which database/table combination reported the
A large filesort could result in a division by zero error and a server crash. (Bug #27119)
InnoDB variables were missing from the
output of mysqld --verbose --help.
Flow control optimization in stored routines could cause exception handlers to never return or execute incorrect logic. (Bug #26977)
Some test suite files were missing from some MySQL-test packages. (Bug #26609)
Concurrent execution of
CREATE TABLE ...
SELECT and other statements involving the target table
suffered from various race conditions, some of which might have
led to deadlocks.
An attempt to execute
CREATE TABLE ...
SELECT when a temporary table with the same name
already existed led to the insertion of data into the temporary
table and creation of an empty nontemporary table.
A statement of the form
TABLE IF NOT EXISTS t1 SELECT f1() AS i failed with a
deadlock error if the stored function
referred to a table with the same name as the to-be-created
table. Now it correctly produces a message that the table
Quoted labels in stored routines were mishandled, rendering the routines unusable. (Bug #21513)
CURDATE() is less than
NOW(), either when comparing
CURDATE() < NOW() is true) or when
DATE) < NOW() is true). However, storing
CURDATE() in a
DATE column and comparing
incorrectly yielded false. This is fixed by
DATE column as
DATETIME for comparisons to a
TABLE IF NOT EXISTS ... SELECT caused a server crash
if the target table already existed and had a
For dates with 4-digit year parts less than 200, an incorrect
implicit conversion to add a century was applied for date
arithmetic performed with
- INTERVAL. (For
INTERVAL 0 SECOND) became
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.