MySQL Manual | D.7.6 Changes in release 3.20.13

Added standard SQL-92 DATE and TIME types.
Fixed bug in SELECT with AND-OR levels.
Added support for Slovenian characters. The `Contrib' directory contains source and instructions for adding other character sets.
Fixed bug with LIMIT and ORDER BY.
Allow ORDER BY and GROUP BY on items that aren't in the SELECT list. (Thanks to Wim Bonis bonis@kiss.de, for pointing this out.)
Allow setting of timestamp values in INSERT.
Fixed bug with SELECT ... WHERE ... = NULL.
Added changes for glibc 2.0. To get glibc to work, you should add the `gibc-2.0-sigwait-patch' before compiling glibc.
Fixed bug in ALTER TABLE when changing a NOT NULL field to allow NULL values.
Added some SQL-92 synonyms as field types to CREATE TABLE. CREATE TABLE now allows FLOAT(4) and FLOAT(8) to mean FLOAT and DOUBLE.
New utility program mysqlaccess by Yves.Carlier@rug.ac.be. This program shows the access rights for a specific user and the grant rows that determine this grant.
Added WHERE const op field (by bonis@kiss.de).

User Comments