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.
The test suite now tests all reachable
BDB interface code. During testing we found and fixed many errors in the interface code.
HAVING on an empty table could produce one result row when it shouldn't.
Fixed the MySQL RPM so it no longer depends on Perl5.
Fixed some problems with
HEAP tables on Windows.
SHOW TABLE STATUS didn't show correct average row length for tables larger than 4GB.
CHECK TABLE ... EXTENDED didn't check row links for fixed size tables.
Fixed problem when using
DECIMAL() keys on negative numbers.
HOUR() (and some other
TIME functions) on a
CHAR column always returned
Fixed security bug in
SHOW GRANT (please upgrade if you are using an earlier MySQL 3.23 version). (CVE-2001-1275)
Fixed buffer overflow bug when writing a certain error message. (CVE-2001-1274)
Added usage of
setrlimit() on Linux to get
-O --open_files_limit= to work on Linux.
bdb_version variable to mysqld.
Fixed bug when using expression of type:
SELECT ... FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=t2.a
In this case the test in the
WHERE clause was wrongly optimized away.
Fixed bug in
MyISAM when deleting keys with possible
NULL values, but the first key-column was not a prefix-compressed text column.
Fixed mysql.server to read the
[mysql.server] option file group rather than the
Fixed safe_mysqld and mysql.server to also read the
server option section.
Threads_created status variable to mysqld.