MySQL Manual | D.4.54 Changes in release 3.23.6

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 SQL-99 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 will 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 table_name didn't work on temporary tables.
Changed function CHAR_LENGTH() to be multi-byte character safe.
Added function ORD(string).

User Comments