Log Message:
mariadb: Update to 10.6.20

                         MariaDB 10.6.20 Release Notes

Notable Items

  Storage Engines

    InnoDB

     * Fix attempt to read outside the bounds of the file: ./ibdata1
       (MDEV-34453)
     * Fix MariaDB crash with SIGILL because the OS does not support AVX512
       (MDEV-34565)
     * Fix deadlock caused by lock_rec_unlock_unmodified() (MDEV-34690)
     * Fix duplicate key error in table 'mysql.innodb_table_stats'
       (MDEV-34207)
     * Fix possible adaptive hash index corruption with ALTER TABLE...IMPORT
       TABLESPACE and FULLTEXT SEARCH (MDEV-35059)
     * XA prepare now correctly releases unmodified records in non-blocking
       mode (MDEV-34466)
     * Fix contention between secondary index UPDATE and purge due to large
       innodb_purge_batch_size (MDEV-34515)
          * New default of 127 for innodb_purge_batch_size (previously 1000).
     * Fix redundant page lookups that hurt performance (MDEV-34791)

    Spider

     * Fix server crash when calling spider UDF after aria_encrypt_tables is
       enabled (MDEV-34682)
     * SELECT MIN on Spider table no longer returns more rows than expected
       (MDEV-26345)
     * Fix Spider group by handler wrong result on order by aggregate
       (MDEV-29546)

    S3

     * Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3
       and possibly other S3 providers (MDEV-34867)
          * A new option s3-provider has been added. s3-provider=Huawai needs
            to be set for Huawai Cloud S3

  Optimizer

     * Fix crash caused by query containing constant having clause
       (MDEV-23983)
     * Fix assertion with optimizer_join_limit_pref_ratio and 1-table select
       (MDEV-35072)

  Data Definition - Alter Table

     * Modification of the column now correctly checks foreign key constraint
       (MDEV-34392)
     * Fix incorrect NULL value handling for instantly dropped BLOB columns
       (MDEV-35122)

  Galera

     * Galera updated to 26.4.20
     * Fix server crash when setting wsrep_cluster_address after adding
       invalid value to wsrep_allowlist table (MDEV-31173)
     * TOI (ALTER) no longer hangs on a parent table if SR transaction is in
       progress on a child table (MDEV-34836)
     * Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera
       (MDEV-34647)
     * Fix case where with wsrep_mode=REPLICATE_ARIA, only part of the
       mixed-engine transactions was replicated (MDEV-30653)
     * Fix galera_ssl_reload failure with warning message (MDEV-32778)
     * When InnoDB gets an assertion failure, WSREP layer is now handled
       gracefully (MDEV-32363)

  Backup

     * Recovery now correctly notes some log corruption (MDEV-34802)
     * InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED
       tables (MDEV-34879)
     * Can now selectively restore sequences using innodb tables from backup
       (MDEV-32350)

  JSON

     * JSON_TABLE now properly unquotes strings (MDEV-27412)
     * JSON_TABLE default values now allows non-string literals (MDEV-25822)

  General

     * mariadbd no longer hangs on startup when --init-file target does not
       exist (MDEV-34814)
     * LOAD DATA INFILE with geometry data no longer fails (MDEV-34883)
     * Fix heap-use-after-free in group_concat with compressed or GIS columns
       (MDEV-16699)
     * Fix assertion `!is_cond()' failed in Item_bool_func::val_int /
       do_select (MDEV-35135)
     * Trigger now works correctly with bulk update (MDEV-34718)
     * Fix assertion failure in find_producing_item upon a query from a view
       (MDEV-35276)
     * Add new setting, --quick-max-column-width to the mariadb client for
       use in --quick mode (MDEV-34704)