This is a Service Pack 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.72).
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.
Previously, index hints did not work for
FULLTEXTsearches. Now they work as follows:
For natural language mode searches, index hints are silently ignored. For example,
IGNORE INDEX(i)is ignored with no warning and the index is still used.
For boolean mode searches, index hints are honored. (Bug #38842)
MySQL Cluster; Packaging: Packages for MySQL Cluster were missing the
libndbclient.afiles. (Bug #42278)
Support for the
.frmfiles has been removed. This addresses the downgrading problem introduced by the fix for Bug #17823. (Bug #40021)
If the operating system is configured to return leap seconds from OS time calls or if the MySQL server uses a time zone definition that has leap seconds, functions such as
NOW()could return a value having a time part that ends with
:59:61. If such values are inserted into a table, they would be dumped as is by mysqldump but considered invalid when reloaded, leading to backup/restore problems.
Now leap second values are returned with a time part that ends with
:59:59. This means that a function such as
NOW()can return the same value for two or three consecutive seconds during the leap second. It remains true that literal temporal values having a time part that ends with
:59:61are considered invalid.
For additional details about leap-second handling, see Time Zone Leap Second Support. (Bug #39920)
Queries of the form
SELECT ... WHEREfailed when the server used a single-byte character set and the client used a multibyte character set. (Bug #34760)
References: See also Bug #20835.