This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0.
This section documents all changes and bugfixes that have been applied since the last MySQL Enterprise Server release (5.0.74). 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.
Functionality Added or Changed
Replication: When rotating relay log files, the slave deletes relay log files and then edits the relay log index file. Formerly, if the slave shut down unexpectedly between these two events, the relay log index file could then reference relay logs that no longer existed. Depending on the circumstances, this could when restarting the slave cause either a race condition or the failure of replication. (Bug #38826, Bug #39325)
The server crashed if an integer field in a CSV file did not have delimiting quotation marks. (Bug #39616)
The mysql client incorrectly parsed statements containing the word “delimiter” in mid-statement.
This fix is different from the one applied for this bug in MySQL 5.0.66. (Bug #33812)
References: See also Bug #38158.
A read past the end of the string could occur while parsing the
value of the
The code for the
ut_usectime() function in
InnoDB did not handle errors from the
gettimeofday() system call. Now it retries
gettimeofday() several times and updates
the value of the
status variable only if
EXPLAIN EXTENDED evaluation of
aggregate functions that required a temporary table caused a
Creating a table with a comment of 62 characters or longer caused a server crash. (Bug #39591)
table was limited to 7680 rows.
In debug builds, obsolete debug code could be used to crash the server. (Bug #41041)
SELECT queries could fail
Duplicate entry error.
max_length metadata value was calculated
incorrectly for the
function, which could cause incorrect result set metadata to be
sent to clients.
Use of spatial data types in prepared statements could cause memory leaks or server crashes. (Bug #37956, Bug #37671)
DAYNAME() functions returned a
binary string, so that using
UPPER() had no effect. Now
DAYNAME() return a value in
Some queries that used a “range checked for each record” scan could return incorrect results. (Bug #40974)
References: See also Bug #44810.
IF(..., CAST( as
an argument to an aggregate function could cause an assertion
FULLTEXT searches that
used the truncation operator did not return matching records and
calculated relevance incorrectly.
In example option files provided in MySQL distributions, the
thread_stack value was
increased from 64K to 128K.
InnoDB could hang trying to open an adaptive
SSL support was not included in some “generic” RPM packages. (Bug #26760)
Queries executed using join buffering of
BIT columns could produce