Note: Due to a
        libtool-related bug in the source
        distribution, the creation of shared
        libmysqlclient libraries was not possible
        (the resulting files were missing the .so
        file name extension). The file ltmain.sh
        was updated to fix this problem and the resulting source
        distribution was released as
        mysql-4.0.23a.tar.gz. This modification did
        not affect the binary packages. (Bug#7401)
      
Fonctionnalité ajoutée ou modifiée :
            Added --hex-blob option to
            mysqldump for dumping binary string
            columns using hexadecimal notation.
          
            Added mysql_hex_string() C API function
            that hex-encodes a string.
          
            InnoDB: Do not periodically write SHOW INNODB
            STATUS information to a temporary file unless the
            configuration option innodb_status_file=1
            is set.
          
InnoDB: Made the foreign key parser better aware of quotes. (Bug#6340)
            mysqlbinlog now prints an informative
            commented line (thread id, timestamp, server id, etc) before
            each LOAD DATA INFILE, like it does for
            other queries; unless --short-form is used.
          
Bogues corrigés :
            Corrected accounts in the mysql.user
            table in Windows distributions that had been created with a
            Host value of build
            rather than %. (Bug#6000)
          
            Prevent adding CREATE TABLE .. SELECT
            query to the binary log when the insertion of new records
            partially failed. (Bug#6682)
          
            Fixed bug which caused FROM_UNIXTIME()
            function to return wrong result if the argument was too big.
            (Bug#6439)
          
            Fixed bug which caused MySQL server to store wrong values in
            TIMESTAMP columns and give wrong results
            for UNIX_TIMESTAMP() function if it was
            run in time zone with leap seconds. (Bug#6387)
          
            InnoDB: Fixed a bug in LOAD DATA
            INFILE…REPLACE printing duplicate key error when
            executing the same load query several times. (Bug#5835)
          
InnoDB: Refuse to open new-style tables created with MySQL 5.0.3 or later. (Bug#7089)
            InnoDB: Do not call rewind() when
            displaying SHOW INNODB STATUS information
            on stderr.
          
            InnoDB: If one used INSERT IGNORE to
            insert several rows at a time, and the first inserts were
            ignored because of a duplicate key collision, then InnoDB in
            a replication slave assigned
            AUTO_INCREMENT values 1 bigger than in
            the master. This broke the MySQL replication. (Bug#6287)
          
            InnoDB: Fix two hangs: FOREIGN KEY
            constraints treated table and database names as
            case-insensitive. RENAME TABLE t TO T
            would hang in an endless loop if t had a
            foreign key constraint defined on it. Fix also a hang over
            the dictionary mutex that would occur if one tried in
            ALTER TABLE or RENAME
            TABLE to create a foreign key constraint name that
            collided with another existing name. (Bug#3478)
          
            InnoDB: Treat character 0xA0 as space in
            InnoDB's FOREIGN KEY parser if MySQL
            treats it as space in the default charset. EMS MySQL Manager
            inserts character 0xA0 after the table
            name in an ALTER, which confused InnoDB's
            parser.
          
Fixed a bug which caused a crash when only the slave I/O thread was stopped and restarted. (Bug#6148)
            If a connection had an open transaction but had done no
            updates to transactional tables (for example if had just
            done a SELECT FOR UPDATE then executed a
            non-transactional update, that update automatically
            committed the transaction (thus releasing InnoDB's row-level
            locks etc). (Bug#5714)
          
            If a connection was interrupted by a network error and did a
            rollback, the network error code got stored into the
            BEGIN and ROLLBACK
            binary log events; that caused superfluous slave stops. (Bug#6522)
          
            A sequence of BEGIN (or SET
            AUTOCOMMIT=0), FLUSH TABLES WITH READ
            LOCK, transactional update,
            COMMIT, FLUSH TABLES WITH READ
            LOCK could hang the connection forever and
            possibly the MySQL server itself. This happened for example
            when running the innobackup script
            several times. (Bug#6732)
          
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.

