D.3.33 Modifications de la version 3.21.3

  • 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 only allow 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 requêtes(in this case big = slow) one should be able to handle without specifying SET OPTION 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.