This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0.
This section documents all changes and bug fixes that have been applied since the last MySQL Enterprise Server release (5.0.34).
After release, a trigger failure problem was found to have been introduced. (Bug #27006) Users affected by this issue should upgrade to MySQL 5.0.38, which corrects the problem.
Functionality Added or Changed
Incompatible Change; MySQL Cluster:
configuration parameter has changed its type and possible
false are no longer accepted for this
parameter. If you were using this parameter and had it set to
false in a previous release, you must
change it to
0. If you had this parameter
true, you should instead use
1 to obtain the same behavior as
2 to take advantage of new
functionality introduced with this release, as described in
the section cited above.
function returned a binary string. Now it returns a string with
a character set and collation given by
collation_connection so that it
can return month and weekday names containing non-ASCII
When using a
MERGE table, the definition of
the table and the underlying
are checked each time the tables are opened for access
INSERT statement). Each table is
compared for column order, types, sizes, and associated indexes.
If there is a difference in any one of the tables, the statement
localhost anonymous user account created
during MySQL installation on Windows now has no global
privileges. Formerly this account had all global privileges. For
operations that require global privileges, the
root account can be used instead.
The bundled yaSSL library was upgraded to version 1.5.8.
INFORMATION_SCHEMA table with
ORDER BY in a subquery could cause a server
We would like to thank Oren Isacson of Flowgate Security Consulting and Stefan Streichsbier of SEC Consult for informing us of this problem. (Bug #24630, Bug #26556, CVE-2007-1420)
ENUM columns that had
enumeration values containing commas, the commas were mapped to
0xff internally. However, this rendered the
commas indistinguishable from true
characters in the values. This no longer occurs. However, the
fix requires that you dump and reload any tables that have
ENUM columns containing any true
0xff values. Dump the tables using
mysqldump with the current server before
upgrading from a version of MySQL 5.0 older than 5.0.36 to
version 5.0.36 or newer.
MySQL Cluster; Partitioning:
A query with an
IN clause against an
NDB table employing explicit
user-defined partitioning did not always return all matching
MySQL Cluster: The loss of one or more data nodes could sometimes cause ndb_mgmd to use a high amount of CPU (15 percent or more, as opposed to 1 to 2 percent normally).
ndb_size.tmpl file (necessary for using
ndb_size.pl script) was missing from
MySQL Cluster: The management server did not handle logging of node shutdown events correctly in certain cases. (Bug #22013)
MySQL Cluster: In some circumstances, shutting down the cluster could cause connected mysqld processes to crash. (Bug #25668)
MySQL Cluster: A node shutdown occurred if the master failed during a commit. (Bug #25364)
Memory allocations for
columns were calculated incorrectly, resulting in space being
wasted and other issues.
Creating a nonunique index with the
HASH clause silently created an ordered index instead
of issuing a warning.
MySQL Cluster: The failure of a master node during a node restart could lead to a resource leak, causing later node failures. (Bug #25554)
SELECT statements with a
TEXT column in the selected
column list and a
WHERE condition including a
primary key lookup on a
primary key produced empty result sets.
Replication: A stored procedure, executed from a connection using a binary character set, and which wrote multi-byte data, would write incorrectly escaped entries to the binary log. This caused syntax errors, and caused replication to fail. (Bug #23619, Bug #24492)
Changes to the
system variable were not replicated.
SET PASSWORD was written to
the binary log, double quotation marks were included in the
statement. If the slave was running in with the server SQL mode
ANSI_QUOTES, then the
event failed, which halted the replication process.
Replication: If a slave server closed its relay log (for example, due to an error during log rotation), the I/O thread did not recognize this and still tried to write to the log, causing a server crash. (Bug #10798)
libndbclient.so was not versioned.
Deletion of an
took a very long time.
ON DUPLICATE KEY UPDATE defeated the
usual restriction against inserting into a join-based view
unless only one of the underlying tables is used.
When opening a corrupted
.frm file during a
query, the server crashes.
readline detection did not work correctly on
SSL connections could hang at connection shutdown. (Bug #21781, Bug #24148)
A return value of
-1 from user-defined
handlers was not handled well and could result in conflicts with
SET lc_time_names = permitted only exact literal values, not expression
If there was insufficient memory to store or update a blob
record in a
MyISAM table then the table will
marked as crashed.
A query with
ORDER BY and
BY clauses where the
clause had more elements than the
clause caused a memory overrun leading to a crash of the server.
The BUILD/check-cpu script did not recognize Celeron processors. (Bug #20061)
Accessing a fixed record format table with a crashed key definition results in server/myisamchk segmentation fault. (Bug #24855)
View definitions that used the
were treated as containing the
which has a different precedence and can produce different
The row count for
MyISAM tables was not
updated properly, causing
STATUS to report incorrect values.
GROUP BY and
NULL values for columns that have a
UNIQUE index. .
readline library wrote to uninitialized
memory, causing mysql to crash.
WITH CHECK OPTION clause for views was
ignored for updates of multiple-table views when the updates
could not be performed on fly and the rows to update had to be
put into temporary tables first.
If a prepared statement accessed a view, access to the tables listed in the query after that view was checked in the security context of the view. (Bug #24404)
UNIQUE index containing many
NULL values, the optimizer would prefer the
conditions over other more selective indexes. .
When updating a table that used a
JOIN of the
table itself (for example, when building trees) and the table
was modified on one side of the expression, the table would
either be reported as crashed or the wrong rows in the table
would be updated.
A yaSSL program named test was installed, causing conflicts with the test system utility. It is no longer installed. (Bug #25417)
DISTINCT queries that were executed using a
loose scan for an
InnoDB table that had been
emptied caused a server crash.
STDDEV() function returned a
positive value for data sets consisting of a single value.
No warning was issued for use of the
INDEX DIRECTORY table
options on a platform that does not support them.
Some queries against
used subqueries failed. .
ORDER BY or
could yield different results when selecting from a view and
selecting from the underlying table.
SELECT ... FOR
... LOCK IN SHARE MODE,
UPDATE statements executed using
a full table scan were not releasing locks on rows that did not
mysqldump --order-by-primary failed if the primary key name was an identifier that required quoting. (Bug #13926)
SHOW COLUMNS reported some
NOT NULL columns as
The presence of
ORDER BY in a view definition
MERGE algorithm from being used
to resolve the view even if nothing else in the definition
UPDATE statements were
slower than in previous versions when the search key could not
be converted to a valid value for the type of the search column.
ORDER BY or
list included a constant expression being optimized away and, at
the same time, containing single-row subselects that returned
more that one row, no error was reported. If a query required
sorting by expressions containing single-row subselects that
returned more than one row, execution of the query could cause a
Type conversion errors during formation of index search conditions were not correctly checked, leading to incorrect query results. (Bug #22344)
DEFAULT into a column with no
default value could result in garbage in the column. Now the
same result occurs as when inserting
NOT NULL column.
INFILE did not work with pipes.
ALTER TABLE ... ENABLE KEYS acquired a global
lock, preventing concurrent execution of other statements that
use tables. .
A query using
cause the server to crash.
unsigned_column NOT IN
When a prepared statement failed during the prepare operation, the error code was not cleared when it was reused, even if the subsequent use was successful. (Bug #15518)
When reading from the standard input on Windows, mysqlbinlog opened the input in text mode rather than binary mode and consequently misinterpreted some characters such as Control+Z. (Bug #23735)
AFTER UPDATE trigger on an
InnoDB table with a composite primary key
caused the server to crash.
FETCH statement using a cursor
on a table which was not in the table cache could sometimes
cause the server to crash.
LEFT JOIN comparisons could be
evaluated incorrectly, leading to improper query results.
Queries that evaluate
NULL IN (SELECT ... UNION SELECT
...) could produce an incorrect result
FALSE instead of
mysqlaccess looked for option files in
/etc even if the
--sysconfdir option for
configure had been given to specify a
An error in the name resolution of nested
USING constructs was corrected.
mysql_upgrade failed when called with a
--basedir path name
NULL value to a user-defined
function from within a stored procedure crashes the server.
mysqltest incorrectly tried to retrieve result sets for some queries where no result set was available. (Bug #19410)
If there was insufficient memory available to mysqld, this could sometimes cause the server to hang during startup. (Bug #24751)
If a duplicate key value was present in the table,
ON DUPLICATE KEY UPDATE reported a row count
indicating that a record was updated, even when no record
actually changed due to the old and new values being the same.
Now it reports a row count of zero.
References: See also Bug #27006, Bug #27033, Bug #27210.
yaSSL was sensitive to the presence of whitespace at the ends of lines in PEM-encoded certificates, causing a server crash. (Bug #25189)
On Windows, if the server was installed as a service, it did not auto-detect the location of the data directory. (Bug #20376)
Attempts to access a
MyISAM table with a
corrupt column definition caused a server crash.
InnoDB parser sometimes did not account
for null bytes, causing spurious failure of some queries.
To enable installation of MySQL RPMs on Linux systems running RHEL 4 (which includes SE-Linux) additional information was provided to specify some actions that are permitted to the MySQL binaries. (Bug #12676)
mysqltest crashed with a stack overflow. (Bug #24498)
mysql_kill() caused a server
crash when used on an SSL connection.
Within a stored routine, accessing a declared routine variable
PROCEDURE ANALYSE() caused a server
On Windows, the
could sleep too long, especially after a change to the system
(Bug #14094, Bug #24686, Bug #17635)
Use of already freed memory caused SSL connections to hang forever. (Bug #19209)
A stored routine containing semicolon in its body could not be reloaded from a dump of a binary log. (Bug #20396)
Storing values specified as hexadecimal values 64 or more bits
UNSIGNED columns did not raise any warning or error if
the value was out of range.
Within stored routines or prepared statements, inconsistent
results occurred with multiple use of
INSERT ... SELECT
... ON DUPLICATE KEY UPDATE when the
DUPLICATE KEY UPDATE clause erroneously tried to
assign a value to a column mentioned only in its
Expressions of the form
(a, b) IN (SELECT c, d
...) could produce incorrect results if
b, or both were
The number of
setsockopt() calls performed
for reads and writes to the network socket was reduced to
decrease system call overhead.
ALTER TABLE, using
could cause a
server crash. Now the
ORDER BY clause permits
only column names to be specified as sort criteria (which was
the only documented syntax, anyway).
Hebrew-to-Unicode conversion failed for some characters. Definitions for the following Hebrew characters (as specified by the ISO/IEC 8859-8:1999) were added: LEFT-TO-RIGHT MARK (LRM), RIGHT-TO-LEFT MARK (RLM) (Bug #24037)
mysql.server stop timed out too quickly (35 seconds) waiting for the server to exit. Now it waits up to 15 minutes, to ensure that the server exits. (Bug #25341)
Expressions of the form
(a, b) IN (SELECT a, MIN(b)
FROM t GROUP BY a) could produce incorrect results
a of table
NULL values while column
b did not.
A workaround was implemented to avoid a race condition in the
--with-readline option for
configure did not work for commercial source
packages, but no error message was printed to that effect. Now a
message is printed.
perror crashed on some platforms due to
failure to handle a
The server might fail to use an appropriate index for
LIMIT, and a nonrestricting
WHERE are present.