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

SQLite Release 3.34.0 On 2020-12-01

    +
  1. Added the sqlite3_txn_state() interface for reporting on the current + transaction state of the database connection. +
  2. Enhance recursive common table expressions to support two or more + recursive terms as is done by SQL Server, since this helps make + queries against graphs easier to write and faster to execute. +
  3. Improved error messages on CHECK constraint failures. +
  4. CLI enhancements: +
      +
    1. The .read dot-command now accepts a pipeline in addition to + a filename. +
    2. Added options --data-only and --nosys to the .dump dot-command. +
    3. Added the --nosys option to the .schema dot-command. +
    4. Table name quoting works correctly for the .import dot-command. +
    5. The generate_series(START,END,STEP) table-valued function + extension is now built into the CLI. +
    6. The .databases dot-command now shows the status of each database + file as determined by sqlite3_db_readonly() and + sqlite3_txn_state(). +
    7. Added the --tabs command-line option that sets + .mode tabs. +
    8. The --init option reports an error if the file named as its argument + cannot be opened. The --init option also now honors the --bail option. +
    +
  5. Query planner improvements: +
      +
    1. Improved estimates for the cost of running a DISTINCT operator. +
    2. When doing an UPDATE or DELETE using a multi-column index where + only a few of the earlier columns of the index are useful for the + index lookup, postpone doing the main table seek until after all + WHERE clause constraints have been evaluated, in case those + constraints can be covered by unused later terms of the index, + thus avoiding unnecessary main table seeks. +
    3. The new OP_SeekScan opcode is used to improve performance of + multi-column index look-ups when later columns are constrained + by an IN operator. +
    +
  6. The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even + if one or more attached database files are read-only. +
  7. Enhanced FTS5 to support trigram indexes. +
  8. Improved performance of WAL mode locking primitives in cases where + there are hundreds of connections all accessing the same database file + at once. +
  9. Enhanced the carray() table-valued function to include a single-argument + form that is bound using the auxiliary sqlite3_carray_bind() interface. +
  10. The substr() SQL function can now also be called "substring()" for + compatibility with SQL Server. +
  11. The syntax diagrams are now implemented as + Pikchr scripts and rendered + as SVG for improved legibility and ease of maintenance. +

    Hashes: +

  12. SQLITE_SOURCE_ID: 2020-12-01 16:14:00 a26b6597e3ae272231b96f9982c3bcc17ddec2f2b6eb4df06a224b91089fed5b +
  13. SHA3-256 for sqlite3.c: fbd895b0655a337b2cd657675f314188a4e9fe614444cc63dfeb3f066f674514 + + +

+ +

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