End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Added the INNOBASE storage engine and the
BDB storage engine to the MySQL source
distribution.
Updated the documentation about GEMINI
tables.
Fixed a bug in INSERT DELAYED
that caused threads to hang when inserting
NULL into an
AUTO_INCREMENT column.
Fixed a bug in CHECK TABLE /
REPAIR TABLE that could cause a
thread to hang.
Fixed problem that REPLACE
would not replace a row that conflicts with an
AUTO_INCREMENT generated key.
mysqld now only sets
CLIENT_TRANSACTIONS in
mysql->server_capabilities if the server
supports a transaction-safe storage engine.
Fixed LOAD DATA
INFILE to allow numeric values to be read into
ENUM and
SET columns.
Improved error diagnostic for slave thread exit.
Fixed bug in ALTER TABLE ... ORDER BY.
Added max_user_connections
variable to mysqld.
Limit query length for replication by
max_allowed_packet, not the
arbitrary limit of 4MB.
Allow space around = in argument to
--set-variable.
Fixed problem in automatic repair that could leave some
threads in state Waiting for table.
SHOW CREATE TABLE now displays
the UNION=() for MERGE
tables.
ALTER TABLE now remembers the
old UNION=() definition.
Fixed bug when replicating timestamps.
Fixed bug in bidirectional replication.
Fixed bug in the BDB storage engine that
occurred when using an index on multiple-part key where a key
part may be NULL.
Fixed MAX() optimization on
sub-key for BDB tables.
Fixed problem where garbage results were returned when using
BDB tables and
BLOB or
TEXT fields when joining many
tables.
Fixed a problem with BDB tables and
TEXT columns.
Fixed bug when using a BLOB key
where a const row wasn't found.
Fixed that mysqlbinlog writes the timestamp
value for each query. This ensures that one gets same values
for date functions like NOW()
when using mysqlbinlog to pipe the queries
to another server.
Allow --skip-gemini,
--skip-bdb, and
--skip-innodb
options to be specified when invoking
mysqld, even if these storage engines are
not compiled in to mysqld.
You can now use ASC and
DESC with GROUP BY
columns to specify a sort order.
Fixed a deadlock in the
SET
code, when one ran SET @foo=bar, where
bar is a column reference, an error was not
properly generated.

User Comments
Add your own comment.