[pkgsrc/trunk]: pkgsrc/databases Changes in MySQL 5.6.33 (2016-09-06)

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/6229aec30fd2
branches:  trunk
changeset: 352120:6229aec30fd2
user:      adam <adam%pkgsrc.org@localhost>
date:      Wed Sep 07 12:58:25 2016 +0000

description:
Changes in MySQL 5.6.33 (2016-09-06)

Test Suite Notes
----------------
In mysql-test-run.pl, a limit of 50 was imposed on the number of workers for parallel testing, which on systems with more than 50 CPUs resulted in exhaustion of unique thread IDs. The ID-exhaustion 
problem has been corrected, and the limit of 50 on number of workers has been lifted. Thanks to Daniel Black for the patch on which this change was based. Additionally, these changes were made:

To avoid idle workers, the number of parallel workers now is limited to the number of tests.

Previously, if --parallel=auto was given and the MTR_MAX_PARALLEL environment variable was not set, a limit of 8 was imposed on the number of parallel workers. This limit has been lifted.

(Bug 22342399, Bug 79585)

Functionality Added or Changed
------------------------------
CMake support for compiling with Solaris Studio 12.5 was added. (Bug 82249, Bug 24303829, Bug 81274, Bug 23212938)

Bugs Fixed
----------
InnoDB: An operation that dropped and created a full-text search table raised an assertion. (Bug 24315031)

InnoDB: Accessing full-text search auxiliary tables while dropping the indexed table raised an assertion. (Bug 24009272)

InnoDB: An online DDL operation on a table with indexed BLOB columns raised an assertion during logging of table modifications. (Bug 23760086)

Replication: mysqlbinlog --read-from-remote-server log1 log2 was opening a new connection for log2 without freeing the connection used for log1. Thanks to Laurynas Biveinis for the contribution. (Bug 
81675, Bug 23540182)

Replication: With binlog_row_image=FULL, when updating single tables temporary tables were unnecessarily being used. The fix ensures single table update follows the same pattern as multi-table 
update. (Bug 79867, Bug 22510353)

For mysqld_safe, the argument to --malloc-lib now must be one of the directories /usr/lib, /usr/lib64, /usr/lib/i386-linux-gnu, or /usr/lib/x86_64-linux-gnu. In addition, the --mysqld and 
--mysqld-version options can be used only on the command line and not in an option file. (Bug 24464380)

It was possible to write log files ending with .ini or .cnf that later could be parsed as option files. The general query log and slow query log can no longer be written to a file ending with .ini or 
.cnf. (Bug 24388753)

Privilege escalation was possible by exploiting the way REPAIR TABLE used temporary files. (Bug 24388746)

If the basedir system variable was set at server startup from the command line or option file, the value was not normalized (on Windows, / was not replaced with /). (Bug 23747899, Bug 82125)

In-place ALTER TABLE operations which when executed separately caused no table rebuild could when combined into a single statement result in a table rebuild. (Bug 23475211, Bug 81587)

A blank server name in CREATE SERVER statements produced a server exit rather than an error. (Bug 23295288)

A prepared statement that used a parameter in the select list of a derived table that was part of a join could cause a server exit. (Bug 22392374, Bug 24380263)

MEDIUMINT columns used in operations with long integer values could result in buffer overflow. (Bug 19984392)

A spurious ER_NO_SUCH_TABLE error could occur when attempting to execute a prepared CREATE TABLE ... SELECT statement that used a temporary table in the FROM clause and called a stored function. The 
same error could occur for a nonprepared version of the statement if used in a stored procedure when the procedure was re-executed. (Bug 16672723, Bug 68972)

EINTR handling in the client library has been fixed so that interrupted read and write calls are retried. Previously, EINTR was ignored. (Bug 82019, Bug 23703570)

diffstat:

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

diffs (107 lines):

diff -r 63844d15af12 -r 6229aec30fd2 databases/mysql56-client/Makefile.common
--- a/databases/mysql56-client/Makefile.common  Wed Sep 07 08:58:59 2016 +0000
+++ b/databases/mysql56-client/Makefile.common  Wed Sep 07 12:58:25 2016 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.34 2016/08/04 10:09:08 adam Exp $
+# $NetBSD: Makefile.common,v 1.35 2016/09/07 12:58:25 adam Exp $
 #
 # used by databases/mysql56-client/Makefile
 # used by databases/mysql56-server/Makefile
 
-DISTNAME=      mysql-5.6.32
+DISTNAME=      mysql-5.6.33
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.6/}
 
diff -r 63844d15af12 -r 6229aec30fd2 databases/mysql56-client/distinfo
--- a/databases/mysql56-client/distinfo Wed Sep 07 08:58:59 2016 +0000
+++ b/databases/mysql56-client/distinfo Wed Sep 07 12:58:25 2016 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.36 2016/08/04 10:09:08 adam Exp $
+$NetBSD: distinfo,v 1.37 2016/09/07 12:58:25 adam Exp $
 
-SHA1 (mysql-5.6.32.tar.gz) = 8a36b375389fedc691eba2ef6905a95c94f30d4c
-RMD160 (mysql-5.6.32.tar.gz) = 3295ef5f2a5cc937a010ce0f93565e6e04673f58
-SHA512 (mysql-5.6.32.tar.gz) = 5af7aaabc1da7d12d16538c89552179423d7f7e2024bc55e75d2f26c99db4fe339e0a1f605e767f91f40dfecee3bcce31c83499a2278204b0f7f24c3411c0d15
-Size (mysql-5.6.32.tar.gz) = 32095208 bytes
+SHA1 (mysql-5.6.33.tar.gz) = 4f1c2e25ce681f92862a75ad52012fbe4017bf42
+RMD160 (mysql-5.6.33.tar.gz) = 2fa192fa1cec9d791cfa9b7347cb5cd9adc7944f
+SHA512 (mysql-5.6.33.tar.gz) = d6f96dfd379b7ddaf3897a04ad756169a9d71319894551cba561e5ab2298dc21526004f656f50850c81bbe52af158926f87badc34d07b2b92107bc136e08359a
+Size (mysql-5.6.33.tar.gz) = 32094894 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 63844d15af12 -r 6229aec30fd2 databases/mysql56-server/PLIST
--- a/databases/mysql56-server/PLIST    Wed Sep 07 08:58:59 2016 +0000
+++ b/databases/mysql56-server/PLIST    Wed Sep 07 12:58:25 2016 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.25 2016/08/04 10:09:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.26 2016/09/07 12:58:25 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -640,7 +640,6 @@
 share/mysql/test/include/ps_query.inc
 share/mysql/test/include/ps_renew.inc
 share/mysql/test/include/purge_first_log.inc
-share/mysql/test/include/python_with_json.inc
 share/mysql/test/include/query_cache.inc
 share/mysql/test/include/query_cache_sql_prepare.inc
 share/mysql/test/include/rand.inc
@@ -1686,6 +1685,7 @@
 share/mysql/test/r/varbinary.result
 share/mysql/test/r/variables-big.result
 share/mysql/test/r/variables-notembedded.result
+share/mysql/test/r/variables-win.result
 share/mysql/test/r/variables.result
 share/mysql/test/r/variables_community.result
 share/mysql/test/r/variables_debug.result
@@ -3500,6 +3500,7 @@
 share/mysql/test/suite/innodb/r/innodb-index-debug.result
 share/mysql/test/suite/innodb/r/innodb-index-online-delete.result
 share/mysql/test/suite/innodb/r/innodb-index-online-fk.result
+share/mysql/test/suite/innodb/r/innodb-index-online-norebuild.result
 share/mysql/test/suite/innodb/r/innodb-index-online-purge.result
 share/mysql/test/suite/innodb/r/innodb-index-online.result
 share/mysql/test/suite/innodb/r/innodb-index.result
@@ -3704,6 +3705,7 @@
 share/mysql/test/suite/innodb/t/innodb-index-online-delete.test
 share/mysql/test/suite/innodb/t/innodb-index-online-fk.test
 share/mysql/test/suite/innodb/t/innodb-index-online-master.opt
+share/mysql/test/suite/innodb/t/innodb-index-online-norebuild.test
 share/mysql/test/suite/innodb/t/innodb-index-online-purge.test
 share/mysql/test/suite/innodb/t/innodb-index-online.test
 share/mysql/test/suite/innodb/t/innodb-index.test
@@ -5012,7 +5014,7 @@
 share/mysql/test/suite/opt_trace/t/subquery_no_prot.test
 share/mysql/test/suite/opt_trace/t/subquery_ps_prot.test
 share/mysql/test/suite/opt_trace/t/temp_table.test
-share/mysql/test/suite/opt_trace/validate_json.py
+share/mysql/test/suite/opt_trace/validate_json.pl
 share/mysql/test/suite/parts/inc/methods1.inc
 share/mysql/test/suite/parts/inc/part_blocked_sql_funcs_main.inc
 share/mysql/test/suite/parts/inc/part_exch_drop_tabs.inc
@@ -5482,7 +5484,6 @@
 share/mysql/test/suite/perfschema/include/upgrade_check.inc
 share/mysql/test/suite/perfschema/include/wait_for_pfs_thread_count.inc
 share/mysql/test/suite/perfschema/include/wait_till_sleep.inc
-share/mysql/test/suite/perfschema/r/aggregate.result
 share/mysql/test/suite/perfschema/r/all_tests.result
 share/mysql/test/suite/perfschema/r/bad_option_1.result
 share/mysql/test/suite/perfschema/r/bad_option_2.result
@@ -5800,7 +5801,6 @@
 share/mysql/test/suite/perfschema/r/trigger_table_io.result
 share/mysql/test/suite/perfschema/r/unary_digest.result
 share/mysql/test/suite/perfschema/r/view_table_io.result
-share/mysql/test/suite/perfschema/t/aggregate.test
 share/mysql/test/suite/perfschema/t/all_tests.test
 share/mysql/test/suite/perfschema/t/bad_option_1.test
 share/mysql/test/suite/perfschema/t/bad_option_2.test
@@ -9796,6 +9796,7 @@
 share/mysql/test/t/variables-master.opt
 share/mysql/test/t/variables-notembedded-master.opt
 share/mysql/test/t/variables-notembedded.test
+share/mysql/test/t/variables-win.test
 share/mysql/test/t/variables.test
 share/mysql/test/t/variables_community.test
 share/mysql/test/t/variables_debug.test