SUSE-SU-2022:3401-1: moderate: Security update for sqlite3

sle-updates at lists.suse.com sle-updates at lists.suse.com
Mon Sep 26 19:25:13 UTC 2022


   SUSE Security Update: Security update for sqlite3
______________________________________________________________________________

Announcement ID:    SUSE-SU-2022:3401-1
Rating:             moderate
References:         #1189802 #1195773 #1201783 
Cross-References:   CVE-2021-36690 CVE-2022-35737
CVSS scores:
                    CVE-2021-36690 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2021-36690 (SUSE): 5.5 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H
                    CVE-2022-35737 (NVD) : 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
                    CVE-2022-35737 (SUSE): 6.3 CVSS:3.1/AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:N

Affected Products:
                    SUSE Linux Enterprise Server 12-SP2-BCL
                    SUSE Linux Enterprise Server 12-SP3-BCL
                    SUSE Linux Enterprise Server 12-SP4-LTSS
                    SUSE Linux Enterprise Server 12-SP5
                    SUSE Linux Enterprise Server for SAP 12-SP4
                    SUSE Linux Enterprise Server for SAP Applications 12-SP5
                    SUSE Linux Enterprise Software Development Kit 12-SP5
                    SUSE OpenStack Cloud 9
                    SUSE OpenStack Cloud Crowbar 9
______________________________________________________________________________

   An update that solves two vulnerabilities and has one
   errata is now available.

Description:

   This update for sqlite3 fixes the following issues:

   Security issues fixed:

   - CVE-2022-35737: Fixed an array-bounds overflow if billions of bytes are
     used in a string argument to a C API (bnc#1201783).
   - CVE-2021-36690: Fixed an issue with the SQLite Expert extension when a
     column has no collating sequence (bsc#1189802).

   - Package the Tcl bindings here again so that we only ship one copy of
     SQLite (bsc#1195773).

   sqlite3 was update to 3.39.3:

   * Use a statement journal on DML statement affecting two or more database
     rows if the statement makes use of a SQL functions that might abort.
   * Use a mutex to protect the PRAGMA temp_store_directory and PRAGMA
     data_store_directory statements, even though they are decremented and
     documented as not being threadsafe.

   Update to 3.39.2:

   * Fix a performance regression in the query planner associated with
     rearranging the order of FROM clause terms in the presences of a LEFT
     JOIN.
   * Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and 1345947, forum
     post 3607259d3c, and other minor problems discovered by internal
     testing. [boo#1201783]

   Update to 3.39.1:

   * Fix an incorrect result from a query that uses a view that contains a
     compound SELECT in which only one arm contains a RIGHT JOIN and where
     the view is not the first FROM clause term
     of the query that contains the view
   * Fix a long-standing problem with ALTER TABLE RENAME that can
     only arise if the sqlite3_limit(SQLITE_LIMIT_SQL_LENGTH) is set to a
      very small value.
   * Fix a long-standing problem in FTS3 that can only arise when compiled
     with the SQLITE_ENABLE_FTS3_PARENTHESIS compile-time
     option.
   * Fix the initial-prefix optimization for the REGEXP extension so that it
     works correctly even if the prefix contains characters that require a
     3-byte UTF8 encoding.
   * Enhance the sqlite_stmt virtual table so that it buffers all of its
     output.

   Update to 3.39.0:

   * Add (long overdue) support for RIGHT and FULL OUTER JOIN
   * Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT
     FROM that are equivalent to IS and IS NOT, respective, for compatibility
     with PostgreSQL and SQL standards
   * Add a new return code (value "3") from the sqlite3_vtab_distinct()
     interface that indicates a query that has both DISTINCT and ORDER BY
     clauses
   * Added the sqlite3_db_name() interface
   * The unix os interface resolves all symbolic links in database filenames
     to create a canonical name for the database before the file is opened
   * Defer materializing views until the materialization is actually needed,
     thus avoiding unnecessary work if the materialization turns out to never
     be used
   * The HAVING clause of a SELECT statement is now allowed on any aggregate
     query, even queries that do not have a GROUP BY clause
   * Many microoptimizations collectively reduce CPU cycles by about 2.3%.

   Update to 3.38.5:

   * Fix a blunder in the CLI of the 3.38.4 release

   Update to 3.38.4:

   * fix a byte-code problem in the Bloom filter pull-down
     optimization added by release 3.38.0 in which an error in the byte code
      causes the byte code engine to enter an infinite loop when the
      pull-down optimization encounters a NULL key

   Update to 3.38.3:

   * Fix a case of the query planner be overly aggressive with
     optimizing automatic-index and Bloom-filter construction, using
      inappropriate ON clause terms to restrict the size of the
      automatic-index or Bloom filter, and resulting in missing rows in the
      output.
   * Other minor patches. See the timeline for details.

   Update to 3.38.2:

   * Fix a problem with the Bloom filter optimization that might cause an
     incorrect answer when doing a LEFT JOIN with a WHERE clause constraint
     that says that one of the columns on the right table of the LEFT JOIN is
     NULL.
   * Other minor patches.

   - Package the Tcl bindings here again so that we only ship one copy
   of SQLite (bsc#1195773).

   Update to 3.38.1:

   * Fix problems with the new Bloom filter optimization that might cause
     some obscure queries to get an incorrect answer.
   * Fix the localtime modifier of the date and time functions so that it
     preserves fractional seconds.
   * Fix the sqlite_offset SQL function so that it works correctly even in
     corner cases such as when the argument is a virtual column or the column
     of a view.
   * Fix row value IN operator constraints on virtual tables so that they
     work correctly even if the virtual table implementation relies on
     bytecode to filter rows that do not satisfy the constraint.
   * Other minor fixes to assert() statements, test cases, and documentation.
     See the source code timeline for details.

   Update to 3.38.0

   * Add the -> and ->> operators for easier processing of JSON
   * The JSON functions are now built-ins
   * Enhancements to date and time functions
   * Rename the printf() SQL function to format() for better compatibility,
     with alias for backwards compatibility.
   * Add the sqlite3_error_offset() interface for helping localize an SQL
     error to a specific character in the input SQL text
   * Enhance the interface to virtual tables
   * CLI columnar output modes are enhanced to correctly handle tabs and
     newlines embedded in text, and add options like "--wrap N", "--wordwrap
     on", and "--quote" to the columnar output modes.
   * Query planner enhancements using a Bloom filter to speed up large
     analytic queries, and a balanced merge tree to evaluate UNION or UNION
     ALL compound SELECT statements that have an ORDER BY clause.
   * The ALTER TABLE statement is changed to silently ignores entries in the
     sqlite_schema table that do not parse when PRAGMA writable_schema=ON

   Update to 3.37.2:

   * Fix a bug introduced in version 3.35.0 (2021-03-12) that can cause
     database corruption if a SAVEPOINT is rolled back while in PRAGMA
     temp_store=MEMORY mode, and other changes are made, and then the outer
     transaction commits
   * Fix a long-standing problem with ON DELETE CASCADE and ON UPDATE CASCADE
     in which a cache of the bytecode used to implement the cascading change
     was not being reset following a local DDL change

   Update to 3.37.1:

   * Fix a bug introduced by the UPSERT enhancements of version 3.35.0 that
     can cause incorrect byte-code to be generated for some obscure but valid
     SQL, possibly resulting in a NULL- pointer dereference.
   * Fix an OOB read that can occur in FTS5 when reading corrupt database
     files.
   * Improved robustness of the --safe option in the CLI.
   * Other minor fixes to assert() statements and test cases.

   Update to 3.37.0:

   * STRICT tables provide a prescriptive style of data type management, for
     developers who prefer that kind of thing.
   * When adding columns that contain a CHECK constraint or a generated
     column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now
     checks new constraints against preexisting rows in the database and will
     only proceed if no constraints are violated.
   * Added the PRAGMA table_list statement.
   * Add the .connection command, allowing the CLI to keep multiple database
     connections open at the same time.
   * Add the --safe command-line option that disables dot-commands and SQL
     statements that might cause side-effects that extend beyond the single
     database file named on the command-line.
   * CLI: Performance improvements when reading SQL statements that span many
     lines.
   * Added the sqlite3_autovacuum_pages() interface.
   * The sqlite3_deserialize() does not and has never worked for the TEMP
     database. That limitation is now noted in the documentation.
   * The query planner now omits ORDER BY clauses on subqueries and views if
     removing those clauses does not change the semantics
     of the query.
   * The generate_series table-valued function extension is modified so that
     the first parameter ("START") is now required. This is done as a way to
     demonstrate how to write table-valued functions with required
     parameters. The legacy behavior is available using the
     -DZERO_ARGUMENT_GENERATE_SERIES compile-time option.
   * Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces.
   * Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2().
   * Use less memory to hold the database schema.
   * bsc#1189802, CVE-2021-36690: Fix an issue with the SQLite Expert
     extension when a column has no collating sequence.


Patch Instructions:

   To install this SUSE 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:

   - SUSE OpenStack Cloud Crowbar 9:

      zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2022-3401=1

   - SUSE OpenStack Cloud 9:

      zypper in -t patch SUSE-OpenStack-Cloud-9-2022-3401=1

   - SUSE Linux Enterprise Software Development Kit 12-SP5:

      zypper in -t patch SUSE-SLE-SDK-12-SP5-2022-3401=1

   - SUSE Linux Enterprise Server for SAP 12-SP4:

      zypper in -t patch SUSE-SLE-SAP-12-SP4-2022-3401=1

   - SUSE Linux Enterprise Server 12-SP5:

      zypper in -t patch SUSE-SLE-SERVER-12-SP5-2022-3401=1

   - SUSE Linux Enterprise Server 12-SP4-LTSS:

      zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2022-3401=1

   - SUSE Linux Enterprise Server 12-SP3-BCL:

      zypper in -t patch SUSE-SLE-SERVER-12-SP3-BCL-2022-3401=1

   - SUSE Linux Enterprise Server 12-SP2-BCL:

      zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2022-3401=1



Package List:

   - SUSE OpenStack Cloud Crowbar 9 (x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1

   - SUSE OpenStack Cloud 9 (x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1

   - SUSE Linux Enterprise Software Development Kit 12-SP5 (aarch64 ppc64le s390x x86_64):

      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1

   - SUSE Linux Enterprise Server for SAP 12-SP4 (ppc64le x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1

   - SUSE Linux Enterprise Server for SAP 12-SP4 (x86_64):

      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1

   - SUSE Linux Enterprise Server 12-SP5 (aarch64 ppc64le s390x x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1

   - SUSE Linux Enterprise Server 12-SP5 (s390x x86_64):

      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1

   - SUSE Linux Enterprise Server 12-SP4-LTSS (aarch64 ppc64le s390x x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1

   - SUSE Linux Enterprise Server 12-SP4-LTSS (s390x x86_64):

      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1

   - SUSE Linux Enterprise Server 12-SP3-BCL (x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1

   - SUSE Linux Enterprise Server 12-SP2-BCL (x86_64):

      libsqlite3-0-3.39.3-9.23.1
      libsqlite3-0-32bit-3.39.3-9.23.1
      libsqlite3-0-debuginfo-3.39.3-9.23.1
      libsqlite3-0-debuginfo-32bit-3.39.3-9.23.1
      sqlite3-3.39.3-9.23.1
      sqlite3-debuginfo-3.39.3-9.23.1
      sqlite3-debugsource-3.39.3-9.23.1
      sqlite3-devel-3.39.3-9.23.1
      sqlite3-tcl-3.39.3-9.23.1


References:

   https://www.suse.com/security/cve/CVE-2021-36690.html
   https://www.suse.com/security/cve/CVE-2022-35737.html
   https://bugzilla.suse.com/1189802
   https://bugzilla.suse.com/1195773
   https://bugzilla.suse.com/1201783



More information about the sle-updates mailing list