D.4.29 Changes in release 3.23.31 (17 Jan 2001)

• 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 4G.
• 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 something (please upgrade if you are using an earlier MySQL 3.23 version).
• Fixed buffer overflow bug when writing a certain error message.
• Added usage of setrlimit() on Linux to get -O --open-files-limit=# 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 optimised 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.

User Comments

Add your own comment.