Fixed Rows_examined count in slow query
            log.
          
            Fixed bug when using a reference to an
            AVG() column in
            HAVING.
          
            Fixed that date functions that require correct dates, like
            DAYOFYEAR(column), will return
            NULL for 0000-00-00
            dates.
          
            Fixed bug in const-propagation when comparing columns of
            different types. (SELECT * FROM
            date_col="2001-01-01" and date_col=time_col)
          
            Fixed bug that caused error message Can't write,
            because of unique constraint with some
            GROUP BY queries.
          
            Fixed problem with sjis character strings
            used within quoted table names.
          
            Fixed core dump when using CREATE ...
            FULLTEXT keys with other storage engines than
            MyISAM.
          
            Don't use signal() on Windows because
            this appears to not be 100% reliable.
          
            Fixed bug when doing WHERE col_name=NULL
            on an indexed column that had NULL
            values.
          
            Fixed bug when doing LEFT JOIN ... ON (col_name =
            constant) WHERE col_name = constant.
          
            When using replications, aborted queries that contained
            % could cause a core dump.
          
            TCP_NODELAY was not used on some systems.
            (Speed problem.)
          
Applied portability fixes for OS/2. (Patch by Yuri Dario.)
        The following changes are for InnoDB tables:
      
            Add missing InnoDB variables to
            SHOW VARIABLES.
          
            Foreign keys checking is now done for
            InnoDB tables.
          
            DROP DATABASE now works also for
            InnoDB tables.
          
            InnoDB now supports datafiles and raw
            disk partitions bigger than 4 GB on those operating systems
            that have big files.
          
            InnoDB calculates better table
            cardinality estimates for the MySQL optimizer.
          
            Accent characters in the default character set
            latin1 are ordered according to the MySQL
            ordering.
          
            Note: if you are using latin1 and have
            inserted characters whose code is greater than 127 into an
            indexed CHAR column, you should run
            CHECK TABLE on your table when you
            upgrade to 3.23.44, and drop and reimport the table if
            CHECK TABLE reports an error!
          
            A new my.cnf parameter,
            innodb_thread_concurrency, helps in
            performance tuning in heavily concurrent environments.
          
            A new my.cnf parameter,
            innodb_fast_shutdown, speeds up server
            shutdown.
          
            A new my.cnf parameter,
            innodb_force_recovery, helps to save your
            data in case the disk image of the database becomes corrupt.
          
            innodb_monitor has been improved and a
            new innodb_table_monitor added.
          
Increased maximum key length from 500 to 7000 bytes.
            Fixed a bug in replication of
            AUTO_INCREMENT columns with multiple-line
            inserts.
          
Fixed a bug when the case of letters changes in an update of an indexed secondary column.
Fixed a hang when there are > 24 datafiles.
            Fixed a crash when MAX(col) is selected
            from an empty table, and col is not the
            first column in a multi-column index.
          
Fixed a bug in purge which could cause crashes.
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.

