CVS commit: pkgsrc/databases/mariadb105-client

["Nia Alarie" <nia%netbsd.org@localhost>]

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.

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