Re: MySQL 6.0.4 Alpha has been released!

[Daniel Fischer]

* 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. It was not
necessary to run this statement on slaves (since the master
should track connection IDs), and the execution of this
statement by slaves was removed.
(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'. BETWEEN
treated the values as DATETIME, whereas the other operators
performed a binary-string comparison. Now they all uniformly
use a DATETIME comparison, but generate warnings for values
with trailing garbage.
(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.
Note:
This issue occurred only when the server had been built with
certain nonstandard combinations of configure options.
(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. These options were
never supported for the these statements, and 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 the statistics in
INFORMATION_SCHEMA.FALCON_DATABASE_IO, the information would
related only to the Falcon database, not user tablespaces. The
output has been updated to report on all tablespaces, and the
column title has been changed to reflect the fact that the
statistics are now reported by tablespace, not database.
(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.
Presence of a BOM does not cause mysql to change its default
character set. To do that, invoke mysql with an option such as
--default-character-set=utf8.
(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. Also, attempting to set them
with SET produced an incorrect Unknown system variable
message. Now these variables are treated as synonyms for
general_log and slow_query_log, which means that they can be
accessed in expressions and their values can be changed with
SET. (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
considerable. This was because the DISABLE KEYS operation
would only mark the existing index, without deleting the index
blocks. The ENABLE KEYS operation would re-create the index,
adding new blocks, while the previous index blocks would
remain. Existing indexes are now dropped and recreated when
the ENABLE KEYS statement is executed.
(Bug#4692: http://bugs.mysql.com/4692)


Enjoy,
Daniel

--
Daniel Fischer, MySQL Release Engineering
Oracle Corporation, http://oss.oracle.com/