Path to this page:
Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2018-04-29 23:44:12
Message id: 20180429214412.BEA8DFBEC@cvs.NetBSD.org
Log Message:
mysql57: updated to 5.7.22
Changes in MySQL 5.7.22:
Deprecation and Removal Notes
These compatibility SQL modes are now deprecated and will be removed in MySQL \
8.0: DB2, MAXDB, MSSQL, MYSQL323, MYSQL40, ORACLE, POSTGRESQL, NO_FIELD_OPTIONS, \
NO_KEY_OPTIONS, NO_TABLE_OPTIONS. These deprecations have two implications:
Assigning a deprecated mode to the sql_mode system variable produces a warning.
With the MAXDB SQL mode enabled, using CREATE TABLE or ALTER TABLE to add a \
TIMESTAMP column to a table produces a warning.
Statements that use these deprecated SQL modes may fail when replicated from a \
MySQL 5.7 master to a MySQL 8.0 slave, or may have different effects on master \
and slave. To avoid such problems, applications that use the modes deprecated in \
MySQL 5.7 should be revised not to use them.
Test Suite Notes
Reduction of compiler and platform differences in GIS handling of floating-point \
results enables simplification of related test cases that no longer need \
rounding to avoid spurious test failures.
X Plugin Notes
X Plugin connection attempts using the X Protocol did not return an error when \
the default database specified in the connection options was invalid, and the \
connection was allowed with a null default database. Connection attempts using \
the classic MySQL protocol did return an error and disallowed the connection. X \
Protocol connection attempts now also disallow the connection if an invalid \
schema is specified.
Functionality Added or Changed
Replication: Changes introduced in version 8 which enable XCom to identify \
members using the concept of an incarnation have been merged in to version 5.7. \
These underlying changes add a UUID to members each time they join a group and \
this information can be used to distinguish among different member incarnations.
Replication: It is now possible to specify whether information written into the \
binary log enables replication slaves to parallelize based on commit timestamps, \
or on transaction write sets.
JSON: The JSON_MERGE() function is renamed to JSON_MERGE_PRESERVE().
JSON: Added the JSON utility function JSON_PRETTY(), which prints an existing \
JSON value, or any string that can successfully be parsed as a JSON document, in \
a format that can be easily read by humans. Each JSON object member or array \
value is displayed on a separate line of the output; each child object or array \
is intended 2 spaces with respect to its parent.
Bugs Fixed
Files: