pkgsrc-Changes-HG archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

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



details:   https://anonhg.NetBSD.org/pkgsrc/rev/b1e37dc5f575
branches:  trunk
changeset: 325622:b1e37dc5f575
user:      adam <adam%pkgsrc.org@localhost>
date:      Thu Nov 22 11:53:33 2018 +0000

description:
mysql56: updated to 5.6.42

Changes in MySQL 5.6.42

Functionality Added or Changed

* Previously, file I/O performed in the I/O cache in the mysys library was not instrumented, affecting in particular file I/O statistics reported by the Performance Schema about the binary log index 
file. Now, this I/O is instrumented and Performance Schema statistics are accurate. Thanks to Yura Sorokin for the contribution.

* The zlib library version bundled with MySQL was raised from version 1.2.3 to version 1.2.11. MySQL implements compression with the help of the zlib library.

* The zlib compressBound() function in zlib 1.2.11 returns a slightly higher estimate of the buffer size required to compress a given length of bytes than it did in zlib version 1.2.3. The 
compressBound() function is called by InnoDB functions that determine the maximum row size permitted when creating compressed InnoDB tables or inserting rows into compressed InnoDB tables. As a 
result, CREATE TABLE ... ROW_FORMAT=COMPRESSED or INSERT operations with row sizes very close to the maximum row size that were successful in earlier releases could now fail.

Bugs Fixed

* InnoDB: An ALTER TABLE operation that added a primary key produced a segmentation fault.

* InnoDB: An assertion was raised during an OPTIMIZE TABLE operation.

* InnoDB: A foreign key constraint name was duplicated during a rename table operation, causing a failure during later query execution.

* InnoDB: The location of the Innodb Merge Temp File that reported by the wait/io/file/innodb/innodb_temp_file Performance Schema instrument was incorrect.

* Replication: When FLUSH statements for specific log types (such as FLUSH SLOW LOGS) resulted in an error, the statements were still written to the binary log. This stopped replication because the 
error had occurred on the master, but did not occur on the slave. MySQL Server now checks on the outcome of these FLUSH statements, and if an error occurred, the statement is not written to the 
binary log.

* Microsoft Windows: On Windows, uninstallation of the MySQL Server MSI package through MySQL Installer produced a spurious popup window.

* Concurrent INSERT and SELECT statements on a MERGE table could result in a server exit.

* MySQL Server and test RPM packages were missing perl-Data-Dumper as a dependency.

* For the mysql client, the -b short option was associated with two long options, --no-beep and --binary-as-hex. The -b option now is associated only with --no-beep.

* Very long table keys were handled incorrectly on replication slaves.

* During server startup/shutdown, PID files could be mishandled.

* For MEMORY tables, memory overflow errors could occur.

* When converting from a BLOB (or TEXT) type to a smaller BLOB (or TEXT) type, no warning or error was reported informing about the truncation or data loss. Now an appropriate error is issued in 
strict SQL mode and a warning in nonstrict SQL mode.

* Failure to create a temporary table during a MyISAM query could cause a server exit. Thanks to Facebook for the patch.

* An attempted read of an uncommitted transaction raised an assertion.

* ALTER TABLE ... REORGANIZE PARTITION ... could result in incorrect behavior if any partition other than the last was missing the VALUES LESS THAN part of the syntax.

* yum update did not properly update from RHEL5 RPM packages to current packages.

* It was possible for a subquery that used a unique key on a column allowing NULL to return multiple rows.

diffstat:

 databases/mysql56-client/Makefile        |   3 +--
 databases/mysql56-client/Makefile.common |   4 ++--
 databases/mysql56-client/PLIST           |   6 +-----
 databases/mysql56-client/distinfo        |  10 +++++-----
 databases/mysql56-server/Makefile        |   4 ++--
 databases/mysql56-server/PLIST           |  32 +++++++++++++++++++++++++++++++-
 6 files changed, 42 insertions(+), 17 deletions(-)

diffs (truncated from 302 to 300 lines):

diff -r caa4439870c0 -r b1e37dc5f575 databases/mysql56-client/Makefile
--- a/databases/mysql56-client/Makefile Thu Nov 22 11:28:13 2018 +0000
+++ b/databases/mysql56-client/Makefile Thu Nov 22 11:53:33 2018 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.26 2018/08/22 09:43:12 wiz Exp $
+# $NetBSD: Makefile,v 1.27 2018/11/22 11:53:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-client-/}
-PKGREVISION=   1
 COMMENT=       MySQL 5, a free SQL database (client)
 
 CONFLICTS=     mysql3-client-[0-9]*
diff -r caa4439870c0 -r b1e37dc5f575 databases/mysql56-client/Makefile.common
--- a/databases/mysql56-client/Makefile.common  Thu Nov 22 11:28:13 2018 +0000
+++ b/databases/mysql56-client/Makefile.common  Thu Nov 22 11:53:33 2018 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.45 2018/02/01 23:01:19 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.46 2018/11/22 11:53:33 adam Exp $
 #
 # used by databases/mysql56-client/Makefile
 # used by databases/mysql56-server/Makefile
 
-DISTNAME=      mysql-5.6.39
+DISTNAME=      mysql-5.6.42
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.6/}
 
diff -r caa4439870c0 -r b1e37dc5f575 databases/mysql56-client/PLIST
--- a/databases/mysql56-client/PLIST    Thu Nov 22 11:28:13 2018 +0000
+++ b/databases/mysql56-client/PLIST    Thu Nov 22 11:53:33 2018 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2013/07/31 09:51:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2018/11/22 11:53:33 adam Exp $
 bin/msql2mysql
 bin/mysql
 bin/mysql_client_test
@@ -116,11 +116,8 @@
 man/man1/myisamchk.1
 man/man1/myisamlog.1
 man/man1/myisampack.1
-man/man1/mysql-stress-test.pl.1
-man/man1/mysql-test-run.pl.1
 man/man1/mysql.1
 man/man1/mysql.server.1
-man/man1/mysql_client_test.1
 man/man1/mysql_client_test_embedded.1
 man/man1/mysql_config.1
 man/man1/mysql_config_editor.1
@@ -149,7 +146,6 @@
 man/man1/mysqlman.1
 man/man1/mysqlshow.1
 man/man1/mysqlslap.1
-man/man1/mysqltest.1
 man/man1/mysqltest_embedded.1
 man/man1/perror.1
 man/man1/replace.1
diff -r caa4439870c0 -r b1e37dc5f575 databases/mysql56-client/distinfo
--- a/databases/mysql56-client/distinfo Thu Nov 22 11:28:13 2018 +0000
+++ b/databases/mysql56-client/distinfo Thu Nov 22 11:53:33 2018 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.47 2018/10/08 13:26:04 sevan Exp $
+$NetBSD: distinfo,v 1.48 2018/11/22 11:53:33 adam Exp $
 
-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 (mysql-5.6.42.tar.gz) = 536ca4899d49222d2c105e827f3a366a57a55b0e
+RMD160 (mysql-5.6.42.tar.gz) = ffbe4ceed2e751999077d089819ceb6a27dbeaaa
+SHA512 (mysql-5.6.42.tar.gz) = 3104e6a3145a119f2b012de6af2a92fc37134aa402b889a562f5fc2391705d0bc2f718166c5fa8387d973fff5ecd9544c8b389b6d0c81d98bdcaf2acfb9b55e8
+Size (mysql-5.6.42.tar.gz) = 32201731 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 caa4439870c0 -r b1e37dc5f575 databases/mysql56-server/Makefile
--- a/databases/mysql56-server/Makefile Thu Nov 22 11:28:13 2018 +0000
+++ b/databases/mysql56-server/Makefile Thu Nov 22 11:53:33 2018 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.34 2018/08/22 09:43:12 wiz Exp $
+# $NetBSD: Makefile,v 1.35 2018/11/22 11:53:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-server-/}
-PKGREVISION=   1
 COMMENT=       MySQL 5, a free SQL database (server)
 
 CONFLICTS=     mysql3-server-[0-9]*
@@ -90,6 +89,7 @@
 SUBST_SED.python+=     -e 's,/usr/bin/python,${PREFIX}/bin/python2.7,'
 
 INSTALLATION_DIRS+=    bin
+TEST_TARGET=           test
 
 .include "../../mk/compiler.mk"
 
diff -r caa4439870c0 -r b1e37dc5f575 databases/mysql56-server/PLIST
--- a/databases/mysql56-server/PLIST    Thu Nov 22 11:28:13 2018 +0000
+++ b/databases/mysql56-server/PLIST    Thu Nov 22 11:53:33 2018 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.31 2018/01/16 16:27:12 adam Exp $
+@comment $NetBSD: PLIST,v 1.32 2018/11/22 11:53:33 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -243,6 +243,7 @@
 share/mysql/test/extra/rpl_tests/rpl_conflicts.test
 share/mysql/test/extra/rpl_tests/rpl_crash_safe.inc
 share/mysql/test/extra/rpl_tests/rpl_crash_safe.test
+share/mysql/test/extra/rpl_tests/rpl_db_stmts_ignored.inc
 share/mysql/test/extra/rpl_tests/rpl_ddl.test
 share/mysql/test/extra/rpl_tests/rpl_deadlock.test
 share/mysql/test/extra/rpl_tests/rpl_delete_no_where.test
@@ -360,6 +361,7 @@
 share/mysql/test/include/check_key_req.inc
 share/mysql/test/include/check_no_concurrent_insert.inc
 share/mysql/test/include/check_no_row_lock.inc
+share/mysql/test/include/check_openssl_version.inc
 share/mysql/test/include/check_qep.inc
 share/mysql/test/include/check_shared_row_lock.inc
 share/mysql/test/include/check_slave_is_running.inc
@@ -511,6 +513,7 @@
 share/mysql/test/include/have_null_audit_plugin.inc
 share/mysql/test/include/have_numa.inc
 share/mysql/test/include/have_openssl.inc
+share/mysql/test/include/have_openssl_support.inc
 share/mysql/test/include/have_optimizer_trace.inc
 share/mysql/test/include/have_outfile.inc
 share/mysql/test/include/have_partition.inc
@@ -1158,6 +1161,7 @@
 share/mysql/test/r/host_cache_size_functionality.result
 share/mysql/test/r/implicit_char_to_num_conversion.result
 share/mysql/test/r/implicit_commit.result
+share/mysql/test/r/import_schema_mismatch.result
 share/mysql/test/r/index_merge_delete.result
 share/mysql/test/r/index_merge_innodb.result
 share/mysql/test/r/index_merge_insert-and-replace.result
@@ -1541,6 +1545,7 @@
 share/mysql/test/r/sp-ucs2.result
 share/mysql/test/r/sp-vars.result
 share/mysql/test/r/sp.result
+share/mysql/test/r/sp_debug.result
 share/mysql/test/r/sp_gis.result
 share/mysql/test/r/sp_notembedded.result
 share/mysql/test/r/sp_stress_case.result
@@ -1566,6 +1571,7 @@
 share/mysql/test/r/ssl_crl_crlpath.result
 share/mysql/test/r/ssl_mode.result
 share/mysql/test/r/ssl_mode_no_ssl.result
+share/mysql/test/r/ssl_verify_identity.result
 share/mysql/test/r/status.result
 share/mysql/test/r/status2.result
 share/mysql/test/r/status_bug17954.result
@@ -1577,6 +1583,7 @@
 share/mysql/test/r/subquery_all.result
 share/mysql/test/r/subquery_all_bka.result
 share/mysql/test/r/subquery_all_bka_nixbnl.result
+share/mysql/test/r/subquery_bugs.result
 share/mysql/test/r/subquery_mat.result
 share/mysql/test/r/subquery_mat_all.result
 share/mysql/test/r/subquery_mat_none.result
@@ -1760,12 +1767,15 @@
 share/mysql/test/std_data/bug49823.CSM
 share/mysql/test/std_data/bug49823.CSV
 share/mysql/test/std_data/bug49823.frm
+share/mysql/test/std_data/ca-cert-verify-san.pem
 share/mysql/test/std_data/ca-cert-verify.pem
 share/mysql/test/std_data/ca-sha512.pem
 share/mysql/test/std_data/cacert.pem
 share/mysql/test/std_data/charset_utf8.txt
 share/mysql/test/std_data/checkDBI_DBD-mysql.pl
+share/mysql/test/std_data/client-cert-verify-san.pem
 share/mysql/test/std_data/client-cert.pem
+share/mysql/test/std_data/client-key-verify-san.pem
 share/mysql/test/std_data/client-key.pem
 share/mysql/test/std_data/cluster_7022_table.MYD
 share/mysql/test/std_data/cluster_7022_table.MYI
@@ -1854,10 +1864,12 @@
 share/mysql/test/std_data/server-cert-sha512.pem
 share/mysql/test/std_data/server-cert-verify-fail.pem
 share/mysql/test/std_data/server-cert-verify-pass.pem
+share/mysql/test/std_data/server-cert-verify-san.pem
 share/mysql/test/std_data/server-cert.pem
 share/mysql/test/std_data/server-key-sha512.pem
 share/mysql/test/std_data/server-key-verify-fail.pem
 share/mysql/test/std_data/server-key-verify-pass.pem
+share/mysql/test/std_data/server-key-verify-san.pem
 share/mysql/test/std_data/server-key.pem
 share/mysql/test/std_data/server8k-cert.pem
 share/mysql/test/std_data/server8k-key.pem
@@ -1942,6 +1954,7 @@
 share/mysql/test/suite/binlog/r/binlog_base64_flag.result
 share/mysql/test/suite/binlog/r/binlog_bug23533.result
 share/mysql/test/suite/binlog/r/binlog_bug36391.result
+share/mysql/test/suite/binlog/r/binlog_cache_write_failure.result
 share/mysql/test/suite/binlog/r/binlog_checksum.result
 share/mysql/test/suite/binlog/r/binlog_crash_safe_master_checksum.result
 share/mysql/test/suite/binlog/r/binlog_database.result
@@ -2057,6 +2070,8 @@
 share/mysql/test/suite/binlog/t/binlog_bug23533.test
 share/mysql/test/suite/binlog/t/binlog_bug36391-master.opt
 share/mysql/test/suite/binlog/t/binlog_bug36391.test
+share/mysql/test/suite/binlog/t/binlog_cache_write_failure-master.opt
+share/mysql/test/suite/binlog/t/binlog_cache_write_failure.test
 share/mysql/test/suite/binlog/t/binlog_checksum.test
 share/mysql/test/suite/binlog/t/binlog_crash_safe_master_checksum-master.opt
 share/mysql/test/suite/binlog/t/binlog_crash_safe_master_checksum.test
@@ -3517,11 +3532,13 @@
 share/mysql/test/suite/innodb/r/autoinc_debug.result
 share/mysql/test/suite/innodb/r/blob-update-debug.result
 share/mysql/test/suite/innodb/r/blob_redo.result
+share/mysql/test/suite/innodb/r/bulk_create_index_online.result
 share/mysql/test/suite/innodb/r/checksum.result
 share/mysql/test/suite/innodb/r/create-index.result
 share/mysql/test/suite/innodb/r/create_isl_with_direct.result
 share/mysql/test/suite/innodb/r/dropdb.result
 share/mysql/test/suite/innodb/r/end_range_check.result
+share/mysql/test/suite/innodb/r/events-merge-tmp-path.result
 share/mysql/test/suite/innodb/r/flush-hang.result
 share/mysql/test/suite/innodb/r/foreign_key.result
 share/mysql/test/suite/innodb/r/ibuf_not_empty.result
@@ -3720,6 +3737,7 @@
 share/mysql/test/suite/innodb/t/blob-update-debug.test
 share/mysql/test/suite/innodb/t/blob_redo-master.opt
 share/mysql/test/suite/innodb/t/blob_redo.test
+share/mysql/test/suite/innodb/t/bulk_create_index_online.test
 share/mysql/test/suite/innodb/t/checksum.test
 share/mysql/test/suite/innodb/t/create-index.test
 share/mysql/test/suite/innodb/t/create_isl_with_direct-master.opt
@@ -3727,6 +3745,8 @@
 share/mysql/test/suite/innodb/t/disabled.def
 share/mysql/test/suite/innodb/t/dropdb.test
 share/mysql/test/suite/innodb/t/end_range_check.test
+share/mysql/test/suite/innodb/t/events-merge-tmp-path-master.opt
+share/mysql/test/suite/innodb/t/events-merge-tmp-path.test
 share/mysql/test/suite/innodb/t/flush-hang.test
 share/mysql/test/suite/innodb/t/foreign_key.test
 share/mysql/test/suite/innodb/t/ibuf_not_empty-master.opt
@@ -6396,6 +6416,7 @@
 share/mysql/test/suite/rpl/r/rpl_critical_errors.result.txt
 share/mysql/test/suite/rpl/r/rpl_cross_version.result
 share/mysql/test/suite/rpl/r/rpl_current_user.result
+share/mysql/test/suite/rpl/r/rpl_db_stmts_ignored.result
 share/mysql/test/suite/rpl/r/rpl_ddl.result
 share/mysql/test/suite/rpl/r/rpl_deadlock_innodb.result
 share/mysql/test/suite/rpl/r/rpl_delayed_slave.result
@@ -6542,6 +6563,7 @@
 share/mysql/test/suite/rpl/r/rpl_mts_relay_log_recovery_on_error.result
 share/mysql/test/suite/rpl/r/rpl_mts_slave_hang_with_partial_trx.result
 share/mysql/test/suite/rpl/r/rpl_mts_stop_slave.result
+share/mysql/test/suite/rpl/r/rpl_mts_stop_slave_report_pos.result
 share/mysql/test/suite/rpl/r/rpl_multi_delete.result
 share/mysql/test/suite/rpl/r/rpl_multi_delete2.result
 share/mysql/test/suite/rpl/r/rpl_multi_engine.result
@@ -6899,6 +6921,7 @@
 share/mysql/test/suite/rpl/t/rpl_current_user-master.opt
 share/mysql/test/suite/rpl/t/rpl_current_user.cnf
 share/mysql/test/suite/rpl/t/rpl_current_user.test
+share/mysql/test/suite/rpl/t/rpl_db_stmts_ignored.test
 share/mysql/test/suite/rpl/t/rpl_ddl.test
 share/mysql/test/suite/rpl/t/rpl_deadlock_innodb-slave.opt
 share/mysql/test/suite/rpl/t/rpl_deadlock_innodb.test
@@ -7141,6 +7164,8 @@
 share/mysql/test/suite/rpl/t/rpl_mts_slave_hang_with_partial_trx.test
 share/mysql/test/suite/rpl/t/rpl_mts_stop_slave-slave.opt
 share/mysql/test/suite/rpl/t/rpl_mts_stop_slave.test
+share/mysql/test/suite/rpl/t/rpl_mts_stop_slave_report_pos-slave.opt
+share/mysql/test/suite/rpl/t/rpl_mts_stop_slave_report_pos.test
 share/mysql/test/suite/rpl/t/rpl_multi_delete-slave.opt
 share/mysql/test/suite/rpl/t/rpl_multi_delete.test
 share/mysql/test/suite/rpl/t/rpl_multi_delete2-slave.opt
@@ -9225,6 +9250,7 @@
 share/mysql/test/t/implicit_char_to_num_conversion.test
 share/mysql/test/t/implicit_commit-master.opt
 share/mysql/test/t/implicit_commit.test
+share/mysql/test/t/import_schema_mismatch.test
 share/mysql/test/t/index_merge_delete.test
 share/mysql/test/t/index_merge_innodb.test
 share/mysql/test/t/index_merge_insert-and-replace.test
@@ -9691,6 +9717,7 @@
 share/mysql/test/t/sp-ucs2.test
 share/mysql/test/t/sp-vars.test
 share/mysql/test/t/sp.test
+share/mysql/test/t/sp_debug.test
 share/mysql/test/t/sp_gis.test
 share/mysql/test/t/sp_notembedded-master.opt
 share/mysql/test/t/sp_notembedded.test
@@ -9724,6 +9751,8 @@
 share/mysql/test/t/ssl_mode.test
 share/mysql/test/t/ssl_mode_no_ssl-master.opt
 share/mysql/test/t/ssl_mode_no_ssl.test
+share/mysql/test/t/ssl_verify_identity-master.opt
+share/mysql/test/t/ssl_verify_identity.test
 share/mysql/test/t/status-master.opt
 share/mysql/test/t/status.test
 share/mysql/test/t/status2.test
@@ -9737,6 +9766,7 @@
 share/mysql/test/t/subquery_all.test
 share/mysql/test/t/subquery_all_bka.test
 share/mysql/test/t/subquery_all_bka_nixbnl.test
+share/mysql/test/t/subquery_bugs.test
 share/mysql/test/t/subquery_mat.test



Home | Main Index | Thread Index | Old Index