D.4.22 Changes in release 3.23.37 (17 Apr 2001)

• Fixed a bug when using MATCH() in HAVING clause.
• Fixed a bug when using HEAP tables with LIKE.
• Added --mysql-version option to safe_mysqld
• Changed INNOBASE to InnoDB (because the INNOBASE name was already used). All configure options and mysqld start options now use innodb instead of innobase. This means that before upgrading to this version, you have to change any configuration files where you have used innobase options!
• Fixed bug when using indexes on CHAR(255) NULL columns.
• Slave thread will now be started even if master-host is not set, as long as server-id is set and valid `master.info' is present.
• Partial updates (terminated with kill) are now logged with a special error code to the binary log. Slave will refuse to execute them if the error code indicates the update was terminated abnormally, and will have to be recovered with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START after a manual sanity check/correction of data integrity.
• Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log -- this bug affected replication.
• Fixed a bug in REGEXP on 64-bit machines.
• UPDATE and DELETE with WHERE unique_key_part IS NULL didn't update/delete all rows.
• Disabled INSERT DELAYED for tables that support transactions.
• Fixed bug when using date functions on TEXT/BLOB column with wrong date format.
• UDFs now also work on Windows. (Patch by Ralph Mason.)
• Fixed bug in ALTER TABLE and LOAD DATA INFILE that disabled key-sorting. These commands should now be faster in most cases.
• Fixed performance bug where reopened tables (tables that had been waiting for FLUSH or REPAIR) would not use indexes for the next query.
• Fixed problem with ALTER TABLE to InnoDB tables on FreeBSD.
• Added mysqld variables myisam_max_sort_file_size and myisam_max_extra_sort_file_size.
• Initialise signals early to avoid problem with signals in InnoDB.
• Applied patch for the tis620 character set to make comparisons case-independent and to fix a bug in LIKE for this character set. Note: All tables that uses the tis620 character set must be fixed with myisamchk -r or REPAIR TABLE !
• Added --skip-safemalloc option to mysqld.

User Comments

Add your own comment.