MySQL 6.0.11 Alpha has been released!

[Jonathan Perkin]

Dear MySQL users,

MySQL 6.0.11-alpha, a new version of the MySQL database system has been
released. The main page for MySQL 6.0 release is at

http://www.mysql.com/mysql60/

6.0.11 will be the last release of 6.0. After this we will be
transitioning into a New Release Model for the MySQL Server

http://forge.mysql.com/wiki/Development_Cycle

The goal of this transition is to enable more frequent and timely
releases of the MySQL Server.

The planned milestone for September 2009 will probably include most of
the features from 6.0. More detail on which, will be communicated
before end of June. Features not in this milestone (e.g. Online Backup,
Falcon, Connection thread pooling, and 4 Byte UTF Support) are planned
for future milestones when they stabilize.

MySQL 6.0 includes two new storage engines: the transactional Falcon
engine, and the crash-safe Maria engine.

If you are new to the Falcon storage engine and need more information,
please read the Falcon Evaluation Guide at

http://www.mysql.com/why-mysql/white-papers/falcon-getting-started.php

and the Falcon White Paper at

http://www.mysql.com/why-mysql/white-papers/storage-engines-falcon.php

The Maria storage engine is a crash-safe version of MyISAM. Maria
supports all of the main functionality of the MyISAM engine, plus recovery
support (in the event of a system crash), all MyISAM row formats and a new
Maria-specific row format. Maria is documented at

http://dev.mysql.com/doc/refman/6.0/en/se-maria.html

MySQL 6.0.11-alpha is available in source and binary form for a number of
platforms from our download pages at

http://dev.mysql.com/downloads/mysql/6.0.html

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, and
patches at

http://forge.mysql.com/wiki/Contributing

The following section lists functionality which has been added or changed,
as well as security-related, incompatible and important bugs fixes since
the previous version of MySQL 6.0. The full changelog including many
other changes can be viewed online at

http://dev.mysql.com/doc/refman/6.0/en/news-6-0-11.html

Enjoy!

Jonathan Perkin
The MySQL Build Team, Sun Microsystems

==============================================================================

   Functionality added or changed:

     * Incompatible Change: The optimizer_switch system variable
       controls optimizations that can be switched on and off. The
       syntax for flags in its value has changed from 'no_opt_name'
       to 'opt_name={on|off|default}'. For information about the new
       syntax, see Section 7.2.22, "Using optimizer_switch to Control
       the Optimizer."

     * Replication: The global server variables sync_master_info and
       sync_relay_log_info are introduced for use on replication
       slaves to control synchronization of, respectively, the
       master.info and relay.info files.
       In each case, setting the variable to a nonzero integer value
       N causes the slave to synchonize the corresponding file to
       disk after every N events. Setting its value to 0 allows the
       operation system to handle syncronization of the file instead.
       The actions of these variables, when enabled, are analogous to
       how the sync_binlog variable works with regard to binary logs
       on a replication master.
       These variables can also be set in my.cnf, or by using the
       server options --sync-master-info and --sync-relay-log-info
       respectively.
       An additional system variable relay_log_recovery is also now
       available. When enabled, this variable causes a replication
       slave to discard relay log files obtained from the replication
       master following a crash.
       This variable can also be set in my.cnf, or by using the
       --relay-log-recovery server option.
       This fix improves and expands upon one made in MySQL 6.0.10
       which introduced the sync_relay_log variable. For more
       information about all of the server system variables
       introduced by these fixes, see Section 16.1.3.3, "Replication
       Slave Options and Variables."
       (Bug#31665: http://bugs.mysql.com/31665,
       Bug#35542: http://bugs.mysql.com/35542,
       Bug#40337: http://bugs.mysql.com/40337)

     * mysql-test-run.pl now supports an --experimental=file_name
       option. It enables you to specify a file that contains a list
       of test cases that should be displayed with the [ exp-fail ]
       code rather than [ fail ] if they fail.
       (Bug#42888: http://bugs.mysql.com/42888)

     * The MD5 algorithm now uses the Xfree implementation.
       (Bug#42434: http://bugs.mysql.com/42434)

     * The RESTORE statement now has a SKIP_GAP_EVENT option that
       causes the restore operation not to write the gap event to the
       binary log that causes any replication slaves to stop
       replication. This is useful when RESTORE is run on a master
       server and the backup image does not contain databases that
       are replicated to the slaves.
       (Bug#39780: http://bugs.mysql.com/39780)

     * Previously, the --secure-file-priv option and secure_file_priv
       system variable, if set to a directory, limited BACKUP
       DATABASE and RESTORE operations to files in the given
       directory. Now the --secure-backup-file-priv option and
       secure_backup_file_priv system variable apply instead.
       (Bug#39581: http://bugs.mysql.com/39581)

     * The query cache now checks whether a SELECT statement begins
       with SQL_NO_CACHE to determine whether it can skip checking
       for the query result in the query cache. This is not supported
       when SQL_NO_CACHE occurs within a comment.
       (Bug#37416: http://bugs.mysql.com/37416)

     * A new program, mysqlbackup, displays information from backups
       created with the BACKUP DATABASE statement.

     * MySQL now implements the SQL standard SIGNAL and RESIGNAL
       statements. See Section 12.8.8, "SIGNAL and RESIGNAL."

   Bugs fixed:

     * Incompatible Change: For system variables that take values of
       ON or OFF, OF was accepted as a legal variable. Now system
       variables that take "enumeration" values must be assigned the
       full value. This affects some other variables that previously
       could be assigned using unambiguous prefixes of allowable
       values, such as tx_isolation.
       (Bug#34828: http://bugs.mysql.com/34828)

     * Incompatible Change: If a data definition language (DDL)
       statement occurred for a table that was being used by another
       session in an active transaction, statements could be written
       to the binary log in the wrong order. For example, this could
       happen if DROP TABLE occurred for a table being used in a
       transaction. This is now prevented by deferring release of
       metadata locks on tables used within a transaction until the
       transaction ends.
       This bug fix results in some incompatibilities with previous
       versions:

          + A table that is being used by a transaction within one
            session cannot be used in DDL statements by other
            sessions until the transaction ends.

          + FLUSH TABLES WITH READ LOCK blocks for active
            transactions that hold metadata locks until those
            transactions end. The same is true for attempts to set
            the global value of the read_only system variable.
       (Bug#989: http://bugs.mysql.com/989)

     * Important Change: Replication: CHANGE MASTER TO ...
       MASTER_HOST='' --- explicitly setting MASTER_HOST equal to an
       empty string --- created a master.info file with an empty host
       field. This led to a The server is not configured as slave
       error when attempting to execute a START SLAVE statement. Now,
       if MASTER_HOST is set to an empty string, the CHANGE MASTER TO
       statement fails with an error.
       (Bug#28796: http://bugs.mysql.com/28796)

     * Replication: Important Note: Binary logging with
       --binlog_format=ROW failed when a change to be logged included
       more than 251 columns. This issue was not known to occur with
       mixed-format or statement-based logging.
       (Bug#42977: http://bugs.mysql.com/42977)
       See also Bug#42914: http://bugs.mysql.com/42914.

     * Replication: The SHOW SLAVE STATUS connection thread competed
       with the slave SQL thread for use of the error message buffer.
       As a result, the connection thread sometimes received
       incomplete messages. This issue was uncovered with valgrind
       when message strings were passed without NULL terminators,
       causing the error Conditional jump or move depends on
       uninitialised value(s).
       (Bug#43076: http://bugs.mysql.com/43076)

     * Replication: This fix handles 2 issues encountered on
       replication slaves during startup:

         1. A failure while allocating the master info structure
            caused the slave to crash.

         2. A failure during recovery caused the relay log file not
            to be properly initialized which led to a crash on the
            slave.
       (Bug#43075: http://bugs.mysql.com/43075)

     * Replication: Assigning an invalid directory for the
       --slave-load-tmpdir caused the replication slave to crash.
       (Bug#42861: http://bugs.mysql.com/42861)

     * Replication: The mysql.procs_priv system table was not
       replicated. (Bug#42217: http://bugs.mysql.com/42217)

     * Replication: When --binlog_format was set to STATEMENT, a
       statement unsafe for statement-based logging caused an error
       or warning to be issued even if sql_log_bin was set to 0.
       (Bug#41980: http://bugs.mysql.com/41980)

     * Replication: An INSERT DELAYED into a TIMESTAMP column issued
       concurrently with a an insert on the same column not using
       DELAYED, but applied after the other insert, was logged using
       the same timestamp as generated by the other (non-DELAYED)
       insert. (Bug#41719: http://bugs.mysql.com/41719)

     * Replication: When using MIXED replication format and temporary
       tables were created in statement-based mode, but a later
       operation in the same session caused a switch to row-based
       mode, the temporary tables were not dropped on the slave at
       the end of the session.
       (Bug#40013: http://bugs.mysql.com/40013)
       See also Bug#43046: http://bugs.mysql.com/43046.
       This regression was introduced by
       Bug#20499: http://bugs.mysql.com/20499.

     * Replication: When using the MIXED replication format, UPDATE
       and DELETE statements that searched for rows where part of the
       key had nullable BIT columns failed. This occurred because
       operations that inserted the data were replicated as
       statements, but UPDATE and DELETE statements affecting the
       same data were replicated using row-based format.
       This issue did not occur when using statement-based
       replication (only) or row-based replication (only).
       (Bug#39753: http://bugs.mysql.com/39753)
       See also Bug#39648: http://bugs.mysql.com/39648.

     * Replication: The MIXED binary logging format did not switch to
       row-based mode for statements containing the LOAD_FILE()
       function. (Bug#39701: http://bugs.mysql.com/39701)

     * Replication: The server SQL mode in effect when a stored
       procedure was created was not retained in the binary log. This
       could cause a CREATE PROCEDURE statement that succeeded on the
       master to fail on the slave.
       This issue was first noticed when a stored procedure was
       created when ANSI_QUOTES was in effect on the master, but
       could possibly cause failed CREATE PROCEDURE statements and
       other problems on the slave when using other server SQL modes
       as well. (Bug#39526: http://bugs.mysql.com/39526)

     * Replication: If --secure-file-priv was set on the slave, it
       was unable to execute LOAD DATA INFILE statements sent from
       the master when using mixed-format or statement-based
       replication.
       As a result of this fix, this security restriction is now
       ignored on the slave in such cases; instead the slave checks
       whether the files were created and should be read by the slave
       in its --slave-load-tmpdir.
       (Bug#38174: http://bugs.mysql.com/38174)

     * Replication: Server IDs greater than 2147483647 (2^32 - 1)
       were represented by negative numbers in the binary log.
       (Bug#37313: http://bugs.mysql.com/37313)

     * Replication: The value of Slave_IO_running in the output of
       SHOW SLAVE STATUS did not distinguish between all 3 possible
       states of the slave I/O thread (not running; running but not
       connected; connected). Now the value Connecting (rather than
       No) is shown when the slave I/O thread is running but the
       slave is not connected to a replication master.
       The server system variable Slave_running also reflects this
       change, and is now consistent with what is shown for
       Slave_IO_running. (Bug#30703: http://bugs.mysql.com/30703,
       Bug#41613: http://bugs.mysql.com/41613)

     * Replication: Queries which were written to the slow query log
       on the master were not written to the slow query log on the
       slave. (Bug#23300: http://bugs.mysql.com/23300)

     * Replication: When the server SQL mode included IGNORE_SPACE,
       statement-based replication of LOAD DATA INFILE ... INTO
       tbl_name failed because the statement was read incorrectly
       from the binary log; a trailing space was omitted, causing the
       statement to fail with a syntax error when run on the slave.
       (Bug#22504: http://bugs.mysql.com/22504)
       See also Bug#43746: http://bugs.mysql.com/43746.

     * Replication: When its disk becomes full, a replication slave
       may wait while writing the binary log, relay log or MyISAM
       tables, continuing after space has been made available. The
       error message provided in such cases was not clear about the
       frequency with which checking for free space is done (once
       every 60 seconds), and how long the server waits after space
       has been freed before continuing (also 60 seconds); this
       caused users to think that the server had hung.
       These issues have been addressed by making the error message
       clearer, and dividing it into two separate messages:

         1. The error message Disk is full writing 'filename'
            (Errcode: error_code). Waiting for someone to free
            space... (Expect up to 60 secs delay for server to
            continue after freeing disk space) is printed only once.

         2. The warning Retry in 60 secs, Message reprinted in 600
            secs is printed once every for every 10 times that the
            check for free space is made; that is, the check is
            performed once each 60 seconds, but the reminder that
            space needs to be freed is printed only once every 10
            minutes (600 seconds).
       (Bug#22082: http://bugs.mysql.com/22082)

     * Memory corruption of join buffers could occur when using the
       Batched Key Access algorithm with incremental join buffers to
       execute join operations for a query over several tables that
       selects BLOB values. (Bug#44250: http://bugs.mysql.com/44250)

     * The server could crash at startup when initializing plugins
       listed in the plugin table.
       (Bug#44137: http://bugs.mysql.com/44137)

     * A RESTORE operation that restored a MyISAM table using the
       native MyISAM restore driver could cause the MyISAM key cache
       to be disabled. (Bug#44068: http://bugs.mysql.com/44068)

     * In some cases, when the Batched Key Access algorithm is used
       with join_cache_level equal to 6, multi-join queries could
       return incorrect results.
       (Bug#44019: http://bugs.mysql.com/44019)

     * valgrind would report errors for the StorageInterface,
       StorageHAndler and CmdGen portions of Falcon.
       (Bug#43995: http://bugs.mysql.com/43995)

     * On 64-bit debug builds, code in safemalloc resulted in errors
       due to use of a 32-bit value for 64-bit allocations.
       (Bug#43885: http://bugs.mysql.com/43885)

     * When performing a high number of concurrent index updates on a
       Falcon table, mysqld could crash due to an assertion.
       (Bug#43765: http://bugs.mysql.com/43765)

     * An attempt by a user who did not have the SUPER privilege to
       kill a system thread could cause a server crash.
       (Bug#43748: http://bugs.mysql.com/43748)

     * On Windows, incorrectly specified link dependencies in
       CMakeLists.txt resulted in link errors for mysql_embedded,
       mysqltest_embedded, and mysql_client_test_embedded.
       (Bug#43715: http://bugs.mysql.com/43715)

     * make distcheck failed to properly handle subdirectories of
       storage/ndb. (Bug#43614: http://bugs.mysql.com/43614)

     * Incorrect use of parser information could lead to acquisition
       of incorrect lock types.
       (Bug#43568: http://bugs.mysql.com/43568)

     * Upgrading MySQL to 6.0.10 from 6.0.9 when using Falcon tables
       and the mysql_upgrade tool would cause mysqld to crash during
       start up. (Bug#43562: http://bugs.mysql.com/43562)

     * Running a SELECT using a range query on FLOAT on a Maria table
       could return invalid result sets.
       (Bug#43552: http://bugs.mysql.com/43552)

     * Running a SELECT using a range query on with <> or < with a
       negative values on a Maria table could return invalid result
       sets. (Bug#43530: http://bugs.mysql.com/43530)

     * Running a SELECT on a multi-range query with a LIMIT clause on
       a Maria table could return invalid result sets.
       (Bug#43527: http://bugs.mysql.com/43527)

     * Executing a LIMIT ... FOR UPDATE statement on a Falcon table
       when using transactions with concurrent threads could cause a
       crash because the record information cannot be accessed
       correctly. (Bug#43488: http://bugs.mysql.com/43488)

     * When performing SELECT statements on a Falcon table using an
       indexed INTEGER column could return incorrect row matches.
       (Bug#43452: http://bugs.mysql.com/43452)

     * RESTORE on a case-insensitive server failed if the backup
       image contained databases or tables with uppercase names. Now,
       RESTORE handles this case by converting the names to lowercase
       in the restore catalog, as long as there are no duplicate
       names after the conversion.
       (Bug#43363: http://bugs.mysql.com/43363)

     * Use of USE INDEX hints could cause EXPLAIN EXTENDED to crash.
       (Bug#43354: http://bugs.mysql.com/43354)

     * BACKUP DATABASE stored incorrect table counts in the backup
       image. (Bug#43324: http://bugs.mysql.com/43324)

     * Assigning a value to the backupdir system variable resulted in
       Valgrind errors. (Bug#43303: http://bugs.mysql.com/43303)

     * mysql crashed if a request for the current database name
       returned an empty result, such as after the client has
       executed a preceding SET sql_select_limit=0 statement.
       (Bug#43254: http://bugs.mysql.com/43254)

     * If the value of the version_comment system variable was too
       long, the mysql client displayed a truncated startup message.
       (Bug#43153: http://bugs.mysql.com/43153)

     * Compilation failures on Windows Vista using Visual Studio 2008
       Professional were corrected.
       (Bug#43120: http://bugs.mysql.com/43120)

     * Recovering a Falcon table from a failure when the table
       contains BLOB columns could cause an assertion failure.
       (Bug#43106: http://bugs.mysql.com/43106)

     * On 32-bit Windows, mysqld could not use large buffers due to a
       2GB user mode address limit.
       (Bug#43082: http://bugs.mysql.com/43082)

     * mysqld would crash when using Falcon tables during shutdown if
       the server was running in embedded mode.
       (Bug#43048: http://bugs.mysql.com/43048)

     * The MySQL Backup library had incorrect logic and error
       reporting for metadata saving.
       (Bug#42959: http://bugs.mysql.com/42959)

     * Queries of the following form returned an empty result:
       SELECT ... WHERE ... (col=col AND col=col) OR ...
       (false expression)
       (Bug#42957: http://bugs.mysql.com/42957)

     * A two-way join query with a GROUP BY or ORDER BY clause could
       produce incorrect results when rows of the first table are
       accessed by an index compatible with the GROUP BY or ORDER BY
       list while the second table is joined using the Batched Key
       Access algorithm. (Bug#42955: http://bugs.mysql.com/42955)

     * The strings/CHARSET_INFO.txt file was not included in source
       distributions. (Bug#42937: http://bugs.mysql.com/42937)

     * When running REPAIR on a crashed Falcon table can crash mysqld
       if pages have been incorrectly marked dirty, but not locked,
       during write. (Bug#42824: http://bugs.mysql.com/42824)

     * stderr should be unbuffered, but when the server redirected
       stderr to a file, it became buffered.
       (Bug#42790: http://bugs.mysql.com/42790)

     * The DATA_TYPE column of the INFORMATION_SCHEMA.COLUMNS table
       displayed the UNSIGNED attribute for floating-point data
       types. (The column should contain only the data type name.)
       (Bug#42758: http://bugs.mysql.com/42758)

     * Recovery of Falcon tables while there were active transaction
       during the crash may fail to recover completely.
       (Bug#42743: http://bugs.mysql.com/42743)

     * Use of semijoin optimization could cause a server crash.
       (Bug#42740: http://bugs.mysql.com/42740)

     * When Falcon is populating the INFORMATION_SCHEMA.TABLESPACES
       table, an exception can be raised because required result set
       has been closed before the resultset has been completed. This
       can happen during a BACKUP operation.
       (Bug#42725: http://bugs.mysql.com/42725,
       Bug#42830: http://bugs.mysql.com/42830)

     * Assigning a value to the backupdir system variable resulted in
       a memory leak. (Bug#42695: http://bugs.mysql.com/42695)

     * Assigning an incorrect value to the backup_progress_log_file
       system variable resulted in Valgrind errors.
       (Bug#42685: http://bugs.mysql.com/42685)

     * When performing SELECT queries on tables containing TIMESTAMP
       or DATETIME colums with indexes using a WHERE clause comparing
       the field value to NULL using the <= or <> operators, the
       wrong information would be returned.
       (Bug#42683: http://bugs.mysql.com/42683,
       Bug#43623: http://bugs.mysql.com/43623,
       Bug#43620: http://bugs.mysql.com/43620,
       Bug#42681: http://bugs.mysql.com/42681)

     * A dangling pointer in mysys/my_error.c could lead to client
       crashes. (Bug#42675: http://bugs.mysql.com/42675)

     * mysqldump included views that were excluded with the
       --ignore-table option.
       (Bug#42635: http://bugs.mysql.com/42635)

     * An earlier bug fix resulted in the problem that the InnoDB
       plugin could not be used with a server that was compiled with
       the built-in InnoDB. To handle this two changes were made:

          + The server now supports an --ignore-builtin-innodb
            (http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters
            .html#option_mysqld_ignore-builtin-innodb) option that
            causes the server to behave as if the built-in InnoDB is
            not present. This option causes other InnoDB options not
            to be recognized.

          + For the INSTALL PLUGIN statement, the server reads option
            (my.cnf) files just as during server startup. This
            enables the plugin to pick up any relevant options from
            those files. Consequently, a plugin no longer is started
            with each option set to its default value.
            Because of this change, it is possible to add plugin
            options to an option file even before loading a plugin
            (if the loose prefix is used). It is also possible to
            uninstall a plugin, edit my.cnf, and install the plugin
            again. Restarting the plugin this way enables it to the
            new option values without a server restart.

       Note
       InnoDB Plugin versions 1.0.4 and higher will take advantage of
       this bug fix. Although the InnoDB Plugin is source code
       compatible with multiple MySQL releases, a given binary InnoDB
       Plugin can be used only with a specific MySQL release. When
       InnoDB Plugin 1.0.4 is released, it is expected to be compiled
       for MySQL 5.1.34. For 5.1.33, you can use InnoDB Plugin 1.0.3,
       but you must build from source.
       (Bug#42610: http://bugs.mysql.com/42610)
       This regression was introduced by
       Bug#29263: http://bugs.mysql.com/29263.

     * With the ONLY_FULL_GROUP_BY SQL mode enabled, some legal
       queries failed. (Bug#42567: http://bugs.mysql.com/42567)

     * Recovery of a Falcon table with a large number of rows can
       cause a failure in the page type written for the internal
       FALCON_USER and FALCON_TEMPORARY tablespaces.
       (Bug#42560: http://bugs.mysql.com/42560)

     * Passing an unknown time zone specification to CONVERT_TZ()
       resulted in a memory leak.
       (Bug#42502: http://bugs.mysql.com/42502)

     * Tables could enter open table cache for a thread without being
       properly cleaned up, leading to a server crash.
       (Bug#42419: http://bugs.mysql.com/42419)

     * Previously, RESTORE would crash if the backup image contained
       tables originally stored in a tablespace that no longer
       existed at RESTORE time. Now the tablespace is recreated like
       it was at BACKUP DATABASE time if it does not exist when
       RESTORE is executed. (Bug#42402: http://bugs.mysql.com/42402)

     * If the server was started with
       --thread_handling=pool-of-threads, the MAX_QUERIES_PER_HOUR
       user resource limit. (Bug#42384: http://bugs.mysql.com/42384)

     * Recovery of Falcon tables with indexes can fail because the
       index page information has not been recorded properly.
       (Bug#42344: http://bugs.mysql.com/42344)

     * Using a LIKE clause on a Maria table using an index and the
       CP1251 collation would return invalid data.
       (Bug#42299: http://bugs.mysql.com/42299)

     * Running a SELECT using a JOIN on a Maria table could return
       invalid result sets. (Bug#42298: http://bugs.mysql.com/42298)

     * Running multi-range queries on Maria tables could cause a
       crash. (Bug#42297: http://bugs.mysql.com/42297)

     * Using a falcon-scavenge-schedule of * * * * * would cause
       Falcon to never execute the required threads to operate.
       (Bug#42275: http://bugs.mysql.com/42275)

     * If the server was started with an option that had a missing or
       invalid value, a subsequent error that would cause normally
       the server to shut down could cause it to crash instead.
       (Bug#42244: http://bugs.mysql.com/42244)

     * Using ORDER BY and or LIMIT on Falcon tables could give
       inconsistent results for rows that contain NULL columns in the
       corresponding ORDER BY clause.
       (Bug#42208: http://bugs.mysql.com/42208)

     * For InnoDB tables, there was a race condition for ALTER TABLE,
       OPTIMIZE TABLE, CREATE INDEX, and DROP INDEX operations when
       periodically checking whether table copying can be committed.
       (Bug#42152: http://bugs.mysql.com/42152)

     * In InnoDB recovery after a server crash, table lookup could
       fail and corrupt the data dictionary cache.
       (Bug#42075: http://bugs.mysql.com/42075)

     * mysqldumpslow parsed the --debug and --verbose options
       incorrectly. (Bug#42027: http://bugs.mysql.com/42027)

     * BACKUP DATABASE and RESTORE did not implement backup and
       restore of privileges for stored procedures and stored
       functions. (Bug#41979: http://bugs.mysql.com/41979)

     * Recovering a Falcon table that uses BLOB columns could cause
       unbounded tablespace growth before recovery completes.
       (Bug#41840: http://bugs.mysql.com/41840)

     * Recovery of Falcon tables could fail with an indicating that a
       wrong page type was identified in the Falcon serial log.
       (Bug#41837: http://bugs.mysql.com/41837,
       Bug#42745: http://bugs.mysql.com/42745,
       Bug#44114: http://bugs.mysql.com/44114)

     * RESTORE crashed for Falcon tables.
       (Bug#41722: http://bugs.mysql.com/41722)

     * With more than two arguments, LEAST(), GREATEST(), and CASE
       could unnecessarily return Illegal mix of collations errors.
       (Bug#41627: http://bugs.mysql.com/41627)

     * Queries that used the loose index scan access method could
       return no rows. (Bug#41610: http://bugs.mysql.com/41610)

     * RESTORE failed if it tried to restore a privilege for a
       non-existent object. (Bug#41578: http://bugs.mysql.com/41578)

     * In InnoDB recovery after a server crash, rollback of a
       transaction that updated a column from NULL to NULL could
       cause another crash. (Bug#41571: http://bugs.mysql.com/41571)

     * The mysql client could misinterpret its input if a line was
       longer than an internal buffer.
       (Bug#41486: http://bugs.mysql.com/41486)

     * The error message for a too-long column comment was Unknown
       error rather than a more appropriate message.
       (Bug#41465: http://bugs.mysql.com/41465)

     * The Falcon CycleManager has been updated, which addresses a
       number of issues when examining records in various transaction
       states and their visisbility/isolation in relation to other
       threads. (Bug#41391: http://bugs.mysql.com/41391,
       Bug#41478: http://bugs.mysql.com/41478,
       Bug#41742: http://bugs.mysql.com/41742,
       Bug#41850: http://bugs.mysql.com/41850,
       Bug#42459: http://bugs.mysql.com/42459,
       Bug#41661: http://bugs.mysql.com/41661,
       Bug#42185: http://bugs.mysql.com/42185,
       Bug#43146: http://bugs.mysql.com/43146,
       Bug#43298: http://bugs.mysql.com/43298,
       Bug#43299: http://bugs.mysql.com/43299,
       Bug#34624: http://bugs.mysql.com/34624,
       Bug#42189: http://bugs.mysql.com/42189)

     * Use of SELECT * allowed users with rights to only some columns
       of a view to access all columns.
       (Bug#41354: http://bugs.mysql.com/41354)

     * If the tables underlying a MERGE table had a primary key but
       the MERGE table itself did not, inserting a duplicate row into
       the MERGE table caused a server crash.
       (Bug#41305: http://bugs.mysql.com/41305)

     * In the help command output displayed by mysql, the description
       for the \c (clear) command was misleading.
       (Bug#41268: http://bugs.mysql.com/41268)

     * Several resource leaks were corrected in the error-handling
       code for the MySQL Backup library.
       (Bug#41250: http://bugs.mysql.com/41250,
       Bug#41294: http://bugs.mysql.com/41294)

     * The server did not robustly handle problems hang if a table
       opened with HANDLER needed to be re-opened because it had been
       altered to use a different storage engine that does not
       support HANDLER. The server also failed to set an error if the
       re-open attempt failed. These problems could cause the server
       to crash or hang. (Bug#41110: http://bugs.mysql.com/41110,
       Bug#41112: http://bugs.mysql.com/41112)

     * SELECT statements executed concurrently with INSERT statements
       for a MyISAM table could cause incorrect results to be
       returned from the query cache.
       (Bug#41098: http://bugs.mysql.com/41098)

     * For prepared statements, multibyte character sets were not
       taking into account when calculating max_length for string
       values and mysql_stmt_fetch() could return truncated strings.
       (Bug#41078: http://bugs.mysql.com/41078)

     * For user-defined variables in a query result, incorrect length
       values were returned in the result metadata.
       (Bug#41030: http://bugs.mysql.com/41030)

     * Using RESTORE to restore a database through a named pipe
       resulted in corrupt data.
       (Bug#40975: http://bugs.mysql.com/40975)

     * Performing SELECT operations on Falcon tables using the
       maximum BIG INT value would fail to return matching rows.
       (Bug#40950: http://bugs.mysql.com/40950)

     * For some queries, an equality propagation problem could cause
       a = b and b = a to be handled differently.
       (Bug#40925: http://bugs.mysql.com/40925)

     * With strict SQL mode enabled, setting a system variable to an
       out-of-bounds value caused an assertion failure.
       (Bug#40657: http://bugs.mysql.com/40657)

     * Table temporary scans were slower than necessary due to use of
       mmap rather than caching, even with the myisam_use_mmap system
       variable disabled. (Bug#40634: http://bugs.mysql.com/40634)

     * Indexes on Falcon tables using numeric columns could return
       incorrect information.
       (Bug#40607: http://bugs.mysql.com/40607,
       Bug#41582: http://bugs.mysql.com/41582,
       Bug#40950: http://bugs.mysql.com/40950)

     * The load_defaults(), my_search_option_files() and
       my_print_default_files() functions in the C client library
       were subject to a race condition in multi-threaded operation.
       (Bug#40552: http://bugs.mysql.com/40552)

     * For a view that references a table in another database,
       mysqldump wrote the view name qualified with the current
       database name. This makes it impossible to reload the dump
       file into a different database.
       (Bug#40345: http://bugs.mysql.com/40345)

     * On platforms where long and pointer variables have different
       sizes, MyISAM could copy key statistics incorrectly, resulting
       in a server crash or incorrect cardinality values.
       (Bug#40321: http://bugs.mysql.com/40321)

     * Falcon could cause an assertion when the system has run out of
       memory and tries to report the memory allocation failure.
       (Bug#40155: http://bugs.mysql.com/40155)

     * DELETE tried to acquire write (not read) locks for tables
       accessed within a subquery of the WHERE clause.
       (Bug#39843: http://bugs.mysql.com/39843)

     * mysql_upgrade did not remove the online_backup and
       online_backup_progress tables from the mysql database. (These
       are what the backup_history and backup_progress tables were
       called previously.) (Bug#39655: http://bugs.mysql.com/39655)

     * With row-based binary logging, replication of InnoDB tables
       containing NULL-valued BIT columns could fail.
       (Bug#39648: http://bugs.mysql.com/39648)

     * When using Falcon and the system runs out of all memory and
       swap space, mysqld could hang while attempting to write an
       error message. (Bug#39552: http://bugs.mysql.com/39552)

     * The mysql_stmt_close() C API function did not flush all
       pending data associated with the prepared statement.
       (Bug#39519: http://bugs.mysql.com/39519)

     * Updating Falcon tables after an online ALTER ADD COLUMN
       operation could fail. (Bug#39445: http://bugs.mysql.com/39445)

     * Following ALTER TABLE ... DISCARD TABLESPACE for an InnoDB
       table, an attempt to determine the free space for the table
       before the ALTER TABLE operation had completely finished could
       cause a server crash. (Bug#39438: http://bugs.mysql.com/39438)

     * perror did not produce correct output for error codes 153 to
       163. (Bug#39370: http://bugs.mysql.com/39370)

     * If --basedir was specified, mysqld_safe did not use it when
       attempting to locate my_print_defaults.
       (Bug#39326: http://bugs.mysql.com/39326)

     * Several functions in libmysqld called exit() when an error
       occurred rather than returning an error to the caller.
       (Bug#39289: http://bugs.mysql.com/39289)

     * Performing an online ALTER TABLE statement against a Falcon
       table, the Falcon serial log could grow beyond the maximum
       permitted size for a serial log, ignoring both the rotation
       and truncation. (Bug#39130: http://bugs.mysql.com/39130)

     * Previously, the num_objects column in the backup_history table
       showed only the number of tables in the backup image. It now
       shows the number of objects with names (tablespaces,
       databases, tables, views, stored programs).
       (Bug#39109: http://bugs.mysql.com/39109)

     * BACKUP DATABASE treated the database list in case-sensitive
       fashion, even on case-insensitive file systems.
       (Bug#39063: http://bugs.mysql.com/39063)

     * The ALTER ROUTINE privilege incorrectly allowed SHOW CREATE
       TABLE. (Bug#38347: http://bugs.mysql.com/38347)

     * BACKUP DATABASE crashed if there was no default database.
       (Bug#38294: http://bugs.mysql.com/38294)

     * Setting a savepoint with the same name as an existing
       savepoint incorrectly deleted any other savepoints that had
       been set in the meantime. For example, setting savepoints
       named a, b, c, b resulted in savepoints a, b, rather than the
       correct savepoints a, c, b.
       (Bug#38187: http://bugs.mysql.com/38187)

     * Locking of myisam.log did not work correctly on Windows.
       (Bug#38133: http://bugs.mysql.com/38133,
       Bug#41224: http://bugs.mysql.com/41224)

     * --help output for myisamchk did not list the --HELP option.
       (Bug#38103: http://bugs.mysql.com/38103)

     * Setting the session value of the debug system variable also
       set the global value. (Bug#38054: http://bugs.mysql.com/38054)

     * Comparisons between row constructors, such as (a, b) = (c, d)
       resulted in unnecessary Illegal mix of collations errors for
       string columns. (Bug#37601: http://bugs.mysql.com/37601)

     * A workload consisting of CREATE TABLE ... SELECT and DML
       operations could cause deadlock.
       (Bug#37433: http://bugs.mysql.com/37433)

     * If a user created a view that referenced tables for which the
       user had disjoint privileges, an assertion failure occurred.
       (Bug#37191: http://bugs.mysql.com/37191)

     * Trying to recover Falcon tables after a crash when the
       corresponding tables and tablespaces have not been created
       before the crash could cause a recovery failure.
       (Bug#36993: http://bugs.mysql.com/36993)

     * When MySQL was configured with the --with-max-indexes=128
       option, mysqld crashed.
       (Bug#36751: http://bugs.mysql.com/36751)

     * The event, general_log, and slow_log tables in the mysql
       database store server_id values, but did not use an UNSIGNED
       column and thus were not able to store the full range of ID
       values. (Bug#36540: http://bugs.mysql.com/36540)

     * Setting the join_buffer_size variable to its minimum value
       produced spurious warnings.
       (Bug#36446: http://bugs.mysql.com/36446)

     * The audit plugin was not receiving MYSQL_AUDIT_GENERAL_ERROR
       events. (Bug#36098: http://bugs.mysql.com/36098)

     * The use of NAME_CONST() can result in a problem for CREATE
       TABLE ... SELECT statements when the source column expressions
       refer to local variables. Converting these references to
       NAME_CONST() expressions can result in column names that are
       different on the master and slave servers, or names that are
       too long to be legal column identifiers. A workaround is to
       supply aliases for columns that refer to local variables.
       Now a warning is issued in such cases that indicate possible
       problems. (Bug#35383: http://bugs.mysql.com/35383)

     * SHOW CREATE EVENT output did not include the DEFINER clause.
       (Bug#35297: http://bugs.mysql.com/35297)

     * mysqld would crash in a concurrent workload with INSERT/CREATE
       TABLE/DROP TABLE or INSERT/ALTER TABLE combinations on Falcon
       tables. (Bug#35255: http://bugs.mysql.com/35255)

     * It was not possible to interrupt a long running BACKUP
       DATABASE or RESTORE operation.
       (Bug#35079: http://bugs.mysql.com/35079)

     * Several deprecated or obsolete settings were removed from the
       sample option files. (Bug#34521: http://bugs.mysql.com/34521)

     * Searching for 0x00 in Falcon tables using the VARBINARY column
       type would fail to return the correct rows. In addition, a
       crash could be encountered when modifying a column to the
       VARBINARY type. (Bug#34478: http://bugs.mysql.com/34478,
       Bug#33190: http://bugs.mysql.com/33190,
       Bug#23692: http://bugs.mysql.com/23692)

     * A subquery using SELECT ... FOR UPDATE on a Falcon table fails
       to lock table correctly during the UPDATE.
       (Bug#34182: http://bugs.mysql.com/34182)

     * With Falcon tables running concurrent transactions, some
       transactions may not be rolled back correctly, leading to an
       infinite loop. (Bug#34174: http://bugs.mysql.com/34174)

     * INSTALL PLUGIN and UNINSTALL PLUGIN did not handle plugin
       identifiers consistently with respect to lettercase.
       (Bug#33731: http://bugs.mysql.com/33731)

     * RESTORE often would not correctly identify the tablespace into
       which a Falcon table should be restored.
       (Bug#33569: http://bugs.mysql.com/33569)

     * mysqldump --compatible=mysql40 emitted statements referring to
       the character_set_client system variable, which is unknown
       before MySQL 4.1. Now the statements are enclosed in
       version-specific comments.
       (Bug#33550: http://bugs.mysql.com/33550)

     * If Falcon runs out of memory while inserting records and you
       try to alter the affected table, you may get a record memory
       is exhausted error, and the table can no longer be used or
       accessed. (Bug#33177: http://bugs.mysql.com/33177)

     * The DDL blocker for BACKUP DATABASE and RESTORE did not block
       all statements that it should. The blocker is now called the
       Backup Metadata Lock and blocks statements that change
       database metadata. (Bug#32702: http://bugs.mysql.com/32702)

     * Detection by configure of several functions such as
       setsockopt(), bind(), sched_yield(), and gtty() could fail.
       (Bug#31506: http://bugs.mysql.com/31506)

     * Use of MBR spatial functions such as MBRTouches() with columns
       of InnoDB tables caused a server crash rather than an error.
       (Bug#31435: http://bugs.mysql.com/31435)

     * When an InnoDB tablespace filled up, an error was logged to
       the client, but not to the error log. Also, the error message
       was misleading and did not indicate the real source of the
       problem. (Bug#31183: http://bugs.mysql.com/31183)

     * The mysql client mishandled input parsing if a delimiter
       command was not first on the line.
       (Bug#31060: http://bugs.mysql.com/31060)

     * SHOW PRIVILEGES listed the CREATE ROUTINE privilege as having
       a context of Functions,Procedures, but it is a database-level
       privilege. (Bug#30305: http://bugs.mysql.com/30305)

     * CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE
       erroneously reported a table to be corrupt if the table did
       not exist or the statement was terminated with KILL.
       (Bug#29458: http://bugs.mysql.com/29458)

     * For InnoDB tables that have their own .ibd tablespace file, a
       superfluous ibuf cursor restoration fails! message could be
       written to the error log. This warning has been suppressed.
       (Bug#27276: http://bugs.mysql.com/27276)

     * Internal base64_xxx() functions were renamed to have a prefix
       of my_ to avoid conflicts with other libraries.
       (Bug#26818: http://bugs.mysql.com/26818)

     * The Time column for SHOW PROCESSLIST output and the value of
       the TIME column of the INFORMATION_SCHEMA.PROCESSLIST table
       now can have negative values. Previously, the column was
       unsigned and negative values were displayed incorrectly as
       large positive values. Negative values can occur if a thread
       alters the time into the future with SET TIMESTAMP = value or
       the thread is executing on a slave and processing events from
       a master that has its clock set ahead of the slave.
       (Bug#22047: http://bugs.mysql.com/22047)

     * Restoring a mysqldump dump file containing FEDERATED tables
       failed because the file contained the data for the table. Now
       only the table definition is dumped (because the data is
       located elsewhere). (Bug#21360: http://bugs.mysql.com/21360)

     * SHOW CREATE DATABASE did not account for the value of the
       lower_case_table_names system variable.
       (Bug#21317: http://bugs.mysql.com/21317)

     * Incorrect length metadata could be returned for LONG TEXT
       columns when a multibyte server character set was used.
       (Bug#19829: http://bugs.mysql.com/19829)

     * ROUND() sometimes returned different results on different
       platforms. (Bug#15936: http://bugs.mysql.com/15936)

--
Jonathan Perkin, Product Engineering, MySQL
Database Technology Group, Sun Microsystems