Software update: SQLite 3.38.5

SQLite is a database system developed in C that can be used for websites and embedded applications, among other things. According to the developers, SQLite requires no installation and administration, supports databases up to two terabytes in size and stores an entire database in one file. Furthermore, it supports almost the full SQL92 specification and it is easy via, among others Tcl/Tk to guide. Version 3.38.5 has been released with the following changes:

Version 3.38.5

• Fix a blunder in the CLI of the 3.38.4 release.

Version 3.38.4

• 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.

Version 3.38.3

• 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.

Version 3.38.2

• 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.

Version 3.38.1

• 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.