D.4.35 Changes in release 3.23.25 (29 Sep 2000)

• Fixed that databasename works as second argument to mysqlhotcopy.
• The values for the UMASK and UMASK_DIR environment variables now can be specified in octal by beginning the value with a zero.
• Added RIGHT JOIN. This makes RIGHT a reserved word.
• Added @@IDENTITY as a synonym for LAST_INSERT_ID(). (This is for MSSQL compatibility.)
• Fixed a bug in myisamchk and REPAIR when using FULLTEXT index.
• LOAD DATA INFILE now works with FIFOs. (Patch by Toni L. Harbaugh-Blackford.)
• FLUSH LOGS broke replication if you specified a log name with an explicit extension as the value of the log-bin option.
• Fixed a bug in MyISAM with packed multi-part keys.
• Fixed crash when using CHECK TABLE on Windows.
• Fixed a bug where FULLTEXT index always used the koi8_ukr character set.
• Fixed privilege checking for CHECK TABLE.
• The MyISAM repair/reindex code didn't use the --tmpdir option for its temporary files.
• Added BACKUP TABLE and RESTORE TABLE.
• Fixed core dump on CHANGE MASTER TO when the slave did not have the master to start with.
• Fixed incorrect Time in the processlist for Connect of the slave thread.
• The slave now logs when it connects to the master.
• Fixed a core dump bug when doing FLUSH MASTER if you didn't specify a filename argument to --log-bin.
• Added missing `ha_berkeley.x' files to the MySQL Windows distribution.
• Fixed some mutex bugs in the log code that could cause thread blocks if new log files couldn't be created.
• Added lock time and number of selected processed rows to slow query log.
• Added --memlock option to mysqld to lock mysqld in memory on systems with the mlockall() call (as in Solaris).
• HEAP tables didn't use keys properly. (Bug from 3.23.23.)
• Added better support for MERGE tables (keys, mapping, creation, documentation...). See section 7.2 MERGE Tables.
• Fixed bug in mysqldump from 3.23 which caused some CHAR columns not to be quoted.
• Merged analyze, check, optimize and repair code.
• OPTIMIZE TABLE is now mapped to REPAIR with statistics and sorting of the index tree. This means that for the moment it only works on MyISAM tables.
• Added a pre-alloced block to root_malloc to get fewer mallocs.
• Added a lot of new statistics variables.
• Fixed ORDER BY bug with BDB tables.
• Removed warning that mysqld couldn't remove the `.pid' file under Windows.
• Changed --log-isam to log MyISAM tables instead of isam tables.
• Fixed CHECK TABLE to work on Windows.
• Added file mutexes to make pwrite() safe on Windows.

User Comments

Add your own comment.