D.3.12 Changes in release 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 optimisation 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.

User Comments

Add your own comment.