MySQL 4.0.5(a) released

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

MySQL 4.0.5, a new version of the world's most popular Open Source Database,
has been released. It is now available in source and binary form for a number
of platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.

This is a new beta development release, adding new features and fixing 
recently discovered bugs. This will be the last release labelled as "beta" - 
the upcoming MySQL 4.0.6 will be labelled "gamma", which emphasizes the fact
that the MySQL 4.0 code base has further stabilized and is becoming ready for 
productive use.

To avoid confusion between the product names of the GPL and non-GPL 
(commercial) binaries, MySQL AB has now further refined the new naming 
scheme. Starting with MySQL 4.0.5 and onwards, the following binaries will be 
available:

MySQL Standard (GPL)
This is the recommended binary for most users that want to use MySQL under the 
terms of the GNU General Public License (GPL). It includes the InnoDB Storage 
Engine and all default features that are considered stable and useful enough 
for general usage.

MySQL Max (GPL)
This is an enhanced version of the Standard GPL package. In addition to the 
InnoDB Storage Engine, it includes additional features like the Berkeley DB 
(BDB) Storage Engine (certain platforms only) as well as other additional 
features that are either not exhaustively tested yet or not required for most 
users, e.g. OpenSSL (where available), User defined functions (UDFs), or 
BIG_TABLE support. When these features have matured and proven to be stable 
enough, they will be part of future versions of the Standard binaries. Please
note, that not all of these features are included in all binaries.

MySQL Classic (Commercial License)
Similar to MySQL Standard, but *without* InnoDB and only available as a 
commercial licensed version.

MySQL Pro (Commercial License)
Similar to MySQL Standard (*including* InnoDB), but only available as a 
commercial licensed version. 


- From the 4.0.5 ChangeLog:

Functionality added or changed:

 * Changed handling of last argument in `WEEK()' so that one can get
   week number according to the ISO 8601 specification.  (Old code
   should still work).
 * Fixed that `INSERT DELAY' threads doesn't hang on `Waiting for
   INSERT' when one sends a `SIGHUP' to `mysqld'.
 * Change that `AND' works according to SQL ANSI99 when it comes to
   `NULL' handling. In practice, this only affects queries where you
   do something like `WHERE ... NOT (NULL AND 0)'.
 * `mysqld' will now resolve `basedir' to its full path (with
   `realpath()'). This enables one to use relative symlinks to the
   MySQL installation directory.  This will however cause `show
   variables' to report different directories on systems where there
   is a symbolic link in the path.
 * Fixed that MySQL will not use an index scan on an index that has
   been disabled with `IGNORE INDEX' or `USE INDEX'.
 * Added `--use-frm' option to `mysqlcheck'. When used with `REPAIR',
   it gets the table structure from the `.frm' file, so the table can
   be repaired even if the `.MYI' header is corrupted.
 * Fixed bug in `MAX()' optimization when used with `JOIN' and `ON'
   expressions.
 * Added support for reading of MySQL 4.1 table definition files.
 * `BETWEEN' behaviour changed (*note Comparison Operators::).  Now
   `datetime_col BETWEEN timestamp AND timespamp' should work as
   expected.
 * One can create `TEMPORARY' `MERGE' tables now.
 * `DELETE FROM myisam_table' now shrinks not only the `.MYD' file but
   also the `.MYI' file.
 * When one uses the `--open-files-limit=#' option to `mysqld_safe'
   it's now passed on to `mysqld'.
 * Changed output from `EXPLAIN' from `'where used'' to `'Using
   where'' to make it more in line with other output.
 * Removed variable `safe_show_database' as it was not used anymore.
 * Updated source tree to be built using `automake 1.5' and `libtool
   1.4'.
 * Fixed an inadvertently changed option (`--ignore-space') back to
   the original `--ignore-spaces' in `mysqlclient'. (Both syntaxes
   will work).
 * Don't require `UPDATE' privilege when using `REPLACE'.
 * Allow braces in joins in all positions. Formerly, things like
   `SELECT * FROM (t2 LEFT JOIN t3 USING (a)), t1' worked, but not
   `SELECT * FROM t1, (t2 LEFT JOIN t3 USING (a))'. Note that braces
   are simply removed, they do not change the way the join is
   executed.
 * InnoDB now supports also isolation levels `READ UNCOMMITTED' and
   `READ COMMITTED'.  For a detailed InnoDB changelog, see the section
   InnoDB Change History in this manual.

Bugs fixed:

 * Corrected test for `root' user in `mysqld_safe'.
 * Fixed error message issued when storage engine cannot do `CHECK'
   or `REPAIR'.
 * Fixed rare core dump problem in complicated `GROUP BY' queries that
   didn't return any result.
 * Fixed `mysqlshow' to work properly with wildcarded database names
   and with database names that contain underscores.
 * Added support for `DROP TEMPORARY TABLE ...', to be used to make
   replication safer.
 * When transactions are enabled, all commands that update temporary
   tables inside a `BEGIN/COMMIT' are now stored in the binary log on
   `COMMIT' and not stored if one does `ROLLBACK'.  This fixes some
   problems with non-transactional temporary tables used inside
   transactions.
 * Portability fixes to get MySQL to compile cleanly with Sun Forte 5.0.
 * Fixed `MyISAM' crash when using dynamic-row tables with huge numbers of
   packed fields.
 * Fixed query cache behaviour with `BDB' transactions.
 * Fixed possible floating point exception in `MATCH' relevance
   calculations.
 * Fixed bug in full-text search `IN BOOLEAN MODE' that made `MATCH'
   to return incorrect relevance value in some complex joins.
 * Fixed a bug that limited `MyISAM' key length to a value slightly
   less that 500. It is exactly 500 now.
 * Fixed that `GROUP BY' on columns that may have a `NULL' value
   doesn't always use disk based temporary tables.
 * The filename argument for the `--des-key-file' argument to `mysqld'
   is interpreted relative to the data directory if given as a
   relative pathname.
 * Removed a condition that temp table with index on column that can
   be `NULL' has to be `MyISAM'. This was okay for 3.23, but not
   needed in 4.*. This resulted in slowdown in many queries since
   4.0.2.
 * Small code improvement in multi-table updates.
 * Fixed a newly introduced bug that caused `ORDER BY ... LIMIT #' to
   not return all rows.
 * Fixed a bug in multi-table deletes when outer join is used on an
   empty table, which gets first to be deleted.
 * Fixed a bug in multi-table updates when a single table is updated.
 * Fixed bug that caused `REPAIR TABLE' and `myisamchk' to corrupt
   `FULLTEXT' indexes.
 * Fixed bug with caching the `mysql' grant table database. Now
   queries in this database are not cached in the query cache.
 * Small fix in `mysqld_safe' for some shells.
 * Give error if a `MyISAM' `MERGE' table has more than 2 ^ 32 rows
   and MySQL was not compiled with with `-DBIG_TABLES'.
 * Fixed some `ORDER BY ... DESC' problems with `InnoDB' tables.


Additional notes:

 * MySQL AB now provides binaries for two additional platforms:

   - Sun Solaris 9 (sparc) 32bit and 64bit
   - HP/UX 11 (64 bit)

 * In addition to the bugs fixed in MySQL 4.0.5, we had to provide some
   packages labelled as "4.0.5a" to fix the following problems that were
   spotted shortly after the original 4.0.5 packages were released:

   - The Linux binary was accidentally linked against an unpatched glibc and
     could behave badly on SMP systems under high load
   - The "mysql" command line client on Solaris 2.8 was accidentally linked
     against a non-default system library (libncurses.so)
   - On MacOS X, the "mysqld" binary did not properly shut down and had to be
     killed manually
   - On HP/UX 11, the MySQL server "mysqld" crashed, when one used the command
     "SHOW VARIABLES"

   Please upgrade, if you had downloaded a 4.0.5 binary and there is a 4.0.5a
   version available for your platform. The latter two problems were resolved
   by applying two additional patches to the 4.0.5 sources. Of course, these
   patches also have been added to our development source tree and will be
   part of future releases by default. They are also included in the 4.0.5a
   source archives.

 * The Windows binary now includes a WinMySQLAdmin binary exclusively for
   the Windows NT operating system named "WinMySQLAdmin-nt.exe". The reason
   for this is that the NT 4.0 Kernel doesn't support a function to catch
   the MySQL server process.

Bye,
	LenZ
- -- 
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Lenz Grimmer <lenz@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Production Engineer
/_/  /_/\_, /___/\___\_\___/   Hamburg, Germany
       <___/   www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE95TwOSVDhKrJykfIRAl8NAJ4gEk1v7HJVTyIVhKtiJUBbCBZSsgCfZOTa
WPlu251CqiK3+3afIyqJWmU=
=76kR
-----END PGP SIGNATURE-----