Added reverse check lookup of hostnames to get better security.
Fixed some possible buffer overflows if filenames that are too long are used.
mysqld
doesn't accept hostnames that
start with digits followed by a '.'
,
because the hostname may look like an IP number.
Added --skip-networking
option to
mysqld
, to allow only socket connections.
(This will not work with MIT-pthreads!)
Added check of too long table names for alias.
Added check if database name is okay.
Added check if too long table names.
Removed incorrect free()
that killed the
server on CREATE DATABASE
or
DROP DATABASE
.
Changed some mysqld
-O
options to better names.
Added -O join_cache_size=#
option to
mysqld
.
Added -O max_join_size=#
option to
mysqld
, to be able to set a limit how big
queries (in this case big = slow) one should be able to
handle without specifying SET
SQL_BIG_SELECTS=1
. A # = is about 10 examined
records. The default is ``unlimited''.
When comparing a TIME
,
DATE
, DATETIME
or
TIMESTAMP
column to a constant, the
constant is converted to a time value before performing the
comparison. This will make it easier to get ODBC
(particularly Access97) to work with the above types. It
should also make dates easier to use and the comparisons
should be quicker than before.
Applied patch from Jochen Wiedmann that allows
query()
in mysqlperl
to take a query with \0
in it.
Storing a timestamp with a 2-digit year
(YYMMDD
) didn't work.
Fix that timestamp wasn't automatically updated if set in an
UPDATE
clause.
Now the automatic timestamp field is the FIRST timestamp field.
SELECT * INTO OUTFILE
, which didn't
correctly if the outfile already existed.
mysql
now shows the thread ID when
starting or doing a reconnect.
Changed the default sort buffer size from 2M to 1M.
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.