Import MariaDB Server 11.8.5 minor maintenance release

Similar to MRs labeled new-upstream-version, this Merge Request contains the import of a new upstream version of MariaDB.

Do not review merge commits or upstream commits, but focus on the ones that are made only on the proposed debian/latest branch update in this MR:

git log --first-parent --reverse --format='format:* %C(yellow)%h%C(reset) %s' debian/latest...

Changelog:

• 36941b1b Update upstream source from tag 'upstream/11.8.5'
• 7719c150 Update changelog and refresh patches after 11.8.5 import
• 3b2135ef MDEV-37600 Backpoint MDEV-9804 Implement a caching_sha2_password plugin
• a5c894a0 MDEV-15502 debian: systemd, with tmpfiles install not required
• 853f534c MDEV-37776: Debian shlibs:Depends shouldn't be explict
• 12871570 Update server trace to include new parameters and values
• 9e3d3fb3 Patch new upstream test main.alter_merge to include 'from Debian'
• 9e0ed68b Add libcrypt-dev to Build-Depends (Closes: #1106944)
• a45d9d30 Update German translation of debconf messages (Closes: #1120669)
• a98f8b0f Extend unstable tests to skip for sparc64 and x32
• 6d44b6da Remove Rules-Requires-Root
• 49d7774c Update patch Forwarded fields to reflect latest status
• 6b39523e Update changelog for 1:11.8.5-1 release

mariadb (1:11.8.5-1) unstable; urgency=medium

  [ Otto Kekäläinen ]
  * New upstream maintenance release 11.8.5. For details about fixes please see
    https://mariadb.com/docs/release-notes/community-server/11.8/11.8.5
  * The version 11.8.4 was skipped in Debian (and Ubuntu) as it has a severe
    regression causing partial data deletion when using the DELETE statement on
    MyISAM or Aria tables under specific conditions (MDEV-38068)
  * For details about fixes in 11.8.4 please see
    https://mariadb.com/docs/release-notes/community-server/11.8/11.8.4
  * This release does _not_ include any CVE tracked security fixes as per
    https://mariadb.com/docs/server/security/securing-mariadb/security
  * Update server trace to include new parameters and values
  * Add Lintian override for false error in test plugin
  * Patch new upstream test main.alter_merge to include 'from Debian'
  * Add libcrypt-dev to Build-Depends (Closes: #1106944)
  * Extend unstable tests to skip for sparc64 and x32
  * Remove Rules-Requires-Root
  * Update patch Forwarded fields to reflect latest status
  * Salsa CI: Disable running `gbp setup-gitattributes`
  * Salsa CI: Fix typos introduced in 855bc4f6

  [ Daniel Black ]
  * MDEV-37411: Re-enable AIO in Debian
  * MDEV-15502: use tmpfiles with systemd (Closes: #1028272)
  * MDEV-37776: shlibs:Depends shouldn't be explict

  [ Jean Weisbuch ]
  * MDEV-37852: Fix mytop connection to localhost (Closes: #1109394)

  [ Christian Hesse ]
  * MDEV-35904/MDEV-19210: use environment file in systemd units for
    _WSREP_START_POSITION (Closes: #1105029)

  [ Aquila Macedo ]
  * Add patch for new PCRE2 version 10.47 offset change (Closes: #1119866)
  * Salsa CI: install build-essential for Python-MySQLdb job (Closes: #1121027)
  * Salsa CI: keep provider plugins in sync in bookworm -> sid upgrade job

  [ Sergei Golubchik ]
  * MDEV-37600: Implement caching_sha2_password plugin for MySQL compatibility

  [ Helge Kreutzmann ]
  * Update German translation of debconf messages (Closes: #1120669)

I am not aware of any additional Debian tracked bugs at https://bugs.debian.org/cgi-bin/pkgreport.cgi?repeatmerged=no&src=mariadb that would be fixed by this version.

I did not spot any new CVEs at https://mariadb.com/docs/server/security that would apply for this version, thus there are no CVE entries in the changelog either.

Note also test builds on multiple architectures at https://launchpad.net/~mysql-ubuntu/+archive/ubuntu/mariadb/+builds?build_text=&build_state=all