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_7_16.html | 182 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 182 insertions(+) create mode 100644 www/releaselog/3_7_16.html (limited to 'www/releaselog/3_7_16.html') diff --git a/www/releaselog/3_7_16.html b/www/releaselog/3_7_16.html new file mode 100644 index 0000000..35744ae --- /dev/null +++ b/www/releaselog/3_7_16.html @@ -0,0 +1,182 @@ + + + + + +SQLite Release 3.7.16 On 2013-03-18 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.7.16 On 2013-03-18

    +
  1. Added the PRAGMA foreign_key_check command. +
  2. Added new extended error codes for all SQLITE_CONSTRAINT errors +
  3. Added the SQLITE_READONLY_ROLLBACK extended error code for when a database + cannot be opened because it needs rollback recovery but is read-only. +
  4. Added SQL functions unicode(A) and char(X1,...,XN). +
  5. Performance improvements for PRAGMA incremental_vacuum, especially in + cases where the number of free pages is greater than what will fit on a + single trunk page of the freelist. +
  6. Improved optimization of queries containing aggregate min() or max(). +
  7. Enhance virtual tables so that they can potentially use an index when + the WHERE clause contains the IN operator. +
  8. Allow indices to be used for sorting even if prior terms of the index + are constrained by IN operators in the WHERE clause. +
  9. Enhance the PRAGMA table_info command so that the "pk" column is an + increasing integer to show the order of columns in the primary key. +
  10. Enhance the query optimizer to exploit transitive join constraints. +
  11. Performance improvements in the query optimizer. +
  12. Allow the error message from PRAGMA integrity_check to be longer than + 20000 bytes. +
  13. Improved name resolution for deeply nested queries. +
  14. Added the test_regexp.c module as a demonstration of how to implement + the REGEXP operator. +
  15. Improved error messages in the RTREE extension. +
  16. Enhance the command-line shell so that a non-zero argument to the + ".exit" command causes the shell to exit immediately without cleanly + shutting down the database connection. +
  17. Improved error messages for invalid boolean arguments to dot-commands + in the command-line shell. +
  18. Improved error messages for "foreign key mismatch" showing the names of + the two tables involved. +
  19. Remove all uses of umask() in the unix VFS. +
  20. Added the PRAGMA vdbe_addoptrace and PRAGMA vdbe_debug commands. +
  21. Change to use strncmp() or the equivalent instead of memcmp() when + comparing non-zero-terminated strings. +
  22. Update cygwin interfaces to omit deprecated API calls. +
  23. Enhance the spellfix1 extension so that the edit distance cost table can + be changed at runtime by inserting a string like 'edit_cost_table=TABLE' + into the "command" field. + +
  24. Bug fix: repair a long-standing problem that could cause incorrect query + results in a 3-way or larger join that compared INTEGER fields against TEXT + fields in two or more places. + Ticket fc7bd6358f +
  25. Bug fix: Issue an error message if the 16-bit reference counter on a + view overflows due to an overly complex query. +
  26. Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in deeply + nested UNION ALL queries. +
  27. Bug fix: Make sure the schema is up-to-date prior to running pragmas + table_info, index_list, index_info, and foreign_key_list. + +
  28. SQLITE_SOURCE_ID: + "2013-03-18 11:39:23 66d5f2b76750f3520eb7a495f6247206758f5b90" +
  29. SHA1 for sqlite3.c: 7308ab891ca1b2ebc596025cfe4dc36f1ee89cf6 + +

+ +

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