Bugs fixed in MySQL 4.1.1

This is the second Alpha development release of the 4.1 tree, adding many new features (see below) and fixing recently discovered bugs. Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version.

However, we encourage you to test and evaluate it and, more importantly, report any bugs or observations to our bug tracking database at http://bugs.mysql.com/

Please note, that for us to resolve a bug report, a reproducible test is required. See "How to report a bug" at http://bugs.mysql.com/how-to-report.php for more details before filing a bug report. We appreciate your support!

Bugs fixed:

* Fixed a bug in privilege handling that caused connections from certain IP addresses to be assigned incorrect database-level privileges. A connection could be assigned the database privileges of the previous successful authentication from one of those IP addresses, even if the IP address username and database name were different. (Bug #1636)

* Error-handling functions were not called properly when an error resulted from `[CREATE | REPLACE| INSERT] ... SELECT' statements.

* `HASH', `BTREE', `RTREE', `ERRORS', and `WARNINGS' no longer are reserved words. (Bug #724)

* Fix for bug in `ROLLUP' when all tables were `const' tables. (Bug #714)

* Fixed a bug in `UNION' that prohibited `NULL' values from being inserted into result set columns where the first `SELECT' of the `UNION' retrieved `NOT NULL' columns.

* Fixed name resolution of columns of reduced subqueries in unions. (Bug #745)

* Fixed memory overrun in subqueries in select list with `WHERE' clause bigger than outer query `WHERE' clause. (Bug #726)

* Fixed a bug that caused `MyISAM' tables with `FULLTEXT' indexes created in 4.0.x to be unreadable in 4.1.x.

* Fixed a data loss bug in `REPAIR TABLE ... USE_FRM' when used with tables that contained `TIMESTAMP' columns and were created in 4.0.x.

* Fixed reduced subquery processing in `ORDER BY'/`GROUP BY' clauses. (Bug #442)

* Fixed name resolution of outer columns of subquery in `INSERT'/`REPLACE' statements. (Bug #446)

* Fixed bug in marking columns of reduced subqueries. (Bug #679)

* Fixed a bug that made `CREATE FULLTEXT INDEX' syntax illegal.

* Fixed a crash when a `SELECT' that required a temporary table (marked by `Using temporary' in `EXPLAIN' output) was used as a derived table in `EXPLAIN' command. (Bug #251)

* Fixed a rare table corruption bug in `DELETE' from a big table with a *new* (created by MySQL-4.1) full-text index.

* `LAST_INSERT_ID()' now returns 0 if the last `INSERT' statement didn't insert any rows.

* Fixed missing last character in function output. (Bug #447)

* Fixed a rare replication bug when a transaction spanned two or more relay logs, and the slave was stopped while executing the part of the transaction that was in the second or later relay log. Then replication would resume at the beginning of the second or later relay log, which was incorrect. (It should resume at `BEGIN', in the first relay log.) (Bug #53)

* `CONNECTION_ID()' now is properly replicated. (Bug #177)

* The new `PASSWORD()' function in 4.1 is now properly replicated. (Bug #344)

* Fixed bug with doubly freed memory.

* Fixed crashing bug in `UNION' operations that involved temporary tables.

* Fixed a crashing bug in `DERIVED TABLES' when `EXPLAIN' is used on a `DERIVED TABLES' with a join.

* Fixed a crashing bug in `DELETE' with `ORDER BY' and `LIMIT' caused by an uninitialized array of reference pointers.

* Fixed a bug in the `USER()' function caused by an error in the size of the allocated string.

* Fixed a crashing bug when attempting to create a table containing a spatial (GIS) column with a storage engine that does not support spatial types.

* Fixed a crashing bug in `UNION' caused by the empty select list and a non-existent column being used in some of the individual `SELECT' statements.

* Fixed a replication bug with a 3.23 master and a 4.0 slave: The slave lost the replicated temporary tables if `FLUSH LOGS' was issued on the master. (Bug #254)

* Fixed a security bug: A server compiled without SSL support still allowed connections by users that had the `REQUIRE SSL' option specified for their accounts.

* When an undefined user variable was used in a updating query on the master (such as `INSERT INTO t VALUES(@a)', where `@a' had never been set by this connection before), the slave could replicate the query incorrectly if a previous transaction on the master used a user variable of the same name. (Bug #1331)

* Fixed bug with prepared statements: Using the `?' prepared statement parameter as the argument to certain functions or statement clauses caused a server crash when `mysql_prepare()' was invoked. (Bug #1500)