Received: by mail.netbsd.org (Postfix, from userid 605) id 48BE384D84; Fri, 23 Sep 2022 08:28:07 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 78CE584D2A for ; Fri, 23 Sep 2022 08:28:06 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([127.0.0.1]) by localhost (mail.netbsd.org [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id Q4W62vmtn9cL for ; Fri, 23 Sep 2022 08:28:05 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.netbsd.org [199.233.217.197]) by mail.netbsd.org (Postfix) with ESMTP id 6AE9284D14 for ; Fri, 23 Sep 2022 08:28:05 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 63E62FA90; Fri, 23 Sep 2022 08:28:05 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_166392168523310" MIME-Version: 1.0 Date: Fri, 23 Sep 2022 08:28:05 +0000 From: "Nia Alarie" Subject: CVS commit: pkgsrc/databases/mariadb105-client To: pkgsrc-changes@NetBSD.org Reply-To: nia@netbsd.org X-Mailer: log_accum Message-Id: <20220923082805.63E62FA90@cvs.NetBSD.org> Sender: pkgsrc-changes-owner@NetBSD.org List-Id: Precedence: bulk List-Unsubscribe: This is a multi-part message in MIME format. --_----------=_166392168523310 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: nia Date: Fri Sep 23 08:28:05 UTC 2022 Modified Files: pkgsrc/databases/mariadb105-client: Makefile Makefile.common distinfo Removed Files: pkgsrc/databases/mariadb105-client/patches: patch-extra_wolfssl_wolfssl_certs_intermediate_genintcerts.sh patch-storage_connect_ioapi.c Log Message: mariadb105: update to 10.5.17 Notable Items InnoDB * InnoDB corruption due to lack of file locking (MDEV-28495) * FULLTEXT search with apostrophe, and mandatory words (MDEV-20797) * ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table (MDEV-28779) * ALTER TABLE wrong-result fix (MDEV-26294) * Crash recovery fixes (MDEV-28668, MDEV-28731) Replication * explicit_defaults_for_timestamp is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. (MDEV-29078) * ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS (MDEV-21087) * INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback (MDEV-21443) * sequences related row-format events are made to correspond to binlog_row_image (MDEV-28487) * Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948) Galera * Possible to write/update with read_only=ON and not a SUPER privilege (MDEV-28546) * Node crashes with Transport endpoint is not connected mysqld got signal 6 (MDEV-25068) * Galera4 not able to report proper wsrep_incoming_addresses (MDEV-20627) * Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862) Optimizer * Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809) * Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant. * Crash when using ANY predicand with redundant subquery in GROUP BY clause (MDEV-29139) * A query with a subuquery in this form could cause a crash: ... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ... * MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427) * Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash. * restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly (MDEV-28749) * Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries. * Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246) * For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from. * Range optimizer regression for key IN (const, ....) (MDEV-25020) * The issue can be observed on MariaDB 10.5.9 and later versions which have the fix for MDEV-9750. That fix introduceds optimizer_max_sel_arg_weight. * If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.: table.keyXpartY [NOT] IN ( ... ) * Wrong result with table elimination combined with not_null_range_scan (MDEV-28858) * If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result. CONNECT * CONNECT Engine now supports INSERT IGNORE with Mysql Table type (MDEV-27766) mariadb Client * New mariadb client option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only. General * explicit_defaults_for_timestamp now also has a session scope, not only global (MDEV-29225) * MariaDB can be built with OpenSSL 3.0 * HELP was updated to include the latest content * Crash in JSON_EXTRACT (MDEV-29188) * ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (MDEV-28727) * Server crash upon CREATE VIEW with unknown column in ON condition (MDEV-29088) * As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Debian 10 "Buster" for ppc64el Security * Fixes for the following security vulnerabilities: * CVE-2022-32082 * CVE-2022-32089 * CVE-2022-32081 * CVE-2018-25032 * CVE-2022-32091 * CVE-2022-32084 To generate a diff of this commit: cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/mariadb105-client/Makefile cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/mariadb105-client/Makefile.common cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/mariadb105-client/distinfo cvs rdiff -u -r1.1 -r0 \ pkgsrc/databases/mariadb105-client/patches/patch-extra_wolfssl_wolfssl_certs_intermediate_genintcerts.sh \ pkgsrc/databases/mariadb105-client/patches/patch-storage_connect_ioapi.c Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_166392168523310 Content-Disposition: inline Content-Length: 3917 Content-Transfer-Encoding: binary Content-Type: text/x-diff; charset=us-ascii Modified files: Index: pkgsrc/databases/mariadb105-client/Makefile diff -u pkgsrc/databases/mariadb105-client/Makefile:1.11 pkgsrc/databases/mariadb105-client/Makefile:1.12 --- pkgsrc/databases/mariadb105-client/Makefile:1.11 Tue Jun 28 11:31:18 2022 +++ pkgsrc/databases/mariadb105-client/Makefile Fri Sep 23 08:28:05 2022 @@ -1,7 +1,6 @@ -# $NetBSD: Makefile,v 1.11 2022/06/28 11:31:18 wiz Exp $ +# $NetBSD: Makefile,v 1.12 2022/09/23 08:28:05 nia Exp $ PKGNAME= ${DISTNAME:S/-/-client-/} -PKGREVISION= 1 COMMENT= MariaDB 10.5, a free MySQL compatible database (client) CONFLICTS= mysql-client-[0-9]* Index: pkgsrc/databases/mariadb105-client/Makefile.common diff -u pkgsrc/databases/mariadb105-client/Makefile.common:1.16 pkgsrc/databases/mariadb105-client/Makefile.common:1.17 --- pkgsrc/databases/mariadb105-client/Makefile.common:1.16 Sat May 21 10:38:25 2022 +++ pkgsrc/databases/mariadb105-client/Makefile.common Fri Sep 23 08:28:05 2022 @@ -1,9 +1,9 @@ -# $NetBSD: Makefile.common,v 1.16 2022/05/21 10:38:25 nia Exp $ +# $NetBSD: Makefile.common,v 1.17 2022/09/23 08:28:05 nia Exp $ # # used by databases/mariadb105-client/Makefile # used by databases/mariadb105-server/Makefile -DISTNAME= mariadb-10.5.16 +DISTNAME= mariadb-10.5.17 CATEGORIES= databases MASTER_SITES= https://archive.mariadb.org/${DISTNAME}/source/ @@ -91,6 +91,7 @@ CMAKE_ARGS+= -DDTRACE_FLAGS="-${ABI}" .endif CFLAGS.SunOS+= -fPIC +CFLAGS.NetBSD+= -DIOAPI_NO_64 REPLACE_PERL+= scripts/mytop.sh REPLACE_PERL+= sql-bench/*.sh Index: pkgsrc/databases/mariadb105-client/distinfo diff -u pkgsrc/databases/mariadb105-client/distinfo:1.13 pkgsrc/databases/mariadb105-client/distinfo:1.14 --- pkgsrc/databases/mariadb105-client/distinfo:1.13 Sat May 21 10:38:25 2022 +++ pkgsrc/databases/mariadb105-client/distinfo Fri Sep 23 08:28:05 2022 @@ -1,13 +1,12 @@ -$NetBSD: distinfo,v 1.13 2022/05/21 10:38:25 nia Exp $ +$NetBSD: distinfo,v 1.14 2022/09/23 08:28:05 nia Exp $ -BLAKE2s (mariadb-10.5.16.tar.gz) = bafab69afbafc1e6dc34cd8cd7a50fa9383abb5a971ecae5762bb116479c3e75 -SHA512 (mariadb-10.5.16.tar.gz) = 28cea63cc3c5e1b236fb13593285e5d4b9aac5eaf259784e760def42bca8b09954510d39014a7a7c9e8656d61f5995a356df2f2ebb0df2696dd739ff3de5865d -Size (mariadb-10.5.16.tar.gz) = 105798374 bytes +BLAKE2s (mariadb-10.5.17.tar.gz) = e2b29683aa1e6ff33bb3ef1e16fabd4c0611d517688225cd72b630c4390e2d39 +SHA512 (mariadb-10.5.17.tar.gz) = 5a68126aac7072bed549404c89f7215bc47dede8f72559076988469372b96523a800fd6bbf11ff3003a277ee30788ca99a21507b7d7e2b7e98437ca70b5ca0fc +Size (mariadb-10.5.17.tar.gz) = 113314849 bytes SHA1 (patch-BUILD_compile-pentium32-gcov) = 89a7da728f94f19c153b4d2d2d6ba5462acc941f SHA1 (patch-CMakeLists.txt) = 574131db46854715758c60ba5f026498f5b29564 SHA1 (patch-client_CMakeLists.txt) = 8fdd8a182304f0b84e120ce95334ace23d02ce88 SHA1 (patch-client_mysql.cc) = 89fe80fb66b8791131a8c6d1b209e57082804a01 -SHA1 (patch-extra_wolfssl_wolfssl_certs_intermediate_genintcerts.sh) = cd9a982889b88f811c3e14ebdf9795b0fa5d1fad SHA1 (patch-include_my__global.h) = a3b831f91ba2efea9f78e70ab4f706da23b80403 SHA1 (patch-mysys_my__context.c) = f9c7e6b3b68b857e7781cf5f36c49e88051cfb66 SHA1 (patch-plugin_auth__socket_CMakeLists.txt) = 00cfaf5826cc97084bc77033985e6686e1ce1628 @@ -15,7 +14,6 @@ SHA1 (patch-plugin_auth__socket_auth__so SHA1 (patch-scripts_CMakeLists.txt) = 54591a4d255a8133e06ab5d52bad262acffcddda SHA1 (patch-scripts_mysqld__safe.sh) = 4124e4c8df1527049f5eec9f3d2d4bbe80e7c33f SHA1 (patch-sql_mysqld.cc) = 19d325124cde1b45376c9710cdd104dc460f4bea -SHA1 (patch-storage_connect_ioapi.c) = 804e2d9d3722fbe4d5ed773cc98a4114fe4cf8a3 SHA1 (patch-storage_connect_tabvct.cpp) = 2e3c7cd7e4b0a86d443da47d3cc514b8b276d836 SHA1 (patch-storage_rocksdb_rdb__io__watchdog.cc) = 85ee5007cfda0d3070ec20b2b774738b01f8e083 SHA1 (patch-storage_rocksdb_rdb__io__watchdog.h) = d790c092d7d35d014c5ef209635c18614c3a8301 --_----------=_166392168523310--