MySQL

3.23.6

Released on 15 Dec 1999
MySQL 3.23.6 Changelog

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.

  • Added -O lower_case_table_names={0|1} option to mysqld to allow users to force table names to lowercase.

  • Added SELECT ... INTO DUMPFILE.

  • Added --ansi option to mysqld to make some functions standard SQL compatible.

  • Temporary table names now start with #sql.

  • Added quoting of identifiers with ` (" in --ansi mode).

  • Changed to use snprintf() when printing floats to avoid some buffer overflows on FreeBSD.

  • Made FLOOR() overflow safe on FreeBSD.

  • Added --quote-names option to mysqldump.

  • Fixed bug that one could make a part of a PRIMARY KEY NOT NULL.

  • Fixed encrypt() to be thread-safe and not reuse buffer.

  • Added mysql_odbc_escape_string() function to support big5 characters in MyODBC.

  • Rewrote the storage engine to use classes. This introduces a lot of new code, but make table handling faster and better.

  • Added patch by Sasha for user-defined variables.

  • Changed that FLOAT and DOUBLE (without any length modifiers) no longer are fixed decimal point numbers.

  • Changed the meaning of FLOAT(X): Now this is the same as FLOAT if X <= 24 and a DOUBLE if 24 < X <= 53.

  • DECIMAL(X) is now an alias for DECIMAL(X,0) and DECIMAL is now an alias for DECIMAL(10,0). The same goes for NUMERIC.

  • Added option ROW_FORMAT={DEFAULT | DYNAMIC | FIXED | COMPRESSED} to CREATE_TABLE.

  • DELETE FROM tbl_name didn't work on temporary tables.

  • Changed function CHAR_LENGTH() to be multi-byte character safe.

  • Added function ORD(string).