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_31_1.html | 183 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 183 insertions(+) create mode 100644 www/releaselog/3_31_1.html (limited to 'www/releaselog/3_31_1.html') diff --git a/www/releaselog/3_31_1.html b/www/releaselog/3_31_1.html new file mode 100644 index 0000000..7d4b339 --- /dev/null +++ b/www/releaselog/3_31_1.html @@ -0,0 +1,183 @@ + + + + + +SQLite Release 3.31.1 On 2020-01-27 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.31.1 On 2020-01-27

Changes in version 3.31.0 (2020-01-22):

+

    +
  1. Add support for generated columns. +
  2. Add the sqlite3_hard_heap_limit64() interface and the corresponding + PRAGMA hard_heap_limit command. +
  3. Enhance the function_list pragma to show the number of arguments on each + function, the type of function (scalar, aggregate, window), and the function + property flags SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, + SQLITE_INNOCUOUS, and/or SQLITE_SUBTYPE. +
  4. Add the aggregated mode feature to the + DBSTAT virtual table. +
  5. Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that + prevents SQLite from opening symbolic links. +
  6. Added the "#-N" array notation for JSON function path arguments. +
  7. Added the SQLITE_DBCONFIG_TRUSTED_SCHEMA connection setting which is + also controllable via the new trusted_schema pragma and at compile-time + using the -DSQLITE_TRUSTED_SCHEMA compile-time option. +
  8. Added APIs sqlite3_filename_database(), sqlite3_filename_journal(), and + sqlite3_filename_wal() which are useful for specialized extensions. +
  9. Add the sqlite3_uri_key() interface. +
  10. Upgraded the sqlite3_uri_parameter() function so that it works with the + rollback journal or WAL filename in addition to the database filename. +
  11. Provide the ability to tag application-defined SQL functions with + new properties SQLITE_INNOCUOUS or SQLITE_DIRECTONLY. +
  12. Add new verbs to sqlite3_vtab_config() so that the xConnect method + of virtual tables can declare the virtual table as + SQLITE_VTAB_INNOCUOUS or SQLITE_VTAB_DIRECTONLY. +
  13. Faster response to sqlite3_interrupt(). +
  14. Added the uuid.c extension module + implementing functions for processing RFC-4122 UUIDs. +
  15. The lookaside memory allocator is enhanced to support two separate memory + pools with different sized allocations in each pool. This allows more memory + allocations to be covered by lookaside while at the same time reducing the + heap memory usage to 48KB per connection, down from 120KB. +
  16. The legacy_file_format pragma is deactivated. It is now a no-op. In its place, + the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is + provided. The legacy_file_format pragma is deactivated because (1) it is + rarely useful and (2) it is incompatible with VACUUM in schemas that have + tables with both generated columns and descending indexes. + Ticket 6484e6ce678fffab +
+

Additional changes in version 3.31.1 (2020-01-27):

+

    +
  1. Revert the data layout for an internal-use-only SQLite data structure. + Applications that use SQLite should never reference internal SQLite + data structures, but some do anyhow, and a change to one such + data structure in 3.30.0 broke a popular and widely-deployed + application. Reverting that change in SQLite, at least temporarily, + gives developers of misbehaving applications time to fix their code. +
  2. Fix a typos in the sqlite3ext.h header file that prevented the + sqlite3_stmt_isexplain() and sqlite3_value_frombind() interfaces + from being called from run-time loadable extensions. +

    Hashes: +

  3. SQLITE_SOURCE_ID: 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837bb4d6 +
  4. SHA3-256 for sqlite3.c: de465c64f09529429a38cbdf637acce4dfda6897f93e3db3594009e0fed56d27 + +

+ +

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