openSUSE Security Update: Security update for sqlite3
______________________________________________________________________________

Announcement ID:    openSUSE-SU-2021:1058-1
Rating:             important
References:         #1157818 #1158812 #1158958 #1158959 #1158960 
                    #1159491 #1159715 #1159847 #1159850 #1160309 
                    #1160438 #1160439 #1164719 #1172091 #1172115 
                    #1172234 #1172236 #1172240 #1173641 #928700 
                    #928701 SLE-16032 
Cross-References:   CVE-2015-3414 CVE-2015-3415 CVE-2019-19244
                    CVE-2019-19317 CVE-2019-19603 CVE-2019-19645
                    CVE-2019-19646 CVE-2019-19880 CVE-2019-19923
                    CVE-2019-19924 CVE-2019-19925 CVE-2019-19926
                    CVE-2019-19959 CVE-2019-20218 CVE-2020-13434
                    CVE-2020-13435 CVE-2020-13630 CVE-2020-13631
                    CVE-2020-13632 CVE-2020-15358 CVE-2020-9327
                   
CVSS scores:
                    CVE-2019-19244 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19244 (SUSE): 5.9 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19317 (NVD) : 9.8 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
                    CVE-2019-19317 (SUSE): 4 CVSS:3.1/AV:L/AC:L/PR:N/UI:N/S:U/C:N/I:L/A:N
                    CVE-2019-19603 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19603 (SUSE): 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19645 (NVD) : 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19645 (SUSE): 5.1 CVSS:3.1/AV:L/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19646 (NVD) : 9.8 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
                    CVE-2019-19646 (SUSE): 6.3 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L
                    CVE-2019-19880 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19923 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19923 (SUSE): 6.3 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L
                    CVE-2019-19924 (NVD) : 5.3 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:L/A:N
                    CVE-2019-19924 (SUSE): 5.3 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:L/A:N
                    CVE-2019-19925 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19925 (SUSE): 3.3 CVSS:3.1/AV:L/AC:L/PR:N/UI:R/S:U/C:N/I:N/A:L
                    CVE-2019-19926 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19926 (SUSE): 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-19959 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:H/A:N
                    CVE-2019-19959 (SUSE): 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:L
                    CVE-2019-20218 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2019-20218 (SUSE): 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-13434 (NVD) : 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-13434 (SUSE): 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-13435 (NVD) : 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-13435 (SUSE): 7.1 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:H
                    CVE-2020-13630 (NVD) : 7 CVSS:3.1/AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H
                    CVE-2020-13630 (SUSE): 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:L/A:L
                    CVE-2020-13631 (NVD) : 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:H/A:N
                    CVE-2020-13631 (SUSE): 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:H/A:N
                    CVE-2020-13632 (NVD) : 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-13632 (SUSE): 4.3 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:L
                    CVE-2020-15358 (NVD) : 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-15358 (SUSE): 6.3 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L
                    CVE-2020-9327 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2020-9327 (SUSE): 4.3 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:L

Affected Products:
                    openSUSE Leap 15.2
______________________________________________________________________________

   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



Package List:

   - openSUSE Leap 15.2 (i586 x86_64):

      libsqlite3-0-3.36.0-lp152.4.3.1
      libsqlite3-0-debuginfo-3.36.0-lp152.4.3.1
      sqlite3-3.36.0-lp152.4.3.1
      sqlite3-debuginfo-3.36.0-lp152.4.3.1
      sqlite3-debugsource-3.36.0-lp152.4.3.1
      sqlite3-devel-3.36.0-lp152.4.3.1

   - openSUSE Leap 15.2 (x86_64):

      libsqlite3-0-32bit-3.36.0-lp152.4.3.1
      libsqlite3-0-32bit-debuginfo-3.36.0-lp152.4.3.1

   - openSUSE Leap 15.2 (noarch):

      sqlite3-doc-3.36.0-lp152.4.3.1


References:

   https://www.suse.com/security/cve/CVE-2015-3414.html
   https://www.suse.com/security/cve/CVE-2015-3415.html
   https://www.suse.com/security/cve/CVE-2019-19244.html
   https://www.suse.com/security/cve/CVE-2019-19317.html
   https://www.suse.com/security/cve/CVE-2019-19603.html
   https://www.suse.com/security/cve/CVE-2019-19645.html
   https://www.suse.com/security/cve/CVE-2019-19646.html
   https://www.suse.com/security/cve/CVE-2019-19880.html
   https://www.suse.com/security/cve/CVE-2019-19923.html
   https://www.suse.com/security/cve/CVE-2019-19924.html
   https://www.suse.com/security/cve/CVE-2019-19925.html
   https://www.suse.com/security/cve/CVE-2019-19926.html
   https://www.suse.com/security/cve/CVE-2019-19959.html
   https://www.suse.com/security/cve/CVE-2019-20218.html
   https://www.suse.com/security/cve/CVE-2020-13434.html
   https://www.suse.com/security/cve/CVE-2020-13435.html
   https://www.suse.com/security/cve/CVE-2020-13630.html
   https://www.suse.com/security/cve/CVE-2020-13631.html
   https://www.suse.com/security/cve/CVE-2020-13632.html
   https://www.suse.com/security/cve/CVE-2020-15358.html
   https://www.suse.com/security/cve/CVE-2020-9327.html
   https://bugzilla.suse.com/1157818
   https://bugzilla.suse.com/1158812
   https://bugzilla.suse.com/1158958
   https://bugzilla.suse.com/1158959
   https://bugzilla.suse.com/1158960
   https://bugzilla.suse.com/1159491
   https://bugzilla.suse.com/1159715
   https://bugzilla.suse.com/1159847
   https://bugzilla.suse.com/1159850
   https://bugzilla.suse.com/1160309
   https://bugzilla.suse.com/1160438
   https://bugzilla.suse.com/1160439
   https://bugzilla.suse.com/1164719
   https://bugzilla.suse.com/1172091
   https://bugzilla.suse.com/1172115
   https://bugzilla.suse.com/1172234
   https://bugzilla.suse.com/1172236
   https://bugzilla.suse.com/1172240
   https://bugzilla.suse.com/1173641
   https://bugzilla.suse.com/928700
   https://bugzilla.suse.com/928701

openSUSE: 2021:1058-1 important: sqlite3

July 19, 2021
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

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


Package List

- openSUSE Leap 15.2 (i586 x86_64): libsqlite3-0-3.36.0-lp152.4.3.1 libsqlite3-0-debuginfo-3.36.0-lp152.4.3.1 sqlite3-3.36.0-lp152.4.3.1 sqlite3-debuginfo-3.36.0-lp152.4.3.1 sqlite3-debugsource-3.36.0-lp152.4.3.1 sqlite3-devel-3.36.0-lp152.4.3.1 - openSUSE Leap 15.2 (x86_64): libsqlite3-0-32bit-3.36.0-lp152.4.3.1 libsqlite3-0-32bit-debuginfo-3.36.0-lp152.4.3.1 - openSUSE Leap 15.2 (noarch): sqlite3-doc-3.36.0-lp152.4.3.1


References

https://www.suse.com/security/cve/CVE-2015-3414.html https://www.suse.com/security/cve/CVE-2015-3415.html https://www.suse.com/security/cve/CVE-2019-19244.html https://www.suse.com/security/cve/CVE-2019-19317.html https://www.suse.com/security/cve/CVE-2019-19603.html https://www.suse.com/security/cve/CVE-2019-19645.html https://www.suse.com/security/cve/CVE-2019-19646.html https://www.suse.com/security/cve/CVE-2019-19880.html https://www.suse.com/security/cve/CVE-2019-19923.html https://www.suse.com/security/cve/CVE-2019-19924.html https://www.suse.com/security/cve/CVE-2019-19925.html https://www.suse.com/security/cve/CVE-2019-19926.html https://www.suse.com/security/cve/CVE-2019-19959.html https://www.suse.com/security/cve/CVE-2019-20218.html https://www.suse.com/security/cve/CVE-2020-13434.html https://www.suse.com/security/cve/CVE-2020-13435.html https://www.suse.com/security/cve/CVE-2020-13630.html https://www.suse.com/security/cve/CVE-2020-13631.html https://www.suse.com/security/cve/CVE-2020-13632.html https://www.suse.com/security/cve/CVE-2020-15358.html https://www.suse.com/security/cve/CVE-2020-9327.html https://bugzilla.suse.com/1157818 https://bugzilla.suse.com/1158812 https://bugzilla.suse.com/1158958 https://bugzilla.suse.com/1158959 https://bugzilla.suse.com/1158960 https://bugzilla.suse.com/1159491 https://bugzilla.suse.com/1159715 https://bugzilla.suse.com/1159847 https://bugzilla.suse.com/1159850 https://bugzilla.suse.com/1160309 https://bugzilla.suse.com/1160438 https://bugzilla.suse.com/1160439 https://bugzilla.suse.com/1164719 https://bugzilla.suse.com/1172091 https://bugzilla.suse.com/1172115 https://bugzilla.suse.com/1172234 https://bugzilla.suse.com/1172236 https://bugzilla.suse.com/1172240 https://bugzilla.suse.com/1173641 https://bugzilla.suse.com/928700 https://bugzilla.suse.com/928701


Severity
Announcement ID: openSUSE-SU-2021:1058-1
Rating: important
Affected Products: openSUSE Leap 15.2 ble.

Related News