D.4 Changes in release 3.23.x (Recent; still supported)

Please note that since release 4.0 is now production level, only critical fixes are done in the 3.23 release series. You are recommended to upgrade when possible, to take advantage of all speed and feature improvements in 4.0. See section Upgrading From Version 3.23 to 4.0.

The 3.23 release has several major features that are not present in previous versions. We have added three new table types:

MyISAM

A new ISAM library which is tuned for SQL and supports large files.

InnoDB

A transaction-safe storage engine that supports row level locking, and many Oracle-like features.

BerkeleyDB or BDB

Uses the Berkeley DB library from Sleepycat Software to implement transaction-safe tables.

Note that only MyISAM is available in the standard binary distribution.

The 3.23 release also includes support for database replication between a master and many slaves, full-text indexing, and much more.

All new features are being developed in the 4.x version. Only bug fixes and minor enhancements to existing features will be added to 3.23.

The replication code and BerkeleyDB code is still not as tested and as the rest of the code, so we will probably need to do a couple of future releases of 3.23 with small fixes for this part of the code. As long as you don't use these features, you should be quite safe with MySQL 3.23!

Note that the above doesn't mean that replication or Berkeley DB don't work. We have done a lot of testing of all code, including replication and BDB without finding any problems. It only means that not as many users use this code as the rest of the code and because of this we are not yet 100% confident in this code.

D.4.1 Changes in release 3.23.59 (not released yet)

D.4.2 Changes in release 3.23.58 (to be released soon)

• Fixed buffer overflow in SET PASSWORD which could potentially be exploited by MySQL users with root privileges to execute random code or to gain shell access (thanks to Jedi/Sector One for spotting and reporting this one).
• mysqldump now correctly quotes all identifiers when communicating with the server. This assures that during the dump process, mysqldump will never send queries to the server that result in a syntax error. This problem is not related to the mysqldump program's output, which was not changed. (Bug #1148)
• Fixed table/column grant handling - proper sort order (from most specific to less specific, see section Access Control, Stage 2: Request Verification) was not honored. (Bug #928)
• Fixed overflow bug in MyISAM and ISAM when a row is updated in a table with a large number of columns and at least one BLOB/TEXT column.
• Fixed MySQL so that field length (in C API) for the second column in SHOW CREATE TABLE is always larger than the data length. The only known application that was affected by the old behaviour was Borland dbExpress, which truncated the output from the command. (Bug #1064)
• Fixed ISAM bug in MAX() optimisation.
• Fixed Unknown error when doing ORDER BY on reference table which was used with NULL value on NOT NULL column. (Bug #479)

D.4.3 Changes in release 3.23.57 (06 Jun 2003)

• Fixed problem in alarm handling that could cause problems when getting a packet that is too large.
• Fixed problem when installing MySQL as a service on Windows when one gave 2 arguments (option file group name and service name) to mysqld.
• Fixed kill pid-of-mysqld to work on Mac OS X.
• SHOW TABLE STATUS displayed incorrect Row_format value for tables that have been compressed with myisampack. (Bug #427)
• SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name of the first datafile. (Bug #468)
• Fixed security problem where mysqld didn't allow one to UPDATE rows in a table even if one had a global UPDATE privilege and a database SELECT privilege.
• Fixed a security problem with SELECT and wildcarded select list, when user only had partial column SELECT privileges on the table.
• Fixed unlikely problem in optimising WHERE clause with a constant expression such as in WHERE 1 AND (a=1 AND b=1).
• Fixed problem on IA-64 with timestamps that caused mysqlbinlog to fail.
• The default option for innodb_flush_log_at_trx_commit was changed from 0 to 1 to make InnoDB tables ACID by default. See section InnoDB start.
• Fixed problem with too many allocated alarms on slave when connecting to master many times (normally not a very critical error).
• Fixed a bug in replication of temporary tables. (Bug #183)
• Fixed 64 bit bug that affected at least AMD hammer systems.
• Fixed a bug when doing LOAD DATA INFILE IGNORE: When reading the binary log, mysqlbinlog and the replication code read REPLACE instead of IGNORE. This could make the slave's table become different from the master's table. (Bug #218)
• Fixed overflow bug in MyISAM when a row is inserted into a table with a large number of columns and at least one BLOB/TEXT column. Bug was caused by incorrect calculation of the needed buffer to pack data.
• The binary log was not locked during TRUNCATE table_name or DELETE FROM table_name statements, which could cause an INSERT to table_name to be written to the log before the TRUNCATE or DELETE statements.
• Fixed rare bug in UPDATE of InnoDB tables where one row could be updated multiple times.
• Produce an error for empty table and column names.
• Changed PROCEDURE ANALYSE() to report DATE instead of NEWDATE.
• Changed PROCEDURE ANALYSE(#) to restrict the number of values in an ENUM column to # also for string values.
• mysqldump no longer silently deletes the binary logs when invoked with the --master-data or --first-slave option; while this behaviour was convenient for some users, others may suffer from it. Now one has to explicitly ask for binary logs to be deleted by using the new --delete-master-logs option.
• Fixed a bug in mysqldump when it was invoked with the --master-data option: The CHANGE MASTER TO statements that were appended to the SQL dump had incorrect coordinates. (Bug #159)

D.4.4 Changes in release 3.23.56 (13 Mar 2003)

• Fixed mysqld crash on extremely small values of sort_buffer variable.
• Fixed a bug in privilege system for GRANT UPDATE on column level.
• Fixed a rare bug when using a date in HAVING with GROUP BY.
• Fixed checking of random part of WHERE clause. (Bug #142)
• Fixed MySQL (and myisamchk) crash on artificially corrupted `.MYI' files.
• Security enhancement: mysqld no longer reads options from world-writeable config files.
• Security enhancement: mysqld and safe_mysqld now only use the first --user option specified on the command line. (Normally this comes from `/etc/my.cnf')
• Security enhancement: Don't allow BACKUP TABLE to overwrite existing files.
• Fixed unlikely deadlock bug when one thread did a LOCK TABLE and another thread did a DROP TABLE. In this case one could do a KILL on one of the threads to resolve the deadlock.
• LOAD DATA INFILE was not replicated by slave if replicate_*_table was set on the slave.
• Fixed a bug in handling CHAR(0) columns that could cause wrong results from the query.
• Fixed a bug in SHOW VARIABLES on 64-bit platforms. The bug was caused by wrong declaration of variable server_id.
• The Comment column in SHOW TABLE STATUS now reports that it can contain NULL values (which is the case for a crashed `.frm' file).
• Fixed the rpl_rotate_logs test to not fail on certain platforms (e.g. Mac OS X) due to a too long file name (changed slave-master-info.opt to .slave-mi).
• Fixed a problem with BLOB NOT NULL columns used with IS NULL.
• Fixed bug in MAX() optimisation in MERGE tables.
• Better RAND() initialisation for new connections.
• Fixed bug with connect timeout. This bug was manifested on OS's with poll() system call, which resulted in timeout the value specified as it was executed in both select() and poll().
• Fixed bug in SELECT * FROM table WHERE datetime1 IS NULL OR datetime2 IS NULL.
• Fixed bug in using aggregate functions as argument for INTERVAL, CASE, FIELD, CONCAT_WS, ELT and MAKE_SET functions.
• When running with --lower-case-table-names (default on Windows) and you had tables or databases with mixed case on disk, then executing SHOW TABLE STATUS followed with DROP DATABASE or DROP TABLE could fail with Errcode 13.
• Fixed bug in logging to binary log (which affects replication) a query that inserts a NULL in an auto_increment field and also uses LAST_INSERT_ID().
• Fixed bug in mysqladmin --relative.
• On some 64 bit systems, show status reported a strange number for Open_files and Open_streams.

D.4.5 Changes in release 3.23.55 (23 Jan 2003)

• Fixed double free'd pointer bug in mysql_change_user() handling, that enabled a specially hacked version of MySQL client to crash mysqld. Note, that one needs to login to the server by using a valid user account to be able to exploit this bug.
• Fixed bug with the --slow-log when logging an administrator command (like FLUSH TABLES).
• Fixed bug in GROUP BY when used on BLOB column with NULL values.
• Fixed a bug in handling NULL values in CASE ... WHEN ....
• Bugfix for --chroot (see section --chroot) is reverted. Unfortunately, there is no way to make it to work, without introducing backward-incompatible changes in `my.cnf'. Those who need --chroot functionality, should upgrade to MySQL 4.0. (The fix in the 4.0 branch did not break backward-compatibility).
• Make --lower-case-table-names default on Mac OS X as the default file system (HFS+) is case insensitive.
• Fixed a bug in `scripts/mysqld_safe.sh' in NOHUP_NICENESS testing.
• Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.
• Fixed a bug in scripts/make_binary_distribution that resulted in a remaining @HOSTNAME@ variable instead of replacing it with the correct path to the hostname binary.
• Fixed a very unlikely bug that could cause SHOW PROCESSLIST to core dump in pthread_mutex_unlock() if a new thread was connecting.
• Forbid SLAVE STOP if the thread executing the query has locked tables. This removes a possible deadlock situation.

D.4.6 Changes in release 3.23.54 (05 Dec 2002)

• Fixed a bug, that allowed to crash mysqld with a specially crafted packet.
• Fixed a rare crash (double free'd pointer) when altering a temporary table.
• Fixed buffer overrun in libmysqlclient library that allowed malicious MySQL server to crash the client application.
• Fixed security-related bug in mysql_change_user() handling. All users are strongly recommended to upgrade to the version 3.23.54.
• Fixed bug that prevented --chroot command-line option of mysqld from working.
• Fixed bug that made OPTIMIZE TABLE to corrupt the table under some rare circumstances.
• Fixed mysqlcheck so it can deal with table names containing dashes.
• Fixed shutdown problem on Mac OS X.
• Fixed bug with comparing an indexed NULL field with <=> NULL.
• Fixed bug that caused IGNORE INDEX and USE INDEX sometimes to be ignored.
• Fixed rare core dump problem in complicated GROUP BY queries that didn't return any result.
• Fixed a bug where MATCH ... AGAINST () >=0 was treated as if it was >.
• Fixed core dump in SHOW PROCESSLIST when running with an active slave (unlikely timing bug).
• Make it possible to use multiple MySQL servers on Windows (code backported from 4.0.2).
• One can create TEMPORARY MERGE tables now.
• Fixed that --core-file works on Linux (at least on kernel 2.4.18).
• Fixed a problem with BDB and ALTER TABLE.
• Fixed reference to freed memory when doing complicated GROUP BY ... ORDER BY queries. Symptom was that mysqld died in function send_fields.
• Allocate heap rows in smaller blocks to get better memory usage.
• Fixed memory allocation bug when storing BLOB values in internal temporary tables used for some (unlikely) GROUP BY queries.
• Fixed a bug in key optimising handling where the expression WHERE column_name = key_column_name was calculated as true for NULL values.
• Fixed core dump bug when doing LEFT JOIN ... WHERE key_column=NULL.
• Fixed MyISAM crash when using dynamic-row tables with huge numbers of packed fields.
• Updated source tree to be built using automake 1.5 and libtool 1.4.

D.4.7 Changes in release 3.23.53 (09 Oct 2002)

• Fixed crash when SHOW INNODB STATUS was used and skip-innodb was defined.
• Fixed possible memory corruption bug in binary log file handling when slave rotated the logs (only affected 3.23, not 4.0).
• Fixed problem in LOCK TABLES on Windows when one connects to a database that contains upper case letters.
• Fixed that --skip-show-databases doesn't reset the --port option.
• Small fix in safe_mysqld for some shells.
• Fixed that FLUSH STATUS doesn't reset delayed_insert_threads.
• Fixed core dump bug when using the BINARY cast on a NULL value.
• Fixed race condition when someone did a GRANT at the same time a new user logged in or did a USE database.
• Fixed bug in ALTER TABLE and RENAME TABLE when running with -O lower_case_table_names=1 (typically on Windows) when giving the table name in uppercase.
• Fixed that -O lower_case_table_names=1 also converts database names to lower case.
• Fixed unlikely core dump with SELECT ... ORDER BY ... LIMIT.
• Changed AND/OR to report that they can return NULL. This fixes a bug in GROUP BY on AND/OR expressions that return NULL.
• Fixed a bug that OPTIMIZE of locked and modified MyISAM table, reported table corruption.
• Fixed a BDB-related ALTER TABLE bug with dropping a column and shutting down immediately thereafter.
• Fixed problem with configure ... --localstatedir=....
• Fixed problem with UNSIGNED BIGINT on AIX (again).
• Fixed bug in pthread_mutex_trylock() on HPUX 11.0.
• Multi-threaded stress tests for InnoDB.

D.4.8 Changes in release 3.23.52 (14 Aug 2002)

• Wrap BEGIN/COMMIT around transaction in the binary log. This makes replication honour transactions.
• Fixed security bug when having an empty database name in the user.db table.
• Changed initialisation of RND() to make it less predicatable.
• Fixed problem with GROUP BY on result with expression that created a BLOB field.
• Fixed problem with GROUP BY on columns that have NULL values. To solve this we now create an MyISAM temporary table when doing a GROUP BY on a possible NULL item. From MySQL 4.0.5 we can use in memory HEAP tables for this case.
• Fixed problem with privilege tables when downgrading from 4.0.2 to 3.23.
• Fixed thread bug in SLAVE START, SLAVE STOP and automatic repair of MyISAM tables that could cause table cache to be corrupted.
• Fixed possible thread related key-cache-corruption problem with OPTIMIZE TABLE and REPAIR TABLE.
• Added name of 'administrator command' logs.
• Fixed bug with creating an auto-increment value on second part of a UNIQUE() key where first part could contain NULL values.
• Don't write slave-timeout reconnects to the error log.
• Fixed bug with slave net read timeouting
• Fixed a core-dump bug with MERGE tables and MAX() function.
• Fixed bug in ALTER TABLE with BDB tables.
• Fixed bug when logging LOAD DATA INFILE to binary log with no active database.
• Fixed a bug in range optimiser (causing crashes).
• Fixed possible problem in replication when doing DROP DATABASE on a database with InnoDB tables.
• Fixed that mysql_info() returns 0 for 'Duplicates' when using INSERT DELAYED IGNORE.
• Added -DHAVE_BROKEN_REALPATH to the Mac OS X (darwin) compile options in `configure.in' to fix a failure under high load.

D.4.9 Changes in release 3.23.51 (31 May 2002)

• Fix bug with closing tags missing slash for mysqldump XML output.
• Remove end space from ENUM values. (This fixed a problem with SHOW CREATE TABLE.)
• Fixed bug in CONCAT_WS() that cut the result.
• Changed name of server variables Com_show_master_stat to Com_show_master_status and Com_show_slave_stat to Com_show_slave_status.
• Changed handling of gethostbyname() to make the client library thread-safe even if gethostbyname_r doesn't exist.
• Fixed core-dump problem when giving a wrong password string to GRANT.
• Fixed bug in DROP DATABASE with symlinked directory.
• Fixed optimisation problem with DATETIME and value outside DATETIME range.
• Removed Sleepycat's BDB doc files from the source tree, as they're not needed (MySQL covers BDB in its own documentation).
• Fixed MIT-pthreads to compile with glibc 2.2 (needed for make dist).
• Fixed the FLOAT(X+1,X) is not converted to FLOAT(X+2,X). (This also affected DECIMAL, DOUBLE and REAL types)
• Fixed the result from IF() is case in-sensitive if the second and third arguments are case sensitive.
• Fixed core dump problem on OSF/1 in gethostbyname_r.
• Fixed that underflowed decimal fields are not zero filled.
• If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED columns, we will just drop the sign.
• Fixed optimisation bug with ISNULL(expression_which_cannot_be_null) and ISNULL(constant_expression).
• Fixed host lookup bug in the glibc library that we used with the 3.23.50 Linux-x86 binaries.

D.4.10 Changes in release 3.23.50 (21 Apr 2002)

• Fixed buffer overflow problem if someone specified a too long datadir parameter to mysqld
• Add missing <row> tags for mysqldump XML output.
• Fixed problem with crash-me and gcc 3.0.4.
• Fixed that @@unknown_variable doesn't hang server.
• Added @@VERSION as a synonym for VERSION().
• SHOW VARIABLES LIKE 'xxx' is now case-insensitive.
• Fixed timeout for GET_LOCK() on HP-UX with DCE threads.
• Fixed memory allocation bug in the glibc library used to build Linux binaries, which caused mysqld to die in 'free()'.
• Fixed SIGINT and SIGQUIT problems in mysql.
• Fixed bug in character table converts when used with big ( > 64K) strings.
• InnoDB now retains foreign key constraints through ALTER TABLE and CREATE/DROP INDEX.
• InnoDB now allows foreign key constraints to be added through the ALTER TABLE syntax.
• InnoDB tables can now be set to automatically grow in size (autoextend).
• Our Linux RPMS and binaries are now compiled with gcc 3.0.4, which should make them a bit faster.
• Fixed some buffer overflow problems when reading startup parameters.
• Because of problems on shutdown we have now disabled named pipes on Windows by default. One can enable named pipes by starting mysqld with --enable-named-pipe.
• Fixed bug when using WHERE key_column = 'J' or key_column='j'.
• Fixed core-dump bug when using --log-bin with LOAD DATA INFILE without an active database.
• Fixed bug in RENAME TABLE when used with lower_case_table_names=1 (default on Windows).
• Fixed unlikely core-dump bug when using DROP TABLE on a table that was in use by a thread that also used queries on only temporary tables.
• Fixed problem with SHOW CREATE TABLE and PRIMARY KEY when using 32 indexes.
• Fixed that one can use SET PASSWORD for the anonymous user.
• Fixed core dump bug when reading client groups from option files using mysql_options().
• Memory leak (16 bytes per every corrupted table) closed.
• Fixed binary builds to use --enable-local-infile.
• Update source to work with new version of bison.
• Updated shell scripts to now agree with new POSIX standard.
• Fixed bug where DATE_FORMAT() returned empty string when used with GROUP BY.

D.4.11 Changes in release 3.23.49

• Don't give warning for a statement that is only a comment; this is needed for mysqldump --disable-keys to work.
• Fixed unlikely caching bug when doing a join without keys. In this case the last used field for a table always returned NULL.
• Added options to make LOAD DATA LOCAL INFILE more secure.
• MySQL binary release 3.23.48 for Linux contained a new glibc library, which has serious problems under high load and Red Hat 7.2. The 3.23.49 binary release doesn't have this problem.
• Fixed shutdown problem on NT.

D.4.12 Changes in release 3.23.48 (07 Feb 2002)

• Added --xml option to mysqldump for producing XML output.
• Changed to use autoconf 2.52 (from autoconf 2.13)
• Fixed bug in complicated join with const tables.
• Added internal safety checks for InnoDB.
• Some InnoDB variables were always shown in SHOW VARIABLES as OFF on high-byte-first systems (like SPARC).
• Fixed problem with one thread using an InnoDB table and another thread doing an ALTER TABLE on the same table. Before that, mysqld could crash with an assertion failure in `row0row.c', line 474.
• Tuned the InnoDB SQL optimiser to favor index searches more often over table scans.
• Fixed a performance problem with InnoDB tables when several large SELECT queries are run concurrently on a multiprocessor Linux computer. Large CPU-bound SELECT queries will now also generally run faster on all platforms.
• If MySQL binlogging is used, InnoDB now prints after crash recovery the latest MySQL binlog name and the offset InnoDB was able to recover to. This is useful, for example, when resynchronising a master and a slave database in replication.
• Added better error messages to help in installation problems of InnoDB tables.
• It is now possible to recover MySQL temporary tables that have become orphaned inside the InnoDB tablespace.
• InnoDB now prevents a FOREIGN KEY declaration where the signedness is not the same in the referencing and referenced integer columns.
• Calling SHOW CREATE TABLE or SHOW TABLE STATUS could cause memory corruption and make mysqld crash. Especially at risk was mysqldump, because it frequently calls SHOW CREATE TABLE.
• If inserts to several tables containing an AUTO_INCREMENT column were wrapped inside one LOCK TABLES, InnoDB asserted in `lock0lock.c'.
• In 3.23.47 we allowed several NULL values in a UNIQUE secondary index for an InnoDB table. But CHECK TABLE was not relaxed: it reports the table as corrupt. CHECK TABLE no longer complains in this situation.
• SHOW GRANTS now shows REFERENCES instead of REFERENCE.

D.4.13 Changes in release 3.23.47 (27 Dec 2001)

• Fixed bug when using the following construct: SELECT ... WHERE key=@var_name OR key=@var_name2
• Restrict InnoDB keys to 500 bytes.
• InnoDB now supports NULL in keys.
• Fixed shutdown problem on HP-UX. (Introduced in 3.23.46)
• Fixed core dump bug in replication when using SELECT RELEASE_LOCK().
• Added new command: DO expression,[expression]
• Added slave-skip-errors option.
• Added statistics variables for all MySQL commands. (SHOW STATUS is now much longer.)
• Fixed default values for InnoDB tables.
• Fixed that GROUP BY expr DESC works.
• Fixed bug when using t1 LEFT JOIN t2 ON t2.key=constant.
• mysql_config now also works with binary (relocated) distributions.

D.4.14 Changes in release 3.23.46 (29 Nov 2001)

• Fixed problem with aliased temporary table replication.
• InnoDB and BDB tables will now use index when doing an ORDER BY on the whole table.
• Fixed bug where one got an empty set instead of a DEADLOCK error when using BDB tables.
• One can now kill ANALYZE, REPAIR, and OPTIMIZE TABLE when the thread is waiting to get a lock on the table.
• Fixed race condition in ANALYZE TABLE.
• Fixed bug when joining with caching (unlikely to happen).
• Fixed race condition when using the binary log and INSERT DELAYED which could cause the binary log to have rows that were not yet written to MyISAM tables.
• Changed caching of binary log to make replication slightly faster.
• Fixed bug in replication on Mac OS X.

D.4.15 Changes in release 3.23.45 (22 Nov 2001)

• (UPDATE|DELETE) ...WHERE MATCH bugfix.
• shutdown should now work on Darwin (Mac OS X).
• Fixed core dump when repairing corrupted packed MyISAM files.
• --core-file now works on Solaris.
• Fix a bug which could cause InnoDB to complain if it cannot find free blocks from the buffer cache during recovery.
• Fixed bug in InnoDB insert buffer B-tree handling that could cause crashes.
• Fixed bug in InnoDB lock timeout handling.
• Fixed core dump bug in ALTER TABLE on a TEMPORARY InnoDB table.
• Fixed bug in OPTIMIZE TABLE that reset index cardinality if it was up to date.
• Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL when date_column was declared as NOT NULL.
• Fixed bug with BDB tables and keys on BLOB columns.
• Fixed bug in MERGE tables on OS with 32-bit file pointers.
• Fixed bug in TIME_TO_SEC() when using negative values.

D.4.16 Changes in release 3.23.44 (31 Oct 2001)

• Fixed Rows_examined count in slow query log.
• Fixed bug when using a reference to an AVG() column in HAVING.
• Fixed that date functions that require correct dates, like DAYOFYEAR(column), will return NULL for 0000-00-00 dates.
• Fixed bug in const-propagation when comparing columns of different types. (SELECT * FROM date_col="2001-01-01" and date_col=time_col)
• Fixed bug that caused error message Can't write, because of unique constraint with some GROUP BY queries.
• Fixed problem with sjis character strings used within quoted table names.
• Fixed core dump when using CREATE ... FULLTEXT keys with other storage engines than MyISAM.
• Don't use signal() on Windows because this appears to not be 100% reliable.
• Fixed bug when doing WHERE col_name=NULL on an indexed column that had NULL values.
• Fixed bug when doing LEFT JOIN ... ON (col_name = constant) WHERE col_name = constant.
• When using replications, aborted queries that contained % could cause a core dump.
• TCP_NODELAY was not used on some systems. (Speed problem.)
• Applied portability fixes for OS/2. (Patch by Yuri Dario.)

The following changes are for InnoDB tables:

• Add missing InnoDB variables to SHOW VARIABLES.
• Foreign keys checking is now done for InnoDB tables.
• DROP DATABASE now works also for InnoDB tables.
• InnoDB now supports datafiles and raw disk partitions bigger than 4 GB on those operating systems that have big files.
• InnoDB calculates better table cardinality estimates for the MySQL optimiser.
• Accent characters in the default character set latin1 are ordered according to the MySQL ordering.

  Note: if you are using latin1 and have inserted characters whose code is greater than 127 into an indexed CHAR column, you should run CHECK TABLE on your table when you upgrade to 3.23.44, and drop and reimport the table if CHECK TABLE reports an error!

• A new `my.cnf' parameter, innodb_thread_concurrency, helps in performance tuning in heavily concurrent environments.
• A new `my.cnf' parameter, innodb_fast_shutdown, speeds up server shutdown.
• A new `my.cnf' parameter, innodb_force_recovery, helps to save your data in case the disk image of the database becomes corrupt.
• innodb_monitor has been improved and a new innodb_table_monitor added.
• Increased maximum key length from 500 to 7000 bytes.
• Fixed a bug in replication of AUTO_INCREMENT columns with multiple-line inserts.
• Fixed a bug when the case of letters changes in an update of an indexed secondary column.
• Fixed a hang when there are > 24 datafiles.
• Fixed a crash when MAX(col) is selected from an empty table, and col is not the first column in a multi-column index.
• Fixed a bug in purge which could cause crashes.

D.4.17 Changes in release 3.23.43 (04 Oct 2001)

• Fixed a bug in INSERT DELAYED and FLUSH TABLES introduced in 3.23.42.
• Fixed unlikely bug, which returned non-matching rows, in SELECT with many tables and multi-column indexes and 'range' type.
• Fixed an unlikely core dump bug when doing EXPLAIN SELECT when using many tables and ORDER BY.
• Fixed bug in LOAD DATA FROM MASTER when using table with CHECKSUM=1.
• Added unique error message when one gets a DEADLOCK during a transaction with BDB tables.
• Fixed problem with BDB tables and UNIQUE columns defined as NULL.
• Fixed problem with myisampack when using pre-space filled CHAR columns.
• Applied patch from Yuri Dario for OS/2.
• Fixed bug in --safe-user-create.

D.4.18 Changes in release 3.23.42 (08 Sep 2001)

• Fixed problem when using LOCK TABLES and BDB tables.
• Fixed problem with REPAIR TABLE on MyISAM tables with row lengths in the range from 65517 to 65520 bytes.
• Fixed rare hang when doing mysqladmin shutdown when there was a lot of activity in other threads.
• Fixed problem with INSERT DELAYED where delay thread could be hanging on upgrading locks with no apparent reason.
• Fixed problem with myisampack and BLOB.
• Fixed problem when one edited `.MRG' tables by hand. (Patch from Benjamin Pflugmann).
• Enforce that all tables in a MERGE table come from the same database.
• Fixed bug with LOAD DATA INFILE and transactional tables.
• Fix bug when using INSERT DELAYED with wrong column definition.
• Fixed core dump during REPAIR of some particularly broken tables.
• Fixed bug in InnoDB and AUTO_INCREMENT columns.
• Fixed bug in InnoDB and RENAME TABLE columns.
• Fixed critical bug in InnoDB and BLOB columns. If you have used BLOB columns larger than 8000 bytes in an InnoDB table, it is necessary to dump the table with mysqldump, drop it and restore it from the dump.
• Applied large patch for OS/2 from Yuri Dario.
• Fixed problem with InnoDB when one could get the error Can't execute the given command... even when no transaction was active.
• Applied some minor fixes that concern Gemini.
• Use real arithmetic operations even in integer context if not all arguments are integers. (Fixes uncommon bug in some integer contexts).
• Don't force everything to lowercase on Windows. (To fix problem with Windows and ALTER TABLE). Now --lower_case_names also works on Unix.
• Fixed that automatic rollback is done when thread end doesn't lock other threads.

D.4.19 Changes in release 3.23.41 (11 Aug 2001)

• Added --sql-mode=value[,value[,value]] option to mysqld. See section mysqld Command-line Options.
• Fixed possible problem with shutdown on Solaris where the `.pid' file wasn't deleted.
• InnoDB now supports < 4 GB rows. The former limit was 8000 bytes.
• The doublewrite file flush method is used in InnoDB. It reduces the need for Unix fsync() calls to a fraction and improves performance on most Unix flavors.
• You can now use the InnoDB Monitor to print a lot of InnoDB state information, including locks, to the standard output. This is useful in performance tuning.
• Several bugs which could cause hangs in InnoDB have been fixed.
• Split record_buffer to record_buffer and record_rnd_buffer. To make things compatible to previous MySQL versions, if record_rnd_buffer is not set, then it takes the value of record_buffer.
• Fixed optimising bug in ORDER BY where some ORDER BY parts where wrongly removed.
• Fixed overflow bug with ALTER TABLE and MERGE tables.
• Added prototypes for my_thread_init() and my_thread_end() to `mysql_com.h'
• Added --safe-user-create option to mysqld.
• Fixed bug in SELECT DISTINCT ... HAVING that caused error message Can't find record in #...

D.4.20 Changes in release 3.23.40

• Fixed problem with --low-priority-updates and INSERT statements.
• Fixed bug in slave thread when under some rare circumstances it could get 22 bytes ahead on the offset in the master.
• Added slave_net_timeout for replication.
• Fixed problem with UPDATE and BDB tables.
• Fixed hard bug in BDB tables when using key parts.
• Fixed problem when using GRANT FILE ON database.* ...; previously we added the DROP privilege for the database.
• Fixed DELETE FROM tbl_name ... LIMIT 0 and UPDATE FROM tbl_name ... LIMIT 0, which acted as though the LIMIT clause was not present (they deleted or updated all selected rows).
• CHECK TABLE now checks if an AUTO_INCREMENT column contains the value 0.
• Sending a SIGHUP to mysqld will now only flush the logs, not reset the replication.
• Fixed parser to allow floats of type 1.0e1 (no sign after e).
• Option --force to myisamchk now also updates states.
• Added option --warnings to mysqld. Now mysqld prints the error Aborted connection only if this option is used.
• Fixed problem with SHOW CREATE TABLE when you didn't have a PRIMARY KEY.
• Properly fixed the rename of innodb_unix_file_flush_method variable to innodb_flush_method.
• Fixed bug when converting BIGINT UNSIGNED to DOUBLE. This caused a problem when doing comparisons with BIGINT values outside of the signed range.
• Fixed bug in BDB tables when querying empty tables.
• Fixed a bug when using COUNT(DISTINCT) with LEFT JOIN and there weren't any matching rows.
• Removed all documentation referring to the GEMINI table type. GEMINI is not released under an Open Source license.

D.4.21 Changes in release 3.23.39 (12 Jun 2001)

• The AUTO_INCREMENT sequence wasn't reset when dropping and adding an AUTO_INCREMENT column.
• CREATE ... SELECT now creates non-unique indexes delayed.
• Fixed problem where LOCK TABLES tbl_name READ followed by FLUSH TABLES put an exclusive lock on the table.
• REAL @variable values were represented with only 2 digits when converted to strings.
• Fixed problem that client "hung" when LOAD TABLE FROM MASTER failed.
• myisamchk --fast --force will no longer repair tables that only had the open count wrong.
• Added functions to handle symbolic links to make life easier in 4.0.
• We are now using the -lcma thread library on HP-UX 10.20 so that MySQL will be more stable on HP-UX.
• Fixed problem with IF() and number of decimals in the result.
• Fixed date-part extraction functions to work with dates where day and/or month is 0.
• Extended argument length in option files from 256 to 512 chars.
• Fixed problem with shutdown when INSERT DELAYED was waiting for a LOCK TABLE.
• Fixed core dump bug in InnoDB when tablespace was full.
• Fixed problem with MERGE tables and big tables (> 4G) when using ORDER BY.

D.4.22 Changes in release 3.23.38 (09 May 2001)

• Fixed a bug when SELECT from MERGE table sometimes results in incorrectly ordered rows.
• Fixed a bug in REPLACE() when using the ujis character set.
• Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2.
• Added --skip-stack-trace option to mysqld.
• CREATE TEMPORARY now works with InnoDB tables.
• InnoDB now promotes sub keys to whole keys.
• Added option CONCURRENT to LOAD DATA.
• Better error message when slave max_allowed_packet is too low to read a very long log event from the master.
• Fixed bug when too many rows where removed when using SELECT DISTINCT ... HAVING.
• SHOW CREATE TABLE now returns TEMPORARY for temporary tables.
• Added Rows_examined to slow query log.
• Fixed problems with function returning empty string when used together with a group function and a WHERE that didn't match any rows.
• New program mysqlcheck.
• Added database name to output for administrative commands like CHECK, REPAIR, OPTIMIZE.
• Lots of portability fixes for InnoDB.
• Changed optimiser so that queries like SELECT * FROM tbl_name,tbl_name2 ... ORDER BY key_part1 LIMIT row_count will use index on key_part1 instead of filesort.
• Fixed bug when doing LOCK TABLE to_table WRITE,...; INSERT INTO to_table... SELECT ... when to_table was empty.
• Fixed bug with LOCK TABLE and BDB tables.

D.4.23 Changes in release 3.23.37 (17 Apr 2001)

• Fixed a bug when using MATCH() in HAVING clause.
• Fixed a bug when using HEAP tables with LIKE.
• Added --mysql-version option to safe_mysqld
• Changed INNOBASE to InnoDB (because the INNOBASE name was already used). All configure options and mysqld start options now use innodb instead of innobase. This means that before upgrading to this version, you have to change any configuration files where you have used innobase options!
• Fixed bug when using indexes on CHAR(255) NULL columns.
• Slave thread will now be started even if master-host is not set, as long as server-id is set and valid `master.info' is present.
• Partial updates (terminated with kill) are now logged with a special error code to the binary log. Slave will refuse to execute them if the error code indicates the update was terminated abnormally, and will have to be recovered with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START after a manual sanity check/correction of data integrity.
• Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log - this bug affected replication.
• Fixed a bug in REGEXP on 64-bit machines.
• UPDATE and DELETE with WHERE unique_key_part IS NULL didn't update/delete all rows.
• Disabled INSERT DELAYED for tables that support transactions.
• Fixed bug when using date functions on TEXT/BLOB column with wrong date format.
• UDFs now also work on Windows. (Patch by Ralph Mason.)
• Fixed bug in ALTER TABLE and LOAD DATA INFILE that disabled key-sorting. These commands should now be faster in most cases.
• Fixed performance bug where reopened tables (tables that had been waiting for FLUSH or REPAIR) would not use indexes for the next query.
• Fixed problem with ALTER TABLE to InnoDB tables on FreeBSD.
• Added mysqld variables myisam_max_sort_file_size and myisam_max_extra_sort_file_size.
• Initialise signals early to avoid problem with signals in InnoDB.
• Applied patch for the tis620 character set to make comparisons case-independent and to fix a bug in LIKE for this character set. Note: All tables that uses the tis620 character set must be fixed with myisamchk -r or REPAIR TABLE !
• Added --skip-safemalloc option to mysqld.

D.4.24 Changes in release 3.23.36 (27 Mar 2001)

• Fixed a bug that allowed use of database names containing a `.' character. This fixes a serious security issue when mysqld is run as root.
• Fixed bug when thread creation failed (could happen when doing a lot of connections in a short time).
• Fixed some problems with FLUSH TABLES and TEMPORARY tables. (Problem with freeing the key cache and error Can't reopen table....)
• Fixed a problem in InnoDB with other character sets than latin1 and another problem when using many columns.
• Fixed bug that caused a core dump when using a very complex query involving DISTINCT and summary functions.
• Added SET TRANSACTION ISOLATION LEVEL ...
• Added SELECT ... FOR UPDATE.
• Fixed bug where the number of affected rows was not returned when MySQL was compiled without transaction support.
• Fixed a bug in UPDATE where keys weren't always used to find the rows to be updated.
• Fixed a bug in CONCAT_WS() where it returned incorrect results.
• Changed CREATE ... SELECT and INSERT ... SELECT to not allow concurrent inserts as this could make the binary log hard to repeat. (Concurrent inserts are enabled if you are not using the binary or update log.)
• Changed some macros to be able to use fast mutex with glibc 2.2.

D.4.25 Changes in release 3.23.35 (15 Mar 2001)

• Fixed newly introduced bug in ORDER BY.
• Fixed wrong define CLIENT_TRANSACTIONS.
• Fixed bug in SHOW VARIABLES when using INNOBASE tables.
• Setting and using user variables in SELECT DISTINCT didn't work.
• Tuned SHOW ANALYZE for small tables.
• Fixed handling of arguments in the benchmark script run-all-tests.

D.4.26 Changes in release 3.23.34a

• Added extra files to the distribution to allow INNOBASE support to be compiled.

D.4.27 Changes in release 3.23.34 (10 Mar 2001)

• Added the INNOBASE storage engine and the BDB storage engine to the MySQL source distribution.
• Updated the documentation about GEMINI tables.
• Fixed a bug in INSERT DELAYED that caused threads to hang when inserting NULL into an AUTO_INCREMENT column.
• Fixed a bug in CHECK TABLE / REPAIR TABLE that could cause a thread to hang.
• REPLACE will not replace a row that conflicts with an AUTO_INCREMENT generated key.
• mysqld now only sets CLIENT_TRANSACTIONS in mysql->server_capabilities if the server supports a transaction-safe storage engine.
• Fixed LOAD DATA INFILE to allow numeric values to be read into ENUM and SET columns.
• Improved error diagnostic for slave thread exit.
• Fixed bug in ALTER TABLE ... ORDER BY.
• Added max_user_connections variable to mysqld.
• Limit query length for replication by max_allowed_packet, not the arbitrary limit of 4 MB.
• Allow space around = in argument to --set-variable.
• Fixed problem in automatic repair that could leave some threads in state Waiting for table.
• SHOW CREATE TABLE now displays the UNION=() for MERGE tables.
• ALTER TABLE now remembers the old UNION=() definition.
• Fixed bug when replicating timestamps.
• Fixed bug in bidirectional replication.
• Fixed bug in the BDB storage engine that occurred when using an index on multi-part key where a key part may be NULL.
• Fixed MAX() optimisation on sub-key for BDB tables.
• Fixed problem where garbage results were returned when using BDB tables and BLOB or TEXT fields when joining many tables.
• Fixed a problem with BDB tables and TEXT columns.
• Fixed bug when using a BLOB key where a const row wasn't found.
• Fixed that mysqlbinlog writes the timestamp value for each query. This ensures that one gets same values for date functions like NOW() when using mysqlbinlog to pipe the queries to another server.
• Allow --skip-gemini, --skip-bdb, and --skip-innodb options to be specified when invoking mysqld, even if these storage engines are not compiled in to mysqld.
• One can now do GROUP BY ... DESC.
• Fixed a deadlock in the SET code, when one ran SET @foo=bar, where bar is a column reference, an error was not properly generated.

D.4.28 Changes in release 3.23.33 (09 Feb 2001)

• Fixed DNS lookups not to use the same mutex as the hostname cache. This will enable known hosts to be quickly resolved even if a DNS lookup takes a long time.
• Added --character-sets-dir option to myisampack.
• Removed warnings when running REPAIR TABLE ... EXTENDED.
• Fixed a bug that caused a core dump when using GROUP BY on an alias, where the alias was the same as an existing column name.
• Added SEQUENCE() as an example UDF function.
• Changed mysql_install_db to use BINARY for CHAR columns in the privilege tables.
• Changed TRUNCATE tbl_name to TRUNCATE TABLE tbl_name to use the same syntax as Oracle. Until 4.0 we will also allow TRUNCATE tbl_name to not crash old code.
• Fixed "no found rows" bug in MyISAM tables when a BLOB was first part of a multi-part key.
• Fixed bug where CASE didn't work with GROUP BY.
• Added --sort-recover option to myisamchk.
• myisamchk -S and OPTIMIZE TABLE now work on Windows.
• Fixed bug when using DISTINCT on results from functions that referred to a group function, like:

  SELECT a, DISTINCT SEC_TO_TIME(SUM(a)) FROM tbl_name GROUP BY a, b;

• Fixed buffer overrun in libmysqlclient library. Fixed bug in handling STOP event after ROTATE event in replication.
• Fixed another buffer overrun in DROP DATABASE.
• Added Table_locks_immediate and Table_locks_waited status variables.
• Fixed bug in replication that broke slave server start with existing `master.info'. This fixes a bug introduced in 3.23.32.
• Added SET SQL_SLAVE_SKIP_COUNTER=n command to recover from replication glitches without a full database copy.
• Added max_binlog_size variable; the binary log will be rotated automatically when the size crosses the limit.
• Added Last_error, Last_errno, and Slave_skip_counter variables to SHOW SLAVE STATUS.
• Fixed bug in MASTER_POS_WAIT() function.
• Execute core dump handler on SIGILL, and SIGBUS in addition to SIGSEGV.
• On x86 Linux, print the current query and thread (connection) id, if available, in the core dump handler.
• Fixed several timing bugs in the test suite.
• Extended mysqltest to take care of the timing issues in the test suite.
• ALTER TABLE can now be used to change the definition for a MERGE table.
• Fixed creation of MERGE tables on Windows.
• Portability fixes for OpenBSD and OS/2.
• Added --temp-pool option to mysqld. Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file. This is to work around a problem in the Linux kernel dealing with creating a bunch of new files with different names. With the old behaviour, Linux seems to "leak" memory, as it's being allocated to the directory entry cache instead of the disk cache.

D.4.29 Changes in release 3.23.32 (22 Jan 2001: Production)

• Changed code to get around compiler bug in Compaq C++ on OSF/1, that broke BACKUP, RESTORE, CHECK, REPAIR, and ANALYZE TABLE.
• Added option FULL to SHOW COLUMNS. Now we show the privilege list for the columns only if this option is given.
• Fixed bug in SHOW LOGS when there weren't any BDB logs.
• Fixed a timing problem in replication that could delay sending an update to the client until a new update was done.
• Don't convert field names when using mysql_list_fields(). This is to keep this code compatible with SHOW FIELDS.
• MERGE tables didn't work on Windows.
• Fixed problem with SET PASSWORD=... on Windows.
• Added missing `my_config.h' to RPM distribution.
• TRIM("foo" from "foo") didn't return an empty string.
• Added --with-version-suffix option to configure.
• Fixed core dump when client aborted connection without mysql_close().
• Fixed a bug in RESTORE TABLE when trying to restore from a non-existent directory.
• Fixed a bug which caused a core dump on the slave when replicating SET PASSWORD.
• Added MASTER_POS_WAIT().

D.4.30 Changes in release 3.23.31 (17 Jan 2001)

• The test suite now tests all reachable BDB interface code. During testing we found and fixed many errors in the interface code.
• Using HAVING on an empty table could produce one result row when it shouldn't.
• Fixed the MySQL RPM so it no longer depends on Perl5.
• Fixed some problems with HEAP tables on Windows.
• SHOW TABLE STATUS didn't show correct average row length for tables larger than 4G.
• CHECK TABLE ... EXTENDED didn't check row links for fixed size tables.
• Added option MEDIUM to CHECK TABLE.
• Fixed problem when using DECIMAL() keys on negative numbers.
• HOUR() (and some other TIME functions) on a CHAR column always returned NULL.
• Fixed security bug in something (please upgrade if you are using an earlier MySQL 3.23 version).
• Fixed buffer overflow bug when writing a certain error message.
• Added usage of setrlimit() on Linux to get -O --open-files-limit=# to work on Linux.
• Added bdb_version variable to mysqld.
• Fixed bug when using expression of type:

  SELECT ... FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=t2.a

  In this case the test in the WHERE clause was wrongly optimised away.

• Fixed bug in MyISAM when deleting keys with possible NULL values, but the first key-column was not a prefix-compressed text column.
• Fixed mysql.server to read the [mysql.server] option file group rather than the [mysql_server] group.
• Fixed safe_mysqld and mysql.server to also read the server option section.
• Added Threads_created status variable to mysqld.

D.4.31 Changes in release 3.23.30 (04 Jan 2001)

• Added SHOW OPEN TABLES command.
• Fixed that myisamdump works against old mysqld servers.
• Fixed myisamchk -k# so that it works again.
• Fixed a problem with replication when the binary log file went over 2G on 32-bit systems.
• LOCK TABLES will now automatically start a new transaction.
• Changed BDB tables to not use internal subtransactions and reuse open files to get more speed.
• Added --mysqld=# option to safe_mysqld.
• Allow hex constants in the --fields-*-by and --lines-terminated-by options to mysqldump and mysqlimport. By Paul DuBois.
• Added --safe-show-database option to mysqld.
• Added have_bdb, have_gemini, have_innobase, have_raid and have_openssl to SHOW VARIABLES to make it easy to test for supported extensions.
• Added --open-files-limit option to mysqld.
• Changed --open-files option to --open-files-limit in safe_mysqld.
• Fixed a bug where some rows were not found with HEAP tables that had many keys.
• Fixed that --bdb-no-sync works.
• Changed --bdb-recover to --bdb-no-recover as recover should be on by default.
• Changed the default number of BDB locks to 10000.
• Fixed a bug from 3.23.29 when allocating the shared structure needed for BDB tables.
• Changed mysqld_multi.sh to use configure variables. Patch by Christopher McCrory.
• Added fixing of include files for Solaris 2.8.
• Fixed bug with --skip-networking on Debian Linux.
• Fixed problem that some temporary files where reported as having the name UNOPENED in error messages.
• Fixed bug when running two simultaneous SHOW LOGS queries.

D.4.32 Changes in release 3.23.29 (16 Dec 2000)

• Configure updates for Tru64, large file support, and better TCP wrapper support. By Albert Chin-A-Young.
• Fixed bug in <=> operator.
• Fixed bug in REPLACE with BDB tables.
• LPAD() and RPAD() will shorten the result string if it's longer than the length argument.
• Added SHOW LOGS command.
• Remove unused BDB logs on shutdown.
• When creating a table, put PRIMARY keys first, followed by UNIQUE keys.
• Fixed a bug in UPDATE involving multi-part keys where one specified all key parts both in the update and the WHERE part. In this case MySQL could try to update a record that didn't match the whole WHERE part.
• Changed drop table to first drop the tables and then the `.frm' file.
• Fixed a bug in the hostname cache which caused mysqld to report the hostname as '' in some error messages.
• Fixed a bug with HEAP type tables; the variable max_heap_table_size wasn't used. Now either MAX_ROWS or max_heap_table_size can be used to limit the size of a HEAP type table.
• Changed the default server-id to 1 for masters and 2 for slaves to make it easier to use the binary log.
• Renamed bdb_lock_max variable to bdb_max_lock.
• Added support for AUTO_INCREMENT on sub-fields for BDB tables.
• Added ANALYZE of BDB tables.
• In BDB tables, we now store the number of rows; this helps to optimise queries when we need an approximation of the number of rows.
• If we get an error in a multi-row statement, we now only roll back the last statement, not the entire transaction.
• If you do a ROLLBACK when you have updated a non-transactional table you will get an error as a warning.
• Added --bdb-shared-data option to mysqld.
• Added Slave_open_temp_tables status variable to mysqld
• Added binlog_cache_size and max_binlog_cache_size variables to mysqld.
• DROP TABLE, RENAME TABLE, CREATE INDEX and DROP INDEX are now transaction endpoints.
• If you do a DROP DATABASE on a symbolically linked database, both the link and the original database is deleted.
• Fixed DROP DATABASE to work on OS/2.
• Fixed bug when doing a SELECT DISTINCT ... table1 LEFT JOIN table2 ... when table2 was empty.
• Added --abort-slave-event-count and --disconnect-slave-event-count options to mysqld for debugging and testing of replication.
• Fixed replication of temporary tables. Handles everything except slave server restart.
• SHOW KEYS now shows whether key is FULLTEXT.
• New script mysqld_multi. See section mysqld_multi.
• Added new script, mysql-multi.server.sh. Thanks to Tim Bunce Tim.Bunce@ig.co.uk for modifying mysql.server to easily handle hosts running many mysqld processes.
• safe_mysqld, mysql.server, and mysql_install_db have been modified to use mysql_print_defaults instead of various hacks to read the `my.cnf' files. In addition, the handling of various paths has been made more consistent with how mysqld handles them by default.
• Automatically remove Berkeley DB transaction logs that no longer are in use.
• Fixed bug with several FULLTEXT indexes in one table.
• Added a warning if number of rows changes on REPAIR/OPTIMIZE.
• Applied patches for OS/2 by Yuri Dario.
• FLUSH TABLES tbl_name didn't always flush the index tree to disk properly.
• --bootstrap is now run in a separate thread. This fixes a problem that caused mysql_install_db to core dump on some Linux machines.
• Changed mi_create() to use less stack space.
• Fixed bug with optimiser trying to over-optimise MATCH() when used with UNIQUE key.
• Changed crash-me and the MySQL benchmarks to also work with FrontBase.
• Allow RESTRICT and CASCADE after DROP TABLE to make porting easier.
• Reset status variable which could cause problem if one used --slow-log.
• Added connect_timeout variable to mysql and mysqladmin.
• Added connect-timeout as an alias for timeout for option files read by mysql_options().

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 section 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 uninitialised 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.

D.4.34 Changes in release 3.23.27 (24 Oct 2000)

• Fixed a bug where the automatic repair of MyISAM tables sometimes failed when the datafile was corrupt.
• Fixed a bug in SHOW CREATE when using AUTO_INCREMENT columns.
• Changed BDB tables to use new compare function in Berkeley DB 3.2.3.
• You can now use Unix sockets with MIT-pthreads.
• Added the latin5 (turkish) character set.
• Small portability fixes.

D.4.35 Changes in release 3.23.26 (18 Oct 2000)

• Renamed FLUSH MASTER and FLUSH SLAVE to RESET MASTER and RESET SLAVE.
• Fixed <> to work properly with NULL.
• Fixed a problem with SUBSTRING_INDEX() and REPLACE(). (Patch by Alexander Igonitchev)
• Fix CREATE TEMPORARY TABLE IF NOT EXISTS not to produce an error if the table exists.
• If you don't create a PRIMARY KEY in a BDB table, a hidden PRIMARY KEY will be created.
• Added read-only-key optimisation to BDB tables.
• LEFT JOIN in some cases preferred a full table scan when there was no WHERE clause.
• When using --log-slow-queries, don't count the time waiting for a lock.
• Fixed bug in lock code on Windows which could cause the key cache to report that the key file was crashed even if it was okay.
• Automatic repair of MyISAM tables if you start mysqld with --myisam-recover.
• Removed the TYPE= keyword from CHECK and REPAIR. Allow CHECK options to be combined. (You can still use TYPE=, but this usage is deprecated.)
• Fixed mutex bug in the binary replication log - long update queries could be read only in part by the slave if it did it at the wrong time, which was not fatal, but resulted in a performance-degrading reconnect and a scary message in the error log.
• Changed the format of the binary log - added magic number, server version, binlog version. Added server id and query error code for each query event.
• Replication thread from the slave now will kill all the stale threads from the same server.
• Long replication user names were not being handled properly.
• Added --replicate-rewrite-db option to mysqld.
• Added --skip-slave-start option to mysqld.
• Updates that generated an error code (such as INSERT INTO foo(some_key) values (1),(1)) erroneously terminated the slave thread.
• Added optimisation of queries where DISTINCT is only used on columns from some of the tables.
• Allow floating-point numbers where there is no sign after the exponent (like 1e1).
• SHOW GRANTS didn't always show all column grants.
• Added --default-extra-file=# option to all MySQL clients.
• Columns referenced in INSERT statements now are initialised properly.
• UPDATE didn't always work when used with a range on a timestamp that was part of the key that was used to find rows.
• Fixed a bug in FULLTEXT index when inserting a NULL column.
• Changed to use mkstemp() instead of tempnam(). Based on a patch from John Jones.

D.4.36 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 MERGE.
• 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.

D.4.37 Changes in release 3.23.24 (08 Sep 2000)

• Added created_tmp_disk_tables variable to mysqld.
• To make it possible to reliably dump and restore tables with TIMESTAMP(X) columns, MySQL now reports columns with X other than 14 or 8 to be strings.
• Changed sort order for latin1 as it was before MySQL Version 3.23.23. Any table that was created or modified with 3.23.22 must be repaired if it has CHAR columns that may contain characters with ASCII values greater than 128!
• Fixed small memory leak introduced from 3.23.22 when creating a temporary table.
• Fixed problem with BDB tables and reading on a unique (not primary) key.
• Restored the win1251 character set (it's now only marked deprecated).

D.4.38 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.

D.4.39 Changes in release 3.23.22 (31 Jul 2000)

• Fixed that lex_hash.h is created properly for each MySQL distribution.
• Fixed that MASTER and COLLECTION are not reserved words.
• The log generated by --slow-query-log didn't contain the whole queries.
• Fixed that open transactions in BDB tables are rolled back if the connection is closed unexpectedly.
• Added workaround for a bug in gcc 2.96 (intel) and gcc 2.9 (IA-64) in gen_lex_hash.c.
• Fixed memory leak in the client library when using host= in the `my.cnf' file.
• Optimised functions that manipulate the hours/minutes/seconds.
• Fixed bug when comparing the result of DATE_ADD()/DATE_SUB() against a number.
• Changed the meaning of -F, --fast for myisamchk. Added -C, --check-only-changed option to myisamchk.
• Added ANALYZE tbl_name to update key statistics for tables.
• Changed binary items 0x... to be regarded as integers by default.
• Fix for SCO and SHOW PROCESSLIST.
• Added auto-rehash on reconnect for the mysql client.
• Fixed a newly introduced bug in MyISAM, where the index file couldn't get bigger than 64M.
• Added SHOW MASTER STATUS and SHOW SLAVE STATUS.

D.4.40 Changes in release 3.23.21

• Added mysql_character_set_name() function to the MySQL C API.
• Made the update log ASCII 0 safe.
• Added the mysql_config script.
• Fixed problem when using < or > with a char column that was only partly indexed.
• One would get a core dump if the log file was not readable by the MySQL user.
• Changed mysqladmin to use CREATE DATABASE and DROP DATABASE statements instead of the old deprecated API calls.
• Fixed chown warning in safe_mysqld.
• Fixed a bug in ORDER BY that was introduced in 3.23.19.
• Only optimise the DELETE FROM tbl_name to do a drop+create of the table if we are in AUTOCOMMIT mode (needed for BDB tables).
• Added extra checks to avoid index corruption when the ISAM/MyISAM index files get full during an INSERT/UPDATE.
• myisamchk didn't correctly update row checksum when used with -ro (this only gave a warning in subsequent runs).
• Fixed bug in REPAIR TABLE so that it works with tables without indexes.
• Fixed buffer overrun in DROP DATABASE.
• LOAD TABLE FROM MASTER is sufficiently bug-free to announce it as a feature.
• MATCH and AGAINST are now reserved words.

D.4.41 Changes in release 3.23.20

• Fixed bug in 3.23.19; DELETE FROM tbl_name removed the `.frm' file.
• Added SHOW CREATE TABLE.

D.4.42 Changes in release 3.23.19

• Changed copyright for all files to GPL for the server code and utilities and to LGPL for the client libraries.
• Fixed bug where all rows matching weren't updated on a MyISAM table when doing update based on key on a table with many keys and some key changed values.
• The Linux MySQL RPMs and binaries are now statically linked with a linuxthread version that has faster mutex handling when used with MySQL.
• ORDER BY can now use REF keys to find subsets of the rows that need to be sorted.
• Changed name of print_defaults program to my_print_defaults to avoid name confusion.
• Fixed NULLIF() to work as required by SQL-99.
• Added net_read_timeout and net_write_timeout as startup parameters to mysqld.
• Fixed bug that destroyed index when doing myisamchk --sort-records on a table with prefix compressed index.
• Added pack_isam and myisampack to the standard MySQL distribution.
• Added the syntax BEGIN WORK (the same as BEGIN).
• Fixed core dump bug when using ORDER BY on a CONV() expression.
• Added LOAD TABLE FROM MASTER.
• Added FLUSH MASTER and FLUSH SLAVE.
• Fixed big/little endian problem in the replication.

D.4.43 Changes in release 3.23.18

• Fixed a problem from 3.23.17 when choosing character set on the client side.
• Added FLUSH TABLES WITH READ LOCK to make a global lock suitable for making a copy of MySQL datafiles.
• CREATE TABLE ... SELECT ... PROCEDURE now works.
• Internal temporary tables will now use compressed index when using GROUP BY on VARCHAR/CHAR columns.
• Fixed a problem when locking the same table with both a READ and a WRITE lock.
• Fixed problem with myisamchk and RAID tables.

D.4.44 Changes in release 3.23.17

• Fixed a bug in FIND_IN_SET() when the first argument was NULL.
• Added table locks to Berkeley DB.
• Fixed a bug with LEFT JOIN and ORDER BY where the first table had only one matching row.
• Added 4 sample `my.cnf' example files in the `support-files' directory.
• Fixed duplicated key problem when doing big GROUP BY operations. (This bug was probably introduced in 3.23.15.)
• Changed syntax for INNER JOIN to match SQL-99.
• Added NATURAL JOIN syntax.
• A lot of fixes in the BDB interface.
• Added handling of --no-defaults and --defaults-file to safe_mysqld.sh and mysql_install_db.sh.
• Fixed bug in reading compressed tables with many threads.
• Fixed that USE INDEX works with PRIMARY keys.
• Added BEGIN statement to start a transaction in AUTOCOMMIT mode.
• Added support for symbolic links for Windows.
• Changed protocol to let client know if the server is in AUTOCOMMIT mode and if there is a pending transaction. If there is a pending transaction, the client library will give an error before reconnecting to the server to let the client know that the server did a rollback. The protocol is still backward-compatible with old clients.
• KILL now works on a thread that is locked on a 'write' to a dead client.
• Fixed memory leak in the replication slave thread.
• Added new log-slave-updates option to mysqld, to allow daisy-chaining the slaves.
• Fixed compile error on FreeBSD and other systems where pthread_t is not the same as int.
• Fixed master shutdown aborting the slave thread.
• Fixed a race condition in INSERT DELAYED code when doing ALTER TABLE.
• Added deadlock detection sanity checks to INSERT DELAYED.

D.4.45 Changes in release 3.23.16

• Added SLAVE START and SLAVE STOP statements.
• Added TYPE=QUICK option to CHECK and to REPAIR.
• Fixed bug in REPAIR TABLE when the table was in use by other threads.
• Added a thread cache to make it possible to debug MySQL with gdb when one does a lot of reconnects. This will also improve systems where you can't use persistent connections.
• Lots of fixes in the Berkeley DB interface.
• UPDATE IGNORE will not abort if an update results in a DUPLICATE_KEY error.
• Put CREATE TEMPORARY TABLE commands in the update log.
• Fixed bug in handling of masked IP numbers in the privilege tables.
• Fixed bug with delay_key_write tables and CHECK TABLE.
• Added replicate-do-db and replicate-ignore-db options to mysqld, to restrict which databases get replicated.
• Added SQL_LOG_BIN option.

D.4.46 Changes in release 3.23.15 (May 2000: Beta)

• To start mysqld as root, you must now use the --user=root option.
• Added interface to Berkeley DB. (This is not yet functional; play with it at your own risk!)
• Replication between master and slaves.
• Fixed bug that other threads could steal a lock when a thread had a lock on a table and did a FLUSH TABLES command.
• Added the slow_launch_time variable and the Slow_launch_threads status variable to mysqld. These can be examined with mysqladmin variables and mysqladmin extended-status.
• Added functions INET_NTOA() and INET_ATON().
• The default type of IF() now depends on the second and third arguments and not only on the second argument.
• Fixed case when myisamchk could go into a loop when trying to repair a crashed table.
• Don't write INSERT DELAYED to update log if SQL_LOG_UPDATE=0.
• Fixed problem with REPLACE on HEAP tables.
• Added possible character sets and time zone to SHOW VARIABLES output.
• Fixed bug in locking code that could result in locking problems with concurrent inserts under high load.
• Fixed a problem with DELETE of many rows on a table with compressed keys where MySQL scanned the index to find the rows.
• Fixed problem with CHECK on table with deleted keyblocks.
• Fixed a bug in reconnect (at the client side) where it didn't free memory properly in some contexts.
• Fixed problems in update log when using LAST_INSERT_ID() to update a table with an AUTO_INCREMENT key.
• Added NULLIF() function.
• Fixed bug when using LOAD DATA INFILE on a table with BLOB/TEXT columns.
• Optimised MyISAM to be faster when inserting keys in sorted order.
• EXPLAIN SELECT ... now also prints out whether MySQL needs to create a temporary table or use file sorting when resolving the SELECT.
• Added optimisation to skip ORDER BY parts where the part is a constant expression in the WHERE part. Indexes can now be used even if the ORDER BY doesn't match the index exactly, as long as all the unused index parts and all the extra ORDER BY columns are constants in the WHERE clause. See section How MySQL Uses Indexes.
• UPDATE and DELETE on a whole unique key in the WHERE part are now faster than before.
• Changed RAID_CHUNKSIZE to be in 1024-byte increments.
• Fixed core dump in LOAD_FILE(NULL).

D.4.47 Changes in release 3.23.14

• Added mysql_real_escape_string() function to the MySQL C API.
• Fixed a bug in CONCAT() where one of the arguments was a function that returned a modified argument.
• Fixed a critical bug in myisamchk, where it updated the header in the index file when one only checked the table. This confused the mysqld daemon if it updated the same table at the same time. Now the status in the index file is only updated if one uses --update-state. With older myisamchk versions you should use --read-only when only checking tables, if there is the slightest chance that the mysqld server is working on the table at the same time!
• Fixed that DROP TABLE is logged in the update log.
• Fixed problem when searching on DECIMAL() key field where the column data contained leading zeros.
• Fix bug in myisamchk when the AUTO_INCREMENT column isn't the first key.
• Allow DATETIME in ISO8601 format: 2000-03-12T12:00:00
• Dynamic character sets. A mysqld binary can now handle many different character sets (you can choose which when starting mysqld).
• Added command REPAIR TABLE.
• Added mysql_thread_safe() function to the MySQL C API.
• Added the UMASK_DIR environment variable.
• Added CONNECTION_ID() function to return the client connection thread ID.
• When using = on BLOB or VARCHAR BINARY keys, where only a part of the column was indexed, the whole column of the result row wasn't compared.
• Fix for sjis character set and ORDER BY.
• When running in ANSI mode, don't allow columns to be used that aren't in the GROUP BY part.

D.4.48 Changes in release 3.23.13

• Fixed problem when doing locks on the same table more than 2 times in the same LOCK TABLE command; this fixed the problem one got when running the test-ATIS test with --fast or --check-only-changed.
• Added SQL_BUFFER_RESULT option to SELECT.
• Removed end space from double/float numbers in results from temporary tables.
• Added CHECK TABLE command.
• Added changes for MyISAM in 3.23.12 that didn't get into the source distribution because of CVS problems.
• Fixed bug so that mysqladmin shutdown will wait for the local server to close down.
• Fixed a possible endless loop when calculating timestamp.
• Added print_defaults program to the `.rpm' files. Removed mysqlbug from the client `.rpm' file.

D.4.49 Changes in release 3.23.12 (07 Mar 2000)

• Fixed bug in MyISAM involving REPLACE ... SELECT ... which could give a corrupted table.
• Fixed bug in myisamchk where it incorrectly reset the AUTO_INCREMENT value.
• LOTS of patches for Linux Alpha. MySQL now appears to be relatively stable on Alpha.
• Changed DISTINCT on HEAP temporary tables to use hashed keys to quickly find duplicated rows. This mostly concerns queries of type SELECT DISTINCT ... GROUP BY .... This fixes a problem where not all duplicates were removed in queries of the above type. In addition, the new code is MUCH faster.
• Added patches to make MySQL compile on Mac OS X.
• Added IF NOT EXISTS clause to CREATE DATABASE.
• Added --all-databases and --databases options to mysqldump to allow dumping of many databases at the same time.
• Fixed bug in compressed DECIMAL() index in MyISAM tables.
• Fixed bug when storing 0 into a timestamp.
• When doing mysqladmin shutdown on a local connection, mysqladmin now waits until the PID file is gone before terminating.
• Fixed core dump with some COUNT(DISTINCT ...) queries.
• Fixed that myisamchk works properly with RAID tables.
• Fixed problem with LEFT JOIN and key_field IS NULL.
• Fixed bug in net_clear() which could give the error Aborted connection in the MySQL clients.
• Added options USE INDEX (key_list) and IGNORE INDEX (key_list) as parameters in SELECT.
• DELETE and RENAME should now work on RAID tables.

D.4.50 Changes in release 3.23.11

• Allow the ALTER TABLE tbl_name ADD (field_list) syntax.
• Fixed problem with optimiser that could sometimes use incorrect keys.
• Fixed that GRANT/REVOKE ALL PRIVILEGES doesn't affect GRANT OPTION.
• Removed extra `)' from the output of SHOW GRANTS.
• Fixed problem when storing numbers in timestamps.
• Fix problem with timezones that have half hour offsets.
• Allow the syntax UNIQUE INDEX in CREATE statements.
• mysqlhotcopy - fast online hot-backup utility for local MySQL databases. By Tim Bunce.
• New more secure mysqlaccess. Thanks to Steve Harvey for this.
• Added --i-am-a-dummy and --safe-updates options to mysql.
• Added select_limit and max_join_size variables to mysql.
• Added SQL_MAX_JOIN_SIZE and SQL_SAFE_UPDATES options.
• Added READ LOCAL lock that doesn't lock the table for concurrent inserts. (This is used by mysqldump.)
• Changed that LOCK TABLES ... READ doesn't anymore allow concurrent inserts.
• Added --skip-delay-key-write option to mysqld.
• Fixed security problem in the protocol regarding password checking.
• _rowid can now be used as an alias for an integer type unique indexed column.
• Added back blocking of SIGPIPE when compiling with --thread-safe-clients to make things safe for old clients.

D.4.51 Changes in release 3.23.10

• Fixed bug in 3.23.9 where memory wasn't properly freed when using LOCK TABLES.

D.4.52 Changes in release 3.23.9

• Fixed problem that affected queries that did arithmetic on group functions.
• Fixed problem with timestamps and INSERT DELAYED.
• Fixed that date_col BETWEEN const_date AND const_date works.
• Fixed problem when only changing a 0 to NULL in a table with BLOB/TEXT columns.
• Fixed bug in range optimiser when using many key parts and or on the middle key parts: WHERE K1=1 and K3=2 and (K2=2 and K4=4 or K2=3 and K4=5)
• Added source command to mysql to allow reading of batch files inside the mysql client. Original patch by Matthew Vanecek.
• Fixed critical problem with the WITH GRANT OPTION option.
• Don't give an unnecessary GRANT error when using tables from many databases in the same query.
• Added VIO wrapper (needed for SSL support; by Andrei Errapart and Tõnu Samuel).
• Fixed optimiser problem on SELECT when using many overlapping indexes. MySQL should now be able to choose keys even better when there are many keys to choose from.
• Changed optimiser to prefer a range key instead of a ref key when the range key can uses more columns than the ref key (which only can use columns with =). For example, the following type of queries should now be faster: SELECT * from key_part_1=const and key_part_2 > const2
• Fixed bug that a change of all VARCHAR columns to CHAR columns didn't change row type from dynamic to fixed.
• Disabled floating-point exceptions for FreeBSD to fix core dump when doing SELECT FLOOR(POW(2,63)).
• Renamed mysqld startup option from --delay-key-write to --delay-key-write-for-all-tables.
• Added read-next-on-key to HEAP tables. This should fix all problems with HEAP tables when using non-UNIQUE keys.
• Added option to print default arguments to all clients.
• Added --log-slow-queries option to mysqld to log all queries that take a long time to a separate log file with a time indicating how long the query took.
• Fixed core dump when doing WHERE key_col=RAND(...).
• Fixed optimisation bug in SELECT ... LEFT JOIN ... key_col IS NULL, when key_col could contain NULL values.
• Fixed problem with 8-bit characters as separators in LOAD DATA INFILE.

D.4.53 Changes in release 3.23.8 (02 Jan 2000)

• Fixed problem when handling indexfiles larger than 8G.
• Added latest patches to MIT-pthreads for NetBSD.
• Fixed problem with timezones that are < GMT - 11.
• Fixed a bug when deleting packed keys in NISAM.
• Fixed problem with ISAM when doing some ORDER BY ... DESC queries.
• Fixed bug when doing a join on a text key which didn't cover the whole key.
• Option --delay-key-write didn't enable delayed key writing.
• Fixed update of TEXT column which involved only case changes.
• Fixed that INSERT DELAYED doesn't update timestamps that are given.
• Added function YEARWEEK() and options x, X, v and V to DATE_FORMAT().
• Fixed problem with MAX(indexed_column) and HEAP tables.
• Fixed problem with BLOB NULL keys and LIKE "prefix%".
• Fixed problem with MyISAM and fixed-length rows < 5 bytes.
• Fixed problem that could cause MySQL to touch freed memory when doing very complicated GROUP BY queries.
• Fixed core dump if you got a crashed table where an ENUM field value was too big.

D.4.54 Changes in release 3.23.7 (10 Dec 1999)

• Fixed workaround under Linux to avoid problems with pthread_mutex_timedwait, which is used with INSERT DELAYED. See section Linux Notes (All Linux Versions).
• Fixed that one will get a 'disk full' error message if one gets disk full when doing sorting (instead of waiting until we got more disk space).
• Fixed a bug in MyISAM with keys > 250 characters.
• In MyISAM one can now do an INSERT at the same time as other threads are reading from the table.
• Added max_write_lock_count variable to mysqld to force a READ lock after a certain number of WRITE locks.
• Inverted flag delay_key_write on show variables.
• Renamed concurrency variable to thread_concurrency.
• The following functions are now multi-byte-safe: LOCATE(substr,str), POSITION(substr IN str), LOCATE(substr,str,pos), INSTR(str,substr), LEFT(str,len), RIGHT(str,len), SUBSTRING(str,pos,len), SUBSTRING(str FROM pos FOR len), MID(str,pos,len), SUBSTRING(str,pos), SUBSTRING(str FROM pos), SUBSTRING_INDEX(str,delim,count), RTRIM(str), TRIM([[BOTH | TRAILING] [remstr] FROM] str), REPLACE(str,from_str,to_str), REVERSE(str), INSERT(str,pos,len,newstr), LCASE(str), LOWER(str), UCASE(str) and UPPER(str); patch by Wei He.
• Fix core dump when releasing a lock from a non-existent table.
• Remove locks on tables before starting to remove duplicates.
• Added option FULL to SHOW PROCESSLIST.
• Added option --verbose to mysqladmin.
• Fixed problem when automatically converting HEAP to MyISAM.
• Fixed bug in HEAP tables when doing insert + delete + insert + scan the table.
• Fixed bugs on Alpha with REPLACE() and LOAD DATA INFILE.
• Added interactive_timeout variable to mysqld.
• Changed the argument to mysql_data_seek() from ulong to ulonglong.

D.4.55 Changes in release 3.23.6

• Added -O lower_case_table_names={0|1} option to mysqld to allow users to force table names to lowercase.
• Added SELECT ... INTO DUMPFILE.
• Added --ansi option to mysqld to make some functions SQL-99 compatible.
• Temporary table names now start with #sql.
• Added quoting of identifiers with ` (" in --ansi mode).
• Changed to use snprintf() when printing floats to avoid some buffer overflows on FreeBSD.
• Made FLOOR() overflow safe on FreeBSD.
• Added --quote-names option to mysqldump.
• Fixed bug that one could make a part of a PRIMARY KEY NOT NULL.
• Fixed encrypt() to be thread-safe and not reuse buffer.
• Added mysql_odbc_escape_string() function to support big5 characters in MyODBC.
• Rewrote the storage engine to use classes. This introduces a lot of new code, but will make table handling faster and better.
• Added patch by Sasha for user-defined variables.
• Changed that FLOAT and DOUBLE (without any length modifiers) no longer are fixed decimal point numbers.
• Changed the meaning of FLOAT(X): Now this is the same as FLOAT if X <= 24 and a DOUBLE if 24 < X <= 53.
• DECIMAL(X) is now an alias for DECIMAL(X,0) and DECIMAL is now an alias for DECIMAL(10,0). The same goes for NUMERIC.
• Added option ROW_FORMAT={default | dynamic | fixed | compressed} to CREATE_TABLE.
• DELETE FROM table_name didn't work on temporary tables.
• Changed function CHAR_LENGTH() to be multi-byte character safe.
• Added function ORD(string).

D.4.56 Changes in release 3.23.5 (20 Oct 1999)

• Fixed some Y2K problems in the new date handling in 3.23.
• Fixed problem with SELECT DISTINCT ... ORDER BY RAND().
• Added patches by Sergei A. Golubchik for text searching on the MyISAM level.
• Fixed cache overflow problem when using full joins without keys.
• Fixed some configure issues.
• Some small changes to make parsing faster.
• Adding a column after the last field with ALTER TABLE didn't work.
• Fixed problem when using an AUTO_INCREMENT column in two keys
• With MyISAM, you now can have an AUTO_INCREMENT column as a key sub part: CREATE TABLE foo (a INT NOT NULL AUTO_INCREMENT, b CHAR(5), PRIMARY KEY (b,a))
• Fixed bug in MyISAM with packed char keys that could be NULL.
• AS on field name with CREATE TABLE table_name SELECT ... didn't work.
• Allow use of NATIONAL and NCHAR when defining character columns. This is the same as not using BINARY.
• Don't allow NULL columns in a PRIMARY KEY (only in UNIQUE keys).
• Clear LAST_INSERT_ID() if one uses this in ODBC: WHERE auto_increment_column IS NULL. This seems to fix some problems with Access.
• SET SQL_AUTO_IS_NULL=0|1 now turns on/off the handling of searching after the last inserted row with WHERE auto_increment_column IS NULL.
• Added new variable concurrency to mysqld for Solaris.
• Added --relative option to mysqladmin to make extended-status more useful to monitor changes.
• Fixed bug when using COUNT(DISTINCT ...) on an empty table.
• Added support for the Chinese character set GBK.
• Fixed problem with LOAD DATA INFILE and BLOB columns.
• Added bit operator ~ (negation).
• Fixed problem with UDF functions.

D.4.57 Changes in release 3.23.4 (28 Sep 1999)

• Inserting a DATETIME into a TIME column no longer will try to store 'days' in it.
• Fixed problem with storage of float/double on little endian machines. (This affected SUM().)
• Added connect timeout on TCP/IP connections.
• Fixed problem with LIKE "%" on an index that may have NULL values.
• REVOKE ALL PRIVILEGES didn't revoke all privileges.
• Allow creation of temporary tables with same name as the original table.
• When granting a user a GRANT option for a database, he couldn't grant privileges to other users.
• New command: SHOW GRANTS FOR user (by Sinisa).
• New date_add syntax: date/datetime + INTERVAL # interval_type. By Joshua Chamas.
• Fixed privilege check for LOAD DATA REPLACE.
• Automatic fixing of broken include files on Solaris 2.7
• Some configure issues to fix problems with big filesystem detection.
• REGEXP is now case-insensitive if you use non-binary strings.

D.4.58 Changes in release 3.23.3

• Added patches for MIT-pthreads on NetBSD.
• Fixed range bug in MyISAM.
• ASC is now the default again for ORDER BY.
• Added LIMIT to UPDATE.
• Added mysql_change_user() function to the MySQL C API.
• Added character set to SHOW VARIABLES.
• Added support of --[whitespace] comments.
• Allow INSERT into tbl_name VALUES (), that is, you may now specify an empty value list to insert a row in which each column is set to its default value.
• Changed SUBSTRING(text FROM pos) to conform to SQL-99. (Before this construct returned the rightmost pos characters.)
• SUM() with GROUP BY returned 0 on some systems.
• Changed output for SHOW TABLE STATUS.
• Added DELAY_KEY_WRITE option to CREATE TABLE.
• Allow AUTO_INCREMENT on any key part.
• Fixed problem with YEAR(NOW()) and YEAR(CURDATE()).
• Added CASE construct.
• New function COALESCE().

D.4.59 Changes in release 3.23.2 (09 Aug 1999)

• Fixed range optimiser bug: SELECT * FROM table_name WHERE key_part1 >= const AND (key_part2 = const OR key_part2 = const). The bug was that some rows could be duplicated in the result.
• Running myisamchk without -a updated the index distribution incorrectly.
• SET SQL_LOW_PRIORITY_UPDATES=1 was causing a parse error.
• You can now update index columns that are used in the WHERE clause. UPDATE tbl_name SET KEY=KEY+1 WHERE KEY > 100
• Date handling should now be a bit faster.
• Added handling of fuzzy dates (dates where day or month is 0), such as '1999-01-00'.
• Fixed optimisation of SELECT ... WHERE key_part1=const1 AND key_part_2=const2 AND key_part1=const4 AND key_part2=const4; indextype should be range instead of ref.
• Fixed egcs 1.1.2 optimiser bug (when using BLOB values) on Linux Alpha.
• Fixed problem with LOCK TABLES combined with DELETE FROM table.
• MyISAM tables now allow keys on NULL and BLOB/TEXT columns.
• The following join is now much faster: SELECT ... FROM t1 LEFT JOIN t2 ON ... WHERE t2.not_null_column IS NULL.
• ORDER BY and GROUP BY can be done on functions.
• Changed handling of 'const_item' to allow handling of ORDER BY RAND().
• Indexes are now used for WHERE key_column = function.
• Indexes are now used for WHERE key_column = col_name even if the columns are not identically packed.
• Indexes are now used for WHERE col_name IS NULL.
• Changed heap tables to be stored in low_byte_first order (to make it easy to convert to MyISAM tables)
• Automatic change of HEAP temporary tables to MyISAM tables in case of "table is full" errors.
• Added --init-file=file_name option to mysqld.
• Added COUNT(DISTINCT value, [value, ...]).
• CREATE TEMPORARY TABLE now creates a temporary table, in its own namespace, that is automatically deleted if connection is dropped.
• New reserved words (required for CASE): CASE, THEN, WHEN, ELSE and END.
• New functions EXPORT_SET() and MD5().
• Support for the GB2312 Chinese character set.

D.4.60 Changes in release 3.23.1

• Fixed some compilation problems.

D.4.61 Changes in release 3.23.0 (05 Aug 1999: Alpha)

• A new storage engine library (MyISAM) with a lot of new features. See section MyISAM.
• You can create in-memory HEAP tables which are extremely fast for lookups.
• Support for big files (63-bit) on OSs that support big files.
• New function LOAD_FILE(filename) to get the contents of a file as a string value.
• New operator <=> which will act as = but will return TRUE if both arguments are NULL. This is useful for comparing changes between tables.
• Added the ODBC 3.0 EXTRACT(interval FROM datetime) function.
• Columns defined as FLOAT(X) are not rounded on storage and may be in scientific notation (1.0 E+10) when retrieved.
• REPLACE is now faster than before.
• Changed LIKE character comparison to behave as =; This means that 'e' LIKE 'é' is now true. (If the line doesn't display correctly, the latter 'e' is a French 'e' with a dot above.)
• SHOW TABLE STATUS returns a lot of information about the tables.
• Added LIKE to the SHOW STATUS command.
• Added Privileges column to SHOW COLUMNS.
• Added Packed and Comment columns to SHOW INDEX.
• Added comments to tables (with CREATE TABLE ... COMMENT "xxx").
• Added UNIQUE, as in CREATE TABLE table_name (col INT not null UNIQUE)
• New create syntax: CREATE TABLE table_name SELECT ...
• New create syntax: CREATE TABLE IF NOT EXISTS ...
• Allow creation of CHAR(0) columns.
• DATE_FORMAT() now requires `%' before any format character.
• DELAYED is now a reserved word (sorry about that :( ).
• An example procedure is added: analyse, file: `sql_analyse.c'. This will describe the data in your query. Try the following:

  SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([max elements,[max memory]])

  This procedure is extremely useful when you want to check the data in your table!

• BINARY cast to force a string to be compared in case-sensitive fashion.
• Added --skip-show-database option to mysqld.
• Check whether a row has changed in an UPDATE now also works with BLOB/TEXT columns.
• Added the INNER join syntax. NOTE: This made INNER a reserved word!
• Added support for netmasks to the hostname in the MySQL grant tables. You can specify a netmask using the IP/NETMASK syntax.
• If you compare a NOT NULL DATE/DATETIME column with IS NULL, this is changed to a compare against 0 to satisfy some ODBC applications. (By shreeve@uci.edu.)
• NULL IN (...) now returns NULL instead of 0. This will ensure that null_column NOT IN (...) doesn't match NULL values.
• Fix storage of floating-point values in TIME columns.
• Changed parsing of TIME strings to be more strict. Now the fractional second part is detected (and currently skipped). The following formats are supported:
  • [[DAYS] [H]H:]MM:]SS[.fraction]
  • [[[[[H]H]H]H]MM]SS[.fraction]
• Detect (and ignore) fractional second part from DATETIME.
• Added the LOW_PRIORITY attribute to LOAD DATA INFILE.
• The default index name now uses the same case as the column name on which the index name is based.
• Changed default number of connections to 100.
• Use bigger buffers when using LOAD DATA INFILE.
• DECIMAL(x,y) now works according to SQL-99.
• Added aggregate UDF functions. Thanks to Andreas F. Bobak (bobak@relog.ch) for this!
• LAST_INSERT_ID() is now updated for INSERT INTO ... SELECT.
• Some small changes to the join table optimiser to make some joins faster.
• SELECT DISTINCT is much faster; it uses the new UNIQUE functionality in MyISAM. One difference compared to MySQL Version 3.22 is that the output of DISTINCT is no longer sorted.
• All C client API macros are now functions to make shared libraries more reliable. Because of this, you can no longer call mysql_num_fields() on a MYSQL object, you must use mysql_field_count() instead.
• Added use of LIBWRAP; patch by Henning P. Schmiedehausen.
• Don't allow AUTO_INCREMENT for other than numerical columns.
• Using AUTO_INCREMENT will now automatically make the column NOT NULL.
• Show NULL as the default value for AUTO_INCREMENT columns.
• Added SQL_BIG_RESULT; SQL_SMALL_RESULT is now default.
• Added a shared library RPM. This enhancement was contributed by David Fox (dsfox@cogsci.ucsd.edu).
• Added --enable-large-files and --disable-large-files switches to configure. See `configure.in' for some systems where this is automatically turned off because of broken implementations.
• Upgraded readline to 4.0.
• New CREATE TABLE options: PACK_KEYS and CHECKSUM.
• Added --default-table-type option to mysqld.

Hosting by: Hurra Communications Ltd.
Generated: 2007-01-26 17:58:44