MySQL リファレンスマニュアル :: D.4.33 Changes in release 3.23.28 (22 Nov 2000: Gamma)

Added new options --pager[=...], --no-pager, --tee=... and --no-tee to the mysql client. The new corresponding interactive commands are pager, nopager, tee and notee. See 項4.9.2. 「mysql（コマンドラインツール）」, mysql --help and the interactive help for more information.

Fixed crash when automatic repair of MyISAM table failed.

Fixed a major performance bug in the table locking code when one constantly had a lot of SELECT, UPDATE and INSERT statements running. The symptom was that the UPDATE and INSERT queries were locked for a long time while new SELECT statements were executed before the updates.

When reading options_files with mysql_options() the return-found-rows option was ignored.

One can now specify interactive-timeout in the option file that is read by mysql_options(). This makes it possible to force programs that run for a long time (like mysqlhotcopy) to use the interactive_timeout time instead of the wait_timeout time.

Added to the slow query log the time and the user name for each logged query. If you are using --log-long-format then also queries that do not use an index are logged, even if the query takes less than long_query_time seconds.

Fixed a problem in LEFT JOIN which caused all columns in a reference table to be NULL.

Fixed a problem when using NATURAL JOIN without keys.

Fixed a bug when using a multi-part keys where the first part was of type TEXT or BLOB.

DROP of temporary tables wasn't stored in the update/binary log.

Fixed a bug where SELECT DISTINCT * ... LIMIT row_count only returned one row.

Fixed a bug in the assembler code in strstr() for SPARC and cleaned up the global.h header file to avoid a problem with bad aliasing with the compiler submitted with Red Hat 7.0. (Reported by Trond Eivind Glomsrød)

The --skip-networking option now works properly on NT.

Fixed a long outstanding bug in the ISAM tables when a row with a length of more than 65K was shortened by a single byte.

Fixed a bug in MyISAM when running multiple updating processes on the same table.

Allow one to use FLUSH TABLE tbl_name.

Added --replicate-ignore-table, --replicate-do-table, --replicate-wild-ignore-table, and --replicate-wild-do-table options to mysqld.

Changed all log files to use our own IO_CACHE mechanism instead of FILE to avoid OS problems when there are many files open.

Added --open-files and --timezone options to safe_mysqld.

Fixed a fatal bug in CREATE TEMPORARY TABLE ... SELECT ....

Fixed a problem with CREATE TABLE ... SELECT NULL.

Added variables large_file_support,net_read_timeout, net_write_timeout and query_buffer_size to SHOW VARIABLES.

Added status variables created_tmp_files and sort_merge_passes to SHOW STATUS.

Fixed a bug where we didn't allow an index name after the FOREIGN KEY definition.

Added TRUNCATE table_name as a synonym for DELETE FROM table_name.

Fixed a bug in a BDB key compare function when comparing part keys.

Added bdb_lock_max variable to mysqld.

Added more tests to the benchmark suite.

Fixed an overflow bug in the client code when using overly long database names.

mysql_connect() now aborts on Linux if the server doesn't answer in timeout seconds.

SLAVE START did not work if you started with --skip-slave-start and had not explicitly run CHANGE MASTER TO.

Fixed the output of SHOW MASTER STATUS to be consistent with SHOW SLAVE STATUS. (It now has no directory in the log name.)

Added PURGE MASTER LOGS TO.

Added SHOW MASTER LOGS.

Added --safemalloc-mem-limit option to mysqld to simulate memory shortage when compiled with the --with-debug=full option.

Fixed several core dumps in out-of-memory conditions.

SHOW SLAVE STATUS was using an uninitialized mutex if the slave had not been started yet.

Fixed bug in ELT() and MAKE_SET() when the query used a temporary table.

CHANGE MASTER TO without specifying MASTER_LOG_POS would set it to 0 instead of 4 and hit the magic number in the master binlog.

ALTER TABLE ... ORDER BY ... syntax added. This will create the new table with the rows in a specific order.