From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/releaselog/3_13_0.html | 191 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 191 insertions(+) create mode 100644 www/releaselog/3_13_0.html (limited to 'www/releaselog/3_13_0.html') diff --git a/www/releaselog/3_13_0.html b/www/releaselog/3_13_0.html new file mode 100644 index 0000000..5490946 --- /dev/null +++ b/www/releaselog/3_13_0.html @@ -0,0 +1,191 @@ + + + + + +SQLite Release 3.13.0 On 2016-05-18 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.13.0 On 2016-05-18

    +
  1. Postpone I/O associated with TEMP files for as long as possible, with the hope + that the I/O can ultimately be avoided completely. +
  2. Merged the session extension into trunk. +
  3. Added the ".auth ON|OFF" command to the command-line shell. +
  4. Added the "--indent" option to the ".schema" and ".fullschema" commands of + the command-line shell, to turn on pretty-printing. +
  5. Added the ".eqp full" option to the command-line shell, that does both EXPLAIN + and EXPLAIN QUERY PLAN on each statement that is evaluated. +
  6. Improved unicode filename handling in the command-line shell on Windows. +
  7. Improved resistance against goofy query planner decisions caused by + incomplete or incorrect modifications to the sqlite_stat1 + table by the application. +
  8. Added the sqlite3_db_config(db,SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION) interface + which allows the sqlite3_load_extension() C-API to be enabled while keeping the + load_extension() SQL function disabled for security. +
  9. Change the temporary directory search algorithm on Unix to allow directories with + write and execute permission, but without read permission, to serve as temporary + directories. Apply this same standard to the "." fallback directory. +

    Bug Fixes: +

  10. Fix a problem with the multi-row one-pass DELETE optimization that was + causing it to compute incorrect answers with a self-referential subquery in + the WHERE clause. Fix for ticket + dc6ebeda9396087 +
  11. Fix a possible segfault with DELETE when table is a rowid table with an + INTEGER PRIMARY KEY and the WHERE clause contains a OR and + the table has one or more indexes that are able to trigger the OR optimization, + but none of the indexes reference any table columns other than the INTEGER PRIMARY KEY. + Ticket 16c9801ceba49. +
  12. When checking for the WHERE-clause push-down optimization, verify that all terms + of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket + f7f8c97e97597. +
  13. Fix a locking race condition in Windows that can occur when two or more processes + attempt to recover the same hot journal at the same time. +

    Hashes: +

  14. SQLITE_SOURCE_ID: "2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2" +
  15. SHA1 for sqlite3.c: 9b9171b1e6ce7a980e6b714e9c0d9112657ad552 + +

    Bug fixes backported into patch release 3.12.2 (2016-04-18):

    + +
  16. Fix a backwards compatibility problem in version 3.12.0 and 3.12.1: + Columns declared as "INTEGER" PRIMARY KEY (with quotes around + the datatype keyword) were not being recognized as an + INTEGER PRIMARY KEY, which resulted in an incompatible database file. + Ticket 7d7525cb01b68 +
  17. Fix a bug (present since version 3.9.0) that can cause the DELETE + operation to miss rows if PRAGMA reverse_unordered_selects is turned on. + Ticket a306e56ff68b8fa5 +
  18. Fix a bug in the code generator that can cause incorrect results if + two or more virtual tables are joined and the virtual table used in + outer loop of the join has an IN operator constraint. +
  19. Correctly interpret negative "PRAGMA cache_size" values when determining + the cache size used for sorting large amounts of data. + +

    Bug fixes backported into patch release 3.12.1 (2016-04-08):

    + +
  20. Fix a boundary condition error introduced by version 3.12.0 + that can result in a crash during heavy SAVEPOINT usage. + Ticket 7f7f8026eda38. +
  21. Fix views so that they inherit column datatypes from the + table that they are defined against, when possible. +
  22. Fix the query planner so that IS and IS NULL operators are able + to drive an index on a LEFT OUTER JOIN. + +

+ +

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