Functionality added or changed:
Replication: 
        Multiple-table UPDATE and
        DELETE statements that do not
        affect any rows are now written to the binary log and will
        replicate.
       (Bug#13348, Bug#12844)
        Range scans can now be performed for queries on VIEWs such as
        column IN (<constants>) and
        column BETWEEN ConstantA AND ConstantB.
       (Bug#13317)
The limit of 255 characters on the input buffer for mysql on Windows has been lifted. The exact limit depends on what the system allows, but can be up to 64K characters. A typical limit is 16K characters. (Bug#12929)
        Added the myisam_stats_method,
        which controls whether NULL values in indexes
        are considered the same or different when collecting statistics
        for MyISAM tables. This influences the query
        optimizer as described in
        Section 7.4.7, “MyISAM Index Statistics Collection”.
       (Bug#12232)
        The CHAR() function now takes
        into account the character set and collation given by the
        character_set_connection and
        collation_connection system
        variables. For an argument n to
        CHAR(), the result is
        n mod 256 for single-byte character
        sets. For multi-byte character sets,
        n must be a valid code point in the
        character set. Also, the result string from
        CHAR() is checked for
        well-formedness. For invalid arguments, or a result that is not
        well-formed, MySQL generates a warning (or, in strict SQL mode,
        an error).
       (Bug#10504)
        Re-enabled the
        --delayed-insert option for
        mysqldump, which now checks for each table
        dumped whether its storage engine supports
        DELAYED inserts.
       (Bug#7815)
        RENAME TABLE now works for views
        as well, as long as you do not try to rename a view into a
        different database.
       (Bug#5508)
        Configure-time checking for the availability of multi-byte
        macros and functions in the bundled readline
        library. This improves handling of multi-byte character sets in
        the mysql client.
       (Bug#3982)
        When an InnoDB foreign key constraint is
        violated, the error message now indicates which table, column,
        and constraint names are involved.
       (Bug#3443)
Bugs fixed:
MySQL Cluster: 
        A trigger updating the value of an
        AUTO_INCREMENT column in an
        NDB table would insert an error
        code rather than the expected value into the column.
       (Bug#13961)
MySQL Cluster: If ndb_restore could not find a free mysqld process, it crashed. (Bug#13512)
MySQL Cluster: Adding an index to a table with a large number of columns (more then 100) crashed the storage node. (Bug#13316)
MySQL Cluster: 
        BIT columns and following columns
        in NDB tables were corrupt when
        dumped by mysqldump.
       (Bug#13152)
MySQL Cluster: 
        Queries on NDB tables that were
        executed using index_merge
        could produce incorrect results.
       (Bug#13081)
MySQL Cluster: 
        Receipt of several ENTER SINGLE USER MODE
        commands by multiple ndb_mgmd processes
        within a short period of time resulted in cluster shutdown.
       (Bug#13053)
MySQL Cluster: Multiple ndb_mgmd processes in a cluster did not know each other's IP addresses. (Bug#12037)
MySQL Cluster: 
        With two mgmd processes in a cluster,
        ndb_mgm output for
        SHOW would display the same IP
        address for both processes, even when they were on different
        hosts.
       (Bug#11595)
MySQL Cluster: 
        LOAD DATA
        INFILE with a large data file failed.
       (Bug#10694)
MySQL Cluster: 
        When deleting a great many (tens of thousands of) rows at once
        from an NDB table, an improperly
        dereferenced pointer could cause the mysqld
        process to crash.
       (Bug#9282)
Replication: 
        The --replicate-rewrite-db and
        --replicate-do-table options did
        not work for statements in which tables were aliased to names
        other than those listed by the options.
       (Bug#11139)
        Certain joins using Range checked for each
        record in the query execution plan could cause the
        server to crash.
       (Bug#24776)
        Joins nested under NATURAL or
        USING joins were sometimes not initialized
        properly, causing a server crash.
       (Bug#13545)
        After running configure with the
        --with-embedded-privilege-control option, the
        embedded server failed to build.
       (Bug#13501)
        The optimizer chose a less efficient execution plan for
         than for col_name BETWEEN
        const AND
        const
        , even though the two
        expressions are logically equivalent. Now the optimizer can use
        the col_name =
        constref access method for
        both expressions.
       (Bug#13455)
        Locking a view with the query cache enabled and
        query_cache_wlock_invalidate
        enabled could cause a server crash.
       (Bug#13424)
        A HAVING clause that references an
        unqualified view column name could crash the server.
       (Bug#13411)
        The --skip-innodb-doublewrite option disables
        use of the InnoDB doublewrite buffer.
        However, having this option in effect when creating a new MySQL
        installation prevented the buffer from even being created,
        resulting in a server crash later.
       (Bug#13367)
        Calling the FORMAT() function
        with a DECIMAL column value
        caused a server crash when the value was
        NULL.
       (Bug#13361)
Comparisons involving row constructors containing constants could cause a server crash. (Bug#13356)
        Aggregate functions sometimes incorrectly were allowed in the
        WHERE clause of
        UPDATE and
        DELETE statements.
       (Bug#13180)
        NATURAL joins and joins with
        USING against a view could return
        NULL rather than the correct value.
       (Bug#13127)
        For queries with DISTINCT and WITH
        ROLLUP, the DISTINCT should be
        applied after the rollup operation, but was not always.
       (Bug#12887)
        It was possible to create a view that executed a stored function
        for which you did not have the
        EXECUTE privilege.
       (Bug#12812)
Shared-memory connections were not working on Windows. (Bug#12723)
        The server was not rejecting
        FLOAT(
        or
        M,D)DOUBLE(
        columns specifications when M,D)M was
        less than D.
       (Bug#12694)
        CHECKSUM TABLE locked
        InnoDB tables and did not use a consistent
        read.
       (Bug#12669)
        Incorrect creation of DECIMAL
        local variables in a stored procedure could cause a server
        crash.
       (Bug#12589)
        For queries for which the optimizer determined a join type of
        “Range checked for each record” (as shown by
        EXPLAIN, the query sometimes
        could cause a server crash, depending on the data distribution.
       (Bug#12291)
        After running configure with the
        --without-server option, the
        distribution failed to build.
       (Bug#11680, Bug#13550)
        Use of a user-defined function within the
        HAVING clause of a query resulted in an
        Unknown column error.
       (Bug#11553)
        The server crashed when processing a view that invoked the
        CONVERT_TZ() function.
       (Bug#11416)
        When SELECT ... FOR
        UPDATE or
        SELECT ... LOCK IN SHARE
        MODE for an InnoDB table were
        executed from within a stored function or a trigger, they were
        converted to a nonlocking consistent read.
       (Bug#11238)
        Queries against a MERGE table that has a
        composite index could produce incorrect results.
       (Bug#9112)
MySQL programs in binary distributions for Solaris 8/9/10 x86 systems would not run on Pentium III machines. (Bug#6772)
Nested handlers within stored procedures didn't work. (Bug#6127)

User Comments
Add your own comment.