List:Announcements« Previous MessageNext Message »
From:Joerg Bruehe Date:September 2 2005 5:00pm
Subject:MySQL 5.0.12-beta has been released
View as plain text  

MySQL 5.0.12-beta, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at and mirror sites.

Note that not all mirror sites may be up to date at this point in time -
if you can't find this version on some mirror, please try again later or
choose another download site.

This is the eighth published Beta release in the 5.0 series.
All attention will continue to be focused on fixing bugs and stabilizing
5.0 for later production release.

NOTE: This Beta release, as any other pre-production release, should not
be installed on ``production'' level systems or systems with critical
data. It is good practice to back up your data before installing any new
version of software. Although MySQL has done its best to ensure a high
level of quality, protect your data by making a backup as you would for
any software beta release.

Please refer to our bug database at for more
details about the individual bugs fixed in this version.

Changes in release 5.0.12:

Functionality added or changed:
* Recursive  triggers  are  detected  and  disallowed.  (Bug  #11896
* Natural joins and joins with USING, including outer join variants, now
   are  processed  according  to  the  SQL:2003  standard. (Bug #4789
   (, Bug #6136 (,
   Bug      #6276     (,     Bug     #6495
   (, Bug #6558 (,
   Bug     #9978     (,     Bug     #10646
   Bug #11710 (
* SHOW  OPEN  TABLES now supports FROM and LIKE clauses. (Bug #12183
   name the same as it does forother databases.  (Bug  #12315
* SHOW ENGINE INNODB STATUS now can display longer query strings. (Bug
   #7819 (
* Added the SLEEP() function, which pauses for the number of seconds
   given by its argument. (Bug #6760 (
* Trying to drop the default keycache by setting
   to  zero now returns a warning that the default keycache cannot be
   dropped. (Bug #10473 (
* The  stability of cursors when used with InnoDB tables was greatly
   improved.  (Bug  #11832  (, Bug #12243
* It is no longer possible to issue FLUSH commands from within stored
   functions or triggers. See Section I.1, "Restrictions on Stored
   Routines and Triggers" for details.
   (Bug #12280  (,
   Bug #12307   (
* INFORMATION_SCHEMA objects are now reported as a SYSTEM VIEW table
   type.  (Bug #11711 (

Bugs fixed:
* An optimizer estimate of zero rows for a non-empty InnoDB table used
   in a left or right join could cause incomplete rollback for the table.
   (Bug #12779 (
* Interleaved  execution of stored procedures and functions could be
   written to the binary log incorrectly, causing replication slaves to
   get out of sync. (Bug #12335 (
* A  query  of the form SHOW TABLE STATUS FROM db_name WHERE name IN
   (select_query)    would    crash    the    server.   (Bug   #12636
* Users created using an IP address or other alias rather than a
   hostname listed in /etc/hosts could not set their own passwords.
   (Bug #12302 (
* Using DESCRIBE on a view after renaming a column in one of the view's
   base   tables   caused   the   server   to   crash.   (Bug  #12533
* DELETE or UPDATE for an indexed MyISAM table could fail. This was due
   to a change in end-space comparison behavior from 4.0 to 4.1. (Bug
   #12565  (
* Joins on VARCHAR columns of different lengths could produce incorrect
   results. (Bug #11398 (
* A “Duplicate column name” error no longer occurs when selecting from a
   view defined as SELECT * from a join that uses a USING clause on
   tables  that have a common column name. (Bug #6558
* Invocations of the SLEEP() function incorrectly could get optimized
   away for statements in which it occurs. Statements containing SLEEP()
   incorrectly  could  be  stored  in  the  query  cache. (Bug #12689
* NDB Cluster: An ALTER TABLE command caused loss of data stored prior
   to the issuing of the command.(Bug #12118
* Query cache is switched off if a thread (connection) has tables
   locked. This prevents invalid results where the locking thread inserts
   values between a second thread connecting and selecting from the
   table. (Bug  #12385 (
* NOW(), CURRENT_TIME and values generated by timestamp columns are now
   constant for the duration of a stored function or trigger. This
   prevents the breaking of statements-based  replication.  (Bug  #12480
* Some statements executed on a master server caused the SQL thread on a
   slave to run out of memory. (Bug #12532 (
* A SELECT DISTINCT query with a constant value for one of the columns
   would     return     only    a    single    row.    (Bug    #12625
* NDB Cluster: Cluster failed to take character set data into account
   when recomputing hashes (and thus could not locate records for
   updating or deletion) following a configuration change and node
   restart. (Bug #12220  (
* NDB Cluster: Wrong error message displayed when cluster management
   server  closed  port  while  mysqld  was  connecting.  (Bug #10950
* A view was allowed to depend on a function that referred to a
   temporary  table. (Bug #10970 (
* Prepared statement parameters could cause errors in the binary log if
   the character set was cp932. (Bug #11338
   incorrect options for tables in INFORMATION_SCHEMA.   (Bug  #12397
* MEMORY tables using B-Tree index on 64-bit platforms could produce
   false table is full errors. (Bug #12460 (
* Issuing  FLUSH INSTANCES followed by STOP INSTANCE caused instance
   manager to crash. (Bug #10957 (
* Duplicate  instructions in stored procedures resulted in incorrect
   execution when the optimizer optimized the duplicate code away. (Bug
   #12168 (
* SHOW TABLES FROM returned wrong error message if the schema specified
   did not exist. (Bug #12591 (
* ROW() function returned incorrect result when comparison involved NULL
   values. (Bug #12509 (
* Views with multiple UNION and UNION ALL produced incorrect results.
   (Bug #10624 (
* Stored procedures with particularly long loops could crash server due
   to memory leak. (Bug #12297 (, Bug #11247
* Trigger and stored procedure execution could break replication. (Bug
   #12482 (
* A server crash could result from an update of a view defined as a
   join, even though the update only updated a single table. (Bug #12569
* On Windows when the --innodb_buffer_pool_awe_mem_mb option has been
   given, the server detects whether AWE support is available and has
   been compiled into the server, and displays an appropriate error
   message if not. (Bug #6581 (
   should be returned as 0 for integer columns. It was being returned as
   NULL.  (Bug #12301 (
   should be returned as NULL if a column has no default value. An empty
   string was being returned if the column was defined as NOT NULL. (Bug
   #12518  (
* Slave  I/O threads were considered to be in the running state when
   launched  (rather than after successfully connecting to the master
   server), resulting in incorrect SHOW SLAVE STATUS output. (Bug #10780
* Column names in subqueries must be unique, but were not being checked
   for uniqueness. (Bug #11796 (
* On Windows, the server could crash during shutdown if both replication
   threads and normal client connection threads were active. (Bug #11796
* Some subqueries of the form SELECT ... WHERE ROW(...) IN (subquery)
   were being handled incorrectly. (Bug #11867
* Selecting from a view after INSERT statements for the view's
   underlying table yielded different results than subsequent selects.
   (Bug #12382  (
* The  mysql_info()  C API function could return incorrect data when
   executed as part of a multi-statement that included a mix of
   statements that do and do not return information.   (Bug   #11688
* When restoring INFORMATION_SCHEMA as the default database after
   failing to execute a stored procedure in an inaccessible database, the
   server returned a spurious ERROR 42000: Unknown database
   'information_schema' message. (Bug #12318
* InnoDB: Limit recursion depth to 200 in deadlock detection to avoid
   running out of stack space. (Bug #12588 (
* Renamed the rest() macro in my_list.h to list_rest() to avoid name
   clashes with user code. (Bug #12327 (
* DATE_ADD() and DATE_SUB() were converting invalid dates to NULL in
   TRADITIONAL SQL mode rather than rejecting them with an error. (Bug
   #10627 (
* A trigger that included a SELECT statement could cause a server crash.
   (Bug #11587 (
* An incorrect conversion from double to ulonglong caused indexes not to
   be    used    for    BDB    tables    on    HP-UX.   (Bug   #10802
* myisampack  failed to delete .TMD temporary files when run with -T
   option. (Bug #12235 (
* Added  portability  check  for Intel compiler to address a problem
   compiling InnoDB code. (Bug #11510 (
* XA allowed two active transactions to be started with the same XID.
   (Bug #12162 (
* Concatenating USER()/DATEBASE() with a column produces invalid
   results.  (Bug #12351 (
* Creating a view that included the TIMESTAMPDIFF() function resulted in
   invalid view. (Bug #12298 (
* Comparison  of InnoDB multi-part primary keys that include VARCHAR
   columns   can   result   in   incorrect   results.   (Bug   #12340
* For PKG installs on Mac OS X, the preinstallation and postinstallation
   scripts were being run only for new installations and not for upgrade
   installations, resulting in an incomplete installation process. (Bug
   #11380 (
* Using cursors and nested queries for the same table, corrupted results
   were    returned    for    the    outer    query.    (Bug   #11909
* User variables were not automatically cast for comparisons, causing
   queries to fail if the column and connection character sets differed.
   Now when mixing strings with different character sets but the same
   coercibility, allow conversion if one character set is a superset of
   the other. (Bug #10892 (
* Selecting from a view defined as a join over many tables could result
   in a server crash due to miscalculation of the number of conditions in
   the WHERE clause. (Bug #12470 (
* Pathame values for options such as ---basedir or --datadir didn't work
   on Japanese Windows machines for directory names containing multibyte
   characters  having  a  second  byte  of  0x5C  (‘\’).  (Bug  #5439
* A race condition between server threads could cause a crash if one
   thread deleted a stored routine while another thread was executing a
   stored routine. (Bug #12228 (
* Mishanding of comparison for rows containg NULL values against rows
   produced by an IN subquery could cause a server crash. (Bug #12392
* Inserting NULL into a GEOMETRY column for a table that has a trigger
   could result in a server crash if the table was subsequently dropped.
   (Bug #12281 (
* A failure to obtain a lock for an IN SHARE MODE query could result in
   a server crash. (Bug #12082 (
* SELECT ... INTO var_name within a trigger could cause a server crash.
   (Bug #11973 (
* INSERT  ...  SELECT ... ON DUPLICATE KEY UPDATE could fail with an
   erroneous  “Column  'col_name' specified twice” error. (Bug #10109
* SHOW TABLE STATUS sometimes reported a Row_format value of Dynamic for
   MEMORY tables, though such tables always have a format of Fixed. (Bug
   #3094 (
* A query using a LEFT JOIN, an IN subquery on the outer table, and an
   ORDER BY clause, caused the server to crash when cursors were enabled.
   (Bug #11901 (
* Using   a   stored   procedure   that  referenced  tables  in  the
   INFORMATION_SCHEMA database would return an empty result set. (Bug
   #10055       (,       Bug       #12278
* Columns defined as TINYINT(1) redefined as TINYINT(4) when
   incorporated into a VIEW. (Bug #11335 (
* ISO-8601 formatted dates were not being parsed correctly. (Bug #7308
   deadlock. (Bug #9459 (
* NULL column definitions read incorrectly for inner tables of nested
   outer joins. (Bug #12154 (
* GROUP_CONCAT ignores the DISTINCT modifier when used in a query
   joining multiple tables where one of the tables has a single row. (Bug
   #12095  (
* UNION  query  with  FULLTEXT could cause server crash. (Bug #11869


Joerg Bruehe, Senior Production Engineer

MySQL 5.0.12-beta has been releasedJoerg Bruehe2 Sep