Dear MySQL users, We are proud to present to you the MySQL Server 5.1.19 Beta release, a new Beta version of the popular open source database.
Bear in mind that this is a beta release, and as any other pre-production release, caution should be taken when installing on production level systems or systems with critical data. For production level systems using 5.0, pay attention to the product description of MySQL Enterprise at: http://mysql.com/products/enterprise/ The MySQL 5.1.19 Beta release is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point in time, so if you can't find this version on some mirror, please try again later or choose another download site. We welcome and appreciate your feedback, bug reports, bug fixes, patches etc.: http://forge.mysql.com/wiki/Contributing The following section lists the changes from version to version in the MySQL source code since the latest released version of MySQL 5.1, the MySQL 5.1.18-beta. It can also be viewed online at http://dev.mysql.com/doc/refman/5.1/en/news-5-1-19.html Note: The following problem with NDB (cluster) was detected only after building this release: * 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) Enjoy, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
