Alterações na distribuição 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 tomysqld
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 tomysqldump
. - 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
andDOUBLE
(without any length modifiers) no longer are fixed decimal point numbers. - Changed the meaning of
FLOAT(X)
: Now this is the same asFLOAT
ifX
<= 24 and aDOUBLE
if 24 <X
<= 53. DECIMAL(X)
is now an alias forDECIMAL(X,0)
andDECIMAL
is now an alias forDECIMAL(10,0)
. The same goes forNUMERIC
.- Added option
ROW_FORMAT={default | dynamic | fixed | compressed}
toCREATE_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)
.