Het MySQL development team heeft een nieuwe unstable release van de MySQL 3.23-beta uitgebracht. Hier het overzicht van de bugfixes en nieuwe features, afkomstig uit de change history:
E.1.1 Changes in release 3.23.26[break] De download locaties van de source code en de OS-specifieke binaries vind je op deze page. [/break]
- Fixed
<>to work properly withNULL.- Fixed problem with
SUBSTRING_INDEX()andREPLACE(). (Patch by Alexander Igonitchev)- Fix
CREATE TEMPORARY TABLE IF NOT EXISTSnot to give an error if the table exists.- If you don't create a
PRIMARY KEYin a BDB table, a hiddenPRIMARY KEYwill be created.- Added read-only-key optimization to BDB tables.
LEFT JOINin some cases preferred a full table scan when there was noWHEREclause.- When using
--log-slow-queries, don't count the time waiting for a lock.- Fixed bug in lock code on
windowswhich could cause the key cache to report that the key file was crashed even if it was okay.- Automatic repair of
MyISAMtables if you startmysqldwith--myisam-recover.- Removed the
TYPE=keyword fromCHECKandREPAIR. AllowCHECKoptions to be combined. (You can still useTYPE=but this usage is deprecated).- Fixed mutex bug in the binary replication log - long update queries could be read only in part by the slave if it did it at the wrong time, which was not fatal, but resulted in a performance-degrading reconnect and a scary message in the error log.
- Changed the format of the binary log - added magic number, server version, binlog version. Added server id and query error code for each query event.
- Replication thread from the slave now will kill all the stale threads from the same server.
- Long replication user names were not being handled properly.
- Added
--replicate-rewrite-dboption tomysqld.- Added
--skip-slave-startoption tomysqld.- Updates that generated an error code (such as
INSERT INTO foo(some_key) values (1),(1)) erroneously terminated the slave thread.- Added optimization of queries where
DISTINCTis only used on columns from some of the tables.- Allow floating point numbers where there is no sign after the exponent (like 1e1).
SHOW GRANTSdidn't always show all column grants.- Added
--default-extra-file=#to all MySQL clients.- Columns referenced in
INSERTstatements now are initialized properly.UPDATEdidn't always work when used with a range on a timestamp that was part of the key that was used to find rows.- Fixed bug in
FULLTEXTindex when inserting aNULLcolumn.- Changed to use
mkstemp()instead oftempnam().
