Appendix C. MySQL Change History

Table of Contents

Changes in release 5.0.x (Development)
Changes in release 5.0.2 (not released yet)
Changes in release 5.0.1 (27 Jul 2004)
Changes in release 5.0.0 (22 Dec 2003: Alpha)
Changes in release 4.1.x (Gamma)
Changes in release 4.1.8 (not released yet)
Changes in release 4.1.7 (to be released soon)
Changes in release 4.1.6 (10 Oct 2004)
Changes in release 4.1.5 (16 Sep 2004)
Changes in release 4.1.4 (26 Aug 2004: Gamma)
Changes in release 4.1.3 (28 Jun 2004: Beta)
Changes in release 4.1.2 (28 May 2004)
Changes in release 4.1.1 (01 Dec 2003)
Changes in release 4.1.0 (03 Apr 2003: Alpha)
Changes in release 4.0.x (Production)
Changes in release 4.0.22 (not released yet)
Changes in release 4.0.21 (06 Sep 2004)
Changes in release 4.0.20 (17 May 2004)
Changes in release 4.0.19 (04 May 2004)
Changes in release 4.0.18 (12 Feb 2004)
Changes in release 4.0.17 (14 Dec 2003)
Changes in release 4.0.16 (17 Oct 2003)
Changes in release 4.0.15 (03 Sep 2003)
Changes in release 4.0.14 (18 Jul 2003)
Changes in release 4.0.13 (16 May 2003)
Changes in release 4.0.12 (15 Mar 2003: Production)
Changes in release 4.0.11 (20 Feb 2003)
Changes in release 4.0.10 (29 Jan 2003)
Changes in release 4.0.9 (09 Jan 2003)
Changes in release 4.0.8 (07 Jan 2003)
Changes in release 4.0.7 (20 Dec 2002)
Changes in release 4.0.6 (14 Dec 2002: Gamma)
Changes in release 4.0.5 (13 Nov 2002)
Changes in release 4.0.4 (29 Sep 2002)
Changes in release 4.0.3 (26 Aug 2002: Beta)
Changes in release 4.0.2 (01 Jul 2002)
Changes in release 4.0.1 (23 Dec 2001)
Changes in release 4.0.0 (Oct 2001: Alpha)
Changes in release 3.23.x (Recent; still supported)
Changes in release 3.23.59 (not released yet)
Changes in release 3.23.58 (11 Sep 2003)
Changes in release 3.23.57 (06 Jun 2003)
Changes in release 3.23.56 (13 Mar 2003)
Changes in release 3.23.55 (23 Jan 2003)
Changes in release 3.23.54 (05 Dec 2002)
Changes in release 3.23.53 (09 Oct 2002)
Changes in release 3.23.52 (14 Aug 2002)
Changes in release 3.23.51 (31 May 2002)
Changes in release 3.23.50 (21 Apr 2002)
Changes in release 3.23.49 (14 Feb 2002)
Changes in release 3.23.48 (07 Feb 2002)
Changes in release 3.23.47 (27 Dec 2001)
Changes in release 3.23.46 (29 Nov 2001)
Changes in release 3.23.45 (22 Nov 2001)
Changes in release 3.23.44 (31 Oct 2001)
Changes in release 3.23.43 (04 Oct 2001)
Changes in release 3.23.42 (08 Sep 2001)
Changes in release 3.23.41 (11 Aug 2001)
Changes in release 3.23.40 (18 Jul 2001)
Changes in release 3.23.39 (12 Jun 2001)
Changes in release 3.23.38 (09 May 2001)
Changes in release 3.23.37 (17 Apr 2001)
Changes in release 3.23.36 (27 Mar 2001)
Changes in release 3.23.35 (15 Mar 2001)
Changes in release 3.23.34a (11 Mar 2001)
Changes in release 3.23.34 (10 Mar 2001)
Changes in release 3.23.33 (09 Feb 2001)
Changes in release 3.23.32 (22 Jan 2001)
Changes in release 3.23.31 (17 Jan 2001: Production)
Changes in release 3.23.30 (04 Jan 2001)
Changes in release 3.23.29 (16 Dec 2000)
Changes in release 3.23.28 (22 Nov 2000: Gamma)
Changes in release 3.23.27 (24 Oct 2000)
Changes in release 3.23.26 (18 Oct 2000)
Changes in release 3.23.25 (29 Sep 2000)
Changes in release 3.23.24 (08 Sep 2000)
Changes in release 3.23.23 (01 Sep 2000)
Changes in release 3.23.22 (31 Jul 2000)
Changes in release 3.23.21 (04 Jul 2000)
Changes in release 3.23.20 (28 Jun 2000: Beta)
Changes in release 3.23.19
Changes in release 3.23.18 (11 Jun 2000)
Changes in release 3.23.17 (07 Jun 2000)
Changes in release 3.23.16 (16 May 2000)
Changes in release 3.23.15 (08 May 2000)
Changes in release 3.23.14 (09 Apr 2000)
Changes in release 3.23.13 (14 Mar 2000)
Changes in release 3.23.12 (07 Mar 2000)
Changes in release 3.23.11 (16 Feb 2000)
Changes in release 3.23.10 (30 Jan 2000)
Changes in release 3.23.9 (29 Jan 2000)
Changes in release 3.23.8 (02 Jan 2000)
Changes in release 3.23.7 (10 Dec 1999)
Changes in release 3.23.6 (15 Nov 1999)
Changes in release 3.23.5 (20 Oct 1999)
Changes in release 3.23.4 (28 Sep 1999)
Changes in release 3.23.3 (13 Sep 1999)
Changes in release 3.23.2 (09 Aug 1999)
Changes in release 3.23.1 (08 Jul 1999)
Changes in release 3.23.0 (05 Jul 1999: Alpha)
Changes in release 3.22.x (Old; discontinued)
Changes in release 3.22.35
Changes in release 3.22.34
Changes in release 3.22.33
Changes in release 3.22.32 (14 Feb 2000)
Changes in release 3.22.31
Changes in release 3.22.30 (11 Jan 2000)
Changes in release 3.22.29 (02 Jan 2000)
Changes in release 3.22.28 (20 Oct 1999)
Changes in release 3.22.27 (05 Oct 1999)
Changes in release 3.22.26 (16 Sep 1999)
Changes in release 3.22.25 (07 Jun 1999)
Changes in release 3.22.24 (05 Jul 1999)
Changes in release 3.22.23 (08 Jun 1999)
Changes in release 3.22.22 (30 Apr 1999)
Changes in release 3.22.21 (04 Apr 1999)
Changes in release 3.22.20 (18 Mar 1999)
Changes in release 3.22.19 (01 Mar 1999)
Changes in release 3.22.18 (26 Feb 1999)
Changes in release 3.22.17 (22 Feb 1999: Production)
Changes in release 3.22.16 (05 Feb 1999)
Changes in release 3.22.15 (27 Jan 1999)
Changes in release 3.22.14 (01 Jan 1999: Gamma)
Changes in release 3.22.13 (16 Dec 1998)
Changes in release 3.22.12 (09 Dec 1998)
Changes in release 3.22.11 (24 Nov 1998)
Changes in release 3.22.10 (04 Nov 1998)
Changes in release 3.22.9 (19 Oct 1998)
Changes in release 3.22.8 (06 Oct 1998)
Changes in release 3.22.7 (21 Sep 1998: Beta)
Changes in release 3.22.6 (31 Aug 1998)
Changes in release 3.22.5 (20 Aug 1998: Alpha)
Changes in release 3.22.4 (06 Jul 1998: Beta)
Changes in release 3.22.3 (30 Jun 1998)
Changes in release 3.22.2
Changes in release 3.22.1 (Jun 1998)
Changes in release 3.22.0 (18 May 1998: Alpha)
Changes in release 3.21.x
Changes in release 3.21.33 (08 Jul 1998)
Changes in release 3.21.32 (30 Jun 1998)
Changes in release 3.21.31 (10 Jun 1998)
Changes in release 3.21.30
Changes in release 3.21.29
Changes in release 3.21.28
Changes in release 3.21.27
Changes in release 3.21.26
Changes in release 3.21.25
Changes in release 3.21.24
Changes in release 3.21.23
Changes in release 3.21.22
Changes in release 3.21.21a
Changes in release 3.21.21
Changes in release 3.21.20
Changes in release 3.21.19
Changes in release 3.21.18
Changes in release 3.21.17
Changes in release 3.21.16
Changes in release 3.21.15
Changes in release 3.21.14b
Changes in release 3.21.14a
Changes in release 3.21.13
Changes in release 3.21.12
Changes in release 3.21.11
Changes in release 3.21.10
Changes in release 3.21.9
Changes in release 3.21.8
Changes in release 3.21.7
Changes in release 3.21.6
Changes in release 3.21.5
Changes in release 3.21.4
Changes in release 3.21.3
Changes in release 3.21.2
Changes in release 3.21.0
Changes in release 3.20.x
Changes in release 3.20.18
Changes in release 3.20.17
Changes in release 3.20.16
Changes in release 3.20.15
Changes in release 3.20.14
Changes in release 3.20.13
Changes in release 3.20.11
Changes in release 3.20.10
Changes in release 3.20.9
Changes in release 3.20.8
Changes in release 3.20.7
Changes in release 3.20.6
Changes in release 3.20.3
Changes in release 3.20.0
Changes in release 3.19.x
Changes in release 3.19.5
Changes in release 3.19.4
Changes in release 3.19.3
InnoDB Change History
MySQL/InnoDB-4.0.21, September 10, 2004
MySQL/InnoDB-4.1.4, August 31, 2004
MySQL/InnoDB-4.1.3, June 28, 2004
MySQL/InnoDB-4.1.2, May 30, 2004
MySQL/InnoDB-4.0.20, May 18, 2004
MySQL/InnoDB-4.0.19, May 4, 2004
MySQL/InnoDB-4.0.18, February 13, 2004
MySQL/InnoDB-5.0.0, December 24, 2003
MySQL/InnoDB-4.0.17, December 17, 2003
MySQL/InnoDB-4.1.1, December 4, 2003
MySQL/InnoDB-4.0.16, October 22, 2003
MySQL/InnoDB-3.23.58, September 15, 2003
MySQL/InnoDB-4.0.15, September 10, 2003
MySQL/InnoDB-4.0.14, July 22, 2003
MySQL/InnoDB-3.23.57, June 20, 2003
MySQL/InnoDB-4.0.13, May 20, 2003
MySQL/InnoDB-4.1.0, April 3, 2003
MySQL/InnoDB-3.23.56, March 17, 2003
MySQL/InnoDB-4.0.12, March 18, 2003
MySQL/InnoDB-4.0.11, February 25, 2003
MySQL/InnoDB-4.0.10, February 4, 2003
MySQL/InnoDB-3.23.55, January 24, 2003
MySQL/InnoDB-4.0.9, January 14, 2003
MySQL/InnoDB-4.0.8, January 7, 2003
MySQL/InnoDB-4.0.7, December 26, 2002
MySQL/InnoDB-4.0.6, December 19, 2002
MySQL/InnoDB-3.23.54, December 12, 2002
MySQL/InnoDB-4.0.5, November 18, 2002
MySQL/InnoDB-3.23.53, October 9, 2002
MySQL/InnoDB-4.0.4, October 2, 2002
MySQL/InnoDB-4.0.3, August 28, 2002
MySQL/InnoDB-3.23.52, August 16, 2002
MySQL/InnoDB-4.0.2, July 10, 2002
MySQL/InnoDB-3.23.51, June 12, 2002
MySQL/InnoDB-3.23.50, April 23, 2002
MySQL/InnoDB-3.23.49, February 17, 2002
MySQL/InnoDB-3.23.48, February 9, 2002
MySQL/InnoDB-3.23.47, December 28, 2001
MySQL/InnoDB-4.0.1, December 23, 2001
MySQL/InnoDB-3.23.46, November 30, 2001
MySQL/InnoDB-3.23.45, November 23, 2001
MySQL/InnoDB-3.23.44, November 2, 2001
MySQL/InnoDB-3.23.43, October 4, 2001
MySQL/InnoDB-3.23.42, September 9, 2001
MySQL/InnoDB-3.23.41, August 13, 2001
MySQL/InnoDB-3.23.40, July 16, 2001
MySQL/InnoDB-3.23.39, June 13, 2001
MySQL/InnoDB-3.23.38, May 12, 2001
MySQL Cluster Change History
MySQL Cluster-4.1.7, (not released yet)
MySQL Cluster-4.1.6, 10 Oct 2004
MySQL Cluster-4.1.5, 16 Sep 2004
MySQL Cluster-4.1.4, 31 Aug 2004
MySQL Cluster-5.0.1, 27 Jul 2004
MySQL Cluster-4.1.3, 28 Jun 2004

This appendix lists the changes from version to version in the MySQL source code.

We are now working actively on MySQL 4.1 and 5.0, and will provide only critical bugfixes for MySQL 4.0 and MySQL 3.23. We update this section as we add new features, so that everybody can follow the development.

Our TODO section contains what further plans we have for MySQL 4.1 and 5.0. See the section called “MySQL and the Future (the TODO)”.

Note that we tend to update the manual at the same time we make changes to MySQL. If you find a recent version of MySQL listed here that you can't find on our download page (http://dev.mysql.com/downloads/), it means that the version has not yet been released.

The date mentioned with a release version is the date of the last BitKeeper ChangeSet on which the release was based, not the date when the packages were made available. The binaries are usually made available a few days after the date of the tagged ChangeSet, because building and testing all packages takes some time.

Changes in release 5.0.x (Development)

The following changelog shows what has already been done in the 5.0 tree:

  • Basic support for read-only server side cursors.

  • Basic support for (updatable) views. See, for example, CREATE VIEW.

  • Basic support for stored procedures (SQL:2003 style). See Chapter 20, Stored Procedures and Functions.

  • Initial support for rudimentary triggers.

  • Added SELECT INTO list_of_vars, which can be of mixed (that is, global and local) types. See SELECT INTO Statement.

  • Removed the update log. It is fully replaced by the binary log. If the MySQL server is started with --log-update, it will be translated to --log-bin (or ignored if the server is explicitly started with --log-bin), and a warning message will be written to the error log. Setting SQL_LOG_UPDATE will silently set SQL_LOG_BIN instead (or do nothing if the server is explicitly started with --log-bin).

  • User variable names are now case insensitive: If you do SET @a=10; then SELECT @A; will now return 10. Case sensitivity of a variable's value depends on the collation of the value.

  • Strict mode, which in essence means that you will get an error instead of a warning when inserting an incorrect value into a column. See the section called “The Server SQL Mode”.

For a full list of changes, please refer to the changelog sections for each individual 5.0.x release.

Changes in release 5.0.2 (not released yet)

Functionality added or changed:

  • The SCHEMA and SCHEMAS keywords now are accepted as synonyms for DATABASE and DATABASES.

  • Added initial support for rudimentary triggers.

  • Added basic support for read-only server side cursors.

  • Added --start-datetime, --stop-datetime, --start-position, --stop-position options to mysqlbinlog (makes point-in-time recovery easier).

  • Made the MySQL server not react to signals SIGHUP and SIGQUIT on Mac OS X 10.3. This is needed because under this OS, the MySQL server receives lots of these signals (reported as Bug #2030).

  • New --auto-increment-increment and --auto-increment-offset startup options. These allow you to set up a server to generate auto-increment values that don't conflict with another server.

  • MySQL now by default will check dates and only allow fully correct dates. If you want to MySQL to behave as default, you should enable the new ALLOW_INVALID_DATES SQL mode.

  • Added STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and TRADITIONAL SQL modes. The TRADITIONAL mode is shorthand for all the preceding modes. When using mode TRADITIONAL, MySQL generates an error if you try to insert a wrong value in a column. It does not adjust the value to the closest possible legal value.

  • MySQL now remembers which columns were declared to have default values. In STRICT_TRANS_TABLES/STRICT_ALL_TABLES mode, you now get an error if you do an INSERT without specifying all columns that don't have a default value. A side effect of this is that when you do SHOW CREATE for a new table, you will no longer see a DEFAULT value for a column for which you didn't specify a default value.

  • The compilation flag DONT_USE_DEFAULT_FIELDS was removed because you can get the same behavior by setting the sql_mode system variable to STRICT_TRANS_TABLES.

  • We now detect too-large floating point numbers during statement parsing and generate an error messages for them.

  • Renamed the sql_updatable_view_key system variable to updatable_views_with_limit. This variable now can have only two values:

    • 1 or YES: Don't issue an error message (warning only) if a VIEW without presence of a key in the underlying table is used in queries with a LIMIT clause for updating. (This is the default value.)

    • 0 or NO: Prohibit update of a VIEW, which does not contain a key in the underlying table and the query uses a LIMIT clause (usually get from GUI tools).

  • Reverted output format of SHOW TABLES to old pre-5.0.1 format that did not include a table type column. To get the additional column that lists the table type, use SHOW FULL TABLES now.

  • The mysql_fix_privilege_tables script now initializes the global CREATE VIEW and SHOW VIEW privileges in the user table to the value of the CREATE privilege in that table.

  • If the server finds that the user table has not been upgraded to include the view-related privilege columns, it treats each account as having view privileges that are the same as its CREATE privilege.

Bugs fixed:

  • Fixed that mysqlbinlog --read-from-remote-server sometimes couldn't accept two binary logfiles on the command line. (Bug #4507)

  • Fixed that mysqlbinlog --position --read-from-remote-server had incorrect # at lines. (Bug #4506)

  • Fixed that CREATE TABLE ... TYPE=HEAP ... AS SELECT... caused replication slave to stop. (Bug #4971)

  • Fixed that mysql_options(...,MYSQL_OPT_LOCAL_INFILE,...) failed to disable LOAD DATA LOCAL INFILE. (Bug #5038)

  • Fixed that disable-local-infile option had no effect if client read it from a configuration file using mysql_options(...,MYSQL_READ_DEFAULT,...). (Bug #5073)

  • Fixed that SET GLOBAL SYNC_BINLOG did not work on some platforms (Mac OS X). (Bug #5064)

  • Fixed that mysql-test-run failed on the rpl_trunc_binlog test if running test from the installed (the target of 'make install') directory. (Bug #5050)

  • Fixed that mysql-test-run failed on the grant_cache test when run as Unix user 'root'. (Bug #4678)

  • Fixed an unlikely deadlock which could happen when using KILL. (Bug #4810)

  • Fixed a crash when one connection got KILLed while it was doing START SLAVE. (Bug #4827)

  • Made FLUSH TABLES WITH READ LOCK block COMMIT if server is running with binary logging; this ensures that the binary log position can be trusted when doing a full backup of tables and the binary log. (Bug #4953)

  • Fixed that the counter of an auto_increment column was not reset by TRUNCATE TABLE is the table was a temporary one. (Bug #5033)

  • Fixed slave SQL thread so that the SET COLLATION_SERVER... statements it replicates don't advance its position (so that if it gets interrupted before the actual update query, it will later redo the SET). (Bug #5705)

  • Fixed that if the slave SQL thread found a syntax error in a query (which should be rare, as the master parsed it successfully), it stops. (Bug #5711)

  • Fixed that if a write to a MyISAM table fails because of a full disk or an exceeded disk quota, it prints a message to the error log every 10 minutes, and waits until disk becomes free. (Bug #3248)

  • Fixed problem introduced in 4.0.21 where a connection starting a transaction, doing updates, then FLUSH TABLES WITH READ LOCK, then COMMIT, would cause replication slaves to stop complaing about error 1223. Bug surfaced when using the InnoDB innobackup script. (Bug #5949)

Changes in release 5.0.1 (27 Jul 2004)

Note: This build passes our test suite and fixes a lot of reported bugs found in the previous 5.0.0 release. However, please be aware that this is not a “standard MYSQL build” in the sense that there are still some open critical bugs in our bugs database at http://bugs.mysql.com/ that affect this release as well. We are actively fixing these and will make a new release where these are fixed as soon as possible. However, this binary should be a good candidate for testing new MySQL 5.0 features for future products.

Functionality added or changed:

  • Added support for read-only and updatable views based on a single table or other updatable views. View use requires that you upgrade your grant tables to add the view-related privileges. See the section called “Upgrading the Grant Tables”.

  • Implemented a new “greedy search” optimizer that can significantly reduce the time spent on query optimization for some many-table joins. (You are affected if not only some particular SELECT is slow, but even using EXPLAIN for it takes a noticeable amount of time.) Two new system variables, optimizer_search_depth and optimizer_prune_level, can be used to fine-tune optimizer behavior.

  • Warning: Incompatible change! C API change: mysql_shutdown() now requires a second argument. This is a source-level incompatibility that affects how you compile client programs; it does not affect the ability of compiled clients to communicate with older servers. See mysql_shutdown().

  • A stored procedure is no longer “global.” That is, it now belongs to a specific database:

    • When a database is dropped, all routines belonging to that database are also dropped.

    • Procedure names may be qualified, for example, db.p()

    • When executed from another database, an implicit USE db_name is in effect.

    • Explicit USE db_name statements no longer are allowed in a stored procedure.

    See Chapter 20, Stored Procedures and Functions.

  • Fixed SHOW TABLES output field name and values according to standard. Field name changed from Type to table_type, values are BASE TABLE, VIEW and ERROR. (Bug #4603)

  • Added the sql_updatable_view_key system variable.

  • Added the --replicate-same-server-id server option.

  • Added Last_query_cost status variable that reports optimizer cost for last compiled query.

  • Added the --to-last-log option to mysqlbinlog, for use in conjunction with --read-from-remote-server.

  • Added the --innodb-safe-binlog server option, which adds consistency guarantees between the content of InnoDB tables and the binary log. See the section called “The Binary Log”.

  • OPTIMIZE TABLE for InnoDB tables is now mapped to ALTER TABLE instead of ANALYZE TABLE.

  • sync_frm is now a settable global variable (not only a startup option).

  • For replication of MEMORY (HEAP) tables: Made the master automatically write a DELETE FROM statement to its binary log when a MEMORY table is opened for the first time since master's startup. This is for the case where the slave has replicated a non-empty MEMORY table, then the master is shut down and restarted: the table is now empty on master; the DELETE FROM empties it on slave too. Note that even with this fix, between the master's restart and the first use of the table on master, the slave still has out-of-date data in the table. But if you use the --init-file option to populate the MEMORY table on the master at startup, it ensures that the failing time interval is zero. (Bug #2477)

  • When a session having open temporary tables terminates, the statement automatically written to the binary log is now DROP TEMPORARY TABLE IF EXISTS instead of DROP TEMPORARY TABLE, for more robustness.

  • The MySQL server now returns an error if SET SQL_LOG_BIN is issued by a user without the SUPER privilege (in previous versions it just silently ignored the statement in this case).

  • Changed that when the MySQL server has binary logging disabled (that is, no --log-bin option was used), then no transaction binary log cache is allocated for connections. This should save binlog_cache_size bytes of memory (32KB by default) for every connection.

  • Added the sync_binlog=N global variable and startup option, which makes the MySQL server synchronize its binary log to disk (fdatasync()) after every Nth write to the binary log.

  • Changed the slave SQL thread to print less useless error messages (no more message duplication; no more messages when an error is skipped because of slave-skip-errors).

  • DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, single-table DELETE, and single-table UPDATE now are written to the binary log even if they changed nothing on the master (for example, even if a DELETE matched no rows). The old behavior sometimes caused bad surprises in replication setups.

  • Replication and mysqlbinlog now have better support for the case that the session character set and collation variables are changed within a given session. See the section called “Replication Features and Known Problems”.

  • Killing a CHECK TABLE statement does not result in the table being marked as “corrupted” any more; the table remains as if CHECK TABLE had not even started. See KILL.

Bugs fixed:

  • Strange results with index (x, y) ... WHERE x=val_1 AND y>=val_2 ORDER BY pk; (Bug #3155)

  • Subquery and order by (Bug #3118)

  • ALTER DATABASE caused the client to hang if the database did not exist. (Bug #2333)

  • SLAVE START (which is a deprecated syntax, START SLAVE should be used instead) could crash the slave. (Bug #2516)

  • Multiple-table DELETE statements were never replicated by the slave if there were any --replicate-*-table options. (Bug #2527)

  • The MySQL server did not report any error if a statement (submitted through mysql_real_query() or mysql_stmt_prepare()) was terminated by garbage characters. This can happen if you pass a wrong length parameter to these functions. The result was that the garbage characters were written into the binary log. (Bug #2703)

  • Replication: If a client connects to a slave server and issues an administrative statement for a table (for example, OPTIMIZE TABLE or REPAIR TABLE), this could sometimes stop the slave SQL thread. This does not lead to any corruption, but you must use START SLAVE to get replication going again. (Bug #1858)

  • Made clearer the error message that one gets when an update is refused because of the --read-only option. (Bug #2757)

  • Fixed that --replicate-wild-*-table rules apply to ALTER DATABASE when the table pattern is %, as is already the case for CREATE DATABASE and DROP DATABASE. (Bug #3000)

  • Fixed that when a Rotate event is found by the slave SQL thread in the middle of a transaction, the value of Relay_Log_Pos in SHOW SLAVE STATUS remains correct. (Bug #3017)

  • Corrected the master's binary log position that InnoDB reports when it is doing a crash recovery on a slave server. (Bug #3015)

  • Changed the column Seconds_Behind_Master in SHOW SLAVE STATUS to never show a value of −1. (Bug #2826)

  • Changed that when a DROP TEMPORARY TABLE statement is automatically written to the binary log when a session ends, the statement is recorded with an error code of value zero (this ensures that killing a SELECT on the master does not result in a superfluous error on the slave). (Bug #3063)

  • Changed that when a thread handling INSERT DELAYED (also known as a delayed_insert thread) is killed, its statements are recorded with an error code of value zero (killing such a thread does not endanger replication, so we thus avoid a superfluous error on the slave). (Bug #3081)

  • Fixed deadlock when two START SLAVE commands were run at the same time. (Bug #2921)

  • Fixed that a statement never triggers a superfluous error on the slave, if it must be excluded given the --replicate-* options. The bug was that if the statement had been killed on the master, the slave would stop. (Bug #2983)

  • The --local-load option of mysqlbinlog now requires an argument.

  • Fixed a segmentation fault when running LOAD DATA FROM MASTER after RESET SLAVE. (Bug #2922)

  • mysqlbinlog --read-from-remote-server read all binary logs following the one that was requested. It now stops at the end of the requested file, the same as it does when reading a local binary log. There is an option --to-last-log to get the old behavior. (Bug #3204)

  • Fixed mysqlbinlog --read-from-remote-server to print the exact positions of events in the "at #" lines. (Bug #3214)

  • Fixed a rare error condition that caused the slave SQL thread spuriously to print the message Binlog has bad magic number and stop when it was not necessary to do so. (Bug #3401)

  • Fixed mysqlbinlog not to forget to print a USE statement under rare circumstances where the binary log contained a LOAD DATA INFILE statement. (Bug #3415)

  • Fixed a memory corruption when replicating a LOAD DATA INFILE when the master had version 3.23. (Bug #3422)

  • Multiple-table DELETE statements were always replicated by the slave if there were some --replicate-*-ignore-table options and no --replicate-*-do-table options. (Bug #3461)

  • Fixed a crash of the MySQL slave server when it was built with --with-debug and replicating itself. (Bug #3568)

  • Fixed that in some replication error messages, a very long query caused the rest of the message to be invisible (truncated), by putting the query last in the message. (Bug #3357)

  • If server-id was not set using startup options but with SET GLOBAL, the replication slave still complained that it was not set. (Bug #3829)

  • mysql_fix_privilege_tables didn't correctly handle the argument of its --password=# option. (Bug #4240)

  • Fixed potential memory overrun in mysql_real_connect() (which required a compromised DNS server and certain operating systems). (Bug #4017)

  • During the installation process of the server RPM on Linux, mysqld was run as the root system user, and if you had --log-bin=<somewhere_out_of_var_lib_mysql> it created binary log files owned by root in this directory, which remained owned by root after the installation. This is now fixed by starting mysqld as the mysql system user instead. (Bug #4038)

  • Made DROP DATABASE honor the value of lower_case_table_names. (Bug #4066)

  • The slave SQL thread refused to replicate INSERT ... SELECT if it examined more than 4 billion rows. (Bug #3871)

  • mysqlbinlog didn't escape the string content of user variables, and did not deal well when these variables were in non-ASCII character sets; this is now fixed by always printing the string content of user variables in hexadecimal. The character set and collation of the string is now also printed. (Bug #3875)

  • Fixed incorrect destruction of expression that led to a server crash on complex AND/OR expressions if query was ignored (either by a replication server because of --replicate-*-table rules, or by any MySQL server because of a syntax error). (Bug #3969, Bug #4494)

  • If CREATE TEMPORARY TABLE t SELECT failed while loading the data, the temporary table was not dropped. (Bug #4551)

  • Fixed that when a multiple-table DROP TABLE failed to drop a table on the master server, the error code was not written to the binary log. (Bug #4553)

  • When the slave SQL thread was replicating a LOAD DATA INFILE statement, it didn't show the statement in the output of SHOW PROCESSLIST. (Bug #4326)

Changes in release 5.0.0 (22 Dec 2003: Alpha)

Functionality added or changed:

  • The KILL statement now takes CONNECTION and QUERY modifiers. The first is the same as KILL with no modifier (it kills a given connection thread). The second kills only the statement currently being executed by the connection.

  • Added TIMESTAMPADD() and TIMESTAMPDIFF() functions.

  • Added WEEK and QUARTER values as INTERVAL arguments for the DATE_ADD() and DATE_SUB() functions.

  • New binary log format that enables replication of these session variables: sql_mode, SQL_AUTO_IS_NULL, FOREIGN_KEY_CHECKS (which was already replicated since 4.0.14, but here it's done more efficiently and takes less space in the binary logs), UNIQUE_CHECKS. Other variables (like character sets, SQL_SELECT_LIMIT, ...) will be replicated in upcoming 5.0.x releases.

  • Implemented Index Merge optimization for OR clauses. See the section called “Index Merge Optimization”.

  • Basic support for stored procedures (SQL:2003 style). See Chapter 20, Stored Procedures and Functions.

  • Added SELECT INTO list_of_vars, which can be of mixed (that is, global and local) types. See SELECT INTO Statement.

  • Easier replication upgrade (5.0.0 masters can read older binary logs and 5.0.0 slaves can read older relay logs). See the section called “Replication Compatibility Between MySQL Versions” for more details). The format of the binary log and relay log is changed compared to that of MySQL 4.1 and older.

  • Important note: If you upgrade to MySQL 4.1.1 or higher, it is difficult to downgrade back to 4.0 or 4.1.0! That is because, for earlier versions, InnoDB is not aware of multiple tablespaces.

Bugs fixed: