Manual de Referência do MySQL :: D.3.14 Alterações na distribuição 4.0.4 (29 Sep 2002)

Fixed bug where GRANT/REVOKE failed if hostname was given in non-matching case.

Don't give warning in LOAD DATA INFILE when setting a timestamp to a string value of '0'.

Fixed bug in myisamchk -R mode.

Fixed bug that caused mysqld to crash on REVOKE.

Fixed bug in ORDER BY when there is a constant in the SELECT statement.

One didn't get an error message if mysqld couldn't open the privilege tables.

SET PASSWORD FOR ... closed the connection in case of errors (bug from 4.0.3).

Increased max possible max_allowed_packet in mysqld to 1 GB.

Fixed bug when doing a multi-line INSERT on a table with an AUTO_INCREMENT key which was not in the first part of the key.

Changed LOAD DATA INFILE to not recreate index if the table had rows from before.

Fixed overrun bug when calling AES_DECRYPT() with incorrect arguments.

--skip-ssl can now be used to disable SSL in the MySQL clients, even if one is using other SSL options in an option file or previously on the command line.

Fixed bug in MATCH ... AGAINST( ... IN BOOLEAN MODE) used with ORDER BY.

Added LOCK TABLES and CREATE TEMPORARY TABLES privilege on the database level. One must run the mysql_fix_privilege_tables script on old installations to activate these.

In SHOW TABLE ... STATUS, compressed tables sometimes showed up as dynamic.

SELECT @@[global|session].var_name didn't report global | session in the result column name.

Fixed problem in replication that FLUSH LOGS in a circular replication setup created an infinite number of binary log files. Now a rotate-binary-log command in the binary log will not cause slaves to rotate logs.

Removed STOP EVENT from binary log when doing FLUSH LOGS.

Disable the use of SHOW NEW MASTER FOR SLAVE as this needs to be completely reworked in a future release.

Fixed a bug with constant expression (for example, field of a one-row table, or field from a table, referenced by a UNIQUE key) appeared in ORDER BY part of SELECT DISTINCT.

--log-binary=a.b.c now properly strips off .b.c.

FLUSH LOGS removed numerical extension for all future update logs.

GRANT ... REQUIRE didn't store the SSL information in the mysql.user table if SSL was not enabled in the server.

GRANT ... REQUIRE NONE can now be used to remove SSL information.

AND is now optional between REQUIRE options.

REQUIRE option was not properly saved, which could cause strange output in SHOW GRANTS.

Fixed that mysqld --help reports correct values for --datadir and --bind-address.

Fixed that one can drop UDFs that didn't exist when mysqld was started.

Fixed core dump problem with SHOW VARIABLES on some 64 bit systems (like Solaris sparc).

Fixed a bug in my_getopt(); --set-variable syntax didn't work for those options that didn't have a valid variable in the my_option struct. This affected at least the default-table-type option.

Fixed a bug from 4.0.2 that caused REPAIR TABLE and myisamchk --recover to fail on tables with duplicates in a unique key.

Fixed a bug from 4.0.3 in calculating the default datatype for some functions. This affected queries of type CREATE TABLE table_name SELECT expression(),...

Fixed bug in queries of type SELECT * FROM table-list GROUP BY ... and SELECT DISTINCT * FROM ....

Fixed bug with the --slow-log when logging an administrator command (like FLUSH TABLES).

Fixed a bug that OPTIMIZE of locked and modified table, reported table corruption.

Fixed a bug in my_getopt() in handling of special prefixes (--skip-, --enable-). --skip-external-locking didn't work and the bug may have affected other similar options.

Fixed bug in checking for output file name of the tee option.

Added some more optimization to use index for SELECT ... FROM many_tables .. ORDER BY key limit #

Fixed problem in SHOW OPEN TABLES when a user didn't have access permissions to one of the opened tables.