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:
RevisionActionfile
1.14modifypkgsrc/databases/mysql57-client/Makefile
1.11modifypkgsrc/databases/mysql57-client/Makefile.common
1.8modifypkgsrc/databases/mysql57-client/PLIST
1.19modifypkgsrc/databases/mysql57-client/distinfo
1.8modifypkgsrc/databases/mysql57-client/patches/patch-cmake_boost.cmake
1.3modifypkgsrc/databases/mysql57-client/patches/patch-rapid_plugin_x_CMakeLists.txt
1.2modifypkgsrc/databases/mysql57-client/patches/patch-rapid_unittest_gunit_xplugin_CMakeLists.txt
1.16modifypkgsrc/databases/mysql57-server/Makefile
1.8modifypkgsrc/databases/mysql57-server/PLIST
1.1removepkgsrc/databases/mysql57-client/patches/patch-mysys__ssl_CMakeLists.txt