D.3.1 Changes in release 4.0.15 (not released yet)

Functionality added or changed:

• MySQL can now use range optimization for BETWEEN with non-constant limits. (Bug #991)
• mysql_install_db now tries to use hostname -h to obtain the fully qualified domain name (FQDN), when possible. (Bug #897)
• Replication error messages now include the default database, so that users can check, against which database the failing query was run.
• A documentation change: added a paragraph about how binlog-do-db and binlog-ignore-db options are tested against the database on the master (see section 4.9.4 The Binary Log), and a paragraph about how replicate-do-db, replicate-do-table and analog options are tested against the database and tables on the slave (see section 4.10.6 Replication Options in `my.cnf').
• Now the slave does not replicate SET PASSWORD if it is configured to exclude the mysql database from replication (using for example replicate-wild-ignore-table=mysql.%), like this was already the case for GRANT and REVOKE since version 4.0.13 (though there was Bug #980 in 4.0.13 & 4.0.14, which has been fixed in 4.0.15).

Bugs fixed:

• Fixed bug in propagating the version number to the manual included in the distribution files. (Bug #1020)
• Fixed key sorting (a PRIMARY key declared for column, that is not explicitly marked NOT NULL, was sorted after UNIQUE key for NOT NULL column).
• Fixed the result of INTERVAL when applied to DATE value. (Bug #792)
• Fixed compiling of the embedded server library in the RPM spec file. (Bug #959)
• Added some missing files to the RPM spec file, fixed some RPM building errors that occured on Red Hat Linux 9. (Bug #998)
• Fixed wrong XOR evaluation in WHERE clause. (Bug #992)
• Fixed bug with processing in query cache merged tables constructed with more then 255 tables. (Bug #930)
• Fixed wrong results from outer join query (e.g. LEFT JOIN) when ON condition is always false, and range search in used. (Bug #926)
• Fixed a bug causing wrong results from MATCH ... AGAINST() in some joins. (Bug #942)
• MERGE tables do not ignore "Using index" (from EXPLAIN output) anymore.
• Fixed a bug that prevented an empty table to be marked as "analyzed". (Bug #937)
• Fixed myisamchk --sort-records crash when used on compressed table.
• Fixed slow (as compared to 3.23) ALTER TABLE and related commands, e.g. CREATE INDEX. (Bug #712)
• GRANT command that creates an anonymous user (that is, with empty username) no longer requires FLUSH PRIVILEGES to work. (Bug #473)
• CHANGE MASTER now flushes `relay-log.info'; previously this was deferred to the next run of START SLAVE, so if after CHANGE MASTER, mysqld was shutdown on the slave, without having run START SLAVE, the relay log's name and position were lost, and at restart they were reloaded from `relay-log.info', so back to their old values of before CHANGE MASTER, leading to error messages (as the pretended relay log did not exist any more) and the slave threads refusing to start. (Bug #858)
• Fixed segmentation fault when one did LOAD DATA FROM MASTER and the master was running without option --log-bin. (Bug #934)
• 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.
• Fixed a random bug: sometimes the slave would replicate GRANT or REVOKE queries even if it was configured to exclude the mysql database from replication (using for example replicate-wild-ignore-table=mysql.%). (Bug #980)
• The Last_errno and Last_error fields in the output of SHOW SLAVE STATUS are now cleared by CHANGE MASTER and when the slave SQL thread starts. (Bug #986)
• A documentation mistake: it said that RESET SLAVE does not change connection information (master host, master port, master user, master password), whereas it does: it resets it to the startup options (master-host etc) if there were some. (Bug #985)
• SHOW SLAVE STATUS now shows correct information (master host, master port, master user, master password) after RESET SLAVE (i.e. it shows the new values, which are copied from the startup options if there were some). (Bug #985)

User Comments

Add your own comment.