オリジナル版：http://dev.mysql.com/doc/refman/5.1/en/news-5-1-19.html
最も普及しているオープンソースデータベースの新ベータバージョンであるMySQL 5.1.19ベータ版がリリースされました。
これはベータ版であり、他の多くの試作商品リリースと同様、商品レベルのシステムまたは、重要なデータを含むシステムに対してインストールしないように注意してください。5.0使用の商品レベルのシステムについては、以下のMySQL Enterpriseの商品説明のページをご覧ください。
http://mysql.com/products/enterprise/
MySQL 5.1.19ベータ版は、http://dev.mysql.com/downloads/とミラーサイトのダウンロード・ページから、ソースコード及び多くのプラットフォームのためのバイナリで現在利用可能です。
すべてのミラーサイトが現在、最新であるとは限らないことに注意してください。
あるミラーサイトでこのバージョンを見つけることができない場合は、再度確認を行うか、あるいは別のダウンロード・サイトを選択してください。
バグレポート、バグ修正、パッチ等の情報をお待ちしておりますので、以下のページをご利用ください。
http://forge.mysql.com/wiki/Contributing
以下のセクションはMySQL5.1の最も最近にリリースされたバージョンであるMySQL5.1.18ベータ版と比較してのMySQLソースコードにおけるバージョン間の変更を記載しています。
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-19.html
注意:このリリースをビルドして初めて、NDBクラスタに関する以下の問題が見つかりました。
* Bug#28783 may occur during high load (http://bugs.mysql.com/28783)
The bug will manifest itself by a ndbd node missing heartbeats and
consequently shutting down.
The release should function well under "normal" operation and may be
used for evaluation purposes, however is not suited for high load
testing, as it is likely to hit this bug.
If you wish to evaluate cluster in a high load situation, please use
5.1.18 or wait for 5.1.20.
以下は、追加または変更された機能です。
Functionality added or changed:
* INSERT DELAYED statements for BLACKHOLE tables caused a server
crash. The BLACKHOLE storage engine now supports INSERT
DELAYED. (Bug#27998:http://bugs.mysql.com/27998)
* The BLACKHOLE storage engine now supports LOCK TABLES and
UNLOCK TABLES. (Bug#26241:http://bugs.mysql.com/26241)
* The data type used for the VARIABLE_VALUE column of the
following INFORMATION_SCHEMA tables has been changed to
VARCHAR:
+ GLOBAL_STATUS
+ SESSION_STATUS
+ GLOBAL_VARIABLES
+ SESSION_VARIABLES
For more information, see Section 22.24, "The
INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables,"
Section 22.25, "The INFORMATION_SCHEMA GLOBAL_VARIABLES and
SESSION_VARIABLES Tables," and
Bug#26994:http://bugs.mysql.com/26994
Bugs fixed:
* Security fix: Use of a view could allow a user to gain update
privileges for tables in other databases.
(Bug#27878:http://bugs.mysql.com/27878)
* Security fix: UDFs are supposed to be loadable only from the
plugin directory, but this restriction was not being enforced.
(Bug#28341:http://bugs.mysql.com/28341)
* NDB Cluster: When an API node sent more than 1024 signals in a
single batch, NDB would process only the first 1024 of these,
and then hang. (Bug#28443:http://bugs.mysql.com/28443)
* NDB Cluster (Disk Data): DDL operations were not supported on
a partially started cluster.
(Bug#24631:http://bugs.mysql.com/24631)
* NDB Cluster: A delay in obtaining AUTO_INCREMENT IDs could
lead to excess temporary errors.
(Bug#28410:http://bugs.mysql.com/28410)
* NDB Cluster: Local checkpoint files related to dropped NDB
tables were not removed.
(Bug#28348:http://bugs.mysql.com/28348)
* NDB Cluster: A failure to release internal resources following
an error could lead to problems with single user mode.
(Bug#25818:http://bugs.mysql.com/25818)
* NDB Cluster: Multiple operations involving deletes followed by
reads were not handled correctly.
(Bug#28276:http://bugs.mysql.com/28276)
Note: This issue could also affect MySQL Cluster Replication.
* NDB Cluster (Disk Data): Extremely large inserts into Disk
Data tables could lead to data node failure in some
circumstances. (Bug#27942:http://bugs.mysql.com/27942)
* NDB Cluster: Repeated insertion of data generated by mysqldump
into NDB tables could eventually lead to failure of the
cluster. (Bug#27437:http://bugs.mysql.com/27437)
* NDB Cluster: Restarting a data node caused SQL nodes to log
repeatedly and unnecessarily the status of the event buffer.
(Bug#27292:http://bugs.mysql.com/27292)
(This issue was known to occur in MySQL 5.1.16 and later
only.)
* NDB Cluster: ndb_mgmd failed silently when the cluster
configuration file contained invalid [TCP] entries.
(Bug#27207:http://bugs.mysql.com/27207)
* NDB Cluster: ndb_connectstring did not appear in the output of
SHOW VARIABLES. (Bug#26675:http://bugs.mysql.com/26675)
* NDB Cluster (APIs): In a multi-operation transaction, a delete
operation followed by the insertion of an implicit NULL failed
to overwrite an existing value.
(Bug#20535:http://bugs.mysql.com/20535)
* Changing the size of a key buffer that is under heavy use
could cause a server crash. The fix partially removes the
limitation that LOAD INDEX INTO CACHE fails unless all indexes
in a table have the same block size. Now the statement fails
only if IGNORE LEAVES is specified.
(Bug#17332:http://bugs.mysql.com/17332)
* EXPLAIN for a query on an empty table immediately after its
creation could result in a server crash.
(Bug#28272:http://bugs.mysql.com/28272)
* Grouping queries with correlated subqueries in WHERE
conditions could produce incorrect results.
(Bug#28337:http://bugs.mysql.com/28337)
* libmysql.dll could not be dynamically loaded on Windows.
(Bug#28358:http://bugs.mysql.com/28358)
* Portability problems caused by use of isinf() were corrected.
(Bug#28239:http://bugs.mysql.com/28239)
* Using a TEXT local variable in a stored routine in an
expression such as SET var = SUBSTRING(var, 3) produced an
incorrect result. (Bug#27415:http://bugs.mysql.com/27415)
* A large filesort could result in a division by zero error and
a server crash. (Bug#27119:http://bugs.mysql.com/27119)
* The server could abort or deadlock for INSERT DELAYED
statements for which another insert was performed implicitly
(for example, via a stored function that inserted a row).
(Bug#21483:http://bugs.mysql.com/21483)
* The server could hang for INSERT IGNORE ... ON DUPLICATE KEY
UPDATE if an update failed.
(Bug#28000:http://bugs.mysql.com/28000)
* Quoted labels in stored routines were mishandled, rendering
the routines unusable.
(Bug#21513:http://bugs.mysql.com/21513)
* Changes to some system variables should invalidate statements
in the query cache, but invalidation did not happen.
(Bug#27792:http://bugs.mysql.com/27792)
* Some ALTER TABLE statements that worked in MySQL 5.0 did not
work in 5.1. (Bug#28415:http://bugs.mysql.com/28415)
* Flow control optimization in stored routines could cause
exception handlers to never return or execute incorrect logic.
(Bug#26977:http://bugs.mysql.com/26977)
* An attempt to execute CREATE TABLE ... SELECT when a temporary
table with the same name already existed led to the insertion
of data into the temporary table and creation of an empty
non-temporary table. (Bug#24508:http://bugs.mysql.com/24508)
* Concurrent execution of CREATE TABLE ... SELECT and other
statements involving the target table suffered from various
race conditions, some of which might have led to deadlocks.
(Bug#24738:http://bugs.mysql.com/24738)
* CREATE TABLE IF NOT EXISTS ... SELECT caused a server crash if
the target table already existed and had a BEFORE INSERT
trigger. (Bug#20903:http://bugs.mysql.com/20903)
* Deadlock occurred for attempts to execute CREATE TABLE IF NOT
EXISTS ... SELECT when LOCK TABLES had been used to acquire a
read lock on the target table.
(Bug#20662:http://bugs.mysql.com/20662)
* It was not possible to use the value -9223372036854775808
(that is, -MAXVALUE + 1) when specifying a LIST partition.
(Bug#28005:http://bugs.mysql.com/28005)
* Some InnoDB variables were missing from the output of mysqld
--verbose --help. (Bug#26987:http://bugs.mysql.com/26987)
* CAST() to DECIMAL did not check for overflow.
(Bug#27957:http://bugs.mysql.com/27957)
* Views ignored precision for CAST() operations.
(Bug#27921:http://bugs.mysql.com/27921)
* For InnoDB, in some rare cases the optimizer preferred a more
expensive ref access to a less expensive range access.
(Bug#28189:http://bugs.mysql.com/28189)
* A query with a NOT IN subquery predicate could cause a crash
when the left operand of the predicate evaluated to NULL.
(Bug#28375:http://bugs.mysql.com/28375)
* Comparisons of DATE or DATETIME values for the IN() function
could yield incorrect results.
(Bug#28133:http://bugs.mysql.com/28133)
* LOAD DATA did not use CURRENT_TIMESTAMP as the default value
for a TIMESTAMP column for which no value was provided.
(Bug#27670:http://bugs.mysql.com/27670)