Alterações na distribuição 3.21.22

Starting with this version, all MariaDB 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'
  

• 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.

Retornar