D.3.24 Modifications de la version 3.21.12

  • Fixed ftruncate() call in MIT-pthreads. This made isamchk destroy the `.ISM' files on (Free)BSD 2.x systems.
  • Fixed broken __P_ patch in MIT-pthreads.
  • Many memory overrun checks. All string functions now return NULL if the returned string should be longer than max_allowed_packet bytes.
  • Changed the name of the INTERVAL type to ENUM, because INTERVAL is used in ANSI SQL.
  • In some cases, doing a JOIN + GROUP + INTO OUTFILE, the result wasn't grouped.
  • LIKE with '_' as last character didn't work. Fixed.
  • Added extended ANSI SQL TRIM() function.
  • Added CURTIME().
  • Added ENCRYPT() function by Zeev Suraski.
  • Fixed better FOREIGN KEY syntax skipping. New reserved words: MATCH, FULL, PARTIAL.
  • mysqld now allows IP number and hostname to the --bind-address option.
  • Added SET OPTION CHARACTER SET cp1251_koi8 to enable conversions of data to/from cp1251_koi8.
  • Lots of changes for Win95 port. In theory, this version should now be easily portable to Win95.
  • Changed the CREATE COLUMN syntax of NOT NULL columns to be after the DEFAULT value, as specified in the ANSI SQL standard. This will make mysqldump with NOT NULL and default values incompatible with MySQL 3.20.
  • Added many function name aliases so the functions can be used with ODBC or ANSI SQL92 syntax.
  • Fixed syntax of ALTER TABLE nom_table ALTER COLUMN nom_colonne SET DEFAULT NULL.
  • Added CHAR and BIT as synonyms for CHAR(1).
  • Fixed core dump when updating as a user who has only select privilege.
  • INSERT ... SELECT ... GROUP BY didn't work in some cases. An Invalid use of group function error occurred.
  • When using LIMIT, SELECT now always uses keys instead of record scan. This will give better performance on SELECT and a WHERE that matches many rows.
  • Added Russian error messages.