[pkgsrc/trunk]: pkgsrc/databases mysql56: updated to 5.6.45

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/ba981187d402
branches:  trunk
changeset: 399284:ba981187d402
user:      adam <adam%pkgsrc.org@localhost>
date:      Tue Aug 06 06:55:15 2019 +0000

description:
mysql56: updated to 5.6.45


Changes in MySQL 5.6.45:

Functionality Added or Changed

Microsoft Windows: A new warning message now reminds DBAs that connections made using the MySQL named pipe on Windows has limited the permissions a connector can request on the named pipe.

Previously, the named_pipe_full_access_group system variable was set to a value that maps to the built-in Windows Everyone group (SID S-1-1-0) by default. However, this group is not ideal and should 
be replaced with a group that restricts its membership for connectors that are unable to request fewer permissions on the MySQL named pipe.

The new warning is written to the error log at startup if the string value assigned to named_pipe_full_access_group is '*everyone*' (or the Windows System Language equivalent) and named pipes are 
enabled. In addition, the warning is written to the error log and raised to the client if the system variable is reset to the Everyone group at runtime.


Bugs Fixed

InnoDB: A query that scanned the primary key of a table did not return the expected result.

InnoDB: A full-text cache lock taken when data is synchronized was not released if the full-text cache size exceeded the full-text cache size limit.

InnoDB: Client sessions using different auto_increment_increment values while performing concurrent insert operations could cause a duplicate key error.

Replication: In query log events in the binary log, the thread ID used for the execution of DROP TABLE and DELETE statements was identified incorrectly or not at all. On a multi-threaded replication 
slave, where temporary tables were involved (which require the correct thread ID as they are session specific), this omission resulted in errors when using mysqlbinlog to replay the binary log for 
point-in-time recovery. The thread ID is now set correctly.

Installing from RPM packages could result in an error log with incorrect permissions.

Enabling audit log encryption could cause a server exit.

MySQL Installer did not install OpenSSL DLL dependencies if the Development component was not selected.

The parser could leak memory for certain multiple-statement queries.

MySQL does not support OpenSSL session tickets, but did not set the SSL_OP_NO_TICKET flag to inform OpenSSL of that. The flag is now set.

UpdateXML() did not always free memory properly in certain cases.

Empty values in the name column of the mysql.plugin system table caused the server to exit during startup.

Some PROXY grants were not replicated to slaves, causing incorrect replication.

If an INSTALL PLUGIN statement contained invalid UTF-8 characters in the shared library name, it caused the server to hang (or to raise an assertion in debug builds).

diffstat:

 databases/mysql56-client/Makefile                                           |   3 +-
 databases/mysql56-client/Makefile.common                                    |   4 +-
 databases/mysql56-client/distinfo                                           |  11 +++----
 databases/mysql56-client/patches/patch-sql-common_client__authentication.cc |  15 ----------
 databases/mysql56-server/Makefile                                           |   3 +-
 5 files changed, 9 insertions(+), 27 deletions(-)

diffs (84 lines):

diff -r 90f7b08cea1a -r ba981187d402 databases/mysql56-client/Makefile
--- a/databases/mysql56-client/Makefile Tue Aug 06 06:16:14 2019 +0000
+++ b/databases/mysql56-client/Makefile Tue Aug 06 06:55:15 2019 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.30 2019/04/30 17:20:23 abs Exp $
+# $NetBSD: Makefile,v 1.31 2019/08/06 06:55:15 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-client-/}
-PKGREVISION=   1
 COMMENT=       MySQL 5, a free SQL database (client)
 
 CONFLICTS=     mysql3-client-[0-9]*
diff -r 90f7b08cea1a -r ba981187d402 databases/mysql56-client/Makefile.common
--- a/databases/mysql56-client/Makefile.common  Tue Aug 06 06:16:14 2019 +0000
+++ b/databases/mysql56-client/Makefile.common  Tue Aug 06 06:55:15 2019 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.51 2019/06/05 09:35:18 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.52 2019/08/06 06:55:15 adam Exp $
 #
 # used by databases/mysql56-client/Makefile
 # used by databases/mysql56-server/Makefile
 
-DISTNAME=      mysql-5.6.44
+DISTNAME=      mysql-5.6.45
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.6/}
 
diff -r 90f7b08cea1a -r ba981187d402 databases/mysql56-client/distinfo
--- a/databases/mysql56-client/distinfo Tue Aug 06 06:16:14 2019 +0000
+++ b/databases/mysql56-client/distinfo Tue Aug 06 06:55:15 2019 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.51 2019/04/25 08:53:43 adam Exp $
+$NetBSD: distinfo,v 1.52 2019/08/06 06:55:15 adam Exp $
 
-SHA1 (mysql-5.6.44.tar.gz) = 7bc331b735c480fc48427e7c8986a2bb82538d6c
-RMD160 (mysql-5.6.44.tar.gz) = 6a6c0a18503e5f6b758e76c76d612a4ada3a8296
-SHA512 (mysql-5.6.44.tar.gz) = 65ace1c803773ca6c8759d171c09bc93c7d61b8e3208ac9905f82e99087622c9dcca602d2da217741dc62fc6eabe9108ebc7f31facd26705072eae65fcc37077
-Size (mysql-5.6.44.tar.gz) = 32531507 bytes
+SHA1 (mysql-5.6.45.tar.gz) = f42901c8d52297912da4978ec9422458cff72071
+RMD160 (mysql-5.6.45.tar.gz) = c711161babd1b8f9b7f96d88264a468972a83a0b
+SHA512 (mysql-5.6.45.tar.gz) = f9d8bb72e96cc83f1064fe7df2e5fe8317ca9d44c4e776cf7827a61292fbcfccec716806c80d565958383d78fef93a19d61c726687b57680d5f93299291ff168
+Size (mysql-5.6.45.tar.gz) = 32525559 bytes
 SHA1 (sphinx-2.2.11-release.tar.gz) = 34e83f43de0e69e258bf749ea00348c60a51632a
 RMD160 (sphinx-2.2.11-release.tar.gz) = 5804b4cce64bc03fa20bac26c7391cd661cecc77
 SHA512 (sphinx-2.2.11-release.tar.gz) = cf1a262a5b0fbf0bd2827ec6ec629edeaf709ce855a6e7b509b65342baaeb26c02717ca63f1578d32c83d21e2fd6d1e92dceb34660e6351b93cd96fd4e623689
@@ -33,7 +33,6 @@
 SHA1 (patch-scripts_CMakeLists.txt) = 5b44d2d137e3e64474d663a8faab5b5f289f4cf5
 SHA1 (patch-scripts_mysql__install__db.pl.in) = c2ed1705a530a0f2dfb8325496ceb7e2a9c98185
 SHA1 (patch-scripts_mysqld_safe.sh) = 0784314227657aa0bc3f4a0b4e21c173a86fa94b
-SHA1 (patch-sql-common_client__authentication.cc) = fb14e5bcb64c4d2d0b8cbbe97ff5b24b725e509e
 SHA1 (patch-sql_CMakeLists.txt) = 83c1e50de6b53a0af5ff010f248dd595745b3eb5
 SHA1 (patch-sql_log_event.h) = a413038ffa29103c75e1d243864615ccb3d9621e
 SHA1 (patch-sql_sql_string.h) = 1ce4d4db59310ea45e384f34e33c0d61935059bf
diff -r 90f7b08cea1a -r ba981187d402 databases/mysql56-client/patches/patch-sql-common_client__authentication.cc
--- a/databases/mysql56-client/patches/patch-sql-common_client__authentication.cc       Tue Aug 06 06:16:14 2019 +0000
+++ /dev/null   Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-$NetBSD: patch-sql-common_client__authentication.cc,v 1.1 2018/02/05 16:09:52 jperkin Exp $
-
-Backport upstream fix.
-
---- sql-common/client_authentication.cc.orig   2017-12-09 07:33:37.000000000 +0000
-+++ sql-common/client_authentication.cc
-@@ -84,7 +84,7 @@ RSA *rsa_init(MYSQL *mysql)
- 
-   if (mysql->options.extension != NULL &&
-       mysql->options.extension->server_public_key_path != NULL &&
--      mysql->options.extension->server_public_key_path != '\0')
-+      mysql->options.extension->server_public_key_path[0] != '\0')
-   {
-     pub_key_file= fopen(mysql->options.extension->server_public_key_path,
-                         "r");
diff -r 90f7b08cea1a -r ba981187d402 databases/mysql56-server/Makefile
--- a/databases/mysql56-server/Makefile Tue Aug 06 06:16:14 2019 +0000
+++ b/databases/mysql56-server/Makefile Tue Aug 06 06:55:15 2019 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.37 2019/04/30 17:20:23 abs Exp $
+# $NetBSD: Makefile,v 1.38 2019/08/06 06:55:15 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-server-/}
-PKGREVISION=   1
 COMMENT=       MySQL 5, a free SQL database (server)
 
 CONFLICTS=     mysql3-server-[0-9]*