MySQL Manual | D.6.11 Changes in release 3.21.23

The following symbols are now reserved words: TIME, DATE, TIMESTAMP, TEXT, BIT, ENUM, NO, ACTION, CHECK, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, STATUS, VARIABLES.
Setting a TIMESTAMP to NULL in LOAD DATA INFILE ... didn't set the current time for the TIMESTAMP.
Fix BETWEEN to recognise binary strings. Now BETWEEN is case-sensitive.
Added --skip-thread-priority option to mysqld, for systems where mysqld's thread scheduling doesn't work properly (BSDI 3.1).
Added ODBC functions DAYNAME() and MONTHNAME().
Added function TIME_FORMAT(). This works like DATE_FORMAT(), but takes a time string ('HH:MM:SS') as argument.
Fixed unlikely(?) key optimiser bug when using OR operators of key parts inside AND expressions.
Added variables command to mysqladmin.
A lot of small changes to the binary releases.
Fixed a bug in the new protocol from MySQL Version 3.21.20.
Changed ALTER TABLE to work with Windows (Windows can't rename open files). Also fixed a couple of small bugs in the Windows version.
All standard MySQL clients are now ported to MySQL for Windows.
MySQL can now be started as a service on NT.

User Comments