Bugs fixed for MySQL 4.0.13 Release

Bugs, that have been fixed for MySQL 4.0.13 release.

- Fixed `Unknown error' when using `UPDATE ... LIMIT'. (Bug #373)

- Fixed problem with ansi mode and `GROUP BY' with constants. (Bug #387)

- Fixed bug with `UNION' and `OUTER JOIN'. (Bug #386)

- Fixed bug if one used a multi-table `UPDATE' and the query required a temporary table bigger than `tmp_table_size'. (Bug #286)

- Run `mysql_install_db' with the `-IN-RPM' option for the Mac OS X installation to not fail on systems with improperly configured hostname configurations.

- `LOAD DATA INFILE' will now read `000000' as a zero date instead as `"2000-00-00"'.

- Fixed bug that caused `DELETE FROM table WHERE const_expression' always to delete the whole table (even if expression result was false). (Bug #355)

- Fixed core dump bug when using `FORMAT('nan',#)'. (Bug #284)

- Fixed name resolution bug with `HAVING ... COUNT(DISTINCT ...)'.

- Fixed wrong result from truncation operator (`*') in `MATCH ... AGAINST()' in some complex joins.

- Fixed a crash in `REPAIR ... USE_FRM' command, when used on read-only, nonexisting table or a table with a crashed index file.

- Fixed a crashing bug in mysql monitor program. It occured if program was started with `--no-defaults', with a prompt that contained hostname and connection to non-existing db was requested

- Fixed problem when comparing a key for a multi-byte-character set. (Bug #152)

- Fixed bug in `LEFT', `RIGHT' and `MID' when used with multi-byte character sets and some `GROUP BY' queries. (Bug #314)

- Fix problem with `ORDER BY' being discarded for some `DISTINCT' queries. (Bug #275)

- Fixed some serious bugs in `UPDATE ... ORDER BY'. (Bug #241)

- Fixed unlikely problem in optimising `WHERE' clause with constant expression like in `WHERE 1 AND (a=1 AND b=1)'.

- Fixed that `SET SQL_BIG_SELECTS=1' works again.

- Introduced proper backtick quoting for db.table in `SHOW GRANTS'.

- `FULLTEXT' index stopped working after `ALTER TABLE' that converts `TEXT' field to `CHAR'. (Bug #283)

- Fixed a security problem with `SELECT' and wildcarded select list, when user only had partial column `SELECT' privileges on the table.

- Mark a MyISAM table as "analyzed" only when all the keys are indeed
analyzed.

- Only ignore world-writeable `my.cnf' files that are regular files
(and not e.g. named pipes or character devices).

- Fixed few smaller issues with `SET PASSWORD'.

- Fixed error message which contained deprecated text.

- Fixed a bug with two `NATURAL JOIN's in the query.

- `SUM()' didn't return `NULL' when there was no rows in result or when all values was `NULL'.

- On Unix symbolic links handling was not enabled by default and there was no way to turn this on.

- Added missing dashes to parameter `--open-files-limit' in `mysqld_safe'. (Bug #264)

- Fixed wrong hostname for TCP/IP connections displayed in `SHOW
PROCESSLIST'.

- Fixed a bug with `NAN' in `FORMAT(...)' function ...

- Fixed a bug with improperly cached database privileges.

- Fixed a bug in `ALTER TABLE ENABLE / DISABLE KEYS' which failed to force a refresh of table data in the cache.

- Fixed bugs in replication of `LOAD DATA INFILE' for custom parameters (`ENCLOSED', `TERMINATED' and so on) and temporary tables (Bugs #183 and #222).

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

- Fixed a bug when doing `LOAD DATA INFILE IGNORE': when reading the binary log, `mysqlbinlog' and the replication code read `REPLACE' instead of `IGNORE'. This could make the slave's table become different from the master's table. (Bug #218)

- Fixed a deadlock when `relay_log_space_limit' was set to a too small value. (Bug #79)

- Fixed a bug in HAVING clause when an alias is used from the *select list*.

- Fixed a bug in `MyISAM' when a row is inserted into a table with a large number of `NULL' columns. Bug was caused by wrong calculation of the record length, as the space required for storage of `NULL' bits was not added to the total record length.

- Fixed a bug when `SELECT' *@nonexistent_variable* caused the error in client-server protocol due to net_printf() being sent to the client twice.

- Fixed a bug in setting `SQL_BIG_SELECTS' option.

- Fixed a bug in `SHOW PROCESSLIST' which only displayed a localhost in the `"Host"' column. This was caused by a glitch that only used current thread info instead info from the linked list of threads.

- Removed unnecessary Mac OS X helper files from server RPM. (Bug #144)

- Allow optimisation of `multi-table-update' for InnoDB tables as well.

- Fixed a bug in `multi-table-updates' that caused some rows to be updated several times.

- Fixed a bug in `mysqldump' when it was called with `--master-data': the `CHANGE MASTER TO' commands appended to the SQL dump had wrong coordinates. (Bug #159)

- Fixed a bug when an updating query using `USER()' was replicated on the slave ; this caused segfault on the slave. (Bug #178). `USER()' is still badly replicated on the slave (it is replicated to `""').