This is a Service Pack release of the MySQL Enterprise Server 5.1.
This section documents all changes and bugfixes that have been applied since the last MySQL Enterprise Server release (5.1.34).
The fix for Bug #40974 in MySQL 5.1.31 caused the regression problem reported in Bug #44810. Users for whom stability is of utmost priority should note that 5.1.34sp1 is affected by this problem because Bug #44810 is not fixed until MySQL 5.1.36.
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.
Incomplete cleanup of
JOIN_TAB::selectduring the filesort of rows for a
GROUP BYclause inside a subquery caused a server crash. (Bug #44290)
On 64-bit systems, a
key_buffer_sizevalue larger than 4GB could couse
MyISAMindex corruption. (Bug #43932)
On Windows, a server crash occurred for attempts to insert a floating-point value into a
CHARcolumn with a maximum length less than the converted floating-point value length. (Bug #43833)
libmysqldcrashed when it was reinitialized. (Bug #43706, Bug #44091)
Certain statements might open a table and then wait for an impending global read lock without noticing whether they hold a table being waiting for by the global read lock, causing a hang. Affected statements are
SELECT ... FOR UPDATE,
LOCK TABLES ... WRITE,
TRUNCATE TABLE, and
LOAD DATA INFILE. (Bug #43230)
Using an XML function such as
ExtractValue()more than once in a single query could produce erroneous results. (Bug #43183)
References: See also Bug #43937.
Incorrect elevation of warning messages to error messages for unsafe statements caused a server crash. (Bug #42640)
DELETEthrough a secondary index,
InnoDBdid not store the cursor position. This made
InnoDBcrash in semi-consistent read while attempting to unlock a nonmatching record. (Bug #39320)
The functions listed in MySQL-Specific Functions That Create Geometry Values, previously accepted WKB arguments and returned WKB values. They now accept WKB or geometry arguments and return geometry values.
The functions listed in Functions That Create Geometry Values from WKB Values, previously accepted WKB arguments and returned geometry values. They now accept WKB or geometry arguments and return geometry values. (Bug #38990)