GNU Info

(mysql.info)News-3.23.31

---

Next: News-3.23.30 Prev: News-3.23.32 Up: News-3.23.x

---

Enter node , (file) or (file)node

Changes in release 3.23.31
--------------------------

   * 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 that the MySQL RPM is not dependent on Perl5 anymore.

   * 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 a
     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 new `mysqld' variable: `bdb_version'.

   * 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 section
     instead of `mysql_server'.

   * Fixed `safe_mysqld' and `mysql.server' to also read the `server'
     option section.

   * Added `Threads_created' status variable to `mysqld'.