Skip navigation links
D.6.13 Alterações na distribuição 3.21.21a »
Section Navigation      [Toggle]

D.6.12. Alterações na distribuição 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'

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

This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.