Skip navigation links
MySQL 3.23, 4.0, 4.1 Reference Manual :: B MySQL Change History :: B.3 Changes in Release 3.23.x :: B.3.30 Changes in Release 3.23.31 (17 January 2001: Production)
B.3.31 Changes in Release 3.23.30 (04 January 2001) »
Section Navigation      [Toggle]

B.3.30. Changes in Release 3.23.31 (17 January 2001: Production)

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.

  • Using 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.

  • Added option MEDIUM to CHECK TABLE.

  • Fixed problem when using DECIMAL() keys on negative numbers.

  • HOUR() (and some other TIME functions) on a CHAR column always returned NULL.

  • 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=val to work on Linux.

  • Added 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 [mysql_server] group.

  • Fixed safe_mysqld and mysql.server to also read the server option section.

  • Added Threads_created status variable to mysqld.