Software update: MySQL Pro 4.0.4 beta

DeTeraarist drew our attention to version 4.0.4 beta of the well-known database program MySQL. Note: InnoDB is included with this version of MySQL and is also the difference with MySQL Classic† Below are the changes from the previous version:

Changelog:

• Fixed bug where GRANT/REVOKE failed if hostname was given in not matching case.
• Don’t give warning in LOAD DATA INFILE when setting a timestamp to a string 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 1GB.
• 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 wrong arguments.
• –skip-ssl can now be used to disable SSL in the MySQL clients, even if one is using other SSL options in an options 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 changed in 4.1.
• Fixed a bug with constant expression (eg 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=abc now properly strips off .bc
• 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 my_option struct. This affected at least default-table-type option.
• Fixed a bug from 4.0.2 that caused REPAIR TABLE and myisamchk –repair to fail on tables with duplicates in a unique key.
• Fixed a bug from 4.0.3 in calculating the default field type 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.