Skip navigation links
D.5.35 Changes in release 3.22.1 (Jun 1998: Alpha) »
Section Navigation      [Toggle]

D.5.34. Changes in release 3.22.2

  • Searching on multiple constant keys that matched more than 30% of the rows didn't always use the best possible key.

  • New functions <<, >>, RPAD() and LPAD().

  • You can now save default options (like passwords) in a configuration file (my.cnf).

  • Lots of small changes to get ORDER BY to work when no records are found when using fields that are not in GROUP BY (MySQL extension).

  • Added --chroot option to mysqld, to start mysqld in a chroot environment (by Nikki Chumakov ).

  • Trailing spaces are now ignored when comparing case-sensitive strings; this should fix some problems with ODBC and flag 512!

  • Fixed a core dump bug in the range optimizer.

  • Added --one-thread option to mysqld, for debugging with LinuxThreads (or glibc). (This replaces the -T32 flag)

  • Added DROP TABLE IF EXISTS to prevent an error from occurring if the table doesn't exist.

  • IF and EXISTS are now reserved words (they would have to be sooner or later).

  • Added lots of new options to mysqldump.

  • Server error messages are now in mysqld_error.h.

  • The server/client protocol now supports compression.

  • All bug fixes from MySQL Version 3.21.32.

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.