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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/1273c2937180
branches:  trunk
changeset: 374138:1273c2937180
user:      adam <adam%pkgsrc.org@localhost>
date:      Tue Jan 16 16:27:12 2018 +0000

description:
mysql56: updated to 5.6.39

MySQL 5.6.39

Configuration Notes
* For RHEL, SLES, and Fedora RPMs, the default plugin directory for debug builds has been changed from /usr/lib64/mysql/plugin to /usr/lib64/mysql/plugin/debug.

Security Notes
* Incompatible Change: Passwords are now restricted to a maximum of 256 characters for the sha256_password authentication plugin, and for the PASSWORD() function when old_passwords=2. Also, the 
number of password hashing rounds is capped to limit CPU time used.
* The linked OpenSSL library for the MySQL Commercial Server has been updated to version 1.0.2n. Issues fixed in the new OpenSSL version are described at 
http://www.openssl.org/news/vulnerabilities.html.
* This change does not affect the Oracle-produced MySQL Community build of MySQL Server, which uses the yaSSL library instead.

Test Suite Notes
* Documentation for the MySQL Test Suite is now maintained in the MySQL source tree using Doxygen (see http://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_MYSQL_TEST_RUN.html). The related Unix man 
pages that previously were produced from the old test suite manual are no longer updated and have gone out of date. Consequently, they are no longer included in MySQL distributions.

Bugs Fixed
* InnoDB: An ALTER TABLE operation caused the server to halt.
* InnoDB: A FLUSH TABLES operation failed to drop an aborted index. While removing the table from the cache, the clustered index was dropped prior to checking for the aborted index.
* InnoDB: Warnings that should only appear in a debug version of MySQL were printed to the error log when the length of the history list exceeded 2000000.
* InnoDB: Full-text search on indexed columns that use a binary collation did not return case sensitive matches.
* Partitioning: In certain cases when fetching heap records a partition ID could be set to zero.
* Replication: With semisynchronous replication in use, if RESET MASTER was issued while an active transaction was waiting for an acknowledgement from the slave, the count of waiting sessions in the 
Rpl_semi_sync_master_wait_sessions server status variable was incorrect after the wait was completed.
* Microsoft Windows: On Windows, with the myisam_use_mmap and flush system variables enabled, MyISAM did not always flush table files properly.
* Microsoft Windows: On Windows, resolution was improved of a timer used for query performance assessment.
* VALUES() was not handled correctly in some cases.
* The Performance Schema now stores rewritten rather than raw SQL statement text when available.
* Incorrect results or a server exit could result when SHA2() was passed a user-defined variable in some character sets.
* Creating a table with excessive index information could cause a server exit.
* REFERENCES privilege checking could use the incorrect database in some cases.
* Some statements could cause a buffer overflow in the digest code. Thanks to Laurynas Biveinis and Roel van de Paar for the patch.
* Incorrect results could occur on a table with a unique index when the optimizer chose a loose index scan even though the unique index had no index extensions.
* Executing a stored procedure containing a statement that created a table from the contents of certain SELECT statements could result in a memory leak.
* For geometry calculations, invalid input parameters could lead to an incorrect result buffer and cause an assertion to be raised or a server exit.
* Setting the MYSQL_GROUP_SUFFIX environment variable had no effect.
* A circular dependency problem involving sql/sql_builtin.cc was resolved.
* A prepared statement containing an ORDER BY list that referred to a parameter was not always handled correctly.

diffstat:

 databases/mysql56-client/Makefile.common |   8 ++++----
 databases/mysql56-client/distinfo        |  10 +++++-----
 databases/mysql56-server/PLIST           |   6 +++++-
 3 files changed, 14 insertions(+), 10 deletions(-)

diffs (85 lines):

diff -r 647d502a8cee -r 1273c2937180 databases/mysql56-client/Makefile.common
--- a/databases/mysql56-client/Makefile.common  Tue Jan 16 16:23:20 2018 +0000
+++ b/databases/mysql56-client/Makefile.common  Tue Jan 16 16:27:12 2018 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.43 2017/10/22 20:18:04 adam Exp $
+# $NetBSD: Makefile.common,v 1.44 2018/01/16 16:27:12 adam Exp $
 #
 # used by databases/mysql56-client/Makefile
 # used by databases/mysql56-server/Makefile
 
-DISTNAME=      mysql-5.6.38
+DISTNAME=      mysql-5.6.39
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.6/}
 
@@ -11,8 +11,8 @@
 HOMEPAGE=      https://www.mysql.com/
 LICENSE=       gnu-gpl-v2
 
-DISTINFO_FILE?=                ${.CURDIR}/../../databases/mysql56-client/distinfo
-PATCHDIR?=             ${.CURDIR}/../../databases/mysql56-client/patches
+DISTINFO_FILE?=        ${.CURDIR}/../../databases/mysql56-client/distinfo
+PATCHDIR?=     ${.CURDIR}/../../databases/mysql56-client/patches
 
 USE_CMAKE=             yes
 USE_LANGUAGES=         c c++
diff -r 647d502a8cee -r 1273c2937180 databases/mysql56-client/distinfo
--- a/databases/mysql56-client/distinfo Tue Jan 16 16:23:20 2018 +0000
+++ b/databases/mysql56-client/distinfo Tue Jan 16 16:27:12 2018 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.44 2017/10/22 20:18:04 adam Exp $
+$NetBSD: distinfo,v 1.45 2018/01/16 16:27:12 adam Exp $
 
-SHA1 (mysql-5.6.38.tar.gz) = bbd89dc891799b84ca0228e996bda1ec5365b38a
-RMD160 (mysql-5.6.38.tar.gz) = e2db45ccba30335cb71dedb7f25d199ce51b0dcd
-SHA512 (mysql-5.6.38.tar.gz) = 8144aec822f053fbdfa11ae542e96d3e7da93552b60ed131f041ec4832f48c95025b322340a2e90a82c18b6ee6bfd708f209735f82e37532198245aad697b93d
-Size (mysql-5.6.38.tar.gz) = 32197625 bytes
+SHA1 (mysql-5.6.39.tar.gz) = 8f69162cfcfb031e0e60f85e46182548a4e34b41
+RMD160 (mysql-5.6.39.tar.gz) = 5b1eb6a5cd696112ec925b5d26dcf67dce7adc08
+SHA512 (mysql-5.6.39.tar.gz) = e1e60854c82d71f9600bf611df964f441815d9d0f896134110a749b29fe340fa216d7c89f4da63d492929565f19a2502463549b8c8c038c658e0be8409a3ffb5
+Size (mysql-5.6.39.tar.gz) = 32110958 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 647d502a8cee -r 1273c2937180 databases/mysql56-server/PLIST
--- a/databases/mysql56-server/PLIST    Tue Jan 16 16:23:20 2018 +0000
+++ b/databases/mysql56-server/PLIST    Tue Jan 16 16:27:12 2018 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.30 2017/07/19 18:48:21 adam Exp $
+@comment $NetBSD: PLIST,v 1.31 2018/01/16 16:27:12 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -3709,6 +3709,7 @@
 share/mysql/test/suite/innodb/r/sp_temp_table.result
 share/mysql/test/suite/innodb/r/strict_checksum.result
 share/mysql/test/suite/innodb/r/strict_mode.result
+share/mysql/test/suite/innodb/r/timestamp.result
 share/mysql/test/suite/innodb/r/tmpdir.result
 share/mysql/test/suite/innodb/r/undo_space_id.result
 share/mysql/test/suite/innodb/r/xa_recovery.result
@@ -3953,6 +3954,7 @@
 share/mysql/test/suite/innodb/t/sp_temp_table.test
 share/mysql/test/suite/innodb/t/strict_checksum.test
 share/mysql/test/suite/innodb/t/strict_mode.test
+share/mysql/test/suite/innodb/t/timestamp.test
 share/mysql/test/suite/innodb/t/tmpdir.test
 share/mysql/test/suite/innodb/t/undo_space_id.test
 share/mysql/test/suite/innodb/t/xa_recovery.test
@@ -6402,6 +6404,7 @@
 share/mysql/test/suite/rpl/r/rpl_do_grant.result
 share/mysql/test/suite/rpl/r/rpl_do_table_filter_insensitive.result
 share/mysql/test/suite/rpl/r/rpl_do_table_filter_sensitive.result
+share/mysql/test/suite/rpl/r/rpl_double_free_bug.result
 share/mysql/test/suite/rpl/r/rpl_drop.result
 share/mysql/test/suite/rpl/r/rpl_drop_db.result
 share/mysql/test/suite/rpl/r/rpl_drop_db_fail.result
@@ -6909,6 +6912,7 @@
 share/mysql/test/suite/rpl/t/rpl_do_table_filter_insensitive.test
 share/mysql/test/suite/rpl/t/rpl_do_table_filter_sensitive-slave.opt
 share/mysql/test/suite/rpl/t/rpl_do_table_filter_sensitive.test
+share/mysql/test/suite/rpl/t/rpl_double_free_bug.test
 share/mysql/test/suite/rpl/t/rpl_drop.test
 share/mysql/test/suite/rpl/t/rpl_drop_db.test
 share/mysql/test/suite/rpl/t/rpl_drop_db_fail.test