MySQL 5.6 Release Notes
LOCK TABLES
privilege checking
for views was improved.
(Bug #31304432)
InnoDB:
In session started with START TRANSACTION WITH
CONSISTENT SNAPSHOT
, a range query returned a
truncated result. The end range flag was not reset at the
beginning of the index read resulting in an aborted read and
missing rows.
(Bug #30950714, Bug #98642)
References: This issue is a regression of: Bug #23481444.
In bootstrapping mode, certain multiple-statement transactions could cause unexpected server behavior. (Bug #31650096)
Assigning CONCAT('')
or
CONCAT_WS('')
to a variable set
the variable to NULL
, not the empty string.
(Bug #31320716, Bug #99485, Bug #31413167, Bug #99722)
ORDER BY
queries were not executed correctly
when sort_buffer_size
and
max_sort_length
were set to
values which caused the internal limit on the maximum number of
keys allowed per sort buffer to be set to 0.
(Bug #30175483)
The internal method Field_tiny::pack()
did
not always perform bounds checking as expected.
(Bug #29948029)
References: See also: Bug #31591391.
A large number of nested arguments in full-text search query caused an error. (Bug #29929684)
An assertion could be raised when the SQL layer passed incorrect
information to InnoDB
about the type of
operation to be performed on a temporary table.
(Bug #22503696)