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.