Released on 5 Jan 2009
MySQL 5.0.76 Changelog

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

  • Functionality Added or Changed

  • Bugs Fixed

Functionality Added or Changed

  • A new status variable, Queries, indicates the number of statements executed by the server. This includes statements executed within stored programs, unlike the Questions variable which includes only statements sent to the server by clients. (Bug #41131)

Bugs Fixed

  • 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)

  • In example option files provided in MySQL distributions, the thread_stack value was increased from 64K to 128K. (Bug #41577)

  • SET PASSWORD caused a server crash if the account name was given as CURRENT_USER(). (Bug #41456)

  • The INFORMATION_SCHEMA.SCHEMA_PRIVILEGES table was limited to 7680 rows. (Bug #41079)

  • In debug builds, obsolete debug code could be used to crash the server. (Bug #41041)

  • Some queries that used a range checked for each record scan could return incorrect results. (Bug #40974)

    References: See also Bug #44810.

  • Certain SELECT queries could fail with a Duplicate entry error. (Bug #40953)

  • IF(..., CAST(longtext_val AS UNSIGNED), signed_val) as an argument to an aggregate function could cause an assertion failure. (Bug #40761)

  • The server crashed if an integer field in a CSV file did not have delimiting quotation marks. (Bug #39616)

  • Creating a table with a comment of 62 characters or longer caused a server crash. (Bug #39591)

  • InnoDB could hang trying to open an adaptive hash index. (Bug #39483)

  • Use of spatial data types in prepared statements could cause memory leaks or server crashes. (Bug #37956, Bug #37671)

  • The MONTHNAME() and DAYNAME() functions returned a binary string, so that using LOWER() or UPPER() had no effect. Now MONTHNAME() and DAYNAME() return a value in character_set_connection character set. (Bug #37575)

  • Certain boolean-mode FULLTEXT searches that used the truncation operator did not return matching records and calculated relevance incorrectly. (Bug #37245)

  • 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 Innodb_row_lock_time_max status variable only if ut_usectime() was successful. (Bug #36819)

  • A read past the end of the string could occur while parsing the value of the --innodb-data-file-path option. (Bug #36149)

  • SHOW CREATE TABLE did not display a printable value for the default value of BIT columns. (Bug #35796)

  • The max_length metadata value was calculated incorrectly for the FORMAT() function, which could cause incorrect result set metadata to be sent to clients. (Bug #35558)

  • EXPLAIN EXTENDED evaluation of aggregate functions that required a temporary table caused a server crash. (Bug #34773)

  • 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.

  • Queries executed using join buffering of BIT columns could produce incorrect results. (Bug #31399)

  • ALTER TABLE CONVERT TO CHARACTER SET did not convert TINYTEXT or MEDIUMTEXT columns to a longer text type if necessary when converting the column to a different character set. (Bug #31291)

  • On Windows, Visual Studio does not take into account some x86 hardware limitations, which led to incorrect results converting large DOUBLE values to unsigned BIGINT values. (Bug #27483)

  • SSL support was not included in some generic RPM packages. (Bug #26760)