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_3_9.html | 159 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 159 insertions(+) create mode 100644 www/releaselog/3_3_9.html (limited to 'www/releaselog/3_3_9.html') diff --git a/www/releaselog/3_3_9.html b/www/releaselog/3_3_9.html new file mode 100644 index 0000000..9a4c788 --- /dev/null +++ b/www/releaselog/3_3_9.html @@ -0,0 +1,159 @@ + + + + + +SQLite Release 3.3.9 On 2007-01-04 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.3.9 On 2007-01-04

    +
  1. Fix bugs in pager.c that could lead to database corruption if two +processes both try to recover a hot journal at the same instant
    2. +
  2. Added the sqlite3_prepare_v2() +API.
    3. +
  3. Fixed the ".dump" command in the command-line shell to show +indices, triggers and views again.
    4. +
  4. Change the table_info pragma so that it returns NULL for the default +value if there is no default value
    5. +
  5. Support for non-ASCII characters in win95 filenames
    6. +
  6. Query optimizer enhancements: +
      +
    1. Optimizer does a better job of using indices to satisfy ORDER BY + clauses that sort on the integer primary key
      2. +
    2. Use an index to satisfy an IS NULL operator in the WHERE clause
      3. +
    3. Fix a bug that was causing the optimizer to miss an OR optimization + opportunity
      4. +
    4. The optimizer has more freedom to reorder tables in the FROM clause + even in there are LEFT joins.
      5. +
    +
  7. Extension loading supported added to WinCE
    8. +
  8. Allow constraint names on the DEFAULT clause in a table definition
    9. +
  9. Added the ".bail" command to the command-line shell
    10. +
  10. Make CSV (comma separate value) output from the command-line shell +more closely aligned to accepted practice
    11. +
  11. Experimental FTS2 module added
    12. +
  12. Use sqlite3_mprintf() instead of strdup() to avoid libc dependencies
    13. +
  13. VACUUM uses a temporary file in the official TEMP folder, not in the +same directory as the original database
    14. +
  14. The prefix on temporary filenames on Windows is changed from "sqlite" +to "etilqs".
    15. + +

+ +

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