Functionality added or changed:
Incompatible Change:
Scheduled events now use the session time zone that is current
when a CREATE EVENT or
ALTER EVENT statement executes is
used to interpret times specified in the event definition
(rather than UTC as in previous releases). The session time zone
becomes the event time zone; that is, the time zone that is used
for event scheduling and is in effect within the event as it
executes. Because of this change, scheduled event metadata now
includes time zone information, which can be seen in the
TIME_ZONE column of the
INFORMATION_SCHEMA.EVENTS table and
the Time zone column in the output of the
SHOW EVENTS statement. These
columns have been added in this release, along with a
time_zone column in the
mysql.event table. Due to these changes,
events created in previous versions of MySQL cannot be created,
viewed, or used until mysql.event has been
upgraded.
For retrievals from INFORMATION_SCHEMA.EVENTS
or SHOW EVENTS, times previously
displayed using UTC now use the event time zone.
(Bug#16420)
Bugs fixed:
Incompatible Change:
INSERT DELAYED statements are not
supported for MERGE tables, but the
MERGE storage engine was not rejecting such
statements, resulting in table corruption. Applications
previously using INSERT DELAYED
into MERGE table will break when upgrading to
versions with this fix. To avoid the problem, remove
DELAYED from such statements.
(Bug#26464)
