[pkgsrc/trunk]: pkgsrc/databases Update MySQL 5.6 to 5.6.50.

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/8854240b1da3
branches:  trunk
changeset: 441085:8854240b1da3
user:      jnemeth <jnemeth%pkgsrc.org@localhost>
date:      Sun Oct 25 22:38:58 2020 +0000

description:
Update MySQL 5.6 to 5.6.50.

Note that the 5.6 series will be end of life in February 2021.  The
current major version is 8.0, which isn't in pkgsrc yet.  You CAN NOT
upgrade directly from 5.6 to 8.0, therefore it is recommended for anybody
running 5.6 to upgrade to this version, then upgrade to 5.7.

Changes in MySQL 5.6.50 (2020-10-19, General Availability)

Functionality Added or Changed

    LOCK TABLES privilege checking for views was improved. (Bug #31304432)

Bugs Fixed

    InnoDB: In session started with START TRANSACTION WITH CONSISTENT
    SNAPSHOT, a range query returned a truncated result. The end
    range flag was not reset at the beginning of the index read
    resulting in an aborted read and missing rows. (Bug #30950714,
    Bug #98642)

    References: This issue is a regression of: Bug #23481444.

    In bootstrapping mode, certain multiple-statement transactions
    could cause unexpected server behavior. (Bug #31650096)

    Assigning CONCAT('') or CONCAT_WS('') to a variable set the
    variable to NULL, not the empty string. (Bug #31320716, Bug
    #99485, Bug #31413167, Bug #99722)

    ORDER BY queries were not executed correctly when sort_buffer_size
    and max_sort_length were set to values which caused the internal
    limit on the maximum number of keys allowed per sort buffer to
    be set to 0. (Bug #30175483)

    The internal method Field_tiny::pack() did not always perform
    bounds checking as expected. (Bug #29948029)

    References: See also: Bug #31591391.

    A large number of nested arguments in full-text search query
    caused an error. (Bug #29929684)

    An assertion could be raised when the SQL layer passed incorrect
    information to InnoDB about the type of operation to be performed
    on a temporary table. (Bug #22503696)

diffstat:

 databases/mysql56-client/Makefile        |   4 ++--
 databases/mysql56-client/Makefile.common |   4 ++--
 databases/mysql56-client/distinfo        |  10 +++++-----
 databases/mysql56-server/Makefile        |   4 ++--
 databases/mysql56-server/PLIST           |   4 ++--
 5 files changed, 13 insertions(+), 13 deletions(-)

diffs (77 lines):

diff -r 2b8051107339 -r 8854240b1da3 databases/mysql56-client/Makefile
--- a/databases/mysql56-client/Makefile Sun Oct 25 19:34:04 2020 +0000
+++ b/databases/mysql56-client/Makefile Sun Oct 25 22:38:58 2020 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.36 2020/08/31 18:06:56 wiz Exp $
+# $NetBSD: Makefile,v 1.37 2020/10/25 22:38:58 jnemeth Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-client-/}
-PKGREVISION=   1
+#PKGREVISION=  1
 COMMENT=       MySQL 5, a free SQL database (client)
 
 CONFLICTS=     mysql3-client-[0-9]*
diff -r 2b8051107339 -r 8854240b1da3 databases/mysql56-client/Makefile.common
--- a/databases/mysql56-client/Makefile.common  Sun Oct 25 19:34:04 2020 +0000
+++ b/databases/mysql56-client/Makefile.common  Sun Oct 25 22:38:58 2020 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.58 2020/08/05 14:38:33 adam Exp $
+# $NetBSD: Makefile.common,v 1.59 2020/10/25 22:38:58 jnemeth Exp $
 #
 # used by databases/mysql56-client/Makefile
 # used by databases/mysql56-server/Makefile
 
-DISTNAME=      mysql-5.6.49
+DISTNAME=      mysql-5.6.50
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.6/}
 
diff -r 2b8051107339 -r 8854240b1da3 databases/mysql56-client/distinfo
--- a/databases/mysql56-client/distinfo Sun Oct 25 19:34:04 2020 +0000
+++ b/databases/mysql56-client/distinfo Sun Oct 25 22:38:58 2020 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.57 2020/08/05 14:38:33 adam Exp $
+$NetBSD: distinfo,v 1.58 2020/10/25 22:38:58 jnemeth Exp $
 
-SHA1 (mysql-5.6.49.tar.gz) = 52756ac68684a5dc04940a2e33786c626ef3b163
-RMD160 (mysql-5.6.49.tar.gz) = 42c4d1bc553133438f3367e0aa8b537b135c3e78
-SHA512 (mysql-5.6.49.tar.gz) = 073722644a65ce8f06f71331b3dc77269d1a83a927d11502c90683f4c6e47a100f00cdc4d3d1e5817a85a98d2a49d051867d391fb0fbffd869568ac26f07b73d
-Size (mysql-5.6.49.tar.gz) = 32402099 bytes
+SHA1 (mysql-5.6.50.tar.gz) = 90ac210ad609e3e922ec10b0789222a88cbcd4d6
+RMD160 (mysql-5.6.50.tar.gz) = e95ba4b422b57d19c4d7f322da5e160049a5f28a
+SHA512 (mysql-5.6.50.tar.gz) = ea8f2c7348acda8454f2f090886c2f92042b4b1ee0407bfa6c19ed11859cedacdba124667dc52585a324f2292deb367888c0abb74f4e58a972f65d5fcc8302c6
+Size (mysql-5.6.50.tar.gz) = 32409084 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
diff -r 2b8051107339 -r 8854240b1da3 databases/mysql56-server/Makefile
--- a/databases/mysql56-server/Makefile Sun Oct 25 19:34:04 2020 +0000
+++ b/databases/mysql56-server/Makefile Sun Oct 25 22:38:58 2020 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.44 2020/08/31 18:06:56 wiz Exp $
+# $NetBSD: Makefile,v 1.45 2020/10/25 22:38:58 jnemeth Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-server-/}
-PKGREVISION=   1
+#PKGREVISION=  1
 COMMENT=       MySQL 5, a free SQL database (server)
 
 CONFLICTS=     mysql3-server-[0-9]*
diff -r 2b8051107339 -r 8854240b1da3 databases/mysql56-server/PLIST
--- a/databases/mysql56-server/PLIST    Sun Oct 25 19:34:04 2020 +0000
+++ b/databases/mysql56-server/PLIST    Sun Oct 25 22:38:58 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.38 2020/08/05 14:38:33 adam Exp $
+@comment $NetBSD: PLIST,v 1.39 2020/10/25 22:38:58 jnemeth Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -1800,7 +1800,7 @@
 share/mysql/test/std_data/crl-client-revoked.crl
 share/mysql/test/std_data/crl-server-cert.pem
 share/mysql/test/std_data/crl-server-key.pem
-share/mysql/test/std_data/crldir/b23bb52f.r0
+share/mysql/test/std_data/crldir/5df06fcb.r0
 share/mysql/test/std_data/des_key_file
 share/mysql/test/std_data/dtrace.d
 share/mysql/test/std_data/funcs_1/innodb_tb1.txt