Skip navigation links

Additional languages
MySQL 3.23, 4.0, 4.1 Reference Manual :: B MySQL Change History :: B.3 Changes in release 3.23.x :: B.3.57 Changes in release 3.23.4 (28 September 1999)
B.3.58 Changes in release 3.23.3 (13 September 1999) »
Section Navigation      [Toggle]

B.3.57. Changes in release 3.23.4 (28 September 1999)

End of Product Lifecycle. Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended. However, for MySQL 4.0 and 4.1, there is still extended support available. For details, see http://www.mysql.com/company/legal/lifecycle/#calendar. According to the MySQL Lifecycle Policy (see http://www.mysql.com/company/legal/lifecycle/#policy), only Security and Severity Level 1 issues will still be fixed for MySQL 4.0 and 4.1. Please consider upgrading to a recent version (MySQL 5.0 or 5.1).

  • Inserting a DATETIME into a TIME column no longer try to store 'days' in it.

  • Fixed problem with storage of float/double on little endian machines. (This affected SUM().)

  • Added connect timeout on TCP/IP connections.

  • Fixed problem with LIKE "%" on an index that may have NULL values.

  • REVOKE ALL PRIVILEGES didn't revoke all privileges.

  • Allow creation of temporary tables with same name as the original table.

  • When granting an account a GRANT option for a database, the account couldn't grant privileges to other users.

  • New statement: SHOW GRANTS FOR user (by Sinisa).

  • New date_add syntax: date/datetime + INTERVAL # interval_type. By Joshua Chamas.

  • Fixed privilege check for LOAD DATA REPLACE.

  • Automatic fixing of broken include files on Solaris 2.7

  • Some configure issues to fix problems with big filesystem detection.

  • REGEXP is now case-insensitive if you use non-binary strings.