CVE-2021-46657

get_sort_by_table in MariaDB before 10.6.2 allows an application crash via certain subquery uses of ORDER BY.

MariaDB is a community developed fork from MySQL - a multi-user, multi-threaded SQL database server. It is a client/server implementation consisting of a server daemon (mariadbd) and many different client programs and libraries. The base package contains the standard MariaDB/MySQL client programs and utilities.

MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases.

Security Fix(es):

MariaDB through 10.5.9 allows attackers to trigger a convert_const_to_int use-after-free when the BIGINT data type is used.(CVE-2021-46669)

MariaDB through 10.5.9 allows an application crash in find_field_in_tables and find_order_in_list via an unused common table expression (CTE).(CVE-2021-46661)

MariaDB before 10.6.5 has a sql_lex.cc integer overflow, leading to an application crash.(CVE-2021-46667)

MariaDB before 10.6.2 allows an application crash because of mishandling of a pushdown from a HAVING clause to a WHERE clause.(CVE-2021-46666)

MariaDB through 10.5.9 allows a set_var.cc application crash via certain uses of an UPDATE statement in conjunction with a nested subquery.(CVE-2021-46662)

MariaDB through 10.5.13 allows a ha_maria::extra application crash via certain SELECT statements.(CVE-2021-46663)

MariaDB through 10.5.9 allows a sql_parse.cc application crash because of incorrect used_tables expectations.(CVE-2021-46665)

MariaDB through 10.5.9 allows an application crash in sub_select_postjoin_aggr for a NULL value of aggr.(CVE-2021-46664)

MariaDB before 10.7.2 allows an application crash because it does not recognize that SELECT_LEX::nest_level is local to each VIEW.(CVE-2021-46659)

get_sort_by_table in MariaDB before 10.6.2 allows an application crash via certain subquery uses of ORDER BY.(CVE-2021-46657)

MariaDB is a multi-user, multi-threaded SQL database server that is binary compatible with MySQL.

The following packages have been upgraded to a later upstream version: mariadb (10.3.32), galera (25.3.34). (BZ#2050543)

Security Fix(es):

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2154)

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2166)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2372)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2389)

• mysql: InnoDB unspecified vulnerability (CPU Oct 2021) (CVE-2021-35604)

• mariadb: Integer overflow in sql_lex.cc integer leading to crash (CVE-2021-46667)

• mariadb: Crash in get_sort_by_table() in subquery with ORDER BY having outer ref (CVE-2021-46657)

• mariadb: save_window_function_values triggers an abort during IN subquery (CVE-2021-46658)

• mariadb: Crash in set_var.cc via certain UPDATE queries with nested subqueries (CVE-2021-46662)

• mariadb: Crash caused by mishandling of a pushdown from a HAVING clause to a WHERE clause (CVE-2021-46666)

• mariadb: No password masking in audit log when using ALTER USER <user> IDENTIFIED BY <password> command (BZ#1981332)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Bug Fix(es):

• mariadb:10.3/mariadb: /etc/security/user_map.conf getting overwritten with mariadb-server upgrade (BZ#2050514)

• MariaDB logrotate leads to "gzip: stdin: file size changed while zipping" (BZ#2050532)

• Crash: WSREP: invalid state ROLLED_BACK (FATAL) (BZ#2050533)

• Galera doesn't work without 'procps-ng' package MariaDB-10.3 (BZ#2050550)

MariaDB is a multi-user, multi-threaded SQL database server that is binary compatible with MySQL.

The following packages have been upgraded to a later upstream version: mariadb (10.5.13), galera (26.4.9). (BZ#2050546)

Security Fix(es):

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2154)

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2166)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2372)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2389)

• mysql: InnoDB unspecified vulnerability (CPU Oct 2021) (CVE-2021-35604)

• mariadb: Integer overflow in sql_lex.cc integer leading to crash (CVE-2021-46667)

• mariadb: Crash in get_sort_by_table() in subquery with ORDER BY having outer ref (CVE-2021-46657)

• mariadb: save_window_function_values triggers an abort during IN subquery (CVE-2021-46658)

• mariadb: Crash in set_var.cc via certain UPDATE queries with nested subqueries (CVE-2021-46662)

• mariadb: Crash caused by mishandling of a pushdown from a HAVING clause to a WHERE clause (CVE-2021-46666)

• mariadb: No password masking in audit log when using ALTER USER <user> IDENTIFIED BY <password> command (BZ#1981332)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Bug Fix(es):

• mariadb-10.5-module: /etc/security/user_map.conf getting overwritten with mariadb-server upgrade (BZ#2050515)

• mariadb-server:10.5 in centos8 stream is not shipping wsrep_sst_rsync_tunnel (BZ#2050524)

• Galera doesn't work without 'procps-ng' package MariaDB-10.5 (BZ#2050542)

get_sort_by_table in MariaDB before 10.6.2 allows an application crash via certain subquery uses of ORDER BY.

MariaDB is a multi-user, multi-threaded SQL database server that is binary compatible with MySQL.

The following packages have been upgraded to a later upstream version: mariadb (10.3.32), galera (25.3.34). (BZ#2050543)

Security Fix(es):

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2154)

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2166)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2372)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2389)

• mysql: InnoDB unspecified vulnerability (CPU Oct 2021) (CVE-2021-35604)

• mariadb: Integer overflow in sql_lex.cc integer leading to crash (CVE-2021-46667)

• mariadb: Crash in get_sort_by_table() in subquery with ORDER BY having outer ref (CVE-2021-46657)

• mariadb: save_window_function_values triggers an abort during IN subquery (CVE-2021-46658)

• mariadb: Crash in set_var.cc via certain UPDATE queries with nested subqueries (CVE-2021-46662)

• mariadb: Crash caused by mishandling of a pushdown from a HAVING clause to a WHERE clause (CVE-2021-46666)

• mariadb: No password masking in audit log when using ALTER USER <user> IDENTIFIED BY <password> command (BZ#1981332)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Bug Fix(es):

• mariadb:10.3/mariadb: /etc/security/user_map.conf getting overwritten with mariadb-server upgrade (BZ#2050514)

• MariaDB logrotate leads to "gzip: stdin: file size changed while zipping" (BZ#2050532)

• Crash: WSREP: invalid state ROLLED_BACK (FATAL) (BZ#2050533)

• Galera doesn't work without 'procps-ng' package MariaDB-10.3 (BZ#2050550)

MariaDB is a multi-user, multi-threaded SQL database server that is binary compatible with MySQL.

The following packages have been upgraded to a later upstream version: mariadb (10.5.13), galera (26.4.9). (BZ#2050546)

Security Fix(es):

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2154)

• mysql: Server: DML unspecified vulnerability (CPU Apr 2021) (CVE-2021-2166)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2372)

• mysql: InnoDB unspecified vulnerability (CPU Jul 2021) (CVE-2021-2389)

• mysql: InnoDB unspecified vulnerability (CPU Oct 2021) (CVE-2021-35604)

• mariadb: Integer overflow in sql_lex.cc integer leading to crash (CVE-2021-46667)

• mariadb: Crash in get_sort_by_table() in subquery with ORDER BY having outer ref (CVE-2021-46657)

• mariadb: save_window_function_values triggers an abort during IN subquery (CVE-2021-46658)

• mariadb: Crash in set_var.cc via certain UPDATE queries with nested subqueries (CVE-2021-46662)

• mariadb: Crash caused by mishandling of a pushdown from a HAVING clause to a WHERE clause (CVE-2021-46666)

• mariadb: No password masking in audit log when using ALTER USER <user> IDENTIFIED BY <password> command (BZ#1981332)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Bug Fix(es):

• mariadb-10.5-module: /etc/security/user_map.conf getting overwritten with mariadb-server upgrade (BZ#2050515)

• mariadb-server:10.5 in centos8 stream is not shipping wsrep_sst_rsync_tunnel (BZ#2050524)

• Galera doesn't work without 'procps-ng' package MariaDB-10.5 (BZ#2050542)

get_sort_by_table in MariaDB before 10.6.2 allows an application crash via certain subquery uses of ORDER BY.

get_sort_by_table in MariaDB before 10.6.2 allows an application crash via certain subquery uses of ORDER BY.

get_sort_by_table in MariaDB before 10.6.2 allows an application crash via certain subquery uses of ORDER BY.

• CVE-2021-46657: fix crash in get_sort_by_table() on subquery with ORDER BY referencing an outer-query alias (MDEV-25629)

• Rebase onto the vendor's 5.5.68-1.0.1 sources
• CVE-2021-46657: fix crash in get_sort_by_table() on subquery with ORDER BY referencing an outer-query alias (MDEV-25629)
• CVE-2025-13699: take the vendor's fix, keep our regression test, fix the mysqlimport crash with the default charset
• Take the vendor's SSL certificate and timezone test fixes, keep the parts they lack: verify-fail certificates, host time zone mapping in timezone.test

• Rebase onto the vendor's 5.5.68-1.0.1 sources
• CVE-2021-46657: fix crash in get_sort_by_table() on subquery with ORDER BY referencing an outer-query alias (MDEV-25629)
• CVE-2025-13699: take the vendor's fix, keep our regression test, fix the mysqlimport crash with the default charset
• Take the vendor's SSL certificate and timezone test fixes, keep the parts they lack: verify-fail certificates, host time zone mapping in timezone.test

This update for mariadb fixes the following issues:

• Update to 10.5.15 (bsc#1196016):

  • 10.5.15: CVE-2021-46665 CVE-2021-46664 CVE-2021-46661 CVE-2021-46668 CVE-2021-46663
  • 10.5.14: CVE-2022-24052 CVE-2022-24051 CVE-2022-24050 CVE-2022-24048 CVE-2021-46659, bsc#1195339

• The following issues have already been fixed in this package but weren't previously mentioned in the changes file: CVE-2021-46658, bsc#1195334 CVE-2021-46657, bsc#1195325

These are all security issues fixed in the libmariadbd-devel-10.7.3-1.1 package on the GA media of openSUSE Tumbleweed.

This update for mariadb104 fixes the following issues:

• Implement version 10.4 of MariaDB (jsc#PED-2455):
  • It is possible to use more than one authentication plugin for each user account.
  • The root user account is being created with the ability to use two authentication plugins.
  • All user accounts, passwords, and global privileges are now stored in the mysql.global_priv table.
  • Is being supported for User Password Expiry, which is not active by default.
  • Faster privilege checks for MariaDB setups with many user accounts or many database grants.
• Update mysql-systemd-helper to be aware of custom group (bsc#1200105)
• MariaDB is now support lz4 compression for 'INNODB'. (bsc#1186031)
• Add 'mysql-user.conf' file to enable systemd generating mysql user in containers. (bsc#1173028)
• Fixes an issue when MariaDB is ignoring the value of the parameter 'open_files_limit' in the global variables. (bsc#1180014)

This update for mariadb104 fixes the following issues:

• Implement version 10.4 of MariaDB (jsc#PED-2455):
  • It is possible to use more than one authentication plugin for each user account.
  • The root user account is being created with the ability to use two authentication plugins.
  • All user accounts, passwords, and global privileges are now stored in the mysql.global_priv table.
  • Is being supported for User Password Expiry, which is not active by default.
  • Faster privilege checks for MariaDB setups with many user accounts or many database grants.
• Update mysql-systemd-helper to be aware of custom group (bsc#1200105)
• MariaDB is now support lz4 compression for 'INNODB'. (bsc#1186031)
• Add 'mysql-user.conf' file to enable systemd generating mysql user in containers. (bsc#1173028)
• Fixes an issue when MariaDB is ignoring the value of the parameter 'open_files_limit' in the global variables. (bsc#1180014)

This update for mariadb fixes the following issues:

• Update to 10.2.43 (bsc#1196016): 10.2.43: CVE-2021-46665 CVE-2021-46664 CVE-2021-46661 CVE-2021-46668 CVE-2021-46663 10.2.42: CVE-2022-24052 CVE-2022-24051 CVE-2022-24050 CVE-2022-24048 CVE-2021-46659, bsc#1195339

• The following issues have already been fixed in this package but weren't previously mentioned in the changes file: CVE-2021-46658, bsc#1195334 CVE-2021-46657, bsc#1195325

This update for mariadb fixes the following issues:

• Update to 10.4.24 (bsc#1196016):

  • 10.4.24: CVE-2021-46665 CVE-2021-46664 CVE-2021-46661 CVE-2021-46668 CVE-2021-46663
  • 10.4.23: CVE-2022-24052 CVE-2022-24051 CVE-2022-24050 CVE-2022-24048 CVE-2021-46659, bsc#1195339

• The following issues have already been fixed in this package but weren't previously mentioned in the changes file: CVE-2021-46658, bsc#1195334 CVE-2021-46657, bsc#1195325

This update for mariadb fixes the following issues:

• Update to 10.5.15 (bsc#1196016):

  • 10.5.15: CVE-2021-46665 CVE-2021-46664 CVE-2021-46661 CVE-2021-46668 CVE-2021-46663
  • 10.5.14: CVE-2022-24052 CVE-2022-24051 CVE-2022-24050 CVE-2022-24048 CVE-2021-46659, bsc#1195339

• The following issues have already been fixed in this package but weren't previously mentioned in the changes file: CVE-2021-46658, bsc#1195334 CVE-2021-46657, bsc#1195325

This update for mariadb fixes the following issues:

• Update to 10.5.15 (bsc#1196016):

  • 10.5.15: CVE-2021-46665 CVE-2021-46664 CVE-2021-46661 CVE-2021-46668 CVE-2021-46663
  • 10.5.14: CVE-2022-24052 CVE-2022-24051 CVE-2022-24050 CVE-2022-24048 CVE-2021-46659, bsc#1195339

• The following issues have already been fixed in this package but weren't previously mentioned in the changes file: CVE-2021-46658, bsc#1195334 CVE-2021-46657, bsc#1195325

This update for mariadb fixes the following issues:

• Update to 10.2.43 (bsc#1196016):

  • 10.2.43: CVE-2021-46665 CVE-2021-46664 CVE-2021-46661 CVE-2021-46668 CVE-2021-46663
  • 10.2.42: CVE-2022-24052 CVE-2022-24051 CVE-2022-24050 CVE-2022-24048 CVE-2021-46659, bsc#1195339

• The following issues have already been fixed in this package but weren't previously mentioned in the changes file: CVE-2021-46658, bsc#1195334 CVE-2021-46657, bsc#1195325

This update for mariadb fixes the following issues:

• Added mariadb-galera (jsc#SLE-22245)

Update to 10.6.8 (bsc#1199928):

• CVE-2021-46669 (bsc#1199928)

• CVE-2022-27376 (bsc#1198628)

• CVE-2022-27377 (bsc#1198603)

• CVE-2022-27378 (bsc#1198604)

• CVE-2022-27379 (bsc#1198605)

• CVE-2022-27380 (bsc#1198606)

• CVE-2022-27381 (bsc#1198607)

• CVE-2022-27382 (bsc#1198609)

• CVE-2022-27383 (bsc#1198610)

• CVE-2022-27384 (bsc#1198611)

• CVE-2022-27386 (bsc#1198612)

• CVE-2022-27387 (bsc#1198613)

• CVE-2022-27444 (bsc#1198634)

• CVE-2022-27445 (bsc#1198629)

• CVE-2022-27446 (bsc#1198630)

• CVE-2022-27447 (bsc#1198631)

• CVE-2022-27448 (bsc#1198632)

• CVE-2022-27449 (bsc#1198633)

• CVE-2022-27451 (bsc#1198639)

• CVE-2022-27452 (bsc#1198640)

• CVE-2022-27455 (bsc#1198638)

• CVE-2022-27456 (bsc#1198635)

• CVE-2022-27457 (bsc#1198636)

• CVE-2022-27458 (bsc#1198637)

• The following issue is not affecting this package: CVE-2022-21427

Update to 10.6.7 (bsc#1196016):

• CVE-2021-46665, CVE-2021-46664, CVE-2021-46661, CVE-2021-46668, CVE-2021-46663

Update to 10.6.6:

• CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659 (bsc#1195339)

The following issues have been fixed already but didn't have CVE references:

• CVE-2021-46658 (bsc#1195334)
• CVE-2021-46657 (bsc#1195325)

Non security fixes:

• Skip failing tests for s390x, fixes bsc#1195076

External refernences:

• https://mariadb.com/kb/en/library/mariadb-1068-release-notes
• https://mariadb.com/kb/en/library/mariadb-1068-changelog
• https://mariadb.com/kb/en/library/mariadb-1067-release-notes
• https://mariadb.com/kb/en/library/mariadb-1067-changelog
• https://mariadb.com/kb/en/library/mariadb-1066-release-notes
• https://mariadb.com/kb/en/library/mariadb-1066-changelog