D.3.12 Modifications de la version 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, OSF1 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 or not a value is NULL. (This is according to ANSI SQL but may break old applications that are ported from mSQL.) You can get the old behavior 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 optimizer when using <= on sub index.
• Added functions DAYOFYEAR(), DAYOFMONTH(), MONTH(), YEAR(), WEEK(), QUARTER(), HOUR(), MINUTE(), SECOND() and FIND_IN_SET().
• Added command SHOW VARIABLES.
• Added support of ``long constant strings'' from ANSI SQL:

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

• Upgraded mSQL-Mysql-modules to 1.1825.
• Upgraded mysqlaccess to 2.02.
• Fixed problem with Russian character set and LIKE.
• Ported to OpenBSD 2.1.
• New Dutch error messages.