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_41_1.html | 207 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 207 insertions(+) create mode 100644 www/releaselog/3_41_1.html (limited to 'www/releaselog/3_41_1.html') diff --git a/www/releaselog/3_41_1.html b/www/releaselog/3_41_1.html new file mode 100644 index 0000000..1ca87de --- /dev/null +++ b/www/releaselog/3_41_1.html @@ -0,0 +1,207 @@ + + + + + +SQLite Release 3.41.1 On 2023-03-10 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.41.1 On 2023-03-10

Prior changes from version 3.41.0 (2023-02-21):

+

    +
  1. Query planner improvements: +
      +
    1. Make use of indexed expressions within an aggregate query that + includes a GROUP BY clause. +
    2. The query planner has improved awareness of when an index is + a covering index and adjusts predicted runtimes accordingly. +
    3. The query planner is more aggressive about using co-routines rather + than materializing subqueries and views. +
    4. Queries against the built-in table-valued functions json_tree() and + json_each() will now usually treat "ORDER BY rowid" as a no-op. +
    5. Enhance the ability of the query planner to use indexed expressions + even if the expression has been modified by the + constant-propagation optimization. + (See forum thread 0a539c7.) +
    +
  2. Add the built-in unhex() SQL function. +
  3. Add the base64 and base85 application-defined functions as an extension and + include that extension in the CLI. +
  4. Add the sqlite3_stmt_scanstatus_v2() interface. (This interface is only + available if SQLite is compiled using SQLITE_ENABLE_STMT_SCANSTATUS.) +
  5. In-memory databases created using sqlite3_deserialize() now report their + filename as an empty string, not as 'x'. +
  6. Changes to the CLI: +
      +
    1. Add the new base64() and base85() SQL functions +
    2. Enhanced EXPLAIN QUERY PLAN output using the new sqlite3_stmt_scanstatus_v2() + interface when compiled using SQLITE_ENABLE_STMT_SCANSTATUS. +
    3. The ".scanstats est" command provides query planner estimates in profiles. +
    4. The continuation prompt indicates if the input is currently inside of a + string literal, identifier literal, comment, trigger definition, etc. +
    5. Enhance the --safe command-line option to disallow dangerous SQL functions. +
    6. The double-quoted string misfeature is now disabled by default for CLI + builds. Legacy use cases can reenable the misfeature at run-time using + the ".dbconfig dqs_dml on" and ".dbconfig dqs_ddl on" + commands. +
    +
  7. Enhance the PRAGMA integrity_check command so that it detects when text strings in + a table are equivalent to but not byte-for-byte identical to the same strings in the index. +
  8. Enhance the carray table-valued function so that it is able to bind an array of + BLOB objects. +
  9. Added the sqlite3_is_interrupted() interface. +
  10. Long-running calls to sqlite3_prepare() and similar now invoke the + progress handler callback and react to sqlite3_interrupt(). +
  11. The sqlite3_vtab_in_first() and sqlite3_vtab_in_next() functions are enhanced so that + they reliably detect if they are invoked on a parameter that was not selected for + multi-value IN processing using sqlite3_vtab_in(). + They return SQLITE_ERROR instead of SQLITE_MISUSE in this case. +
  12. The parser now ignores excess parentheses around a subquery on the right-hand side + of an IN operator, so that SQLite now works the same as PostgreSQL in this regard. + Formerly, SQLite treated the subquery as an expression with an implied "LIMIT 1". +
  13. Added the SQLITE_FCNTL_RESET_CACHE option to the sqlite3_file_control() API. +
  14. Makefile improvements: +
      +
    1. The new makefile target "sqlite3r.c" builds an amalgamation that includes + the recovery extension. +
    2. New makefile targets "devtest" and "releasetest" for running a + quick developmental test prior to doing a check-in and for doing a full + release test, respectively. +
    +
  15. Miscellaneous performance enhancements. +
+

Changes in this specific patch release, version 3.41.1 (2023-03-10):

+

    +
  1. Provide compile-time options -DHAVE_LOG2=0 and -DHAVE_LOG10=0 to enable SQLite to be + compiled on systems that omit the standard library functions log2() and log10(), repectively. +
  2. Ensure that the datatype for column t1.x in + "CREATE TABLE t1 AS SELECT CAST(7 AS INT) AS x;" continues to be INT and is not NUM, + for historical compatibility. +
  3. Enhance PRAGMA integrity_check to detect when extra bytes appear at the end of an + index record. +
  4. Fix various obscure bugs reported by the user community. See the + timeline of changes + for details. + +

    Hashes: +

  5. SQLITE_SOURCE_ID: 2023-03-10 12:13:52 20399f3eda5ec249d147ba9e48da6e87f969d7966a9a896764ca437ff7e737ff +
  6. SHA3-256 for sqlite3.c: d0d9db8425570f4a57def04fb8f4ac84f5c3e4e71d3d4d10472e3639c5fdf09f + +

+ +

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