Security update for sqlite3 (important)

An update that fixes 21 vulnerabilities, contains one
feature is now available.

Description:

This update for sqlite3 fixes the following issues:

• Update to version 3.36.0
• CVE-2020-15358: heap-based buffer overflow in multiSelectOrderBy due to
  mishandling of query-flattener
  optimization (bsc#1173641)
• CVE-2020-9327: NULL pointer dereference and segmentation fault because
  of generated column optimizations in isAuxiliaryVtabOperator
  (bsc#1164719)
• CVE-2019-20218: selectExpander in select.c proceeds with WITH stack
  unwinding even after a parsing error (bsc#1160439)
• CVE-2019-19959: memory-management error via ext/misc/zipfile.c involving
  embedded ‘\0’ input (bsc#1160438)
• CVE-2019-19923: improper handling of certain uses of SELECT DISTINCT
  in flattenSubquery may lead to null pointer dereference (bsc#1160309)
• CVE-2019-19924: improper error handling in sqlite3WindowRewrite()
  (bsc#1159850)
• CVE-2019-19925: improper handling of NULL pathname during an update of a
  ZIP archive (bsc#1159847)
• CVE-2019-19926: improper handling of certain errors during parsing
  multiSelect in select.c (bsc#1159715)
• CVE-2019-19880: exprListAppendList in window.c allows attackers to
  trigger an invalid pointer dereference (bsc#1159491)
• CVE-2019-19603: during handling of CREATE TABLE and CREATE VIEW
  statements, does not consider confusion with a shadow table name
  (bsc#1158960)
• CVE-2019-19646: pragma.c mishandles NOT NULL in an integrity_check
  PRAGMA command in certain cases of generated columns (bsc#1158959)
• CVE-2019-19645: alter.c allows attackers to trigger infinite recursion
  via certain types of self-referential views in conjunction with ALTER
  TABLE statements (bsc#1158958)
• CVE-2019-19317: lookupName in resolve.c omits bits from the colUsed
  bitmask in the case of a generated column, which allows attackers to
  cause a denial of service (bsc#1158812)
• CVE-2019-19244: sqlite3,sqlite2,sqlite: The function sqlite3Select in
  select.c allows a crash if a sub-select uses both DISTINCT and window
  functions, and also has certain ORDER BY usage (bsc#1157818)
• CVE-2015-3415: sqlite3VdbeExec comparison operator vulnerability
  (bsc#928701)
• CVE-2015-3414: sqlite3,sqlite2: dequoting of collation-sequence names
  (bsc#928700)
• CVE-2020-13434: integer overflow in sqlite3_str_vappendf (bsc#1172115)
• CVE-2020-13630: (bsc#1172234: use-after-free in fts3EvalNextRow
• CVE-2020-13631: virtual table allowed to be renamed to one of its shadow
  tables (bsc#1172236)
• CVE-2020-13632: NULL pointer dereference via crafted matchinfo() query
  (bsc#1172240)
• CVE-2020-13435: Malicious SQL statements could have crashed the process
  that is running SQLite (bsc#1172091)

This update was imported from the SUSE:SLE-15:Update update project.

Patch Instructions:

To install this openSUSE Security Update use the SUSE recommended installation methods
like YaST online_update or “zypper patch”.

Alternatively you can run the command listed for your product:

• openSUSE Leap 15.2:

  zypper in -t patch openSUSE-2021-1058=1