D.3.15 Changes in release 4.0.1 (23 Dec 2001)

• Added system command to mysql.
• Fixed bug when HANDLER was used with some unsupported table type.
• mysqldump now puts ALTER TABLE tbl_name DISABLE KEYS and ALTER TABLE tbl_name ENABLE KEYS in the sql dump.
• Added mysql_fix_extensions script.
• Fixed stack overrun problem with LOAD DATA FROM MASTER on OSF/1.
• Fixed shutdown problem on HP-UX.
• Added DES_ENCRYPT() and DES_DECRYPT() functions.
• Added FLUSH DES_KEY_FILE statement.
• Added --des-key-file option to mysqld.
• HEX(string) now returns the characters in string converted to hexadecimal.
• Fixed problem with GRANT when using lower_case_table_names=1.
• Changed SELECT ... IN SHARE MODE to SELECT ... LOCK IN SHARE MODE (as in MySQL 3.23).
• A new query cache to cache results from identical SELECT queries.
• Fixed core dump bug on 64-bit machines when it got an incorrect communication packet.
• MATCH ... AGAINST(... IN BOOLEAN MODE) can now work without FULLTEXT index.
• Fixed slave to replicate from 3.23 master.
• Miscellaneous replication fixes/cleanup.
• Got shutdown to work on Mac OS X.
• Added myisam/ft_dump utility for low-level inspection of FULLTEXT indexes.
• Fixed bug in DELETE ... WHERE ... MATCH ....
• Added support for MATCH ... AGAINST(... IN BOOLEAN MODE). Note: you must rebuild your tables with ALTER TABLE tablename TYPE=MyISAM to be able to use boolean full-text search.
• LOCATE() and INSTR() are now case-sensitive if either argument is a binary string.
• Changed RAND() initialisation so that RAND(N) and RAND(N+1) are more distinct.
• Fixed core dump bug in UPDATE ... ORDER BY.
• In 3.23, INSERT INTO ... SELECT always had IGNORE enabled. Now MySQL will stop (and possibly roll back) by default in case of an error unless you specify IGNORE.
• Ignore DATA DIRECTORY and INDEX DIRECTORY directives on Windows.
• Added boolean full-text search code. It should be considered early alpha.
• Extended MODIFY and CHANGE in ALTER TABLE to accept the FIRST and AFTER keywords.
• Indexes are now used with ORDER BY on a whole InnoDB table.

User Comments

Add your own comment.