MySQL Community Server 5.6.3 has been released (part 2 - bug fixes)

Dear MySQL users,

This is the list of bug fixes. For the functional enhancements, see part
1 of this mail:

Bugs fixed:

* Incompatible Change: For socket I/O, an optimization for the
case when the server used alarms for timeouts could cause a
slowdown when socket timeouts were used instead.
The fix for this issue results in several changes:

+ Previously, timeouts applied to entire packet-level send
or receive operations. Now timeouts apply to individual
I/O operations at a finer level, such as sending 10 bytes
of a given packet.

+ The handling of packets larger than max_allowed_packet
has changed. Previously, if an application sent a packet
bigger than the maximum permitted size, or if the server
failed to allocate a buffer sufficiently large to hold
the packet, the server kept reading the packet until its
end, then skipped it and returned an
ER_NET_PACKET_TOO_LARGE error. Now the server disconnects
the session if it cannot handle such large packets.

+ On Windows, the default value for the
MYSQL_OPT_CONNECT_TIMEOUT option to mysql_options() is no
longer 20 seconds. Now the default is no timeout
(infinite), the same as on other platforms.

+ Building and running MySQL on POSIX systems now requires
support for poll() and O_NONBLOCK. These should be
available on any modern POSIX system.
(Bug #54790, Bug #11762221, Bug #36225, Bug #11762221)

* InnoDB Storage Engine: Replication: Trying to update a column,
previously set to NULL, of an InnoDB table with no primary key
caused replication to fail with Can't find record in 'table'
on the slave. (Bug #11766865, Bug #60091)

* InnoDB Storage Engine: A failed CREATE INDEX operation for an
InnoDB table could result in some memory being allocated but
not freed. This memory leak could affect tables created with
the ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED setting. (Bug
#12699505)

* InnoDB Storage Engine: Stability is improved when using BLOB
values within InnoDB tables in a heavily loaded system,
especially for tables using the ROW_FORMAT=DYNAMIC or
ROW_FORMAT=COMPRESSED setting. (Bug #12612184)

* InnoDB Storage Engine: The server could halt if InnoDB
interpreted a very heavy I/O load for 15 minutes or more as an
indication that the server was hung. This change fixes the
logic that measures how long InnoDB threads were waiting,
which formerly could produce false positives. (Bug #11877216,
Bug #11755413, Bug #47183)

* InnoDB Storage Engine: With the setting
lower_case_table_names=2, inserts into InnoDB tables covered
by foreign key constraints could fail after a server restart.
(Bug #11831040, Bug #60196, Bug #60909)

* InnoDB Storage Engine: If the server crashed while an XA
transaction was prepared but not yet committed, the
transaction could remain in the system after restart, and
cause a subsequent shutdown to hang. (Bug #11766513, Bug
#59641)

* InnoDB Storage Engine: With the setting
lower_case_table_names=2, inserts into InnoDB tables covered
by foreign key constraints could fail after a server restart.
This is a similar problem to the foreign key error in Bug
#11831040 / Bug #60196 / Bug #60909, but with a different root
cause and occurring on Mac OS X.

* Partitioning: The internal get_partition_set() function did
not take into account the possibility that a key specification
could be NULL in some cases. (Bug #12380149)

* Partitioning: When executing a row-ordered retrieval index
merge, the partitioning handler used memory from that
allocated for the table, rather than that allocated to the
query, causing table object memory not to be freed until the
table was closed. (Bug #11766249, Bug #59316)

* Partitioning: Attempting to use ALTER TABLE ... EXCHANGE
PARTITION to exchange a view with a (nonexistent) partition of
a table that was not partitioned caused the server to crash.
(Bug #11766232, Bug #60039)

* Partitioning: Auto-increment columns of partitioned tables
were checked even when they were not being written to. In
debug builds, this could lead to a server crash. (Bug
#11765667, Bug #58655)

* Partitioning: The UNIX_TIMESTAMP() function was not treated as
a monotonic function for purposes of partition pruning. (Bug
#11746819, Bug #28928)

* Replication: A mistake in thread cleanup could cause a
replication master to crash. (Bug #12578441)

* Replication: When using row-based replication and attribute
promotion or demotion (see Section 15.4.1.6.2, "Replication of
Columns Having Different Data Types"), memory allocated
internally for conversion of BLOB columns was not freed
afterwards. (Bug #12558519)

* Replication: A memory leak could occur when re-creating a
missing master info repository, because a new I/O cache used
for a reference to the repository was re-created when the
repository was re-created, but the previous cache was never
removed. (Bug #12557307)

* Replication: A race condition could occur between a user
thread and the SQL thread when both tried to read the same
memory before its value was safely set. This issue has now
been corrected.
In addition, internal functions relating to creation of and
appending to log events, when storing data, used memory local
to the functions which was freed when the functions returned.
As part of the fix for this problem, the output of SHOW SLAVE
STATUS has been modified such that it no longer refers to
files or file names in the accompanying status message, but
rather contains one of the messages Making temporary file
(append) before replaying LOAD DATA INFILE or Making temporary
file (create) before replaying LOAD DATA INFILE. (Bug
#12416611)

* Replication: The name of the Ssl_verify_server_cert column in
the mysql.slave_master_info table was misspelled as
Ssl_verify_servert_cert. (Bug #12407446, Bug #60988)

* Replication: When mysqlbinlog was invoked using
--base64-output=decode-row and --start-position=pos, (where
pos is a point in the binary log past the format description
log event), a spurious error of the type shown here was
generated:
malformed binlog: it does not contain any
Format_description_log_event...
However, since there is nothing unsafe about not printing the
format description log event, the error has been removed for
this case. (Bug #12354268)

* Replication: A failed CREATE USER statement was mistakenly
written to the binary log. (Bug #11827392, Bug #60082)

* Replication: It is no longer possible to change the storage
engine used by the mysql.slave_master_info and
mysql.slave_relay_log_info tables while replication is
running. This means that, to make replication crash-safe, you
must make sure that both of these tables use a transactional
storage engine before starting replication.
For more information, see Section 15.2.2, "Replication Relay
and Status Logs," and Section 15.1.3.4, "Options for logging
slave status to tables." (Bug #11765887, Bug #58897)

* Replication: A transaction was written to the binary log even
when it did not update any nontransactional tables. (Bug
#11763471, Bug #56184)
See also Bug #11763126, Bug #55789.

* Replication: mysqlbinlog using the --raw option did not
function correctly with binary logs from MySQL Server versions
5.0.3 and earlier. (Bug #11763265, Bug #55956)

* Replication: Retrying a transaction on the slave could insert
extra data into nontransactional tables. (Bug #11763126, Bug
#55789)
See also Bug #11763471, Bug #56184.

* Replication: Typographical errors appeared in the text of
several replication error messages. (The word "position" was
misspelled as "postion".) (Bug #11762616, Bug #55229)

* Replication: Temporary deadlocks in the slave SQL thread could
cause unnecessary Deadlock found when trying to get lock; try
restarting transaction error messages to be logged on the
slave.
Now in such cases, only a warning is logged unless
slave_transaction_retries has been exceeded by the number of
such warnings for a given transaction. (Bug #11748510, Bug
#36524)

* Replication: When a slave requested a binary log file which
did not exist on master, the slave continued to request the
file regardless. This caused the slave's error log to be
flooded with low-level EE_FILENOTFOUND errors (error code 29)
from the master. (Bug #11745939, Bug #21437)

* mysqld_safe ignored any value of plugin_dir specified in
my.cnf files. (Bug #12925024)

* Partitioning: A problem with a previous fix for poor
performance of INSERT ON DUPLICATE KEY UPDATE statements on
tables having many partitions caused the handler function for
reading a row from a specific index to fail to store the ID of
the partition last used. This caused some statements to fail
with Can't find record errors. (Bug #59297, Bug #11766232)

* The metadata locking subsystem added too much overhead for
INFORMATION_SCHEMA queries that were processed by opening only
.frm or .TRG files and had to scan many tables. For example,
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRIGGERS was affected.
(Bug #12828477)

* The result for ANY subqueries with nested joins could be
missing rows. (Bug #12795555)

* Compilation failed on Mac OS X 10.7 (Lion) with a warning:
Implicit declaration of function 'pthread_init' (Bug
#12779790)

* With profiling disabled or not compiled in,
set_thd_proc_info() unnecessarily checked file name lengths.
(Bug #12756017)

* Compiling the server with maintainer mode enabled failed for
gcc 4.6 or higher. (Bug #12727287)

* Selecting SUM() combined with STRAIGHT_JOIN could produce an
incomplete result set. (Bug #12699645)

* For prepared statements, an OK could be sent to the client if
the prepare failed due to being killed. (Bug #12661349)

* Some Valgrind warnings were corrected:

+ For the SUBSTRING(), LEFT(), RIGHT(), LPAD(), RPAD(), and
REPEAT() functions, a missing NULL value check was
corrected.

+ For the LIKE operator, an attempt to use an uninitialized
string buffer in the case of an empty wildcard was
corrected.
(Bug #12634989, Bug #59851, Bug #11766684)

* Adding support for Windows authentication to libmysql
introduced a link dependency on the system Secur32 library.
The Microsoft Visual C++ link information now pulls in this
library automatically. (Bug #12612143)

* With index condition pushdown enabled, a crash could occur due
to an invalid end-of-range value. (Bug #12601961)

* The option-parsing code for empty strings leaked memory. (Bug
#12589928)

* Killing certain statements could make the server unresponsive.
(Bug #12567331)

* The server could fail to free allocated memory when INSERT
DELAYED was used with binary logging enabled. (Bug #12538873)

* A DBUG_ASSERT added by Bug #11792200 was overly aggressive in
raising assertions. (Bug #12537160)

* In some cases, memory allocated for
Query_tables_list::sroutines() was not freed properly. (Bug
#12429877)

* After the fix for Bug #11889186, MAKEDATE() arguments with a
year part greater than 9999 raised an assertion. (Bug
#12403504)

* An assertion could be raised due to a missing NULL value check
in Item_func_round::fix_length_and_dec(). (Bug #12392636)

* Assignments to NEW.var_name within triggers, where var_name
had a BLOB or TEXT type, were not properly handled and
produced incorrect results. (Bug #12362125)

* An assertion could be raised if Index Condition Pushdown code
pushed down an index condition containing a subquery. (Bug
#12355958)

* XA COMMIT could fail to clean up the error state if it
discovered that the current XA transaction had to be rolled
back. Consequently, the next XA transaction could raise an
assertion when it checked for proper cleanup of the previous
transaction. (Bug #12352846)

* An assertion could be raised during two-phase commits if the
binary log was used as the transaction coordinator log. (Bug
#12346411)

* InnoDB could add temporary index information to
INFORMATION_SCHEMA, which could raise an assertion. (Bug
#12340873)

* On Windows, the server rejected client connections if no DNS
server was available. (Bug #12325375)

* A too-strict assertion could cause a server crash. (Bug
#12321461)

* mysql_upgrade did not properly upgrade the
authentication_string column of the mysql.user table. (Bug
#11936829)

* The optimizer sometimes chose a forward index scan followed by
a filesort to reserve the order rather than scanning the index
in reverse order. (Bug #11882131)

* Previously, an inappropriate error message was produced if a
multiple-table update for an InnoDB table with a clustered
primary key would update a table through multiple aliases, and
perform an update that may physically move the row in at least
one of these aliases. Now the error message is: Primary
key/partition key update is not permitted since the table is
updated both as 'tbl_name1' and 'tbl_name2' (Bug #11882110)
See also Bug #11764529.

* Queries that used STRAIGHT_JOIN on data that included NULL
values could return incorrect results if index condition
pushdown was enabled. (Bug #11873324)

* InnoDB invoked some zlib functions without proper
initialization. (Bug #11849231)

* Division of large numbers could cause stack corruption. (Bug
#11792200)

* CHECK TABLE and REPAIR TABLE failed to find problems with
MERGE tables that had underlying tables missing or with the
wrong storage engine. Issues were reported only for the first
underlying table. (Bug #11754210)

* Replication: If a LOAD DATA INFILE statement---replicated
using statement-based replication---featured a SET clause, the
name-value pairs were regenerated using a method
(Item::print()) intended primarily for generating output for
statements such as EXPLAIN EXTENDED, and which cannot be
relied on to return valid SQL. This could in certain cases
lead to a crash on the slave.
To fix this problem, the server now names each value in its
original, user-supplied form, and uses that to create LOAD
DATA INFILE statements for statement-based replication. (Bug
#60580, Bug #11902767)
See also Bug #34283, Bug #11752526, Bug #43746.

* Replication: Error 1590 (ER_SLAVE_INCIDENT) caused the slave
to stop even when it was started with
--slave-skip-errors=1590. (Bug #59889, Bug #11768580, Bug
#11799671)

* Replication: Using the --server-id option with mysqlbinlog
could cause format description log events to be filtered from
the binary log, leaving mysqlbinlog unable to read the
remainder of the log. Now such events are always read without
regard to the value of this option.
As part of the the fix for this problem, mysqlbinlog now also
reads rotate log events without regard to the value of
--server-id. (Bug #59530, Bug #11766427)

* Replication: A failed DROP DATABASE statement could break
statement-based replication. (Bug #58381, Bug #11765416)

* Replication: Processing of corrupted table map events could
cause the server to crash. This was especially likely if the
events mapped different tables to the same identifier, such as
could happen due to Bug#56226.
Now, before applying a table map event, the server checks
whether the table has already been mapped with different
settings, and if so, an error is raised and the slave SQL
thread stops. If it has been mapped with the same settings, or
if the table is set to be ignored by filtering rules, there is
no change in behavior: the event is skipped and IDs are not
checked. (Bug #44360, Bug #11753004)
See also Bug #11763509.

* (5 DIV 2) and (5.0 DIV 2) produced different results (2 versus
3) because the result of the latter expression was not
truncated before conversion to integer. This differed from the
behavior in MySQL 5.0 and 5.1. Now both expressions produce 2.
(Bug #61676, Bug #12711164)

* The server failed to compile if partitioning support was
disabled. (Bug #61625, Bug #12694147)

* ALTER TABLE {MODIFY|CHANGE} ... FIRST did nothing except
rename columns if the old and new versions of the table had
exactly the same structure with respect to column data types.
As a result, the mapping of column name to column data was
incorrect. The same thing happened for ALTER TABLE DROP COLUMN
... ADD COLUMN statements intended to produce a new version of
the table with exactly the same structure as the old version.
(Bug #61493, Bug #12652385)

* Incorrect handling of metadata locking for FLUSH TABLES WITH
READ LOCK for statements requiring prelocking caused two
problems:

+ Execution of any data-changing statement that required
prelocking (that is, involved a stored function or
trigger) as part of a transaction slowed down somewhat
all subsequent statements in the transaction. Performance
in a transaction that periodically involved such
statements gradually degraded over time.

+ Execution of any data-changing statement that required
prelocking as part of a transaction prevented a
concurrent FLUSH TABLES WITH READ LOCK from proceeding
until the end of the transaction rather than at the end
of the particular statement.
(Bug #61401, Bug #12641342)

* A problem introduced in 5.5.11 caused very old (MySQL 4.0)
clients to be unable to connect to the server. (Bug #61222,
Bug #12563279)

* The fractional part of the "Queries per second" value could be
displayed incorrectly in MySQL status output (for example, in
the output from mysqladmin status or the mysql STATUS
command). (Bug #61205, Bug #12565712)

* The mysql-log-rotate script was updated because it referred to
deprecated MySQL options. (Bug #61038, Bug #12546842)

* Using CREATE EVENT IF NOT EXISTS for an event that already
existed and was enabled caused multiple instances of the event
to run. (Bug #61005, Bug #12546938)

* If a statement ended with mismatched quotes, the server
accepted the statement and interpreted whatever was after the
initial quote as a text string. (Bug #60993, Bug #12546960)

* LOAD DATA INFILE incorrectly parsed relative data file path
names that ascended more than three levels in the file system
and as a consequence was unable to find the file. (Bug #60987,
Bug #12403662)

* Table I/O for the Performance Schema
table_io_waits_summary_by_index_usage table was counted as
using no index for UPDATE and DELETE statements, even when an
index was used. (Bug #60905, Bug #12370950)

* An internal client macro reference was removed from the
client_plugin.h header file. This reference made the file
unusable. (Bug #60746, Bug #12325444)

* Comparison of a DATETIME stored program variable and NOW() led
to an "Illegal mix of collations error" when
character_set_connection was set to utf8. (Bug #60625, Bug
#11926811)

* Selecting from a view for which the definition included a
HAVING clause failed with an error:
1356: View '...' references invalid table(s) or column(s)
or function(s) or definer/invoker of view lack rights to use them
(Bug #60295, Bug #11829681)

* CREATE TABLE syntax permits specification of a STORAGE
{DEFAULT|DISK|MEMORY} option. However, this value was not
written to the .frm file, so that a subsequent CREATE TABLE
... LIKE for the table did not include that option.
Also, ALTER TABLE of a table that had a tablespace incorrectly
destroyed the tablespace. (Bug #60111, Bug #11766883, Bug
#34047, Bug #11747789)

* The mysql_load_client_plugin() C API function did not clear
the previous error. (Bug #60075, Bug #11766854)

* For repeated invocation of some stored procedures, the server
consumed memory that it did not release until the connection
terminated. (Bug #60025, Bug #11848763)

* The server permitted max_allowed_packet to be set lower than
net_buffer_length, which does not make sense because
max_allowed_packet is the upper limit on net_buffer_length
values. Now a warning occurs and the value remains unchanged.
(Bug #59959, Bug #11766769)

* The server did not check for certain invalid out of order
sequences of XA statements, and these sequences raised an
assertion. (Bug #59936, Bug #11766752, Bug #12348348)

* For unknown users, the native password plugin reported
incorrectly that no password had been specified even when it
had. (Bug #59792, Bug #11766641)

* SELECT DISTINCT with a deterministic stored function in the
WHERE clause could produce incorrect results. (Bug #59736, Bug
#11766594)

* Setting optimizer_join_cache_level to 3 or greater raised an
assertion for some queries. (Bug #59651, Bug #11766522)

* Previously, Performance Schema table columns that held byte
counts were BIGINT UNSIGNED. These were changed to BIGINT
(signed). This makes it easier to perform calculations that
compute differences between columns. (Bug #59631, Bug
#11766504)

* A missing variable initialization for Item_func_set_user_var
objects could raise an assertion. (Bug #59527, Bug #11766424)

* For some queries, the optimizer performed range analysis too
many times for the same index. (Bug #59415, Bug #11766327)

* With the conversion from GNU autotools to CMake for
configuring MySQL, the USE_SYMDIR preprocessor symbol was
omitted. This caused failure of symbolic links (described at
Section 7.11.3.1, "Using Symbolic Links"). (Bug #59408, Bug
#11766320)

* An incorrect max_length value for YEAR values could be used in
temporary result tables for UNION, leading to incorrect
results. (Bug #59343, Bug #11766270)

* In Item_func_in::fix_length_and_dec(), a Valgrind warning for
uninitialized values was corrected. (Bug #59270, Bug
#11766212)

* An invalid pathname argument for the --defaults-extra-file
option of MySQL programs caused a program crash. (Bug #59234,
Bug #11766184)

* In Item_func_month::val_str(), a Valgrind warning for a
too-late NULL value check was corrected. (Bug #59166, Bug
#11766126)

* In Item::get_date, a Valgrind warning for a missing NULL value
check was corrected. (Bug #59164, Bug #11766124)

* In extract_date_time(), a Valgrind warning for a missing
end-of-string check was corrected. (Bug #59151, Bug #11766112)

* Some tables were not instrumented by the Performance Schema
even though they were listed in the setup_objects table. (Bug
#59150, Bug #11766111)

* In string context, the MIN() and MAX() functions did not take
into account the unsignedness of a BIGINT UNSIGNED argument.
(Bug #59132, Bug #11766094)

* In Item_func::val_decimal, a Valgrind warning for a missing
NULL value check was corrected. (Bug #59125, Bug #11766087)

* On Windows, the authentication_string column recently added to
the mysql.user table caused the Configuration Wizard to fail.
(Bug #59038, Bug #11766011)

* In ROUND() calculations, a Valgrind warning for uninitialized
memory was corrected. (Bug #58937, Bug #11765923)

* The range created by the optimizer when OR-ing two conditions
could be incorrect, causing incorrect query results. (Bug
#58834, Bug #11765831)

* Valgrind warnings caused by comparing index values to an
uninitialized field were corrected. (Bug #58705, Bug
#11765713)

* As a side effect of optimizing condition AND TRUE or condition
OR FALSE, MySQL for certain subqueries forgot that the columns
used by the condition needed to be read, which raised an
assertion in debug builds. (Bug #58690, Bug #11765699)

* CREATE TRIGGER and DROP TRIGGER can change the prelocking list
of stored routines, but the routine cache did not detect such
changes, resulting in routine execution with an inaccurate
locking list. (Bug #58674, Bug #11765684)

* In Item_func_str_to_date::val_str, a Valgrind warning for an
uninitialized variable was corrected. (Bug #58154, Bug
#11765216)

* The code for PROCEDURE ANALYSE() had a missing DBUG_RETURN
statement, which could cause a server crash in debug builds.
(Bug #58140, Bug #11765202)

* LOAD DATA INFILE errors could leak I/O cache memory. (Bug
#58072, Bug #11765141)

* For LOAD DATA INFILE, multibyte character sequences could be
pushed onto a stack too small to accommodate them. (Bug
#58069, Bug #11765139)

* The embedded server crashed when argc = 0. (Bug #57931, Bug
#12561297)

* An assertion could be raised in
Item_func_int_val::fix_num_length_and_dec() due to overflow
for geometry functions. (Bug #57900, Bug #11764994)

* An assertion was raised if a statement tried to upgrade a
metadata lock while there was an active FLUSH TABLE tbl_list
WITH READ LOCK statement. Now if a statement tries to upgrade
a metadata lock in this situation, the server returns an
ER_TABLE_NOT_LOCKED_FOR_WRITE error to the client. (Bug
#57649, Bug #11764779)

* The optimizer sometimes requested ordered access from a
storage engine when ordered access was not required. (Bug
#57601, Bug #11764737)

* An embedded client aborted rather than issuing an error
message if it issued a TEE command (\T file_name) and the
directory containing the file did not exist. This occurred
because the wrong error handler was called. (Bug #57491, Bug
#11764633)

* ALTER EVENT could change the event status. (Bug #57156, Bug
#11764334)

* For an outer join with a NOT IN subquery in the WHERE clause,
a null left operand to the NOT IN returned was treated
differently than a literal NULL operand. (Bug #56881, Bug
#11764086)

* Threads blocked in the waiting for table metadata state were
not visible in performance_schema.THREADS or SHOW PROFILE.
(Bug #56475, Bug #11763728)

* With prepared statements, the server could attempt to send
result set metadata after the table had been closed. (Bug
#56115, Bug #11763413)

* Table objects associated with one session's optimizer
structures could be closed after being passed to another
session, prematurely ending the second session's table or
index scan. (Bug #56080, Bug #11763382)

* In some cases, SHOW WARNINGS returned an empty result when the
previous statement failed. (Bug #55847, Bug #11763166)

* A handled condition (error or warning) could be shown as not
handled at the end of the statement. (Bug #55843, Bug
#11763162)

* In debug builds, Field_new_decimal::store_value() was subject
to buffer overflows. (Bug #55436, Bug #11762799)

* For an InnoDB table, dropping and adding an index in a single
ALTER TABLE statement could fail. (Bug #54927, Bug #11762345)

* For a client connected using SSL, the Ssl_cipher_list status
variable was empty and did not show the possible cipher types.
(Bug #52596, Bug #11760210)

* The mysql client sometimes did not properly close sessions
terminated by the user with Control+C. (Bug #52515, Bug
#11760134)

* CREATE TABLE ... LIKE for a MyISAM table definition that
included an DATA DIRECTORY or INDEX DIRECTORY table option
failed, instead of creating a table with those option omitted
as documented. (Bug #52354, Bug #11759990)

* Attempts to grant the EXECUTE or ALTER ROUTINE privilege for a
nonexistent stored procedure returned success instead of an
error. (Bug #51401, Bug #11759114)

* With lower_case_table_names=2, resolution of objects qualified
by database names could fail. (Bug #50924, Bug #11758687)

* CREATE TABLE without an ENGINE option determined the default
engine at parse rather than execution time. This led to
incorrect results if the statement was executed within a
stored program and the default engine had been changed in the
meantime. (Bug #50614, Bug #11758414)

* On Linux, the mysql client built using the bundled libedit did
not read ~/.editrc. (Bug #49967, Bug #11757855)

* For some statements such as DESCRIBE or SHOW, views with too
many columns produced errors. (Bug #49437, Bug #11757397)

* The optimizer sometimes incorrectly processed HAVING clauses
for queries that did not also have an ORDER BY clause. (Bug
#48916, Bug #11756928)

* PROCEDURE ANALYZE() could leak memory for NULL results, and
could return incorrect results if used with a LIMIT clause.
(Bug #48137, Bug #11756242)

* A race condition between loading a stored routine using the
name qualified by the database name and dropping that database
resulted in a spurious error message: The table mysql.proc is
missing, corrupt, or contains bad data (Bug #47870, Bug
#11756013)

* When used to upgrade tables, mysqlcheck (and mysql_upgrade,
which invokes mysqlcheck) did not upgrade some tables for
which table repair was found to be necessary. In particular,
it failed to upgrade InnoDB tables that needed repair, leaving
them in a nonupgraded state. This occurred because:

+ mysqlcheck --check-upgrade ---auto-repair checks for
tables that are incompatible with the current version of
MySQL. It does this by issuing the CHECK TABLE ... FOR
UPGRADE statement and examining the result.

+ For any table found to be incompatible, mysqlcheck issues
a REPAIR TABLE statement. But this fails for storage
engines such as InnoDB that do not support the repair
operation. Consequently, the table remained unchanged.
To fix the problem, the following changes were made to CHECK
TABLE ... FOR UPGRADE and mysqlcheck. Because mysql_upgrade
invokes mysqlcheck, these changes also fix the problem for
mysql_upgrade.

+ CHECK TABLE ... FOR UPGRADE returns a different error if
a table needs repair but its storage engine does not
support REPAIR TABLE:
Previous:
Error: ER_TABLE_NEEDS_UPGRADE
Table upgrade required. Please do "REPAIR TABLE
`tbl_name`" or dump/reload to fix it!
Now:
Error: ER_TABLE_NEEDS_REBUILD
Table rebuild required. Please do "ALTER TABLE
`tbl_name` FORCE" or dump/reload to fix it!

+ mysqlcheck recognizes the new error and issues an ALTER
TABLE ... FORCE statement. The FORCE option for ALTER
TABLE was recognized but did nothing; now it is
implemented and acts as a "null" alter operation that
rebuilds the table.
(Bug #47205, Bug #11755431)

* On some platforms, the Incorrect value: xxx for column yyy at
row zzz error produced by LOAD DATA INFILE could have an
incorrect value of zzz. (Bug #46895, Bug #11755168)

* The mysql_affected_rows() C API function returned 3 (instead
of 2) for INSERT ... ON DUPLICATE KEY UPDATE statements where
there was a duplicated key value. (Bug #46675, Bug #11754979)

* Upgrades using an RPM package recreated the test database,
which is undesirable when the DBA had removed it. (Bug #45415,
Bug #11753896)

* In MySQL 5.1 and up, if a table had triggers that used syntax
supported in 5.0 but not 5.1, the table became unavailable.
Now the table is marked as having broken triggers. (Bug
#45235, Bug #11753738)

* An attempt to install nonexistent files during installation
was corrected. (Bug #43247, Bug #11752142)

* Some status variables rolled over to zero after reaching the
maximum 32-bit value. They have been changed to 64-bit values.
(Bug #42698, Bug #11751727)

* SHOW EVENTS did not always show events from the correct
database. (Bug #41907, Bug #11751148)

* For queries with many eq_ref joins, the optimizer took
excessive time to develop an execution plan. (Bug #41740, Bug
#11751026, Bug #58225, Bug #11765274)

* On FreeBSD 64-bit builds of the embedded server, exceptions
were not prevented from propagating into the embedded
application. (Bug #38965, Bug #11749418)

* With DISTINCT CONCAT(col_name,...) returned incorrect results
when the arguments to CONCAT() were columns with an integer
data type declared with a display width narrower than the
values in the column. (For example, if an INT(1) column
contained 1111.) (Bug #4082)

Hery Ramilison
MySQL/ORACLE Release Engineering Team





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org