D.4.37 Changes in release 3.23.23 (01 Sep 2000)

• Changed sort order for 'German'; all tables created with 'German' sortorder must be repaired with REPAIR TABLE or myisamchk before use!
• Added --core-file option to mysqld to get a core file on Linux if mysqld dies on the SIGSEGV signal.
• MySQL client mysql now starts with option --no-named-commands (-g) by default. This option can be disabled with --enable-named-commands (-G). This may cause incompatibility problems in some cases, for example, in SQL scripts that use named commands without a semicolon, etc.! Long format commands still work from the first line.
• Fixed a problem when using many pending DROP TABLE statements at the same time.
• Optimiser didn't use keys properly when using LEFT JOIN on an empty table.
• Added shorter help text when invoking mysqld with incorrect options.
• Fixed non-fatal free() bug in mysqlimport.
• Fixed bug in MyISAM index handling of DECIMAL/NUMERIC keys.
• Fixed a bug in concurrent insert in MyISAM tables. In some contexts, usage of MIN(key_part) or MAX(key_part) returned an empty set.
• Updated mysqlhotcopy to use the new FLUSH TABLES table_list syntax. Only tables which are being backed up are flushed now.
• Changed behaviour of --enable-thread-safe-client so that both non-threaded (-lmysqlclient) and threaded (-lmysqlclient_r) libraries are built. Users who linked against a threaded -lmysqlclient will need to link against -lmysqlclient_r now.
• Added atomic RENAME TABLE command.
• Don't count NULL values in COUNT(DISTINCT ...).
• Changed ALTER TABLE, LOAD DATA INFILE on empty tables and INSERT ... SELECT ... on empty tables to create non-unique indexes in a separate batch with sorting. This will make the above calls much faster when you have many indexes.
• ALTER TABLE now logs the first used insert_id correctly.
• Fixed crash when adding a default value to a BLOB column.
• Fixed a bug with DATE_ADD/DATE_SUB where it returned a datetime instead of a date.
• Fixed a problem with the thread cache which made some threads show up as ***DEAD*** in SHOW PROCESSLIST.
• Fixed a lock in our thr_rwlock code, which could make selects that run at the same time as concurrent inserts crash. This only affects systems that don't have the pthread_rwlock_rdlock code.
• When deleting rows with a non-unique key in a HEAP table, all rows weren't always deleted.
• Fixed bug in range optimiser for HEAP tables for searches on a part index.
• Fixed SELECT on part keys to work with BDB tables.
• Fixed INSERT INTO bdb_table ... SELECT to work with BDB tables.
• CHECK TABLE now updates key statistics for the table.
• ANALYZE TABLE will now only update tables that have been changed since the last ANALYZE. Note that this is a new feature and tables will not be marked to be analysed until they are updated in any way with 3.23.23 or newer. For older tables, you have to do CHECK TABLE to update the key distribution.
• Fixed some minor privilege problems with CHECK, ANALYZE, REPAIR and SHOW CREATE commands.
• Added CHANGE MASTER TO statement.
• Added FAST, QUICK EXTENDED check types to CHECK TABLES.
• Changed myisamchk so that --fast and --check-only-changed are also honored with --sort-index and --analyze.
• Fixed fatal bug in LOAD TABLE FROM MASTER that did not lock the table during index re-build.
• LOAD DATA INFILE broke replication if the database was excluded from replication.
• More variables in SHOW SLAVE STATUS and SHOW MASTER STATUS.
• SLAVE STOP now will not return until the slave thread actually exits.
• Full-text search via the MATCH() function and FULLTEXT index type (for MyISAM files). This makes FULLTEXT a reserved word.

User Comments

Add your own comment.