From 18657a960e125336f704ea058e25c27bd3900dcb Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 19:28:19 +0200 Subject: Adding upstream version 3.40.1. Signed-off-by: Daniel Baumann --- www/releaselog/3_37_1.html | 175 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 175 insertions(+) create mode 100644 www/releaselog/3_37_1.html (limited to 'www/releaselog/3_37_1.html') diff --git a/www/releaselog/3_37_1.html b/www/releaselog/3_37_1.html new file mode 100644 index 0000000..ce2df88 --- /dev/null +++ b/www/releaselog/3_37_1.html @@ -0,0 +1,175 @@ + + + + + +SQLite Release 3.37.1 On 2021-12-30 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.37.1 On 2021-12-30

Changes in version 3.37.0 (2021-11-27):

+

    +
  1. STRICT tables provide a prescriptive style of data type management, + for developers who prefer that kind of thing. +
  2. 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. +
  3. Added the PRAGMA table_list statement. +
  4. CLI enhancements: +
      +
    1. Add the .connection command, allowing the CLI to keep multiple database + connections open at the same time. +
    2. 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. +
    3. Performance improvements when reading SQL statements + that span many lines. +
    +
  5. Added the sqlite3_autovacuum_pages() interface. +
  6. The sqlite3_deserialize() does not and has never worked for the TEMP + database. That limitation is now noted in the documentation. +
  7. The query planner now omits ORDER BY clauses on subqueries and views + if removing those clauses does not change the semantics of the query. +
  8. 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. +
  9. Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces. +
  10. Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2(). +
  11. Use less memory to hold the database schema. + +
+

Additional changes in version 3.37.1 (2021-12-30):

+

    +
  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. +
  2. Fix an OOB read that can occur in FTS5 when reading corrupt database files. +
  3. Improved robustness of the --safe option in the CLI. +
  4. Other minor fixes to assert() statements and test cases. + +

    Hashes: +

  5. SQLITE_SOURCE_ID: 2021-12-30 15:30:28 378629bf2ea546f73eee84063c5358439a12f7300e433f18c9e1bddd948dea62 +
  6. SHA3-256 for sqlite3.c: 915afb3f29c2d217ea0c283326a9df7d505e6c73b40236f0b33ded91f812d174 + +

+ +

A complete list of SQLite releases + in a single page and a chronology are both also available. + A detailed history of every + check-in is available at + + SQLite version control site.

+ + -- cgit v1.2.3