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_9_2.html | 197 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 197 insertions(+) create mode 100644 www/releaselog/3_9_2.html (limited to 'www/releaselog/3_9_2.html') diff --git a/www/releaselog/3_9_2.html b/www/releaselog/3_9_2.html new file mode 100644 index 0000000..3ce4234 --- /dev/null +++ b/www/releaselog/3_9_2.html @@ -0,0 +1,197 @@ + + + + + +SQLite Release 3.9.2 On 2015-11-02 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.9.2 On 2015-11-02

Changes in version 3.9.0 (2015-10-14):

+

    +

    Policy Changes: +

  1. The version numbering conventions for SQLite are revised to use the + emerging standard of semantic versioning. +

    New Features And Enhancements: +

  2. Added the json1 extension module in the source tree, and in the amalgamation. + Enable support using the SQLITE_ENABLE_JSON1 compile-time option. +
  3. Added Full Text Search version 5 (FTS5) to the amalgamation, enabled + using SQLITE_ENABLE_FTS5. FTS5 will be considered "experimental" (subject + to incompatible changes) for at least one more release cycle. +
  4. The CREATE VIEW statement now accepts an optional list of + column names following the view name. +
  5. Added support for indexes on expressions. +
  6. Added support for table-valued functions in the FROM clause of a + SELECT statement. +
  7. Added support for eponymous virtual tables. +
  8. A VIEW may now reference undefined tables and functions when + initially created. Missing tables and functions are reported when + the VIEW is used in a query. +
  9. Added the sqlite3_value_subtype() and sqlite3_result_subtype() + interfaced (used by the json1 extension). +
  10. The query planner is now able to use partial indexes that contain + AND-connected terms in the WHERE clause. +
  11. The sqlite3_analyzer.exe utility is updated to report the depth of + each btree and to show the average fanout for indexes and + WITHOUT ROWID tables. +
  12. Enhanced the dbstat virtual table so that it can be used as a + table-valued function where the argument is the schema to be + analyzed. +

    Other changes: +

  13. The sqlite3_memory_alarm() interface, which has been deprecated and + undocumented for 8 years, is changed into a no-op. +

    Important fixes: +

  14. Fixed a critical bug in the + SQLite Encryption Extension that + could cause the database to become unreadable and unrecoverable if a VACUUM command + changed the size of the encryption nonce. +
  15. Added a memory barrier in the implementation of + sqlite3_initialize() to help ensure that it is thread-safe. +
  16. Fix the OR optimization so that it always ignores subplans that + do not use an index. +
  17. Do not apply the WHERE-clause pushdown optimization on terms that originate + in the ON or USING clause of a LEFT JOIN. Fix for ticket + c2a19d81652f40568c. + +
+

Additional changes in version 3.9.1 (2015-10-16):

+

    +
  1. Fix the json1 extension so that it does not recognize ASCII form-feed as a + whitespace character, in order to comply with RFC-7159. Fix for ticket + 57eec374ae1d0a1d +
  2. Add a few #ifdef and build script changes to address compilation issues that + appeared after the 3.9.0 release. + +
+

Additional changes in version 3.9.2 (2015-11-02):

+

    +
  1. Fix the schema parser so that it interprets certain + (obscure and ill-formed) + CREATE TABLE statements the same as legacy. Fix for ticket + ac661962a2aeab3c331 +
  2. Fix a query planner problem that could result in an incorrect + answer due to the use of automatic indexing in subqueries in + the FROM clause of a correlated scalar subqueries. Fix for ticket + 8a2adec1. + +
  3. SQLITE_SOURCE_ID: "2015-11-02 18:31:45 bda77dda9697c463c3d0704014d51627fceee328" +
  4. SHA1 for sqlite3.c: 1c4013876f50bbaa3e6f0f98e0147c76287684c1 + +

+ +

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