List:Announcements« Previous MessageNext Message »
From:Joerg Bruehe Date:March 10 2008 6:38pm
Subject:MySQL 6.0.4 Alpha has been released ! (part 2 of 2)
View as plain text  
Dear MySQL users,

MySQL 6.0.4-alpha, a new version of the MySQL database system including
the Falcon transactional storage engine (now at beta stage), has been
released. The main page for MySQL 6.0 is at:

       http://www.mysql.com/mysql60/

If you are new to the Falcon storage engine and need more information,
please read the Falcon Evaluation Guide at:

http://www.mysql.com/why-mysql/white-papers/falcon-getting-started.php

and the Falcon White Paper at:

http://www.mysql.com/why-mysql/white-papers/storage-engines-falcon.php

MySQL 6.0.4-alpha is available in source and binary form for a number
of platforms from our download pages at

       http://dev.mysql.com/downloads/mysql/6.0.html

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

We welcome and appreciate your feedback, bug reports, bug fixes,
patches etc.:

       http://forge.mysql.com/wiki/Contributing

Despite all trimming, describing all changes since the last released
version of MySQL 6.0 exceeds the mailing list configuration.
We had to split this message into two parts: part 1 (the other)
lists all changes which are labeled "functionality", "security",
"incompatible", or "important",
while this one lists the changes without such a label.
You can view the full list online at

       http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html

Changes since the last release:

...

Bugs fixed (part 2):
* Partitioning: MySQL Cluster: EXPLAIN PARTITIONS reported partition
   usage by queries on NDB tables according to the standard MySQL hash
   function than the hash function used in the NDB storage engine.
   (Bug#29550: http://bugs.mysql.com/29550)
* Replication: MySQL Cluster: Row-based replication from or to a
   big-endian machine where the table used the NDB storage engine
   failed, if the same table on the other machine was either
   non-NDB or the other machine was little-endian.
   (Bug#29549: http://bugs.mysql.com/29549,
   Bug#30790: http://bugs.mysql.com/30790)
   See also Bug#24231: http://bugs.mysql.com/24231,
   Bug#30024: http://bugs.mysql.com/30024,
   Bug#30133: http://bugs.mysql.com/30133,
   Bug#30134: http://bugs.mysql.com/30134
* MySQL Cluster: An insert or update with combined range and equality
   constraints failed when run against an NDB table with the error Got
   unknown error from NDB. An example of such a statement would be UPDATE
   t1 SET b = 5 WHERE a IN (7,8) OR a >= 10;.
   (Bug#31874: http://bugs.mysql.com/31874)
* MySQL Cluster: An error with an if statement in sql/ha_ndbcluster.cc
   could potentially lead to an infinite loop in case of failure when
   working with AUTO_INCREMENT columns in NDB tables.
   (Bug#31810: http://bugs.mysql.com/31810)
* MySQL Cluster: The NDB storage engine code was not safe for
   strict-alias optimization in gcc 4.2.1.
   (Bug#31761: http://bugs.mysql.com/31761)
* MySQL Cluster: Following an upgrade, ndb_mgmd would fail with
   an ArbitrationError. (Bug#31690: http://bugs.mysql.com/31690)
* MySQL Cluster: It was possible in some cases for a node group to be
   "lost" due to missed local checkpoints following a system restart.
   (Bug#31525: http://bugs.mysql.com/31525)
* MySQL Cluster: A query against a table with TEXT or BLOB columns that
   would return more than a certain amount of data failed with Got error
   4350 'Transaction already aborted' from NDBCLUSTER.
   (Bug#31482: http://bugs.mysql.com/31482)
   This regression was introduced by
   Bug#29102: http://bugs.mysql.com/29102
* MySQL Cluster: NDB tables having names containing
   non-alphanumeric characters (such as " $ ") were not
   discovered correctly. (Bug#31470: http://bugs.mysql.com/31470)
* MySQL Cluster: A node failure during a local checkpoint could
   lead to a subsequent failure of the cluster during a system
   restart. (Bug#31257: http://bugs.mysql.com/31257)
* MySQL Cluster: In some cases, the cluster managment server
   logged entries multiple times following a restart of mgmd.
   (Bug#29565: http://bugs.mysql.com/29565)
* MySQL Cluster: ndb_mgm --help did not display any information
   about the -a option. (Bug#29509: http://bugs.mysql.com/29509)
* MySQL Cluster: An interpreted program of sufficient size and
   complexity could cause all cluster data nodes to shut down due
   to buffer overruns. (Bug#29390: http://bugs.mysql.com/29390)
* MySQL Cluster: Performing DELETE operations after a data node
   had been shut down could lead to inconsistent data following a
   restart of the node. (Bug#26450: http://bugs.mysql.com/26450)
* MySQL Cluster: UPDATE IGNORE could sometimes fail on NDB
   tables due to the use of unitialized data when checking for
   duplicate keys to be ignored.
   (Bug#25817: http://bugs.mysql.com/25817)
* MySQL Cluster: The cluster log was formatted inconsistently
   and contained extraneous newline characters.
   (Bug#25064: http://bugs.mysql.com/25064)
* MySQL Cluster: (Replication): Inconsistencies could occur
   between the master and the slave when replicating Disk Data
   tables. (Bug#19259: http://bugs.mysql.com/19259,
   Bug#19227: http://bugs.mysql.com/19227)
* Partitioning: Repeated updates of a table that was partitioned
   by KEY on a TIMESTAMP column eventually crashed the server.
   (Bug#32067: http://bugs.mysql.com/32067)
* Partitioning: Selecting from a table partitioned by KEY on a
   VARCHAR column whose size was greater than 65530 caused the
   server to crash. (Bug#31705: http://bugs.mysql.com/31705)
* Partitioning: INSERT DELAYED into a partitioned table crashed
   the server. (Bug#31201: http://bugs.mysql.com/31201)
* Partitioning: Using ALTER TABLE to partition an existing table
   having an AUTO_INCREMENT column could crash the server.
   (Bug#30878: http://bugs.mysql.com/30878)
   This regression was introduced by
   Bug#27405: http://bugs.mysql.com/27405
* Partitioning: Falcon cannot drop a table for which there is a
   pending transaction, but the error message for such attempts
   was misleading. (Bug#22972: http://bugs.mysql.com/22972)
* Replication: When dropping a database containing a stored
   procedure while using row-cased replication, the delete of the
   stored procedure from the mysql.proc table was recorded in the
   binary log following the DROP DATABASE statement. To correct
   this issue, DROP DATABASE now uses statement-based
   replication. (Bug#32435: http://bugs.mysql.com/32435)
* Replication: It was possible for the name of the relay log
   file to exceed the amount of memory reserved for it, possibly
   leading to a crash of the server.
   (Bug#31836: http://bugs.mysql.com/31836)
   See also Bug#28597: http://bugs.mysql.com/28597
* Replication: Corruption of log events caused the server to
   crash on 64-bit Linux systems having 4 GB of memory or more.
   (Bug#31793: http://bugs.mysql.com/31793)
* Replication: Trying to replicate an update of a row that was
   missing on the slave led to a failure on the slave.
   (Bug#31702: http://bugs.mysql.com/31702)
* Replication: Table names were displayed as binary "garbage"
   characters in slave error messages. The issue was observed on
   64-bit Windows but may have effected other platforms.
   (Bug#30854: http://bugs.mysql.com/30854)
* Replication: One thread could read uninitialized memory from
   the stack of another thread. This issue was only known to
   occur in a mysqld process acting as both a master and a slave.
   (Bug#30752: http://bugs.mysql.com/30752)
* Replication: It was possible to set SQL_SLAVE_SKIP_COUNTER
   such that the slave would jump into the middle of an event
   group, including possibly a transaction.
   (Bug#28618: http://bugs.mysql.com/28618)
   See also Bug#12691: http://bugs.mysql.com/12691
* Replication: Due a previous change in how the default name and
   location of the binlog file were determined, replication
   failed following some upgrades.
   (Bug#28597: http://bugs.mysql.com/28597,
   Bug#28603: http://bugs.mysql.com/28603)
   See also Bug#31836: http://bugs.mysql.com/31836
   This regression was introduced by
   Bug#20166: http://bugs.mysql.com/20166
* Replication: Stored procedures having BIT parameters were not
   replicated correctly. (Bug#26199: http://bugs.mysql.com/26199)
* Replication: Issuing SHOW SLAVE STATUS as mysqld was shutting
   down could cause a crash.
   (Bug#26000: http://bugs.mysql.com/26000)
* Replication: If a temporary error occured inside an event
   group on an event that was not the first event of the group,
   the slave could get caught in an endless loop because the
   retry counter was reset whenever an event was executed
   successfully. (Bug#24860: http://bugs.mysql.com/24860)
   See also Bug#12691: http://bugs.mysql.com/12691,
   Bug#23171: http://bugs.mysql.com/23171
* Replication: An UPDATE statement using a stored function that
   modified a non-transactional table was not logged if it
   failed. This caused the copy of the non-transactional table on
   the master have a row that the copy on the slave did not.
   (Bug#23333: http://bugs.mysql.com/23333)
   See also Bug#12713: http://bugs.mysql.com/12713
* Replication: A replication slave sometimes failed to reconnect
   because it was unable to run SHOW SLAVE HOSTS.
   (Bug#21132: http://bugs.mysql.com/21132)
   See also Bug#13963: http://bugs.mysql.com/13963,
   Bug#21869: http://bugs.mysql.com/21869
* Replication: A replication slave sometimes stopped for changes
   that were idempotent (that is, such changes should have been
   considered "safe"), even though it should have simply noted
   that the change was already done, and continued operation.
   (Bug#19958: http://bugs.mysql.com/19958)
* Cluster Replication: A replication slave could return "garbage" data
   that was not in recognizable row format due to a problem with the
   internal all_set() method. (Bug#33375: http://bugs.mysql.com/33375)
* Cluster Replication: A node failure during replication could
   lead to buckets out of order; now active subscribers are
   checked for, rather than empty buckets.
   (Bug#31701: http://bugs.mysql.com/31701)
* Cluster Replication: In some cases, not all tables were
   properly initialized before the binlog thread was started.
   (Bug#31618: http://bugs.mysql.com/31618)
* Using Falcon when accessing multiple versions of the same
   record, certain records could fail to be retrieved from the
   record cache, causing an assertion failure.
   (Bug#32862: http://bugs.mysql.com/32862)
* Creating an index on a Falcon table with a column using UTF32
   that has been converted to UTF8 would cause a server crash.
   (Bug#32833: http://bugs.mysql.com/32833)
* Using ALTER TABLE on a Falcon table it would be possible to
   create two tables with the same name but different case.
   (Bug#32830: http://bugs.mysql.com/32830)
* Converting a table from InnoDB to Falcon, where the Falcon
   table with the same name (but different case) would cause a
   server crash. (Bug#32829: http://bugs.mysql.com/32829)
* mysqld_safe looked for error messages in the wrong location.
   (Bug#32679: http://bugs.mysql.com/32679)
* An issue with the NO_ENGINE_SUBSTITUTION sql_mode database can
   cause the creation of stored routines to fail. If you are
   having problems with creating stored routines while using this
   sql_mode value, remove this value from your sql_mode setting.
   (Bug#32633: http://bugs.mysql.com/32633)
* Repeatedly creating and dropping Falcon tablespaces would fail
   because a dropped tablespace would not be dropped before the
   new tablespace file was created.
   (Bug#32621: http://bugs.mysql.com/32621)
* The INTERVAL() function incorrectly handled NULL values in the
   value list. (Bug#32560: http://bugs.mysql.com/32560)
* Use of a NULL-returning GROUP BY expression in conjunction
   with WITH ROLLUP could cause a server crash.
   (Bug#32558: http://bugs.mysql.com/32558)
   See also Bug#31095: http://bugs.mysql.com/31095
* ORDER BY UpdateXML(...) caused the server to crash in queries
   where UpdateXML() returned NULL.
   (Bug#32557: http://bugs.mysql.com/32557)
* Falcon used a fixed index key size which would be too small to
   cope with some Falcon page sizes, leading to a crash. Falcon
   now supports variable length index keys according to the
   supported page sizes. See falcon_page_size.
   (Bug#32554: http://bugs.mysql.com/32554)
* The rules for valid column names were being applied differently for
   base tables and views. (Bug#32496: http://bugs.mysql.com/32496)
* Falcon options to set the limits of memory usage would not be
   honoured. This could lead to crashes and assertions during
   normal usage, instead of generating a suitable warning.
   (Bug#32413: http://bugs.mysql.com/32413)
* Falcon would incorrectly return the supported repeatable-read
   level when queried by the Online Backup system, preventing the
   ability to create a consistent snapshot backup.
   (Bug#32301: http://bugs.mysql.com/32301)
* Some uses of user variables in a query could result in a
   server crash. (Bug#32260: http://bugs.mysql.com/32260)
* Under certain conditions, the presence of a GROUP BY clause
   could cause an ORDER BY clause to be ignored.
   (Bug#32202: http://bugs.mysql.com/32202)
* Altering a Falcon table to support an auto increment column on
   a column with existing data and null values would incorrectly
   update the table and return an incorrect count of the altered
   rows. (Bug#32194: http://bugs.mysql.com/32194)
* InnoDB does not support SPATIAL indexes, but could crash when
   asked to handle one. Now an error is returned.
   (Bug#32125: http://bugs.mysql.com/32125)
* The server crashed on optimizations involving a join of INT
   and MEDIUMINT columns and a system variable in the WHERE
   clause. (Bug#32103: http://bugs.mysql.com/32103)
* mysql-test-run.pl used the --user option when starting mysqld,
   which produces warnings if the current user is not root. Now
   --user is added only for root.
   (Bug#32078: http://bugs.mysql.com/32078)
* Inserting, updating and deleting a large number of BLOB records in a
   Falcon table would take significant amount of time and may prevent
   shutdown. (Bug#32062: http://bugs.mysql.com/32062)
* On 64-bit platforms, assignments of values to enumeration-valued
   storage engine-specific system variables were not validated and could
   result in unexpected values. (Bug#32034: http://bugs.mysql.com/32034)
* A DELETE statement with a subquery in the WHERE clause would sometimes
   ignore an error during subquery evaluation and proceed with the delete
   operation. (Bug#32030: http://bugs.mysql.com/32030)
* Using dates in the range '0000-00-01' to '0000-00-99' range in the
   WHERE clause could result in an incorrect result set. (These dates are
   not in the supported range for DATE, but different results for a given
   query could occur depending on position of records containing the
   dates within a table.) (Bug#32021: http://bugs.mysql.com/32021)
* User-defined functions are not loaded if the server is started
   with the --skip-grant-tables option, but the server did not
   properly handle this case and issued an Out of memory error
   message instead. (Bug#32020: http://bugs.mysql.com/32020)
* If a user-defined function was used in a SELECT statement, and
   an error occurred during UDF initialization, the error did not
   terminate execution of the SELECT, but rather was converted to
   a warning. (Bug#32007: http://bugs.mysql.com/32007)
* In debug builds, testing the result of an IN subquery against
   NULL caused an assertion failure.
   (Bug#31884: http://bugs.mysql.com/31884)
* SHOW CREATE TRIGGER caused a server crash.
   (Bug#31866: http://bugs.mysql.com/31866)
* The server crashed after insertion of a negative value into an
   AUTO_INCREMENT column of an InnoDB table.
   (Bug#31860: http://bugs.mysql.com/31860)
* For libmysqld applications, handling of mysql_change_user()
   calls left some pointers improperly updated, leading to server
   crashes. (Bug#31850: http://bugs.mysql.com/31850)
* Comparison results for BETWEEN were different from those for
   operators like < and > for DATETIME-like values with trailing
   extra characters such as '2007-10-01 00:00:00 GMT-6'.
   (Bug#31800: http://bugs.mysql.com/31800)
* With ONLY_FULL_GROUP_BY SQL mode enabled, queries such as
   SELECT a FROM t1 HAVING COUNT(*)>2 were not being rejected as
   they should have been. (Bug#31794: http://bugs.mysql.com/31794)
* The server could crash during filesort for ORDER BY based on
   expressions with INET_NTOA() or OCT() if those functions
   returned NULL. (Bug#31758: http://bugs.mysql.com/31758)
* For a fatal error during filesort in find_all_keys(), the error was
   returned without the necessary handler uninitialization, causing an
   assertion failure. Fixed by uninitializing  the  handler before
   returning the error. (Bug#31742: http://bugs.mysql.com/31742)
* The examined-rows count was not incremented for const queries.
   (Bug#31700: http://bugs.mysql.com/31700)
* Falcon tables would fail during replication if ROW-based
   replication was specified. (Bug#31671: http://bugs.mysql.com/31671)
* The mysql_change_user() C API function was subject to buffer
   overflow. (Bug#31669: http://bugs.mysql.com/31669)
* For SELECT ... INTO OUTFILE, if the ENCLOSED BY string is
   empty and the FIELDS TERMINATED BY string started with a
   special character (one of n, t, r, b, 0, Z, or N), every
   occurrence of the character within field values would be
   duplicated. (Bug#31663: http://bugs.mysql.com/31663)
* SHOW COLUMNS and DESCRIBE displayed null as the column type
   for a view with no valid definer. This caused mysqldump to
   produce a non-reloadable dump file for the view.
   (Bug#31662: http://bugs.mysql.com/31662)
* The mysqlbug script did not include the correct values of
   CFLAGS and CXXFLAGS that were used to configure the
   distribution. (Bug#31644: http://bugs.mysql.com/31644)
* For queries for which loose index scan is applicable, the
   optimizer could choose the wrong execution plan for correlated
   subqueries. (Bug#31639: http://bugs.mysql.com/31639)
* Queries that include a comparison of an INFORMATION_SCHEMA
   table column to NULL caused a server crash.
   (Bug#31633: http://bugs.mysql.com/31633)
* EXPLAIN EXTENDED for SELECT from INFORMATION_SCHEMA tables
   caused an assertion failure.
   (Bug#31630: http://bugs.mysql.com/31630)
* A buffer used when setting variables was not dimensioned to
   accommodate the trailing '\0' byte, so a single-byte buffer
   overrun was possible. (Bug#31588: http://bugs.mysql.com/31588)
* For semi-join processing, pullout of functionally dependent
   tables was not handled transitively.
   (Bug#31563: http://bugs.mysql.com/31563)
* HAVING could treat lettercase of table aliases incorrectly if
   lower_case_table_names was enabled.
   (Bug#31562: http://bugs.mysql.com/31562)
* Spurious duplicate-key errors could occur for multiple-row
   inserts into an InnoDB table that activate a trigger.
   (Bug#31540: http://bugs.mysql.com/31540)
* When inserting dates into a DATETIME column with a Falcon, the
   values would automatically be converted with values between 70
   and 99 converted to 1970-1999, and values from 00 to 69
   converted to 2000 to 2069. These dates are now correctly
   handled. (Bug#31490: http://bugs.mysql.com/31490)
* The length of the result from IFNULL() could be calculated
   incorrectly because the sign of the result was not taken into
   account. (Bug#31471: http://bugs.mysql.com/31471)
* Queries that used the ref access method or index-based subquery
   execution over indexes that have DECIMAL columns could fail with an
   error Column col_name cannot be null.
   (Bug#31450: http://bugs.mysql.com/31450)
* InnoDB now tracks locking and use of tables by MySQL only after a
   table has been successfully locked on behalf of a transaction.
   Previously, the locked flag was set and the table in-use counter was
   updated before checking whether the lock on the table succeeded.
   A subsequent failure in obtaining a lock on the table led to an
   inconsistent state as the table was neither locked nor in use.
   (Bug#31444: http://bugs.mysql.com/31444)
* SELECT 1 REGEX NULL caused an assertion failure for debug
   servers. (Bug#31440: http://bugs.mysql.com/31440)
* INFORMATION_SCHEMA.TABLES was returning incorrect information.
   (Bug#31381: http://bugs.mysql.com/31381)
* DROP USER caused an increase in memory usage.
   (Bug#31347: http://bugs.mysql.com/31347)
* TABLESPACE names within Falcon did not support characters
   outside the alpha-numeric ASCII character set.
   (Bug#31311: http://bugs.mysql.com/31311)
* For InnoDB tables with READ COMMITTED isolation level, UPDATE
   statements skipped rows locked by another transaction, rather
   than waiting for the locks to be released.
   (Bug#31310: http://bugs.mysql.com/31310)
* For an almost-full MyISAM table, an insert that failed could
   leave the table in a corrupt state.
   (Bug#31305: http://bugs.mysql.com/31305)
* When dropping Falcon tablespaces the associated tablespace
   file would not be deleted. (Bug#31296: http://bugs.mysql.com/31296)
* myisamchk --unpack could corrupt a table that when unpacked has static
   (fixed-length) row format. (Bug#31277: http://bugs.mysql.com/31277)
* Building a 64-bit binary with support for the Falcon storage
   engine using gcc on Solaris could fail. See Section 2.9,
   "MySQL Installation Using a Source Distribution," for more
   information. (Bug#31268: http://bugs.mysql.com/31268,
   Bug#33126: http://bugs.mysql.com/33126)
* When a TIMESTAMP with a non-zero time part was converted to a
   DATE value, no warning was generated. This caused index
   lookups to assume that this is a valid conversion and was
   returning rows that match a comparison between a TIMESTAMP
   value and a DATE keypart. Now a warning is generated so that
   TIMESTAMP with a non-zero time part will not match DATE
   values. (Bug#31221: http://bugs.mysql.com/31221)
* If MAKETIME() returned NULL when used in an ORDER BY that was
   evaluated using filesort, a server crash could result.
   (Bug#31160: http://bugs.mysql.com/31160)
* LAST_INSERT_ID() execution could be handled improperly in
   subqueries. (Bug#31157: http://bugs.mysql.com/31157)
* An assertion designed to detect a bug in the ROLLUP implementation
   would incorrectly be triggered when used in a subquery context with
   non-cacheable statements. (Bug#31156: http://bugs.mysql.com/31156)
* When creating a TABLESPACE that uses the same name as an existing
   TABLESPACE, Falcon would return Unknown error -103. MySQL will now
   return an error stating that the specified tablespace already exists.
   (Bug#31114: http://bugs.mysql.com/31114)
* mysqldump failed to handle databases containing a `-' character
   in the name. (Bug#31113: http://bugs.mysql.com/31113)
* Starting the server using --read-only and with the Event Scheduler
   enabled caused it to crash. (Bug#31111: http://bugs.mysql.com/31111)
* Dropping a tablespace and specifying an engine type that does not
   support tablespaces would report a warning. The response has now been
   updated to report an error. (Bug#31110: http://bugs.mysql.com/31110)
* GROUP BY NULL WITH ROLLUP could cause a server crash.
   (Bug#31095: http://bugs.mysql.com/31095)
   See also Bug#32558: http://bugs.mysql.com/32558
* A rule to prefer filesort over an indexed ORDER BY when
   accessing all rows of a table was being used even if a LIMIT
   clause was present. (Bug#31094: http://bugs.mysql.com/31094)
* REGEXP operations could cause a server crash for character sets such
   as ucs2. Now the arguments are converted to utf8 if possible, to allow
   correct results to be produced if the resulting strings contain only
   8-bit characters. (Bug#31081: http://bugs.mysql.com/31081)
* Expressions of the form WHERE col NOT IN (col, ...), where the
   same column was named both times, could cause a server crash
   in the optimizer. (Bug#31075: http://bugs.mysql.com/31075)
* Falcon would fail to compile on FreeBSD. This limitation has
   now been fixed. (Bug#31045: http://bugs.mysql.com/31045)
* Using ORDER BY with ARCHIVE tables caused a server crash.
   (Bug#31036: http://bugs.mysql.com/31036)
* The MOD() function and the % operator crashed the server for a
   divisor less than 1 with a very long fractional part.
   (Bug#31019: http://bugs.mysql.com/31019)
* Using falcon_serial_log_dir to set the location of the Falcon
   serial log would have no effect.
   (Bug#31005: http://bugs.mysql.com/31005)
* The LooseScan subquery optimization strategy could produce
   duplicate rows in query results.
   (Bug#30993: http://bugs.mysql.com/30993)
* A character set introducer followed by a hexadecimal or bit-value
   literal did not check its argument and could return an ill-formed
   result for invalid input. (Bug#30986: http://bugs.mysql.com/30986)
* CHAR(str USING charset) did not check its argument and could
   return an ill-formed result for invalid input.
   (Bug#30982: http://bugs.mysql.com/30982)
* The result from CHAR(str USING ucs2) did not add a leading
   0x00 byte for input strings with an odd number of bytes.
   (Bug#30981: http://bugs.mysql.com/30981)
* A cluster restart could sometimes fail due to an issue with
   table IDs. (Bug#30975: http://bugs.mysql.com/30975)
* The GeomFromText() function could cause a server crash if the
   first argument was NULL or the empty string.
   (Bug#30955: http://bugs.mysql.com/30955)
* When invoked with constant arguments, STR_TO_DATE() could use
   a cached value for the format string and return incorrect
   results. (Bug#30942: http://bugs.mysql.com/30942)
* GROUP_CONCAT() returned ',' rather than an empty string when
   the argument column contained only empty strings.
   (Bug#30897: http://bugs.mysql.com/30897)
* A server crash could occur if a stored function that contained
   a DROP TEMPORARY TABLE statement was invoked by a CREATE
   TEMPORARY TABLE statement that created a table of the same
   name. (Bug#30882: http://bugs.mysql.com/30882)
* Calling NAME_CONST() with non-constant arguments triggered an
   assertion failure. Non-constant arguments are now disallowed.
   (Bug#30832: http://bugs.mysql.com/30832)
* Running ALTER TABLE ... OPTIMIZE PARTITION on a Falcon table,
   a 'divide by zero' error would be reported during a server
   crash. (Bug#30826: http://bugs.mysql.com/30826)
* For a spatial column with a regular (non-SPATIAL) index,
   queries failed if the optimizer tried to use the index.
   (Bug#30825: http://bugs.mysql.com/30825)
* INFORMATION_SCHEMA.SCHEMATA was returning incorrect information.
   (Bug#30795: http://bugs.mysql.com/30795)
* On Windows, the pthread_mutex_trylock() implementation was incorrect.
   One symptom was that invalidating the query cache could cause a server
   crash. (Bug#30768: http://bugs.mysql.com/30768)
* A multiple-table UPDATE involving transactional and non-transactional
   tables caused an assertion failure.
   (Bug#30763: http://bugs.mysql.com/30763)
* Under some circumstances, CREATE TABLE ... SELECT could crash
   the server or incorrectly report that the table row size was
   too large. (Bug#30736: http://bugs.mysql.com/30736)
* Using the MIN() or MAX() function to select one part of a
   multi-part key could cause a crash when the function result
   was NULL. (Bug#30715: http://bugs.mysql.com/30715)
* INFORMATION_SCHEMA.VIEWS.VIEW_DEFINITION was incorrect for views that
   were defined to select from other INFORMATION_SCHEMA tables.
   (Bug#30689: http://bugs.mysql.com/30689)
* Issuing an ALTER SERVER statement to update the settings for a
   FEDERATED server would cause the mysqld to crash.
   (Bug#30671: http://bugs.mysql.com/30671)
* The optimizer could ignore ORDER BY in cases when the result
   set is ordered by filesort, resulting in rows being returned
   in incorrect order. (Bug#30666: http://bugs.mysql.com/30666)
* A different execution plan was displayed for EXPLAIN than
   would actually have been used for the SELECT because the test
   of sort keys for ORDER BY did not consider keys mentioned in
   IGNORE KEYS FOR ORDER BY.
   (Bug#30665: http://bugs.mysql.com/30665)
* MyISAM tables could not exceed 4294967295 (2^32 - 1) rows on
   Windows. (Bug#30638: http://bugs.mysql.com/30638)
* mysql-test-run.pl could not run mysqld with root privileges.
   (Bug#30630: http://bugs.mysql.com/30630)
* Using GROUP BY on an expression of the form timestamp_col DIV
   number caused a server crash due to incorrect calculation of
   number of decimals. (Bug#30587: http://bugs.mysql.com/30587)
* The options available to the CHECK TABLE statement were also
   allowed in OPTIMIZE TABLE and ANALYZE TABLE statements, but
   caused corruption during their execution. An error is now
   raised if you try to apply these options to these statements.
   (Bug#30495: http://bugs.mysql.com/30495)
* When expanding a * in a USING or NATURAL join, the check for
   table access for both tables in the join was done using only
   the grant information of the first table.
   (Bug#30468: http://bugs.mysql.com/30468)
* Compared to MySQL 5.1, the 6.0 optimizer failed to use join
   buffering for certain queries, resulting in slower performance
   for those queries. (Bug#30363: http://bugs.mysql.com/30363)
* A table-access check was performed improperly by libmysqld,
   causing a crash. (Bug#30329: http://bugs.mysql.com/30329)
* Some valid euc-kr characters having the second byte in the
   ranges [0x41..0x5A] and [0x61..0x7A] were rejected.
   (Bug#30315: http://bugs.mysql.com/30315)
* When loading a dynamic plugin on FreeBSD, the plugin would fail to
   load. This was due to a build error where the required symbols would
   be not exported correctly. (Bug#30296: http://bugs.mysql.com/30296)
* Setting certain values on a table using a spatial index could cause
   the server to crash. (Bug#30286: http://bugs.mysql.com/30286)
* Some INFORMATION_SCHEMA tables are intended for internal use, but
   could be accessed by using SHOW statements.
   (Bug#30079: http://bugs.mysql.com/30079)
* On some 64-bit systems, inserting the largest negative value into a
   BIGINT column resulted in incorrect data.
   (Bug#30069: http://bugs.mysql.com/30069)
* mysqlslap did not properly handle multiple result sets from
   stored procedures. (Bug#29985: http://bugs.mysql.com/29985)
* Running the sqlbench test suite against Falcon would cause a
   crash. (Bug#29870: http://bugs.mysql.com/29870)
* When accessing statistics in INFORMATION_SCHEMA.FALCON_DATABASE_IO,
   the information would relate only to the Falcon database, not user
   tablespaces. (Bug#29823: http://bugs.mysql.com/29823)
* Whitespace characters other than spaces within XML tags, such
   as linefeeds or tabs, caused LOAD XML INFILE to skip rows.
   (Bug#29752: http://bugs.mysql.com/29752)
* configure did not find nss on some Linux platforms.
   (Bug#29658: http://bugs.mysql.com/29658)
* Compilation failed on systems where a native log2() implementation was
   unavailable. (Bug#29640: http://bugs.mysql.com/29640)
* Use of the latin2_czech_cs collation caused a server crash.
   (Bug#29459: http://bugs.mysql.com/29459)
* Using two simultaneous connections it was possible to create a
   deadlock situation between two different active transactions on the
   same Falcon table. There is no way to prevent this, but a new
   parameter, falcon_lock_timeout can set the timeout for deadlocked
   transactions. The default timeout is 0 (timeouts are disabled).
   (Bug#29452: http://bugs.mysql.com/29452)
* The mysql client program now ignores Unicode byte order mark
   (BOM) characters at the beginning of input files. Previously,
   it read them and sent them to the server, resulting in a
   syntax error. (Bug#29323: http://bugs.mysql.com/29323)
* Insert information into the same table from multiple threads could
   cause duplicate key errors. This was related to the changes made to
   allow compatibility with the InnoDB repeatable-read isolation level.
   The option, falcon_innodb_compatibility, has been renamed to
   falcon_consistent_read, but with the opposite effect. The default is
   for this option to be on. When set to off, the behaviour of Falcon is
   similar to that in InnoDB. (Bug#29151: http://bugs.mysql.com/29151)
* For transactional tables, an error during a multiple-table DELETE
   statement did not roll back the statement.
   (Bug#29136: http://bugs.mysql.com/29136)
* The log and log_slow_queries system variables were displayed by SHOW
   VARIABLES but could not be accessed in expressions as @@log and
   @@log_slow_queries. (Bug#29131: http://bugs.mysql.com/29131)
* When loading large data sets using LOAD DATA INFILE into a Falcon
   table, the server could crash.
   (Bug#29081: http://bugs.mysql.com/29081)
* SHOW VARIABLES did not display the relay_log, relay_log_index,
   or relay_log_info_file system variables.
   (Bug#28893: http://bugs.mysql.com/28893)
* Index hints specified in view definitions were ignored when using the
   view to select from the base table.
   (Bug#28702: http://bugs.mysql.com/28702)
* Views do not have indexes, so index hints do not apply. Use of
   index hints when selecting from a view is now disallowed.
   (Bug#28701: http://bugs.mysql.com/28701)
* After changing the SQL mode to a restrictive value that would
   make already-inserted dates in a column be considered invalid,
   searches returned different results depending on whether the
   column was indexed. (Bug#28687: http://bugs.mysql.com/28687)
* The result from CHAR() was incorrectly assumed in some contexts to
   return a single-byte result. (Bug#28550: http://bugs.mysql.com/28550)
* Using a temporary table within Falcon that is created in a
   directory where the path contains a mixture of upper and lower
   letters would fail. (Bug#28541: http://bugs.mysql.com/28541)
* Under heavy load when updating Falcon tables, a race condition
   could occur that would ultimately result in a crash.
   (Bug#28519: http://bugs.mysql.com/28519)
* The result of a comparison between VARBINARY and BINARY
   columns differed depending on whether the VARBINARY column was
   indexed. (Bug#28076: http://bugs.mysql.com/28076)
* The metadata in some MYSQL_FIELD members could be incorrect
   when a temporary table was used to evaluate a query.
   (Bug#27990: http://bugs.mysql.com/27990)
* It was possible to create a view having a column whose name
   consisted of an empty string or space characters only.
   (Bug#27695: http://bugs.mysql.com/27695)
   See also Bug#31202: http://bugs.mysql.com/31202
* ALTER TABLE tbl_name ROW_FORMAT=format_type did not cause the
   table to be rebuilt. (Bug#27610: http://bugs.mysql.com/27610)
* Searching a Falcon table that uses DATETIME columns with an index
   could return incorrect results.
  (Bug#27426: http://bugs.mysql.com/27426)
* Removing a partition on a Falcon table when there are two
   tables with the same name, but different case, would cause a
   crash during normal shutdown. (Bug#27425: http://bugs.mysql.com/27425)
* Mixing differently cased tables between MyISAM and Falcon
   tables would cause a crash. (Bug#27424: http://bugs.mysql.com/27424)
* The ExtractValue() and UpdateXML() functions performed extremely
   slowly for large amounts of XML data (greater than 64 KB). These
   functions now execute approximately 2000 times faster than previously.
   (Bug#27287: http://bugs.mysql.com/27287)
* On Windows, writes to the debug log were using freopen() instead of
   fflush(), resulting in slower performance.
   (Bug#27099: http://bugs.mysql.com/27099)
* Connections from one mysqld server to another failed on Mac OS X,
   affecting replication and FEDERATED tables.
   (Bug#26664: http://bugs.mysql.com/26664)
   See also Bug#29083: http://bugs.mysql.com/29083
* LOAD DATA INFILE ran very slowly when reading large files into
   partitioned tables. (Bug#26527: http://bugs.mysql.com/26527)
* Threads that were calculating the estimated number of records for a
   range scan did not respond to the KILL statement. That is, if a range
   join type is possible (even if not selected by the optimizer as a join
   type of choice and thus not shown by EXPLAIN), the query in the
   statistics state (shown by the SHOW PROCESSLIST) did not respond to
   the KILL statement. (Bug#25421: http://bugs.mysql.com/25421)
* For mysql --show-warnings, warnings were in some cases not displayed.
   (Bug#25146: http://bugs.mysql.com/25146)
* Using CREATE UNIQUE INDEX on a Falcon table where rows contain
   duplicate values could result in pending transactions to the
   table being deleted. (Bug#22842: http://bugs.mysql.com/22842)
* Creating a Falcon table with an auto-increment column that is not
   indexed as the first column in a multi-column index would
   auto0increment. This behavior was different to the behavior in both
   MyISAM and InnoDB. Falcon now rejects such tables during creation in
   the same way InnoDB does. (Bug#22564: http://bugs.mysql.com/22564)
* For storage engines that do not redefine handler::index_next_same()
   and are capable of indexes, statements that include a WHERE clause
   might select incorrect data. (Bug#22351: http://bugs.mysql.com/22351)
* Creating a new table or dropping a database on a newly created
   database or tablespace where the Falcon engine was used would
   raise an error. (Bug#22199: http://bugs.mysql.com/22199)
* Using TRUNCATE on a Falcon table did not reset the auto-increment
   counters and used an inefficient method of deleting existing data.
   (Bug#22173: http://bugs.mysql.com/22173)
* Creating a DATE outside the normal range within a Falcon table
   would result in a zero DATE value being returned, even though
   normally invalid values would be stored correctly in other
   storage engines. (Bug#22168: http://bugs.mysql.com/22168)
* Selecting information from a Falcon table using a DOUBLE
   column with an index would produce incorrect results.
   (Bug#22125: http://bugs.mysql.com/22125)
* The readline library has been updated to version 5.2. This
   addresses issues in the mysql client where history and editing
   within the client would fail to work as expected.
   (Bug#18431: http://bugs.mysql.com/18431)
* mysql stripped comments from statements sent to the server.
   Now the --comments or --skip-comments option can be used to
   control whether to retain or strip comments. The default is
   --skip-comments. (Bug#11230: http://bugs.mysql.com/11230,
   Bug#26215: http://bugs.mysql.com/26215)
* Executing DISABLE KEYS and ENABLE KEYS on a non-empty table would
   cause the size of the index file for the table to grow considerably.
   (Bug#4692: http://bugs.mysql.com/4692)


Enjoy,
Daniel

-- 
Daniel Fischer, Team Lead, Build           +46 18174400 ext. 4537
MySQL GmbH, Dachauer Strasse 37, D-80335 Muenchen - www.mysql.com
Geschaeftsfuehrer: Kaj Arnoe                  HRB Muenchen 162140
Are you MySQL certified? mysql.com/certification    49.011, 8.376



Thread
MySQL 6.0.4 Alpha has been released ! (part 2 of 2)Joerg Bruehe10 Mar