MySQL Manual | D.6.22 Changes in release 3.21.14a

Ported to SCO Openserver 5.0.4 with FSU Pthreads.
HP-UX 10.20 should work.
Added new function DATE_FORMAT().
Added NOT IN.
Added automatic removal of 'ODBC function conversions': {fn now() }
Handle ODBC 2.50.3 option flags.
Fixed comparison of DATE and TIME values with NULL.
Changed language name from germany to german to be consistent with the other language names.
Fixed sorting problem on functions returning a FLOAT. Previously, the values were converted to INT values before sorting.
Fixed slow sorting when sorting on key field when using key_column=constant.
Sorting on calculated DOUBLE values sorted on integer results instead.
mysql no longer requires a database argument.
Changed the place where HAVING should be. According to the SQL standards, it should be after GROUP BY but before ORDER BY. MySQL Version 3.20 incorrectly had it last.
Added Sybase command USE database to start using another database.
Added automatic adjusting of number of connections and table cache size if the maximum number of files that can be opened is less than needed. This should fix that mysqld doesn't crash even if you haven't done a ulimit -n 256 before starting mysqld.
Added lots of limit checks to make it safer when running with too little memory or when doing weird queries.

User Comments