--- - branch: MAIN date: Sun Apr 29 21:44:12 UTC 2018 files: - new: '1.14' old: '1.13' path: pkgsrc/databases/mysql57-client/Makefile pathrev: pkgsrc/databases/mysql57-client/Makefile@1.14 type: modified - new: '1.11' old: '1.10' path: pkgsrc/databases/mysql57-client/Makefile.common pathrev: pkgsrc/databases/mysql57-client/Makefile.common@1.11 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/mysql57-client/PLIST pathrev: pkgsrc/databases/mysql57-client/PLIST@1.8 type: modified - new: '1.19' old: '1.18' path: pkgsrc/databases/mysql57-client/distinfo pathrev: pkgsrc/databases/mysql57-client/distinfo@1.19 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/mysql57-client/patches/patch-cmake_boost.cmake pathrev: pkgsrc/databases/mysql57-client/patches/patch-cmake_boost.cmake@1.8 type: modified - new: '0' old: '1.1' path: pkgsrc/databases/mysql57-client/patches/patch-mysys__ssl_CMakeLists.txt pathrev: pkgsrc/databases/mysql57-client/patches/patch-mysys__ssl_CMakeLists.txt@0 type: deleted - new: '1.3' old: '1.2' path: pkgsrc/databases/mysql57-client/patches/patch-rapid_plugin_x_CMakeLists.txt pathrev: pkgsrc/databases/mysql57-client/patches/patch-rapid_plugin_x_CMakeLists.txt@1.3 type: modified - new: '1.2' old: '1.1' path: pkgsrc/databases/mysql57-client/patches/patch-rapid_unittest_gunit_xplugin_CMakeLists.txt pathrev: pkgsrc/databases/mysql57-client/patches/patch-rapid_unittest_gunit_xplugin_CMakeLists.txt@1.2 type: modified - new: '1.16' old: '1.15' path: pkgsrc/databases/mysql57-server/Makefile pathrev: pkgsrc/databases/mysql57-server/Makefile@1.16 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/mysql57-server/PLIST pathrev: pkgsrc/databases/mysql57-server/PLIST@1.8 type: modified id: 20180429T214412Z.9409ecb31616c7beff2160832fb135ba67d5b1f5 log: | 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 module: pkgsrc subject: 'CVS commit: pkgsrc/databases' unixtime: '1525038252' user: adam