SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent check-ins

2026-04-21
22:55
Various minor bug fixes cherrypicked from trunk. (leaf check-in: f1276db5da ... user: drh tags: branch-3.53)
22:19
Fix harmless compiler warning in QRF. (leaf check-in: dcfb505ac7 ... user: drh tags: trunk)
20:40
Disable optimization of nested EXIST loops. Possible fix for forum post 77c02e8ed. (check-in: d0d95a39bc ... user: dan tags: trunk)
20:28
Fix the BETWEEN operator so that it propagates the EP_Subquery, EP_Collate, and EP_HasFunc flags in the expression tree, as it ought. Fix for the problem reported at forum post 2026-04-21T19:10:55Z and probably a bunch of other problems too. This has been incorrect for a long time. (check-in: 2d1d2947b2 ... user: drh tags: trunk)
18:07
Correctly dequote the constraint name passed to ALTER TABLE DROP CONSTRAINT. This improves upon the partial fix in [7f5afb12f4]. Forum post a746b08b87. (check-in: 9387238cb0 ... user: dan tags: trunk)
16:40
Disable optimization of nested EXIST loops. Possible fix for forum post 77c02e8ed. (closed check-in: 64f0d9eb63 ... user: dan tags: disable-nested-exist-opt)
16:07
Fix an off-by-one buffer size calculation in the decimal.c extension. (check-in: 24df42104d ... user: drh tags: trunk)
14:39
Do not unnecessarily delay opening the database file in the CLI. (check-in: ab6ee76c12 ... user: drh tags: trunk)
13:06
Fix another bug in EXISTS-to-JOIN - this one having to do with an OFFSET clause of a LIMIT. (check-in: f91099ecee ... user: drh tags: branch-3.53)
12:59
Fix another bug in EXISTS-to-JOIN - this one having to do with an OFFSET clause of a LIMIT. Reported by forum post 2026-04-21T10:57:09Z. (check-in: 1dd3c6a5e5 ... user: drh tags: trunk)
11:01
Experimental changes to star-query planning heuristics. (leaf check-in: edabcc0559 ... user: drh tags: star-query-experimental)
10:19
Reformulate how the OPFS async proxy Worker is loaded for the bundler-friendly builds to work around a bug in Vite in which it incompatibly rewrites the Worker's URL arguments. Addresses the discussion at npm package PR 159 and patch validated by Jure Rotar. (check-in: ec877a30f5 ... user: stephan tags: trunk)
10:15
Reformulate how the OPFS async proxy Worker is loaded for the bundler-friendly builds to work around a bug in Vite in which it incompatibly rewrites the Worker's URL arguments. Addresses the discussion at npm package PR 159 and patch validated by Jure Rotar. (check-in: 6215c9dd27 ... user: stephan tags: branch-3.53)
2026-04-20
10:28
Fix the fileio extension for Windows builds so that it does not depend on the sqlite3_win32_utf8_to_unicode() and sqlite3_win32_unicode_to_utf() routines that are found in the SQLite core. Forum post 2026-04-20T02:02:56Z. (check-in: fe0414a9a3 ... user: drh tags: trunk)
2026-04-18
21:51
Fix a harmless compiler warning in test/speedtest1.c. (check-in: 13f0fd1daa ... user: drh tags: trunk)
12:31
Performance improvement in the substr() and length() SQL functions. Caution: The new code may give different results for malformed UTF8. I do not consider that to be a problem by the GI/GO principle. (check-in: 6124d27a33 ... user: drh tags: trunk)
2026-04-17
19:12
Fix a test case that started failing due to a change in the help text for the ".prompt" command of the CLI. (check-in: bfe9df1bf4 ... user: drh tags: trunk)
15:09
Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand(). (check-in: 1979aa0902 ... user: dan tags: trunk)
11:41
Help-text and comment fixes in the CLI. Add the output-redir-test.txt testing script. (check-in: ec58a133b4 ... user: drh tags: trunk)
04:59
On platforms which support ./configure --with-icu-config, ensure that 'make tclextension' includes the ICU pieces in the tcl extension. Intended to resolve forum post 92a88de4b88929fe. (check-in: a4f27adb97 ... user: stephan tags: branch-3.53)
01:55
Fix parsing of options to the .once command. (check-in: fd21b079e9 ... user: drh tags: branch-3.53)
01:50
Less error-prone parsing of ".once" options. Fix for the problem reported by forum post 2026-04-17T01:26:56Z. (check-in: b235a80937 ... user: drh tags: trunk)
2026-04-16
19:50
Fix testrunner.tcl so that it does not create directories with names ending in "sqlite3.o" or "sqlite3.lo". Use "sqlite3obj" for those directory names instead. Otherwise "make clean" gets confused. (check-in: a4bf9289c9 ... user: drh tags: trunk)
19:33
Improved comments explaining the logic, and improved diagnostic messages when testrunner.tcl encounters trouble loading the sqlite3 extension. (check-in: 8d820b0ccf ... user: drh tags: trunk)
17:07
Minor updates to testrunner documentation. (check-in: f8507bd5e2 ... user: drh tags: trunk)
16:43
Run C-language tests in tests/c/ as part of release test. (check-in: e6929022b7 ... user: dan tags: trunk)
13:07
Tentatively change the name of the new ".dbstat" dot-command to ".inspect" as suggested by forum post 2026-04-15T01:09:41 (leaf check-in: 8f0275d65c ... user: drh tags: dbstat-to-inspect)
2026-04-15
19:09
Version number to 3.53.1 (check-in: b4c1cc5efc ... user: drh tags: branch-3.53)
17:13
Handle a special case of a corrupt changeset in sqlite3changegroup_add(). (check-in: dceee93ab3 ... user: dan tags: branch-3.53)
16:22
Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. Forum post 8bfbaec404. (check-in: 2d37af77a1 ... user: dan tags: branch-3.53)
14:41
The sqlite3_str_new() interface never returns NULL, even after an OOM. Code that uses that interface should invoke sqlite3_str_errcode() to see if an OOM has occurred. (check-in: cb910047ed ... user: drh tags: trunk)
14:22
Bug fix in sqlite3_str_free(): Do not crash if called on an sqlite3_str object returned from sqlite3_str_new() following an OOM. (check-in: b6b1d069cd ... user: drh tags: branch-3.53)
14:17
Bug fix in sqlite3_str_free(): Do not crash if called on an sqlite3_str object returned from sqlite3_str_new() following an OOM. (check-in: 92d8ac0c49 ... user: drh tags: trunk)
13:05
Add support for the analyze() extension function to the fuzzcheck test program. (check-in: abd94554d2 ... user: drh tags: trunk)
12:47
Improve the analyze() extension so that it returns a simple error message as text (it does not throw an error) if the database is empty or is "temp" or does not exist. (check-in: 35379f6092 ... user: drh tags: trunk)
12:35
Fix harmless compiler warnings seen by MSVC in the previous check-in. Also add ext/misc/analyze.c to the makefile dependencies for the CLI. (check-in: 5a0ee6e227 ... user: drh tags: trunk)
12:20
Add the analyze() SQL function implemented the ext/misc/analyze.c extension (but not part of the amalgamation). Make that function available in the CLI and add a new ".dbstat" command to the CLI using that function. (check-in: 4c4988e56d ... user: drh tags: trunk)
11:58
Add a missing open_db() call in the new ".dbstat" command of the CLI. (closed check-in: a138e44a24 ... user: drh tags: analyze-sql-func)
11:41
Add the .dbstat command to the CLI. (check-in: fdba76df2b ... user: drh tags: analyze-sql-func)
11:40
On platforms which support ./configure --with-icu-config, ensure that 'make tclextension' includes the ICU pieces in the tcl extension. Intended to resolve forum post 92a88de4b88929fe. (check-in: 404fde8bac ... user: stephan tags: trunk)
11:23
Avoid a potentially undefined left-shift in the fts5 porter tokenizer. (check-in: 46a288e43e ... user: dan tags: trunk)
11:07
Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. Forum post 8bfbaec404. (check-in: 7f5afb12f4 ... user: dan tags: trunk)
10:49
Compute the average fanout for b-trees of depth 2 or more. (check-in: 2f8598bb09 ... user: drh tags: analyze-sql-func)
2026-04-14
23:53
Minor doc typo fixes contributed by BrickViking. (check-in: c4660ce205 ... user: stephan tags: trunk)
23:19
Code simplifications. Return NULL is the specified SCHEMA does not exist. (check-in: 953969c881 ... user: drh tags: analyze-sql-func)
20:18
Handle a special case of a corrupt changeset in sqlite3changegroup_add(). (check-in: eba625f917 ... user: dan tags: trunk)
20:17
Have the session module detect some corrupt changesets earlier. (closed check-in: 0de91ff0d7 ... user: dan tags: corrupt-changeset_fix)
20:17
Merge trunk enhancements and fixes into the analyze-sql-func branch. (check-in: bb4a9beac8 ... user: drh tags: analyze-sql-func)
20:07
Various minor tweaks and refinements to the analyze() function. (check-in: 48d94e72ea ... user: drh tags: analyze-sql-func)
20:02
Handle a special case of a corrupt changeset in sqlite3changegroup_add(). (check-in: 49b3bac482 ... user: dan tags: corrupt-changeset_fix)