MySQL Community Server 5.0.92 がリリースされました


最も普及しているオープンソースデータベース管理システムの新バージョンであるMySQL Community Server 5.0.92がリリースされました。5.0のアクティブメンテナンスは終了しており、このコミュニティビルドは以下のセキュリティのバグ修正のためにのみ 提供されます。



MySQL Server 5.0のミラーサービスは終了しました。また、利用の少ないいくつかのプラットフォーム向けのサポートも終了しました。 MySQL Server 5.0は現在拡張サポートのみ提供されており、積極的な開発はMySQL 5.1, 5.5以降で行われていることに注意してください。MySQLのライフサイクルポリシーはここで見つけられるでしょう:

あなたのためを思って、われわれはMySQL 5.0を利用しているすべてのユーザにMySQL 5.1にアップグレードすることを強くお勧めします。



以下のセクションは、以前のリリースであるMySQL Community Server 5.0.91以降のMySQLソースコードにおけるバージョン間の変更を記載しています。


あなたが使用するバージョンおよび機能と関係のある修正に関するより詳細かつ個別の更新アラートを受けたい場合、MySQL Enterpriseへの申し込みを検討してください。(商用でMySQLが提供しています)。より詳細な個別の修正情報は以下を参照してください。



Functionality added or changed:

    * The time zone tables available at
http://dev.mysql.com/downloads/timezones.html have been
      updated. These tables can be used on systems such as
      Windows or HP-UX that do not include zoneinfo files.

Bugs fixed:

    * Security Fix: During evaluation of arguments to
      extreme-value functions (such as LEAST() and GREATEST()),
      type errors did not propagate properly, causing the
      server to crash.

    * Security Fix: The server could crash after materializing
      a derived table that required a temporary table for

    * Security Fix: A user-variable assignment expression that
      is evaluated in a logical expression context can be
      precalculated in a temporary table for GROUP BY. However,
      when the expression value is used after creation of the
      temporary table, it was re-evaluated, not read from the
      table and a server crash resulted.

    * Security Fix: Joins involving a table with a unique SET
      column could cause a server crash.

    * Security Fix: Pre-evaluation of LIKE predicates during
      view preparation could cause a server crash.

    * Security Fix: GROUP_CONCAT() and WITH ROLLUP together
      could cause a server crash.

    * Security Fix: Queries could cause a server crash if the
      GREATEST() or LEAST() function had a mixed list of
      numeric and LONGBLOB arguments, and the result of such a
      function was processed using an intermediate temporary

    * Security Fix: Using EXPLAIN with queries of the form
      SELECT ... UNION ... ORDER BY (SELECT ... WHERE ...)
      could cause a server crash.

    * InnoDB Storage Engine: Creating or dropping a table with
      1023 transactions active caused an assertion failure.

    * The make_binary_distribution target to make could fail on
      some platforms because the lines generated were too long
      for the shell.

    * A client could supply data in chunks to a prepared
      statement parameter other than of type TEXT or BLOB using
      the mysql_stmt_send_long_data() C API function (or
      COM_STMT_SEND_LONG_DATA command). This led to a crash
      because other data types are not valid for long data.

    * Builds of the embedded mysqld would fail due to a missing
      element of the struct NET.

    * The definition of the MY_INIT macro in my_sys.h included
      an extraneous semicolon, which could cause compilation

    * If the remote server for a FEDERATED table could not be
      accessed, queries for the INFORMATION_SCHEMA.TABLES table

    * mysqld could fail during execution when using SSL.

    * Threads that were calculating the estimated number of
      records for a range scan did not respond to the KILL
      statement. That is, if a range join type is possible
      (even if not selected by the optimizer as a join type of
      choice and thus not shown by EXPLAIN), the query in the
      statistics state (shown by the SHOW PROCESSLIST) did not
      respond to the KILL statement.