SQLite Release 3.38.5 On 2022-05-06

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_38_5.html | 237 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 237 insertions(+) create mode 100644 www/releaselog/3_38_5.html (limited to 'www/releaselog/3_38_5.html') diff --git a/www/releaselog/3_38_5.html b/www/releaselog/3_38_5.html new file mode 100644 index 0000000..e4aab81 --- /dev/null +++ b/www/releaselog/3_38_5.html @@ -0,0 +1,237 @@ + + + + + +SQLite Release 3.38.5 On 2022-05-06 + + + +

+ +

+Small. Fast. Reliable.
Choose any three. +

+ + +

+ +

SQLite Release 3.38.5 On 2022-05-06

Changes in version 3.38.0 (2022-02-22):

Added the -> and ->> operators for easier processing of JSON. + The new operators are compatible with MySQL and PostgreSQL. +
The JSON functions are now built-ins. It is no longer necessary + to use the -DSQLITE_ENABLE_JSON1 compile-time option to enable JSON + support. JSON is on by default. Disable the JSON interface using + the new -DSQLITE_OMIT_JSON compile-time option. +
Enhancements to date and time functions: +
1. Added the unixepoch() function. +
2. Added the auto modifier and the julianday modifier. +
+
Rename the printf() SQL function to format() for better + compatibility. The original printf() name is retained as an alias + for backwards compatibility. +
Added the sqlite3_error_offset() interface, which can sometimes + help to localize an SQL error to a specific character in the input + SQL text, so that applications can provide better error messages. +
Enhanced the interface to virtual tables as follows: +
1. Added the sqlite3_vtab_distinct() interface. +
2. Added the sqlite3_vtab_rhs_value() interface. +
3. Added new operator types SQLITE_INDEX_CONSTRAINT_LIMIT + and SQLITE_INDEX_CONSTRAINT_OFFSET. +
4. Added the sqlite3_vtab_in() interface (and related) to enable + a virtual table to process IN operator constraints all at once, + rather than processing each value of the right-hand side of the + IN operator separately. +
+
CLI enhancements: +
1. Columnar output modes are enhanced to correctly handle tabs + and newlines embedded in text. +
2. Added options like "--wrap N", "--wordwrap on", and "--quote" + to the columnar output modes. +
3. Added the .mode qbox alias. +
4. The .import command automatically disambiguates column names. +
5. Use the new sqlite3_error_offset() interface to provide better + error messages. +
+
Query planner enhancements: +
1. Use a Bloom filter to speed up large analytic queries. +
2. Use a balanced merge tree to evaluate UNION or UNION ALL + compound SELECT statements that have an ORDER BY clause. +
+
The ALTER TABLE statement is changed to silently ignores entries in the + sqlite_schema table that do not parse when PRAGMA writable_schema=ON. +

Additional changes in version 3.38.1 (2022-03-12):

Fix problems with the new Bloom filter optimization that might cause + some obscure queries to get an incorrect answer. +
Fix the localtime modifier of the date and time functions so that + it preserves fractional seconds. +
Fix the sqlite_offset SQL function so that it works correctly even + in corner cases such as when the argument is a virtual column or the + column of a view. +
Fix row value IN operator constraints on virtual tables so that they + work correctly even if the virtual table implementation relies on bytecode + to filter rows that do not satisfy the constraint. +
Other minor fixes to assert() statements, test cases, and documentation. + See the source code timeline + for details. + +

Additional changes in version 3.38.2 (2022-03-26):

Fix a user-discovered problem with the new Bloom filter optimization + that might cause an incorrect answer when doing a LEFT JOIN with a WHERE + clause constraint that says that one of the columns on the right table of + the LEFT JOIN is NULL. See + forum thread 031e262a89b6a9d2. +
Other minor patches. See the + timeline for + details. + +

Additional changes in version 3.38.3 (2022-04-27):

Fix a case of the query planner be overly aggressive with optimizing automatic-index + and Bloom-filter construction, using inappropriate ON clause terms to restrict the + size of the automatic-index or Bloom filter, and resulting in missing rows in the + output. + Forum thread 0d3200f4f3bcd3a3. +
Other minor patches. See the + timeline for + details. + +

Additional changes in version 3.38.4 (2022-05-04):

Fix a byte-code problem in the Bloom filter pull-down optimization added by release + 3.38.0 in which an error in the byte code causes the byte code engine to enter an + infinite loop when the pull-down optimization encounters a NULL key. + Forum thread 2482b32700384a0f. +
Other minor patches. See the + timeline for + details. + +

Additional changes in version 3.38.5 (2022-05-06):

Fix a blunder in the CLI of the 3.38.4 release. + +
Hashes: +
SQLITE_SOURCE_ID: 2022-05-06 15:25:27 78d9c993d404cdfaa7fdd2973fa1052e3da9f66215cff9c5540ebe55c407d9fe +
SHA3-256 for sqlite3.c: b05ef42ed234009b4b3dfb36c5f5ccf6d728da80f25ee560291269cf6cfe635f + +

+ +

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