mysql57: updated to 5.7.38

Changes in MySQL 5.7.38

SQL Function and Operator Notes

When the mysql client was started with --default-character-set=utf8mb4, successive calls to the UUID() function returned duplicate values.

Security Notes

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

Functionality Added or Changed

The default for the group_replication_transaction_size_limit system variable, which sets the maximum transaction size that a replication group accepts, is changed from zero (no limit) to 150000000 bytes (approximately 143 MB), which is the same as the default in MySQL 8.0. Setting a limit for this system variable by default helps to avoid delays or errors caused by excessively large transactions. Transactions above the limit are rolled back and are not sent to Group Replication's Group Communication System (GCS) for distribution to the group. If your Group Replication servers previously accepted transactions larger than the new default limit, and you were allowing group_replication_transaction_size_limit to default to the old zero limit, those transactions will start to fail after the upgrade to the new default. You must either specify an appropriate size limit that allows the maximum message size you need the group to tolerate (which is the recommended solution), or specify a zero setting to restore the previous behavior.

The myisam_repair_threads system variable and myisamchk --parallel-recover option are deprecated; expect support for both to be removed in a future release of MySQL.

Values other than 1 (the default) for myisam_repair_threads produce a warning.

Bugs Fixed

InnoDB: A missing null pointer check for an index instance caused a failure.

InnoDB: Purge threads processed undo records of an encrypted table for which the tablespace was not loaded, causing a failure.

InnoDB: Incorrect AUTO_INCREMENT values were generated when the maximum integer column value was exceeded. The error was due to the maximum column value not being considered. The previous valid AUTO_INCREMENT value should have been returned in this case, causing a duplicate key error.

Partitioning: In some cases, establishing a connection to MySQL server could fail if the .ibd file for a partition was missing.

Statements that cannot be parsed (due, for example, to syntax errors) are no longer written to the slow query log.

It was not possible to revoke the DROP privilege on the Performance Schema.

A page cleaner thread timed out as it waited for an exclusive lock on an index page held by a full-text index creation operation on a large table.

A memory leak occurred if mysqldump was used on more than one table with the --order-by-primary option. The memory allocated for sorting each table’s rows is now freed after every table, rather than only once.

mysqld_safe log message textual errors were corrected.

3 files changed, 8 insertions, 8 deletions

diff --git a/databases/mysql57-client/Makefile.common b/databases/mysql57-client/Makefile.common
index f77f114d1ca..5c0626aa6d3 100644
--- a/databases/mysql57-client/Makefile.common
+++ b/databases/mysql57-client/Makefile.common
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.37 2022/01/21 11:23:50 adam Exp $
+# $NetBSD: Makefile.common,v 1.38 2022/04/28 13:19:04 adam Exp $
 #
 # used by databases/mysql57-client/Makefile
 # used by databases/mysql57-server/Makefile
 
-DISTNAME=	mysql-5.7.37
+DISTNAME=	mysql-5.7.38
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_MYSQL:=MySQL-5.7/}
 
diff --git a/databases/mysql57-client/PLIST b/databases/mysql57-client/PLIST
index 7e06b639330..a6b8c36ab5f 100644
--- a/databases/mysql57-client/PLIST
+++ b/databases/mysql57-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.24 2022/01/21 11:23:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.25 2022/04/28 13:19:04 adam Exp $
 bin/mysql
 bin/mysql_client_test
 bin/mysql_config
@@ -122,7 +122,7 @@ include/mysql/typelib.h
 lib/libmysqlclient.a
 lib/libmysqlclient.so
 lib/libmysqlclient.so.20
-lib/libmysqlclient.so.20.3.24
+lib/libmysqlclient.so.20.3.25
 lib/pkgconfig/mysqlclient.pc
 man/man1/comp_err.1
 man/man1/innochecksum.1
diff --git a/databases/mysql57-client/distinfo b/databases/mysql57-client/distinfo
index bbb8c44631f..02a4e515320 100644
--- a/databases/mysql57-client/distinfo
+++ b/databases/mysql57-client/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.48 2022/01/21 11:23:50 adam Exp $
+$NetBSD: distinfo,v 1.49 2022/04/28 13:19:04 adam Exp $
 
-BLAKE2s (mysql-5.7.37.tar.gz) = f4871be0ffd6432fa7a6b6833d30eb38e49ecc95bc0df154b0f5b13a4b4d26b9
-SHA512 (mysql-5.7.37.tar.gz) = 6268227d61d4ff7d29c767c409245a1ba26f6760fac724d53af18931b27295c8e7ef70819b7991746b57f36fe863561afff1577b01b73b517444a4aea3d867d3
-Size (mysql-5.7.37.tar.gz) = 56248775 bytes
+BLAKE2s (mysql-5.7.38.tar.gz) = 4e3a03502455685971333d26608680590ba5b7f1957b2f1dbc899b5041d9d778
+SHA512 (mysql-5.7.38.tar.gz) = 1f861c6edd81a89aff6a4e8116bf78a1df11c3fa6bedbf99dbd827ae1e4dbae5b3625f825b00410c731dd298d1563feb922fd65d8c48036ba46e0d8dffb80f81
+Size (mysql-5.7.38.tar.gz) = 56247722 bytes
 SHA1 (patch-CMakeLists.txt) = 1409a98380c999c6973fa3106dc35684b7c3b3cc
 SHA1 (patch-client_CMakeLists.txt) = 4af2fb3f3d05a66a9ee89f3653e2fcccadfa5f79
 SHA1 (patch-client_completion_hash.cc) = b86ec80beac624b2aa21c7587e351ff126400ecb