Index index by Group index by Distribution index by Vendor index by creation date index by Name Mirrors Help Search

sqlite3-3.36.0-1.1 RPM for armv7hl

From OpenSuSE Ports Tumbleweed for armv7hl

Name: sqlite3 Distribution: openSUSE Tumbleweed
Version: 3.36.0 Vendor: openSUSE
Release: 1.1 Build date: Mon Jun 28 15:36:49 2021
Group: Productivity/Databases/Servers Build host: armbuild02
Size: 1480988 Source RPM: sqlite3-3.36.0-1.1.src.rpm
Summary: Embeddable SQL Database Engine
SQLite is a C library that implements an embeddable SQL database
engine. Programs that link with the SQLite library can have SQL
database access without running a separate RDBMS process.

SQLite is not a client library used to connect to a big database
server. SQLite is a server and the SQLite library reads and writes
directly to and from the database files on disk.

SQLite can be used via the sqlite command line tool or via any
application that supports the Qt database plug-ins.






* Tue Jun 22 2021 Paolo Stivanin <>
  - SQLite3 3.36.0:
    * Improvement to the EXPLAIN QUERY PLAN output to make it
      easier to understand.
    * Byte-order marks at the start of a token are skipped
      as if they were whitespace.
    * An error is raised on any attempt to access the rowid of a VIEW
      or subquery. Formerly, the rowid of a VIEW would be indeterminate
      and often would be NULL. The -DSQLITE_ALLOW_ROWID_IN_VIEW
      compile-time option is available to restore the legacy behavior
      for applications that need it.
    * The sqlite3_deserialize() and sqlite3_serialize() interfaces
      are now enabled by default. The -DSQLITE_ENABLE_DESERIALIZE
      compile-time option is no longer required. Instead, there is
      a new -DSQLITE_OMIT_DESERIALIZE compile-time option to omit
      those interfaces.
    * The "memdb" VFS now allows the same in-memory database
      to be shared among multiple database connections in the same
      process as long as the database name begins with "/".
    * Back out the EXISTS-to-IN optimization (item 8b in the
      SQLite 3.35.0 change log) as it was found to slow down
      queries more often than speed them up.
    * Improve the constant-propagation optimization so that it works
      on non-join queries.
    * The REGEXP extension is now included in CLI builds.
* Tue Apr 20 2021 Andreas Stieger <>
  - SQLite3 3.35.5:
    * Fix defects in the new ALTER TABLE DROP COLUMN feature that
      could corrupt the database file
    * Fix an obscure query optimizer problem that might cause an
      incorrect query result
* Tue Apr 06 2021 Reinhard Max <>
  - Fix build on SLE-12
* Tue Apr 06 2021 Dirk Müller <>
  - use https urls
* Sat Apr 03 2021 Andreas Stieger <>
  - SQLite 3.35.4:
    * Fix a defect in the query planner optimization
    * Fix a defect in the new RETURNING syntax
    * Fix the new RETURNING feature so that it raises an error if one
      of the terms in the RETURNING clause references a unknown
      table, instead of silently ignoring that error
    * Fix an assertion associated with aggregate function processing
      that was incorrectly triggered by the push-down optimization
* Sat Mar 27 2021 Andreas Stieger <>
  - SQLite 3.35.3:
    * Enhance the OP_OpenDup opcode of the bytecode engine so that
      it works even if the cursor being duplicated itself came from
    * When materializing correlated common table expressions, do so
      separately for each use case, as that is required for
      correctness. This fixes a problem that was introduced by the
      MATERIALIZED hint enhancement.
    * Fix a problem in the filename normalizer of the unix VFS
    * Fix the "box" output mode in the CLI so that it works with
      statements that returns one or more rows of zero columns
      (such as PRAGMA incremental_vacuum)
    * Improvements to error messages generated by faulty common
      table expressions
    * Fix some incorrect assert() statements
    * Fix to the SELECT statement syntax diagram so that the FROM
      clause syntax is shown correctly
    * Fix the EBCDIC character classifier so that it understands
      newlines as whitespace
    * Improvements the xBestIndex method in the implementation of the
      (unsupported) wholenumber virtual table extension so that it
      does a better job of convincing the query planner to avoid
      trying to materialize a table with an infinite number of rows
* Fri Mar 19 2021 Martin Liška <>
  - Fix typo in macro definition.
* Wed Mar 17 2021 Andreas Stieger <>
  - SQLite 3.35.2:
    * Fix a problem in the appendvfs.c extension that was introduced
      into version 3.35.0.
    * Ensure that date/time functions with no arguments (which
      generate responses that depend on the current time) are treated
      as non-deterministic functions.
    * Fix a problem in the sqldiff utility program having to do with
      unusual whitespace characters in a virtual table definition.
    * Limit the new UNION ALL optimization described by item 8c in
      the 3.35.0 release so that it does not try to make too many
      new subqueries.
  - include changes from 3.35.1:
    * Fix a bug in the new DROP COLUMN feature when used on columns
      that are indexed and that are quoted in the index definition.
    * Improve the built-in documentation for the .dump command in the
* Mon Mar 15 2021 Dirk Müller <>
  - update to 3.35.0:
    * Added built-in SQL math functions().
      (Requires the -DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option.)
    * Added support for ALTER TABLE DROP COLUMN.
    * Generalize UPSERT:
    * Allow multiple ON CONFLICT clauses that are evaluated in order,
    * The final ON CONFLICT clause may omit the conflict target and yet still use DO UPDATE.
    * Add support for the RETURNING clause on DELETE, INSERT, and UPDATE statements.
    * Use less memory when running VACUUM on databases containing very large TEXT
      or BLOB values. It is no longer necessary to hold the entire TEXT or BLOB
      in memory all at once.
    * Add support for the MATERIALIZED and NOT MATERIALIZED hints when specifying
      common table expressions. The default behavior was formerly NOT
      MATERIALIZED, but is now changed to MATERIALIZED for CTEs that are used
      more than once.
      are modified so that they only control triggers and views in the main
      database schema or in attached database schemas and not in the TEMP schema.
      TEMP triggers and views are always allowed.
    * Query planner/optimizer improvements
    * Enhance the ".stats" command to accept new arguments "stmt" and "vmstep",
      causing prepare statement statistics and only the virtual-machine step
      count to be shown, respectively.
    * Add the ".filectrl data_version" command.
    * Enhance the ".once" and ".output" commands so that if the destination
      argument begins with "|" (indicating that output is redirected into a pipe)
      then the argument does not need to be quoted.
    * Fix a bug in the IN-operator optimization of version 3.33.0 that can cause
      an incorrect answer.
    * Fix incorrect answers from the LIKE operator if the pattern ends with "%"
      and there is an "ESCAPE '_'" clause.
* Thu Jan 21 2021 Andreas Stieger <>
  - SQLite 3.34.1:
    * Fix a potential use-after-free bug when processing a a subquery
      with both a correlated WHERE clause and a "HAVING 0" clause and
      where the parent query is an aggregate (boo#1181261)
    * Fix documentation typos
    * Fix minor problems in extensions
* Wed Dec 02 2020 Reinhard Max <>
  - SQLite 3.34.0:
    * Added the sqlite3_txn_state() interface for reporting on the
      current transaction state of the database connection.
    * Enhance recursive common table expressions to support two or more
      recursive terms as is done by SQL Server, since this helps make
      queries against graphs easier to write and faster to execute.
    * Improved error messages on CHECK constraint failures.
    * The .read dot-command now accepts a pipeline in addition to a
    * Added options --data-only and --nosys to the .dump dot-command.
    * Added the --nosys option to the .schema dot-command.
    * Table name quoting works correctly for the .import dot-command.
    * The generate_series(START,END,STEP) table-valued function
      extension is now built into the CLI.
    * The .databases dot-command now show the status of each database
      file as determined by sqlite3_db_readonly() and
    * Added the --tabs command-line option that sets .mode tabs.
    * The --init option reports an error if the file named as its
      argument cannot be opened. The --init option also now honors the
    - -bail option.
    * Improved estimates for the cost of running a DISTINCT operator.
    * When doing an UPDATE or DELETE using a multi-column index where
      only a few of the earlier columns of the index are useful for the
      index lookup, postpone doing the main table seek until after all
      WHERE clause constraints have been evaluated, in case those
      constraints can be covered by unused later terms of the index,
      thus avoiding unnecessary main table seeks.
    * The new OP_SeekScan opcode is used to improve performance of
      multi-column index look-ups when later columns are constrained by
      an IN operator.
    * The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if
      one or more attached database files are read-only.
    * Enhanced FTS5 to support trigram indexes.
    * Improved performance of WAL mode locking primitives in cases where
      there are hundreds of connections all accessing the same database
      file at once.
    * Enhanced the carray() table-valued function to include a
      single-argument form that is bound using the auxiliary
      sqlite3_carray_bind() interface.
    * The substr() SQL function can now also be called "substring()" for
      compatibility with SQL Server.
    * The syntax diagrams are now implemented as Pikchr scripts and
      rendered as SVG for improved legibility and ease of maintenance.
* Sat Aug 15 2020 Andreas Stieger <>
  - SQLite 3.33.0:
    * Support for UPDATE FROM following the PostgreSQL syntax
    * Increase the maximum size of database files to 281 TB
    * Extend the PRAGMA integrity_check statement so that it can
      optionally be limited to verifying just a single table and its
      indexes, rather than the entire database file.
    * Add the decimal extension for doing arbitrary-precision decimal
    * Enhancements to the ieee754 extension for working with IEEE 754
      binary64 numbers
    * cli: Add four new output modes: "box", "json", "markdown",
      and "table"
    * cli: The "column" output mode automatically expands columns to
      contain the longest output row and automatically turns
      ".header" on if it has not been previously set
    * cli: The "quote" output mode honors ".separator"
    * cli: The decimal extension and the ieee754 extension are
      built-in to the CLI
    * multiple query planner improvements
* Sat Jun 20 2020 Andreas Stieger <>
  - SQLite 3.32.3:
    * Fix Heap Buffer Overflow in multiSelectOrderBy
    * Fix Assertion `flags3==pIn3->flags' failed
    * Fix Assertion `pExpr->pAggInfo==pAggInfo' failed
    * Fix Segfault in sqlite3Select
    * Fix Use after free in resetAccumulator
      CVE-2020-13871 boo#1172646
* Fri Jun 05 2020 Paolo Stivanin <>
  - SQLite 3.32.2:
    * Fix a long-standing bug in the byte-code engine that can cause
      a COMMIT command report as success when in fact it failed to commit
* Tue May 26 2020 Andreas Stieger <>
  - SQLite 3.32.1:
    * CVE-2020-13435: Malicious SQL statements could have crashed the
      process that is running SQLite (boo#1172091)
* Sun May 24 2020 Andreas Stieger <>
  - SQLite 3.32.0:
    * Add support for approximate ANALYZE using the PRAGMA
      analysis_limit command
    * Add the bytecode virtual table
    * Add the checksum VFS shim to the set of run-time loadable
      extensions included in the source tree
    * Add the iif() SQL function.
    * INSERT and UPDATE statements now always apply column affinity
      before computing CHECK constraints
    * Increase the default upper bound on the number of parameters
      from 999 to 32766
    * Add code for the UINT collating sequence as an optional
      loadable extension
    * multiple enhancements to the CLI
    * CVE-2020-13434 boo#1172115: integer overflow in
    * CVE-2020-13630 boo#1172234: use-after-free in fts3EvalNextRow
    * CVE-2020-13631 boo#1172236: virtual table allowed to be renamed
      to one of its shadow tables
    * CVE-2020-13632 boo#1172240: NULL pointer dereference via
      crafted matchinfo() query
  - drop upstreamed patches:
    * 04885763c4cd00cb-s390-compatibility.patch
    * b20503aaf5b6595a-adapt-FTS-tests-for-big-endian.patch
* Wed Jan 29 2020 Stefan Brüns <>
  - Fix a regression on ppc64be and s390x, found by the fuzzing
    tests, add 04885763c4cd00cb-s390-compatibility.patch.
  - Adapt some FTS tests to work on big endian archs:
* Mon Jan 27 2020 Andreas Stieger <>
  - SQLite 3.31.1:
    * Revert changes to the data layout for an internal data structure
* Thu Jan 23 2020 Andreas Stieger <>
  - SQLite 3.31.0:
    * add support for generated columns
    * various fixes and improvements
  - drop upstreamed patches:
    * 8a39167bd2-Further-improvements-to-LEFT-JOIN.patch
    * fix_dir_exists_on_btrfs.patch
    * 7833feecfe-Prevent-SQLite-from-bad-NULL-assumption.patch
    * 548082dfab-Improvements-to-the-LEFT-JOIN.patch
    * sqlite3-avoid-truncation-error.patch
* Fri Jan 17 2020 Stefan Brüns <>
  - Fix regression found when running python-Django/Djano1 testsuite:
    + 7833feecfe-Prevent-SQLite-from-bad-NULL-assumption.patch
    + 548082dfab-Improvements-to-the-LEFT-JOIN.patch
    + 8a39167bd2-Further-improvements-to-LEFT-JOIN.patch
  - Fix check for existing dirs, triggers when running the testsuite
    on BTRFS or XFS:
    + fix_dir_exists_on_btrfs.patch
  - Fix truncation/bad rounding of timestamps in SQLite strftime
    function, exposed when running testsuite on i586:
    + sqlite3-avoid-truncation-error.patch
* Fri Oct 11 2019 Andreas Stieger <>
  - sqlite 3.30.1:
    * fix a segfault for nested queries that use the FILTER clause
      ib aggregate functions (introduced in 3.30.0)
* Sun Oct 06 2019 Andreas Stieger <>
  - update to 3.30.0:
    * Add support for the FILTER clause on aggregate functions
    * Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses
    * The index_info and index_xinfo pragmas are enhanced to provide
      information about the on-disk representation of WITHOUT ROWID tables
    * Add the sqlite3_drop_modules() interface, allowing applications
      to disable automatically loaded virtual tables that they do not need
    * Improvements to the .recover dot-command in the CLI so that it
      recovers more content from corrupt database files
    * Enhance the RBU extension to support indexes on expressions
    * Change the schema parser so that it will error out if any of
      the type, name, and tbl_name columns of the sqlite_master table
      have been corrupted and the database connection is not in
      writable_schema mode.
    * The PRAGMA function_list, PRAGMA module_list, and PRAGMA
      pragma_list commands are now enabled in all builds by default
    * Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
    * Added the TCL Interface config method in order to be able to
      disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other
      sqlite3_db_config() options from TCL.
    * Added the SQLITE_DIRECTONLY flag for application-defined SQL
      functions to prevent those functions from being used inside
      triggers and views
  - drop sqlite3-CVE-2019-16168.patch, upstream
* Tue Sep 10 2019 Reinhard Max <>
  - bsc#1150137, CVE-2019-16168, sqlite3-CVE-2019-16168.patch:
    Improper validation of qlite_stat1 sz field leads to division by
* Thu Jul 11 2019 Ismail Dönmez <>
  - Update to version 3.29.0
      actions to sqlite3_db_config() for activating and deactivating
      the double-quoted string literal misfeature. Both default to
      "on" for legacy compatibility, but developers are encouraged
      to turn them "off", perhaps using the -DSQLITE_DQS=0
      compile-time option.
    * -DSQLITE_DQS=0 is now a recommended compile-time option.
    * Improvements to the query planner:
      + Improved optimization of AND and OR operators when one or
      the other operand is a constant.
      + Enhancements to the LIKE optimization for cases when the
      left-hand side column has numeric affinity.
    * Added the "sqlite_dbdata" virtual table for extracting raw
      low-level content from an SQLite database, even a database
      that is corrupt.
    * Enhancements to the CLI:
      + Add the ".recover" command which tries to recover as much
      content as possible from a corrupt database file.
      + Add the ".filectrl" command useful for testing.
      + Add the long-standing ".testctrl" command to the ".help" menu.
      + Added the ".dbconfig" command
* Thu Apr 18 2019 Reinhard Max <>
  - Upgrade to 3.28.0:
    * CVE-2019-9936, bsc#1130326: running fts5 prefix queries inside
      a transaction could trigger a heap-based buffer over-read.
    * CVE-2019-9937, bsc#1130325: interleaving reads and writes in a
      single transaction with an fts5 virtual table will lead to a
      NULL Pointer Dereference.
    * Enhanced window functions
    * Enhanced VACUUM INTO so that it works for read-only databases.
    * New query optimizations.
    * Added the sqlite3_value_frombind() API for determining if the
      argument to an SQL function is from a bound parameter.
    * Security and compatibilities enhancements to fts3_tokenizer().
    * Improved robustness against corrupt database files.
* Sun Mar 10 2019 Andreas Stieger <>
  - SQLite 3.27.2:
    * Add the VACUUM INTO command
    * Issue an SQLITE_WARNING message on the error log if a
      double-quoted string literal is used
    * Add the remove_diacritics=2 option to FTS3 and FTS5.
    * Add  the SQLITE_PREPARE_NO_VTAB option to sqlite3_prepare_v3().
      Use that option to prevent circular references to shadow tables
      from causing resource leaks.
    * Enhancements to the sqlite3_deserialize() interface
    * Enhancements to the CLI, mostly to support testing and debugging
      of the SQLite library itself
    * Increased robustness against malicious SQL that is run against
      a maliciously corrupted database
  - drop sqlite3-btree02-100.patch
* Thu Jan 17 2019 Reinhard Max <>
  - btree02.test depended on Tcl internals that changed in 8.6.9.
* Wed Dec 05 2018
  - SQLite 3.26.0:
    * Optimization: When doing an UPDATE on a table with indexes on
      expressions, do not update the expression indexes if they do
      not refer to any of the columns of the table being updated.
    * Allow the xBestIndex() method of virtual table implementations
      to return SQLITE_CONSTRAINT to indicate that the proposed query
      plan is unusable and should not be given further consideration.
    * Added the SQLITE_DBCONFIG_DEFENSIVE option which disables the
      ability to create corrupt database files using ordinary SQL.
    * Added support for read-only shadow tables when the
      SQLITE_DBCONFIG_DEFENSIVE option is enabled.
    * Added the PRAGMA legacy_alter_table command, which if enabled
      causes the ALTER TABLE command to behave like older version of
      SQLite (prior to version 3.25.0) for compatibility.
    * Added PRAGMA table_xinfo that works just like PRAGMA table_info
      except that it also shows hidden columns in virtual tables.
    * Added the explain virtual table as a run-time loadable
    * Add a limit counter to the query planner to prevent excessive
      sqlite3_prepare() times for certain pathological SQL inputs.
    * Added support for the sqlite3_normalized_sql() interface, when
      compiling with SQLITE_ENABLE_NORMALIZE.
    * Enhanced triggers so that they can use table-valued functions
      that exist in schemas other than the schema where the trigger
      is defined.
    * Improvements to the ".help" command in the CLI.
    * The SQLITE_HISTORY environment variable, if it exists,
      specifies the name of the command-line editing history file.
    * The --deserialize option associated with opening a new database
      in the CLI cause the database file to be read into memory and
      accessed using the sqlite3_deserialize() API. This simplifies
      running tests on a database without modifying the file on disk.
* Sat Oct 06 2018
  - SQLite 3.25.2:
    * Add the PRAGMA legacy_alter_table=ON command that causes the
      "ALTER TABLE RENAME" command to behave as in 3.24.0 and earlier
    * Fix issue with some expressions with windows functions in views
  - includes changes from SQLite 3.25.1:
    * Avoid false-positive error checks on ALTER TABLE
    * Further ORDER BY LIMIT optimization fixes for window functions
* Sun Sep 16 2018
  - SQLite 3.25.0:
    * Add support for window functions
    * Add support for renaming columns within a table
    * Query optimizer improvements
    * slightly better concurrency in multi-threaded environments
    * The ORDER BY LIMIT optimization might have caused an infinite
      loop in the byte code of the prepared statement under very
      obscure circumstances, due to a confluence of minor defects in
      the query optimizer
* Sat Jun 30 2018
  - Enable the FTS3 extension
* Fri Jun 29 2018
  - Run tests during build
* Fri Jun 08 2018
  - Use 'src' archive instead of 'amalgamation' to be able to use
  - Remove 'sqlite-fts5-link.patch' since patched file is not
    availaible in 'src' archive. Add '-lm' flag to LIBS var instead
* Thu Jun 07 2018
* Wed Jun 06 2018
  - update to 3.24.0:
    * Add support for PostgreSQL-style UPSERT
    * Add support for auxiliary columns in r-tree tables
    * Add C-language APIs for discovering SQL keywords used by SQLite
    * Add C-language APIs for dynamic strings based on sqlite3_str
    * Enhance ALTER TABLE so that it recognizes "true" and "false" as
      valid arguments to DEFAULT
    * Add the sorter-reference optimization as a compile-time option
    * Improve the format of the EXPLAIN QUERY PLAN raw output, so that
    it gives better information about the query plan and about the
      relationships between the various components of the plan
    * Added the SQLITE_DBCONFIG_RESET_DATABASE option to the
      sqlite3_db_config() API.
    * Automatically intercept the raw EXPLAIN QUERY PLAN output an
      reformat it into an ASCII-art graph.
    * Lines that begin with "#" and that are not in the middle of an
      SQL statement are interpreted as comments
    * Add the --append option to the ".backup" command
    * Add the ".dbconfig" command
    * various performance improvements
    * various bug fixes
* Wed Apr 11 2018
  - update to 3.23.1:
    * Fix two problems in the new LEFT JOIN strength reduction
    * Fix misbehavior of the FTS5 xBestIndex method
    * Fix a harmless reference to an uninitialized virtual machine
    * Fix the eval.c extension so that it works with PRAGMA
    * Fix the generate_series virtual table so that it correctly
      returns no rows if any of its constraints are NULL
    * Performance enhancements in the parser
* Mon Apr 02 2018
  - update to 3.23.0:
    * Add the sqlite3_serialize() and sqlite3_deserialize()
      interfaces when the SQLITE_ENABLE_DESERIALIZE compile-time
      option is used.
    * Recognize TRUE and FALSE as constants. (For compatibility, if
      there exist columns named "true" or "false", then the
      identifiers refer to the columns rather than Boolean constants.)
    * Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
    * Added the SQLITE_DBSTATUS_CACHE_SPILL option to
      sqlite3_db_status() for reporting the number of cache spills
      that have occurred.
    * The "alternate-form-2" flag ("!") on the built-in printf
      implementation now causes string substitutions to measure the
      width and precision in characters instead of bytes.
    * If the xColumn method in a virtual table implementation returns
      an error message using sqlite3_result_error() then give that
      error message preference over internally-generated messages.
    * Added the -A command-line option to the CLI to make it easier to
      manage SQLite Archive files.
      OR REPLACE in the Zipfile virtual table.
    * Enhance the sqlite3changeset_apply() interface so that it is
      hardened against attacks from deliberately corrupted changeset
    * Added the sqlite3_normalize() extension function.
    * Query optimizer enhancements
    * Various bug fixes
    * Fix various issues reported by fuzzers, including:
      + CVE-2018-8740: NULL pointer dereference on CREATE TABLE as
* Thu Feb 01 2018
  - update to 3.22.0:
    * Add Zipfile virtual table to read and write a ZIP Archive.
    * Improved handling of WAL mode databases
    * various improvements, optimizations and bug fixes



Generated by rpm2html 1.8.1

Fabrice Bellet, Fri Dec 3 23:48:33 2021