This is a Service Pack 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.30).
Functionality added or changed:
Incompatible Change:
InnoDB rolls back only the last statement on
a transaction timeout. A new option,
--innodb_rollback_on_timeout, causes
InnoDB to abort and roll back the entire
transaction if a transaction timeout occurs (the same behavior
as in MySQL 5.0.13 and earlier).
(Bug#24200)
Bugs fixed:
The loose index scan optimization for GROUP
BY with MIN or
MAX was not applied within other queries,
such as CREATE TABLE ... SELECT ...,
INSERT ... SELECT ..., or in the
FROM clauses of subqueries.
(Bug#24156)
The size of MEMORY tables and internal
temporary tables was limited to 4GB on 64-bit Windows systems.
(Bug#24052)
A stored procedure, executed from a connection using a binary character set, and which wrote multibyte data, would write incorrectly escaped entries to the binary log. This caused syntax errors, and caused replication to fail. (Bug#23619, Bug#24492)
Accuracy was improved for comparisons between
DECIMAL columns and numbers represented as
strings.
(Bug#23260)
Calculation of COUNT(DISTINCT),
AVG(DISTINCT), or
SUM(DISTINCT) when they are
referenced more than once in a single query with GROUP
BY could cause a server crash.
(Bug#23184)
Evaluation of subqueries that require the filesort algorithm
were allocating and freeing the
sort_buffer_size buffer many times, resulting
in slow performance. Now the buffer is allocated once and
reused.
(Bug#21727)
InnoDB crashed while performing XA recovery
of prepared transactions.
(Bug#21468)
Certain malformed INSERT statements could
crash the mysql client.
(Bug#21142)
CONCURRENT did not work correctly for
LOAD DATA INFILE.
(Bug#20637)
Several string functions could return incorrect results when given very large length arguments. (Bug#10963)

User Comments
Add your own comment.