CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Aug  5 14:38:33 UTC 2020

Modified Files:
        pkgsrc/databases/mysql56-client: Makefile.common distinfo
        pkgsrc/databases/mysql56-server: PLIST

Log Message:
mysql56: updated to 5.6.49

Changes in MySQL 5.6.49

Configuration Notes

tcmalloc is no longer a permitted value for the mysqld_safe --malloc-lib option.

Security Notes

Incompatible Change: Access to the INFORMATION_SCHEMA.FILES table now requires the PROCESS privilege.

This change affects users of the mysqldump command, which accesses tablespace information in the FILES table, and thus now requires the PROCESS privilege as well. Users who do not need to dump 
tablespace information can work around this requirement by invoking mysqldump with the --no-tablespaces option.

The linked OpenSSL library for MySQL Server has been updated to version 1.1.1g. Issues fixed in the new OpenSSL version are described at https://www.openssl.org/news/cl111.txt and 
https://www.openssl.org/news/vulnerabilities.html.

Bugs Fixed

Partitioning: A query against a partitioned table, which used an ORDER BY, returned unordered results under the following conditions:

The table had a composite index with a prefix on one of the columns.

The query's WHERE clause contained an equality condition on the prefixed column.

The column with the prefix was the leftmost column in the index.

The column used in the ORDER BY was the rightmost column in the index.

The index was used for handling the ORDER BY.

Our thanks to Quanan Han for the contribution.

Replication: When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source uses a given MEMORY table 
after startup, it notifies replicas that the table must be emptied by writing a DELETE statement for that table to the binary log. Previously, the generated DELETE statement was written to the binary 
log statement cache for the current session, which could result in it being logged together with other statements under the same GTID, or logged without BEGIN and COMMIT statements. Also, in some 
situations, the generated DELETE statement could consume the GTID intended for the transaction that triggered it. The generated DELETE statement is now logged with accompanying BEGIN and COMMIT 
statements, and the resulting transaction is flushed to the binary log immediately after it is written to the statement cache, so that it always receives its own GTID and is kept separate from other 
tra
nsactions.

mysql_store_result() could fail to detect invalid data packets.

The server sometimes mistakenly removed a subquery with a GROUP BY when optimizing a query, even in some cases when this subquery was used by an outer select. This could occur when the subquery also 
used an aggregate function.


To generate a diff of this commit:
cvs rdiff -u -r1.57 -r1.58 pkgsrc/databases/mysql56-client/Makefile.common
cvs rdiff -u -r1.56 -r1.57 pkgsrc/databases/mysql56-client/distinfo
cvs rdiff -u -r1.37 -r1.38 pkgsrc/databases/mysql56-server/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/mysql56-client/Makefile.common
diff -u pkgsrc/databases/mysql56-client/Makefile.common:1.57 pkgsrc/databases/mysql56-client/Makefile.common:1.58
--- pkgsrc/databases/mysql56-client/Makefile.common:1.57        Tue Jul  7 20:18:20 2020
+++ pkgsrc/databases/mysql56-client/Makefile.common     Wed Aug  5 14:38:33 2020
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.57 2020/07/07 20:18:20 adam Exp $
+# $NetBSD: Makefile.common,v 1.58 2020/08/05 14:38:33 adam Exp $
 #
 # used by databases/mysql56-client/Makefile
 # used by databases/mysql56-server/Makefile
 
-DISTNAME=      mysql-5.6.48
+DISTNAME=      mysql-5.6.49
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.6/}
 

Index: pkgsrc/databases/mysql56-client/distinfo
diff -u pkgsrc/databases/mysql56-client/distinfo:1.56 pkgsrc/databases/mysql56-client/distinfo:1.57
--- pkgsrc/databases/mysql56-client/distinfo:1.56       Tue Jul  7 20:18:20 2020
+++ pkgsrc/databases/mysql56-client/distinfo    Wed Aug  5 14:38:33 2020
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.56 2020/07/07 20:18:20 adam Exp $
+$NetBSD: distinfo,v 1.57 2020/08/05 14:38:33 adam Exp $
 
-SHA1 (mysql-5.6.48.tar.gz) = 419977992ac9979ee2a45c7b7ae2b781633c2a95
-RMD160 (mysql-5.6.48.tar.gz) = 3bc7d47d78b61f5262ce632d81d15c280db671ab
-SHA512 (mysql-5.6.48.tar.gz) = 4a34ad9e2b67137027c0bcdc8716d6e5a52bd2faec68482bd37b12138010a399945a0c3dfbb3ae41fe3f71d1c2dd8a4f2ca5e0dc0a780345a687b819ae847714
-Size (mysql-5.6.48.tar.gz) = 32401200 bytes
+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 (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

Index: pkgsrc/databases/mysql56-server/PLIST
diff -u pkgsrc/databases/mysql56-server/PLIST:1.37 pkgsrc/databases/mysql56-server/PLIST:1.38
--- pkgsrc/databases/mysql56-server/PLIST:1.37  Tue Jul  7 20:18:20 2020
+++ pkgsrc/databases/mysql56-server/PLIST       Wed Aug  5 14:38:33 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.37 2020/07/07 20:18:20 adam Exp $
+@comment $NetBSD: PLIST,v 1.38 2020/08/05 14:38:33 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -346,6 +346,7 @@ share/mysql/test/include/allowed_ciphers
 share/mysql/test/include/analyze-sync_with_master.test
 share/mysql/test/include/analyze-timeout.test
 share/mysql/test/include/assert.inc
+share/mysql/test/include/assert_binlog_events.inc
 share/mysql/test/include/assert_command_output.inc
 share/mysql/test/include/assert_grep.inc
 share/mysql/test/include/begin_include_file.inc
@@ -700,6 +701,7 @@ share/mysql/test/include/rpl_sync.inc
 share/mysql/test/include/rpl_udf.inc
 share/mysql/test/include/running_event_scheduler.inc
 share/mysql/test/include/safe_set_to_maybe_ro_var.inc
+share/mysql/test/include/save_binlog_position.inc
 share/mysql/test/include/save_io_thread_pos.inc
 share/mysql/test/include/save_master_pos.inc
 share/mysql/test/include/search_pattern.inc
@@ -6472,9 +6474,11 @@ share/mysql/test/suite/rpl/r/rpl_grant_p
 share/mysql/test/suite/rpl/r/rpl_group_commit_deadlock.result
 share/mysql/test/suite/rpl/r/rpl_gtid_binary_log_as_relay_log.result
 share/mysql/test/suite/rpl/r/rpl_gtid_binlog_errors.result
+share/mysql/test/suite/rpl/r/rpl_gtid_delete_memory_table_after_start_server.result
 share/mysql/test/suite/rpl/r/rpl_gtid_deleted_binlog_fail_to_connect.result
 share/mysql/test/suite/rpl/r/rpl_gtid_do_table_filter_insensitive.result
 share/mysql/test/suite/rpl/r/rpl_gtid_do_table_filter_sensitive.result
+share/mysql/test/suite/rpl/r/rpl_gtid_drop_mem_table.result
 share/mysql/test/suite/rpl/r/rpl_gtid_drop_table.result
 share/mysql/test/suite/rpl/r/rpl_gtid_empty_transaction.result
 share/mysql/test/suite/rpl/r/rpl_gtid_execution.result
@@ -6584,6 +6588,7 @@ share/mysql/test/suite/rpl/r/rpl_multi_u
 share/mysql/test/suite/rpl/r/rpl_mysql_upgrade.result
 share/mysql/test/suite/rpl/r/rpl_mysqlbinlog_gtid_on.result
 share/mysql/test/suite/rpl/r/rpl_name_const.result
+share/mysql/test/suite/rpl/r/rpl_no_gtid_delete_memory_table_after_start_server.result
 share/mysql/test/suite/rpl/r/rpl_non_direct_mixed_mixing_engines.result
 share/mysql/test/suite/rpl/r/rpl_non_direct_row_mixing_engines.result
 share/mysql/test/suite/rpl/r/rpl_non_direct_stm_mixing_engines.result
@@ -7005,12 +7010,15 @@ share/mysql/test/suite/rpl/t/rpl_group_c
 share/mysql/test/suite/rpl/t/rpl_gtid_binary_log_as_relay_log.test
 share/mysql/test/suite/rpl/t/rpl_gtid_binlog_errors-master.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_binlog_errors.test
+share/mysql/test/suite/rpl/t/rpl_gtid_delete_memory_table_after_start_server.test
 share/mysql/test/suite/rpl/t/rpl_gtid_deleted_binlog_fail_to_connect.test
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_insensitive-master.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_insensitive-slave.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_insensitive.test
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_sensitive-slave.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_sensitive.test
+share/mysql/test/suite/rpl/t/rpl_gtid_drop_mem_table.cnf
+share/mysql/test/suite/rpl/t/rpl_gtid_drop_mem_table.test
 share/mysql/test/suite/rpl/t/rpl_gtid_drop_table.cnf
 share/mysql/test/suite/rpl/t/rpl_gtid_drop_table.test
 share/mysql/test/suite/rpl/t/rpl_gtid_empty_transaction.cnf
@@ -7196,6 +7204,7 @@ share/mysql/test/suite/rpl/t/rpl_multi_u
 share/mysql/test/suite/rpl/t/rpl_mysql_upgrade.test
 share/mysql/test/suite/rpl/t/rpl_mysqlbinlog_gtid_on.test
 share/mysql/test/suite/rpl/t/rpl_name_const.test
+share/mysql/test/suite/rpl/t/rpl_no_gtid_delete_memory_table_after_start_server.test
 share/mysql/test/suite/rpl/t/rpl_non_direct_mixed_mixing_engines.test
 share/mysql/test/suite/rpl/t/rpl_non_direct_row_mixing_engines.test
 share/mysql/test/suite/rpl/t/rpl_non_direct_stm_mixing_engines.test