オリジナル版：http://dev.mysql.com/doc/mysql/en/news-5-0-11.html
最も普及しているオープンソースデータベース管理システムであるのMySQL 5.0.11 ベータ版がリリースされました。コミュニティーエディションは、http://dev.mysql.com/downloads/とミラーサイトのダウンロード・ページから多くのプラットフォームのためのソースおよびバイナリで、現在利用可能です。
すべてのミラーサイトが現在、最新であるとは限らないことに注意してください。あるミラーサイトでこのバージョンを見つけることができない場合は、再度確認を行うか、あるいは別のダウンロード・サイトを選択してください。
これは、5.0シリーズの7回目に発表されたベータリリースとなります。すべての注意は、後の製品リリースのために、5.0のバグフィックスと安定化に焦点を合わせ続けられるでしょう。
注意：このベータリリースは、他の出荷前製品リリースと同様、重大なデータを備えた、「製品」レベルのシステムあるいはシステムにインストールされるべきではありません。新しいバージョンのソフトウェアのインストールの前にデータをバックアップことは良い習慣です。MySQLは高いレベルの品質を確実にするために最善をつくしましたが、あたなが、どんなソフトウェアベータリリースの対しても行うようにバックアップを作ることによって、データを保護してください。
このバージョンで公開され解消された個々のバグに関するその他の詳細については、http://bugs.mysql.com/のバグデータベースを参照してください。
リリース5.0.11の変更点
＝＝＝＝＝＝＝＝＝＝＝
Functionality added or changed:
* Security improvement: Applied a patch that addresses a potential zlib data vulnerability that could result in an application crash. (CAN-2005-1849 (http://cve.mitre.org/cgi-bin/cvename.cgi?name=CAN-2005-1849)) This only affects the binaries for platforms that are linked statically against the bundled zlib (most notably Microsoft Windows and HP-UX).
* SHOW CHARACTER SET and INFORMATION_SCHEMA now properly report the Latin1 character set as cp1252. (Bug #11216 (http://bugs.mysql.com/11216)) mysqldump now dumps triggers for each dumped table. This can be suppressed with the --skip-triggers option. (Bug #10431 (http://bugs.mysql.com/10431))
* Added new ER_STACK_OVERRUN_NEED_MORE error message to indicate that, while the stack is not completely full, more stack space is required. (Bug #11213 (http://bugs.mysql.com/11213))
* NDB: Improved handling of the configuration variables NoOfPagesToDiskDuringRestartACC, NoOfPagesToDiskAfterRestartACC, NoOfPagesToDiskDuringRestartTUP, and NoOfPagesToDiskAfterRestartTUP should result in noticeably faster startup times for MySQL Cluster.(Bug #12149 (http://bugs.mysql.com/12149))
* Added support of where clause for queries with FROM DUAL. (Bug #11745 (http://bugs.mysql.com/11745))
* Added an optimization that avoids key access with NULL keys for the ref method when used in outer joins. (Bug #12144 (http://bugs.mysql.com/12144))
* Maximum size of stored procedures increased from 64k to 4Gb. (Bug #11602 (http://bugs.mysql.com/11602))
* Added error message for users who attempt CREATE TABLE ... LIKE and specify a non-table in the LIKE clause.
(Bug #6859 (http://bugs.mysql.com/6859))
Bugs fixed:
* Creation of the mysql group account failed during the RPM installation.big5 strings were not being stored in FULLTEXT index. (Bug #12075 (http://bugs.mysql.com/12075))
* When DROP DATABASE was called concurrently with a DROP TABLE of any table the MySQL Server crashed. (Bug #12212 (http://bugs.mysql.com/12212)) max_connections_per_hour setting was being capped by unrelated max_user_connections setting. (Bug #9947 (http://bugs.mysql.com/9947))
* SELECT @@local... returned @@session... in the column header. (Bug #10724 (http://bugs.mysql.com/10724))
* Multiplying ABS() output by a negative number would return incorrect results. (Bug #11402 (http://bugs.mysql.com/11402))
* Updated dependency list for RPM builds to include missing dependencies such as useradd and groupadd. (Bug #12233 (http://bugs.mysql.com/12233))
* mysql_install_db used static localhost value in GRANT tables even when server hostname is not localhost, such as localhost.localdomain. This change is applied to version 5.0.10b on Windows. (Bug #11822 (http://bugs.mysql.com/11822))
* Multiple SELECT SQL_CACHE queries in a stored procedure causes error and client hang. (Bug #6897 (http://bugs.mysql.com/6897))
* Added checks to prevent error when allocating memory when there was insufficient memory available. (Bug #7003 (http://bugs.mysql.com/7003))
* Character data truncated when GBK characters 0xA3A0 and 0xA1 are present. (Bug #11987 (http://bugs.mysql.com/11987))
* Comparisons like SELECT "A\\" LIKE "A\\"; fail when using SET NAMES utf8;. (Bug #11754 (http://bugs.mysql.com/11754))
* Corrected inaccurate error message when inserting out of range data under TRADITIONAL SQL mode. (Bug #11546 (http://bugs.mysql.com/11546))
* When used in a SELECT query against a view, the GROUP_CONCAT() function returned only a single row. (Bug #11412 (http://bugs.mysql.com/11412))
* Calling the C API function mysql_stmt_fetch() after all rows of a result set were exhausted would return an error instead of MYSQL_NO_DATA. (Bug #11037 (http://bugs.mysql.com/11037))
* Information about a trigger was not displayed in the output of SELECT ... FROM INFORMATION_SCHEMA.TRIGGERS when the selected database was INFORMATION_SCHEMA, prior to the trigger's first invocation. (Bug #12127 (http://bugs.mysql.com/12127))
* Issuing successive FLUSH TABLES WITH READ LOCK would cause the mysql client to hang. (Bug #11934 (http://bugs.mysql.com/11934))
* In stored procedures, a cursor that fetched an empty string into a variable would set the variable to NULL instead. (Bug #8692 (http://bugs.mysql.com/8692))
* A trigger dependent on a feature of one SQL_MODE setting would cause an error when invoked after the SQL_MODE was changed. (Bug #5891 (http://bugs.mysql.com/5891))
* A delayed insert that would duplicate an existing record crashed the server instead. (Bug #12226 (http://bugs.mysql.com/12226))
* ALTER TABLE when SQL_MODE = 'TRADITIONAL' gave rise to an invalid error message. (Bug #11964 (http://bugs.mysql.com/11964))
* Attempting to repair a table having a fulltext index on a column containing words whose length exceeded 21 characters and where myisam_repair_threads was greater than 1 would crash the server. (Bug #11684 (http://bugs.mysql.com/11684))
* The MySQL Cluster backup log was invalid where the number of Cluster nodes was not equal to a power of 2. (Bug #11675 (http://bugs.mysql.com/11675))
* GROUP_CONCAT() sometimes returned a result with a different collation that that of its arguments. (Bug #10201 (http://bugs.mysql.com/10201))
* The LPAD() and RPAD() functions returned the wrong length to mysql_fetch_fields(). (Bug #11311 (http://bugs.mysql.com/11311))
* A UNIQUE VARCHAR column would be mis-identified as MUL in table descriptions. (Bug #11227 (http://bugs.mysql.com/11227))
* Incorrect error message displayed if user attempted to create a table in a non-existing database using CREATE database_name.table_name syntax. (Bug #10407 (http://bugs.mysql.com/10407))
* InnoDB: Do not flush after each write, not even before setting up the doublewrite buffer. Flushing can be extremely slow on some systems. (Bug #12125 (http://bugs.mysql.com/12125))
* InnoDB: True VARCHAR: Return NULL columns in the format expected by MySQL. (Bug #12186 (http://bugs.mysql.com/12186))
* Two threads could potentially initialize different characters sets and overwrite each other. (Bug #12109 (http://bugs.mysql.com/12109))
* Unsigned LONG system variables may return incorrect value when retreived with a SELECT for certain values. (Bug #10351 (http://bugs.mysql.com/10351))
* Prepared statements were not being written to the Slow Query log. (Bug #9968 (http://bugs.mysql.com/9968))