:: DEVELOPER ZONE
Functionality added or changed:
ENGINE is now a synonym for the TYPE option for
CREATE TABLE and ALTER TABLE.
Added init_connect and init_slave server variables.
The values should be SQL statements to be executed when each client
connects or each time a slave's SQL thread starts, respectively.
C API enhancement:
SERVER_QUERY_NO_INDEX_USED and
SERVER_QUERY_NO_GOOD_INDEX_USED flags are now set
in server_status field of MYSQL structure.
It is these flags that make the query to be logged as slow
if mysqld was started with --log-slow-queries --log-queries-not-using-indexes.
Bugs fixed:
Fixed a bug with the INTERVAL() function when 8 or more
comparison arguments are provided. (Bug #1561)
Packaging:
Fixed a bug in the Mac OS PKG postinstall script
(mysql_install_db was called with an obsolete argument).
Packaging:
Added missing file mysql_create_system_tables to the server RPM
package. This bug was fixed for the 4.1.1 RPMs by updating the MySQL-server
RPM from MySQL-server-4.1.1-0 to MySQL-server-4.1.1-1. The
other RPMs were not affected by this change.
Fixed a bug in myisamchk and CHECK TABLE that sometimes
resulted in a spurious error Found key at page ..... that points to record outside datafile for a table with a FULLTEXT index. (Bug #1977)
Fixed a hang in full-text indexing of strings in multi-byte (all besides
utf8) charsets. (Bug #2065)
Fixed a crash in full-text indexing of UTF-8 data. (Bug #2033)
Replication: a rare race condition in the slave SQL thread that could lead to an incorrect complaint that the relay log is corrupted. (Bug #2011)
Replication:
if an administrative command on a table (OPTIMIZE TABLE, REPAIR TABLE etc) was run on the slave, this could sometimes stop the slave
SQL thread (this did not lead to any corruption; one just had to type
START SLAVE to get replication going again). (Bug #1858)
Replication:
in the slave SQL thread, a multi-table UPDATE could produce an
incorrect complaint that some record was not found in one table, if the
UPDATE was preceded by a INSERT ... SELECT. (Bug #1701)
© 1995-2005 MySQL AB. All rights reserved.
