Fixed ftruncate() call in MIT-pthreads.
This made isamchk destroy the
.ISM files on (Free)BSD 2.x systems.
Fixed broken __P_ patch in MIT-pthreads.
Many memory overrun checks. All string functions now return
NULL if the returned string should be
longer than max_allowed_packet bytes.
Changed the name of the INTERVAL type to
ENUM, because INTERVAL
is used in SQL-99.
In some cases, doing a JOIN +
GROUP + INTO OUTFILE,
the result wasn't grouped.
LIKE with '_' as last
character didn't work. Fixed.
Added extended SQL-99 TRIM() function.
Added CURTIME().
Added ENCRYPT() function by Zeev Suraski.
Fixed better FOREIGN KEY syntax skipping.
New reserved words: MATCH,
FULL, PARTIAL.
mysqld now allows IP number and hostname
for the --bind-address option.
Added SET CHARACTER SET cp1251_koi8 to
enable conversions of data to and from the
cp1251_koi8 character set.
Lots of changes for Windows 95 port. In theory, this version should now be easily portable to Windows 95.
Changed the CREATE COLUMN syntax of
NOT NULL columns to be after the
DEFAULT value, as specified in the SQL-99
standard. This will make mysqldump with
NOT NULL and default values incompatible
with MySQL Version 3.20.
Added many function name aliases so the functions can be used with ODBC or SQL-92 syntax.
Fixed syntax of ALTER TABLE tbl_name ALTER COLUMN
col_name SET DEFAULT NULL.
Added CHAR and BIT as
synonyms for CHAR(1).
Fixed core dump when updating as a user who has only
SELECT privilege.
INSERT ... SELECT ... GROUP BY didn't
work in some cases. An Invalid use of group
function error occurred.
When using LIMIT,
SELECT now always uses keys instead of
record scan. This will give better performance on
SELECT and a WHERE
that matches many rows.
Added Russian error messages.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
