Creating NDB
tables containing
BLOB
columns but no primary key caused
unpredictable behavior. (Bug #17559)
Creating an event and using a whitespace character other than
space following the DO
keyword caused a
server crash. (Bug #17453)
Previously, a stored function invocation was written to the
binary log as DO
func_name
()
if the
invocation changes data and occurs within a non-logged
statement, or if the function invokes a stored procedure that
produces an error. These invocations now are logged as
SELECT
func_name
()
instead for
better control over error code checking (slave servers could
stop due to detecting a different error than occurred on the
master). (Bug #14769)
CHECKSUM TABLE
returned different values on
MyISAM table depending on whether the QUICK
or EXTENDED
options were used. (Bug #8841)
Querying the INFORMATION_SCHEMA.partitions
table on a non-max server caused a server crash. (Bug #16591)
MySQL server dropped client connection for certain SELECT
statements against views defined that used
MERGE
algorithm. (Bug #16260)
A statement containing GROUP BY
and
HAVING
clauses could return incorrect
results when the HAVING
clause contained
logic that returned FALSE
for every row.
(Bug #14927)
Using GROUP BY
on column used in
WHERE
clause could cause empty set to be
returned. (Bug #16203)
DROP DATABASE
did not drop events for the
database. (Bug #16406)
Race conditions between event creation, dropping, and
execution could result in a server crash or hang. (Bug #17373)
SET sql_mode =
N
, where
N
> 31, did not work properly.
(Bug #13897)
Repeated invocation of my_init()
and
my_end()
caused corruption of character set
data and connection failure. (Bug #6536)
When used with the ExtractValue()
function,
an XPath expression having no leading
“/
” character would crash the
server. (Bug #16234)
A SELECT
from the last partition of a
subpartitioned table having a UNIQUE KEY
could crash the MySQL Server. (Bug #16907)
A SELECT
on a subpartitioned table having a
multiple-column PRIMARY
or UNIQUE
KEY
, and whose partitioning function used only the
first column of the key, could cause mysqld
to crash. (Bug #16901)
Using REPLACE INTO
on a partitioned table
having a primary key would crash the server in the event of a
duplicate key error. (Bug #16782)
DROP TABLE
would sometimes fail on a table
having subpartitions that used the default storage engine.
(Bug #16775)
NDB Cluster
: Sharing of table names
containing special characters between multiple SQL nodes was
not handled correctly when binary logging was enabled (a
timeout error resulted). (Bug #17415)
NDB Cluster
: Table definitions were not
shared between multiple SQL nodes in a cluster without binary
logging being enabled. (Bug #17414)
NDB Cluster
: Cluster log file paths were
truncated to 128 characters. They may now be as long as
MAX_PATH
(the maximum path length permitted
by the operating system). (Bug #17411)
SHOW CREATE EVENT
displayed no output. (Bug
#16423)
Statements that contained Unicode characters were not logged
to the log tables correctly. (Bug #16905)
On Windows platforms, some attempts to create partitioned
tables from the command line would cause the
mysql
client to hang. (Bug #17082)
NDB Cluster
: SHOW CREATE
TABLE
would fail when run against a table created in
a different session. (Bug #17340)
NDB Cluster
: Following multiple forced
shutdowns and restarts of data nodes, DROP
DATABASE
could fail. (Bug #17325)
NDB Cluster
: An UPDATE
with an inner join failed to match any records if both tables
in the join did not have a primary key. (Bug #17257)
NDB Cluster
: A DELETE
with a join in the WHERE
clause failed to
retrieve any records if both tables in the join did not have a
primary key. (Bug #17249)
The NDB Cluster
storage engine did not
allow views to be updated. (Bug #17206)
NDB Cluster
: Row-based replication of a
cluster failed to take --binlog_ignore_db
settings
into account. (Bug #17188)
Trying to create a partitioned table with more than 32
attributes failed. (Bug #17179)
NDB Cluster
: When attempting to import data
into an NDB
table using LOAD DATA
INFILE
, the server would hang in the event of a
duplicate key error. (Bug #17154)
NDB Cluster
: In some cases, LOAD
DATA INFILE
did not load all data into
NDB
tables. (Bug #17081)
NDB Cluster
: Performing large numbers of
data manipulation statements on cluster tables using Disk Data
could lead to a server crash. ()
NDB Cluster
: In some cases, a cluster using
Disk Data tables could not be restarted following a normal
shutdown. (Bug #16872)
NDB Cluster
: The REDO
log would become corrupted (and thus unreadable) in some
circumstances, due to a failure in the query handler. (Bug
#17295)
NDB Cluster
: CREATE TABLE
new_tbl
LIKE
old_tbl
;
failed when
old_tbl
used the
NDB
storage engine. (Bug #17005)
NDB Cluster
: No error message was generated
for setting NoOfFragmentLogFiles
too low.
(Bug #13966)
NDB Cluster
: No error message was generated
for setting MaxNoOfAttributes
too low. (Bug
#13965)
The SELECT
privilege was required for
triggers that performed no selects. (Bug #15196)
The UPDATE
privilege was required for
triggers that performed no updates. (Bug #15166)
CAST(... AS TIME)
operations returned
different results when using versus not using
prepared-statement protocol. (Bug #15805)
Killing a long-running query containing a subquery could cause
a server crash. (Bug #14851)
InnoDB
could display an incorrect error
message for a cascading update. (Bug #9680)
A RETURN
statement within a trigger caused
a server crash. RETURN
now is disallowed
within triggers. To exit immediately, use
LEAVE
. (Bug #16829)