D.3.6 Changes in release 4.0.10 (29 Jan 2003)

Functionality added or changed:

• Added option --log-error[=file_name] to mysqld_safe and mysqld. This option will force all error messages to be put in a log file if the option --console is not given. On Windows --log-error is enabled as default, with a default name of host_name.err if the name is not specified.
• Changed some things from Warning: to Note: in the log files.
• The mysqld server should now compile on NetWare.
• Added optimisation that if one does GROUP BY ... ORDER BY NULL then result is not sorted.
• New --ft-stopword-file command-line option for mysqld to replace/disable the built-in stopword list that is used in full-text searches. See section 4.5.7.4 SHOW VARIABLES.
• Changed default stack size from 64K to 192K; This fixes a core dump problem on Red Hat 8.0 and other systems with a glibc that requires a stack size larger than 128K for gethostbyaddr() to resolve a hostname. You can fix this for earlier MySQL versions by starting mysqld with --thread-stack=192K.
• Added mysql_waitpid to the binary distribution and the MySQL-client RPM subpackage (required for mysql-test-run).
• Renamed the main MySQL RPM package to MySQL-server. When updating from an older version, MySQL-server.rpm will simply replace MySQL.rpm.
• If a slave is configured with replicate_wild_do_table=db.% or replicate_wild_ignore_table=db.%, these rules will be applied to CREATE/DROP DATABASE too.
• Added timeout value for MASTER_POS_WAIT().

Bugs fixed:

• Fixed initialisation of the random seed for newly created threads to give a better rand() distribution from the first call.
• Fixed a bug that caused mysqld to hang when a table was opened with the HANDLER command and then dropped without being closed.
• 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 an unlikely bug that could cause a memory overrun when using ORDER BY constant_expression.
• Fixed a table corruption in myisamchk's parallel repair mode.
• Fixed bug in query cache invalidation on simple table renaming.
• Fixed bug in mysqladmin --relative.
• On some 64 bit systems, show status reported a strange number for Open_files and Open_streams.
• Fixed wrong number of columns in EXPLAIN on empty table.
• Fixed bug in LEFT JOIN that caused zero rows to be returned in the case the WHERE condition was evaluated as FALSE after reading const tables. (Unlikely condition).
• FLUSH PRIVILEGES didn't correctly flush table/column privileges when mysql.tables_priv is empty.
• Fixed bug in replication when using LOAD DATA INFILE one a file that updated and auto_increment field with NULL or 0. This bug only affected MySQL 4.0 masters (not slaves or MySQL 3.23 masters). NOTE: If you have a slave that has replicated a file with generated auto_increment fields then the slave data is corrupted and you should reinitialise the affected tables from the master.
• Fixed possible memory overrun when sending a blob > 16M to the client.
• Fixed wrong error message when setting a NOT NULL field to an expression that returned NULL.
• Fixed core dump bug in str LIKE "%other_str%" where str or other_str contained characters >= 128.
• Fixed bug: When executing on master LOAD DATA and InnoDB failed with table full error the binary log was corrupted.

User Comments

Add your own comment.