LOCK TABLES
privilege checking for views was improved. (Bug #31304432, WL #14092)
-
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('')
orCONCAT_WS('')
to a variable set the variable toNULL
, not the empty string. (Bug #31320716, Bug #99485, Bug #31413167, Bug #99722)ORDER BY
queries were not executed correctly whensort_buffer_size
andmax_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)