D.6.24 Changes in release 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 SQL-99.
• 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 SQL-99 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 for the --bind-address option.
• Added SET CHARACTER SET cp1251_koi8 to enable conversions of data to and from the cp1251_koi8 character set.
• Lots of changes for Windows 95 port. In theory, this version should now be easily portable to Windows 95.
• Changed the CREATE COLUMN syntax of NOT NULL columns to be after the DEFAULT value, as specified in the SQL-99 standard. This will make mysqldump with NOT NULL and default values incompatible with MySQL Version 3.20.
• Added many function name aliases so the functions can be used with ODBC or SQL-92 syntax.
• Fixed syntax of ALTER TABLE tbl_name ALTER COLUMN col_name 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.

User Comments

Add your own comment.