Log message:
mariadb105: Various SunOS fixes.

Log message:
mariadb105: update to 10.5.18

                         MariaDB 10.5.18 Release Notes

Notable Items

  Backup

     * mariabackup --compress hangs (MDEV-29043)
     * Assertion on info.page_size failed in xb_delta_open_matching_space
       (MDEV-18589)

  InnoDB

     * InnoDB unnecessarily extends data files (MDEV-13013)
     * Adaptive hash index MDEV-27700, MDEV-29384
     * MVCC and locking MDEV-29666, MDEV-27927
     * Virtual columns MDEV-29299, MDEV-29753
     * InnoDB crash recovery fixes (MDEV-29438, MDEV-29475)
     * InnoDB crash recovery fixes (MDEV-29559)
     * MVCC and locking (MDEV-28709)
     * Race condition between KILL and transaction commit (MDEV-29368)

  Galera

     * Galera updated to 26.4.13
     * Galera server crashes after 10.3 > 10.4 upgrade (MDEV-29375)
     * wsrep_incoming_addresses status variable prints 0 as port number if
       the port is not mentioned in wsrep_node_incoming_address system
       variable (MDEV-28868)

  JSON

     * JSON_VALUE() does not parse NULL properties properly (MDEV-27151)

  Replication

     * minor correction in unsafe warning message (MDEV-28827)
     * False replication error-stop of REVOKE PRIVILEGES from a non-existing
       user on primary (MDEV-28530) in combination with a filtering replica
       is corrected
     * SET DEFAULT ROLE replication is mended on a replica that filters
       system tables (MDEV-28294)
     * XA COMMIT is not binlogged when the XA transaction has not updated any
       transaction engine (MDEV-25616)
     * Concurrent CREATE TRIGGER statements made to binlog without any mixup
       (MDEV-25606)

Log message:
*: bump PKGREVISION for libunistring shlib major bump

Log message:
mariadb105-client: SunOS doesn't support hwaddr.

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

Log message:
*: recursive bump for perl 5.36

Log message:
mariadb105: Update to 10.5.16

                         MariaDB 10.5.16 Release Notes

Notable Items

  InnoDB

     * innodb_disallow_writes removed (MDEV-25975)
     * InnoDB gap locking fixes (MDEV-20605, MDEV-28422)
     * InnoDB performance improvements (MDEV-27557, MDEV-28185)

  Replication

     * Server initialization time gtid_slave_pos purge related reason of
       crashing in binlog background thread is removed (MDEV-26473)
     * Shutdown of the semisync master can't produce inconsistent state
       anymore (MDEV-11853)
     * Binlogs disappear after rsync IST (MDEV-28583)
     * autocommit=0 slave hang is eliminated (DBAAS-7828)
     * master crash is eliminated in compressed semisync replication protocol
       with packet counting amendment (MDEV-25580)
     * OPTIMIZE on a sequence does not cause counterfactual
       ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617)
     * Automatically generated Gtid_log_list_event is made to recognize
       within replication event group as a formal member (MDEV-28550)
     * Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE using two or more
       unique key values at a time with MIXED format binlogging is corrected
       (MDEV-28310)
     * Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE stops issuing
       unnessary "Unsafe statement" with MIXED binlog format (MDEV-21810)
     * Incomplete replication event groups are detected to error out by the
       slave IO thread (MDEV-27697)
     * mysqlbinlog --stop-never --raw now flushes the result file to disk
       after each processed event so the file can be listed with the actual
       bytes (MDEV-14608)

  Backup

     * Incorrect binlogs after Galera SST using rsync and mariabackup
       (MDEV-27524)
     * mariabackup does not detect multi-source replication slave
       (MDEV-21037)
     * Useless warning "InnoDB: Allocated tablespace ID <id> for \ 
<tablename>,
       old maximum was 0" during backup stage (MDEV-27343)
     * mariabackup prepare fails for incrementals if a new schema is created
       after full backup is taken (MDEV-28446)

  Optimizer

     * A SEGV in Item_field::used_tables/update_depend_map_for_order...
       (MDEV-26402)
     * ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries
       (MDEV-27699)
     * Subquery in an UPDATE query uses full scan instead of range
       (MDEV-22377)
     * Assertion `item1->type() == Item::FIELD_ITEM ... (MDEV-19398)
     * Server crashes in Expression_cache_tracker::fetch_current_stats
       (MDEV-28268)
     * MariaDB server crash at Item_subselect::init_expr_cache_tracker
       (MDEV-26164, MDEV-26047)
     * Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)
     * SIGSEGV in st_join_table::cleanup (MDEV-24560)
     * Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)

  General

     * Server error messages are now available in Chinese (MDEV-28227)
     * For RHEL/CentOS 7, non x86_64 architectures are no longer supported
       upstream and so our support will also be dropped with this release

  Security

     * Fixes for the following security vulnerabilities:
          * CVE-2022-27376
          * CVE-2022-27377
          * CVE-2022-27378
          * CVE-2022-27379
          * CVE-2022-27380
          * CVE-2022-27381
          * CVE-2022-27382
          * CVE-2022-27383
          * CVE-2022-27384
          * CVE-2022-27386
          * CVE-2022-27387
          * CVE-2022-27444
          * CVE-2022-27445
          * CVE-2022-27446
          * CVE-2022-27447
          * CVE-2022-27448
          * CVE-2022-27449
          * CVE-2022-27451
          * CVE-2022-27452
          * CVE-2022-27455
          * CVE-2022-27456
          * CVE-2022-27457
          * CVE-2022-27458

Log message:
mariadb105-client: no need to special case __APPLE__ for pkgsrc builds

The file client/mysql.cc uses the readline library, but it has preprocessor
conditionals specially for __APPLE__.  Pkgsrc expects a common readline,
however, and so the build fails.  Removing the special case handles __APPLE__
the same as other platforms.

Log message:
mariadb105: update to 10.5.15

                         MariaDB 10.5.15 Release Notes

Notable Items

  InnoDB

     * Set innodb_change_buffering=none by default (MDEV-27734)

  Security

     * Fixes for the following security vulnerabilities:
          * CVE-2021-46665
          * CVE-2021-46664
          * CVE-2021-46661
          * CVE-2021-46668
          * CVE-2021-46663

                         MariaDB 10.5.14 Release Notes

Notable Items

  InnoDB

     * --skip-symbolic-links does not disallow .isl file creation
       (MDEV-26870)
     * Indexed CHAR columns are broken with NO_PAD collations (MDEV-25440)
     * insert-intention lock conflicts with waiting ORDINARY lock
       (MDEV-27025)
     * Crash recovery improvements (MDEV-26784, MDEV-27022, MDEV-27183,
       MDEV-27610)

  Galera

     * Galera updated to 26.4.11
     * Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory
       (MDEV-27181)
     * Alter Sequence do not replicate to another nodes with in Galera
       Cluster (MDEV-19353)
     * Galera crash - Assertion. Possible parallel writeset problem
       (MDEV-26803)
     * CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel
       (MDEV-27276)
     * Galera cluster node consider old server_id value even after
       modification of server_id [wsrep_gtid_mode=ON] (MDEV-26223)

  Replication

     * Seconds behind master corrected from artificial spikes at relay-log
       rotation (MDEV-16091)
     * Statement rollback in binlog when transaction creates or drop
       temporary table is set right (MDEV-26833)
     * CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to
       stabilize its parallel execution on slave (MDEV-27365)

  Security

     * Fixes for the following security vulnerabilities:
          * CVE-2022-24052
          * CVE-2022-24051
          * CVE-2022-24050
          * CVE-2022-24048
          * CVE-2021-46659

Log message:
revbump for icu and libffi