MySQL Manual | D.6.12 Changes in release 3.21.22

Starting with this version, all MySQL distributions will be configured, compiled and tested with crash-me and the benchmarks on the following platforms: SunOS 5.6 sun4u, SunOS 5.5.1 sun4u, SunOS 4.14 sun4c, SunOS 5.6 i86pc, Irix 6.3 mips5k, HP-UX 10.20 hppa, AIX 4.2.1 ppc, OSF/1 V4.0 alpha, FreeBSD 2.2.2 i86pc and BSDI 3.1 i386.
Fix COUNT(*) problems when the WHERE clause didn't match any records. (Bug from 3.21.17.)
Removed that NULL = NULL is true. Now you must use IS NULL or IS NOT NULL to test whether a value is NULL. (This is according to SQL-99 but may break old applications that are ported from mSQL.) You can get the old behaviour by compiling with -DmSQL_COMPLIANT.
Fixed bug that core dumped when using many LEFT OUTER JOIN clauses.
Fixed bug in ORDER BY on string formula with possible NULL values.
Fixed problem in range optimiser when using <= on sub index.
Added functions DAYOFYEAR(), DAYOFMONTH(), MONTH(), YEAR(), WEEK(), QUARTER(), HOUR(), MINUTE(), SECOND() and FIND_IN_SET().
Added SHOW VARIABLES command.

Added support of ``long constant strings'' from SQL-99:

mysql> SELECT 'first ' 'second';       -> 'first second'

User Comments