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.
Optimizer 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 behavior 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 optimizer 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.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
