]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
3 months agoAdd the SQLITE_UTF8_ZT value which can be the encoding argument to
drh [Fri, 23 Jan 2026 00:55:36 +0000 (00:55 +0000)] 
Add the SQLITE_UTF8_ZT value which can be the encoding argument to
sqlite3_result_text64() or sqlite3_bind_test64() to indicate that the
argument is UTF-8 text that is zero-terminated.

FossilOrigin-Name: cef0eed8054f3f760cf3142a897c7eead20869157da8b2a0ee9443733eecd371

3 months agoMerge the latest trunk enhancements into the utf8-zt branch. utf8-zt
drh [Thu, 22 Jan 2026 19:29:34 +0000 (19:29 +0000)] 
Merge the latest trunk enhancements into the utf8-zt branch.

FossilOrigin-Name: 0dd1633d34a0c6a6d56e32ca3b05bc0aa55e47097f600d1fc9f00022a53681b3

3 months agoEnhance the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] so that
drh [Thu, 22 Jan 2026 19:02:32 +0000 (19:02 +0000)] 
Enhance the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] so that
the inserted JOIN terms are not required to be on the inner-most loops,
as long as all dependencies for the EXISTS-to-JOIN loops are in outer
loops.  This addresses the performance concern of
[forum:/forumpost/2026-01-21T19:49:04z|forum post 2026-01-21T19:49:04z].
Test cases in TH3.

FossilOrigin-Name: 298d5c8fa6207afb6cdcca3b312a1eeddda0edeb6d840aa5476a7195047a2158

3 months agoFor the ".eqp full" show both the QUERY PLAN and the full byte code, just as
drh [Thu, 22 Jan 2026 15:59:45 +0000 (15:59 +0000)] 
For the ".eqp full" show both the QUERY PLAN and the full byte code, just as
it has in the past.

FossilOrigin-Name: 756484fcaa7efed0691814f3affeb2449d3301c5c764530f2ec8e290caea567f

3 months agoAdd a new encoding constant SQLITE_UTF8_ZT, which if used with
drh [Wed, 21 Jan 2026 19:24:07 +0000 (19:24 +0000)] 
Add a new encoding constant SQLITE_UTF8_ZT, which if used with
sqlite3_result_text64() or sqlite3_bind_text64() declares that the
string provided is UTF8 and zero-terminated at the length specified.

FossilOrigin-Name: 2d84ce88fed12766272f6b1293927eb4c7ce92da0334b09b4875ed2dfdd00ade

3 months agoAdd a new assert().
drh [Wed, 21 Jan 2026 11:29:20 +0000 (11:29 +0000)] 
Add a new assert().

FossilOrigin-Name: bc450aba674a8934d718a88af3c2343555b43c2d8403bd5f6d14e177fce6bc9f

3 months agoStrive to use sort-and-merge for compounds in CTEs.
drh [Tue, 20 Jan 2026 20:10:41 +0000 (20:10 +0000)] 
Strive to use sort-and-merge for compounds in CTEs.

FossilOrigin-Name: 73ed1c790bb386a2981bf7076d23d37e09fa9db3966a7a164b8964fdb14fdad2

3 months agoUpdate the shell tool to work with SQLITE_OMIT_AUTOINIT builds.
dan [Tue, 20 Jan 2026 18:30:48 +0000 (18:30 +0000)] 
Update the shell tool to work with SQLITE_OMIT_AUTOINIT builds.

FossilOrigin-Name: 2b3b36da9d60c265dceec5964ea51c752d81f41459fb6849c8faea658b253552

3 months agoFix another test case to work with union-by-merge.
drh [Tue, 20 Jan 2026 18:20:26 +0000 (18:20 +0000)] 
Fix another test case to work with union-by-merge.

FossilOrigin-Name: 8279c10e2465838010508f6018aa6fdb0e07ca3639f65e727a03a4222573ea57

3 months agoTiny JS doc touchup.
stephan [Tue, 20 Jan 2026 18:07:27 +0000 (18:07 +0000)] 
Tiny JS doc touchup.

FossilOrigin-Name: 6d9ec0a21a2b33a7bb3cf9c3677c9ef7a9738d318cd2d8159b33583b2bd4abec

3 months agowasm: make pre-js.c-pp.js a no-op in bundler-friendly builds.
stephan [Tue, 20 Jan 2026 18:01:56 +0000 (18:01 +0000)] 
wasm: make pre-js.c-pp.js a no-op in bundler-friendly builds.

FossilOrigin-Name: 982a91abc0c97e7e785d3ba69a4d0516a899f4d6cd462027ebdf7115e577e8c3

3 months agowasm: a potential workaround for cases such as [forum:1eec339854c935bd|forum post...
stephan [Tue, 20 Jan 2026 17:10:22 +0000 (17:10 +0000)] 
wasm: a potential workaround for cases such as [forum:1eec339854c935bd|forum post 1eec339854c935bd], where client-local needs require overriding Emscripten config defaults (which we very intentionally do not document or support for reasons explained in that thread). This is untested because it requires a special-needs setup, but it doesn't break anything for run-of-the-mill cases.

FossilOrigin-Name: c8e6be9241e3e17898c451baad109b75dc8a97a91ff1e43c67a6c962b75af8f3

3 months agoMinor fixes. Tests are passing now.
drh [Tue, 20 Jan 2026 15:07:28 +0000 (15:07 +0000)] 
Minor fixes.  Tests are passing now.

FossilOrigin-Name: 305ae331f5e791941c12b04b727656ac8d80f7c5cb6343277b979a456eb3b834

3 months agoAdd an SQLITE_API_ARMOR check to sqlite3_get_clientdata(), per request in [forum...
stephan [Tue, 20 Jan 2026 10:57:44 +0000 (10:57 +0000)] 
Add an SQLITE_API_ARMOR check to sqlite3_get_clientdata(), per request in [forum:a011a001f4|forum post a011a001f4].

FossilOrigin-Name: 346ad366a8ebed1e7936c59f8a40e9c8e7e31d0153bc4f654a47b2ddc39b18ca

3 months agoMinor doc updates in mkwasmbuilds.c.
stephan [Mon, 19 Jan 2026 22:20:12 +0000 (22:20 +0000)] 
Minor doc updates in mkwasmbuilds.c.

FossilOrigin-Name: 81840bd4b2132c1c701bb6fd5a2ac48a4ed33d2b68a3f7a826fa32dc0fc16483

3 months agowasm: remove the bundler-friend builds from the 'all' target, as they're only needed...
stephan [Mon, 19 Jan 2026 22:01:10 +0000 (22:01 +0000)] 
wasm: remove the bundler-friend builds from the 'all' target, as they're only needed for the 'npm' target.

FossilOrigin-Name: dfe4b788ca6596ea9f26445c864f56f81c7816798f5fedfc4e89ba1eb097b0aa

3 months agoMinor doc touchups in the opfs-sahpool VFS. No functional changes.
stephan [Mon, 19 Jan 2026 21:57:32 +0000 (21:57 +0000)] 
Minor doc touchups in the opfs-sahpool VFS. No functional changes.

FossilOrigin-Name: 67c0d11701842baaa5227ccce02483ead07bec8426b9861f2e2a0465414ae382

3 months agoBe more aggressive about using a sort-and-merge to compute the UNION of
drh [Mon, 19 Jan 2026 19:51:03 +0000 (19:51 +0000)] 
Be more aggressive about using a sort-and-merge to compute the UNION of
two SELECT statements.  Experimental branch.  This check-in is failing some
tests.

FossilOrigin-Name: e534af8a78f5458bd656f70eb9f68084c0ed3f97360f5a033fba3564849e970c

3 months agoAdd two new JSON functions: json_array_insert() and jsonb_array_insert().
drh [Mon, 19 Jan 2026 11:44:59 +0000 (11:44 +0000)] 
Add two new JSON functions: json_array_insert() and jsonb_array_insert().
Patterned after the json_array_insert() function of MySQL.
[forum:/forumpost/2026-01-17T10:40:39z|Forum thread 2026-01-17T10:40:39z].

FossilOrigin-Name: c1e55132410a80d37bad30e4ddecc7a98fad92a68b436880324998af1cee37ae

3 months agoRaise an error if any PATH argument to json_array_insert() is not the path json_array_insert
drh [Sat, 17 Jan 2026 19:01:37 +0000 (19:01 +0000)] 
Raise an error if any PATH argument to json_array_insert() is not the path
of an array element.  Add some test cases for json_array_insert().

FossilOrigin-Name: 96b7d2c60a3f8a9f9d69313bad599a3a5ad335cb382263e4254e2d20929d5e55

3 months agoAdd new SQL function: json_array_insert(). Suggested in
drh [Sat, 17 Jan 2026 14:23:28 +0000 (14:23 +0000)] 
Add new SQL function: json_array_insert().  Suggested in
[forum:/forumpost/2026-01-17T10:40:39z|forum thread 2026-01-17T10:40:39z].
This check-in seems to work, but contains no test cases.  Also, no error
is raised if the PATH does not reference an array.  Prototype only.

FossilOrigin-Name: d6c82c8248f8b1ce3d2c01a92e7d1058beac2b2ccac3b122a2cd385c77dc76df

3 months agoFix further problems with deleting from corrupt fts5 databases in secure-delete mode.
dan [Fri, 16 Jan 2026 20:04:04 +0000 (20:04 +0000)] 
Fix further problems with deleting from corrupt fts5 databases in secure-delete mode.

FossilOrigin-Name: f8f89d2e10f06b54acf58a3b0543aef749c3d2b65670d4cc71530dea7997651e

3 months agoTry to prevent false positives in fuzzinvariants.c due to scalar subqueries.
drh [Fri, 16 Jan 2026 17:48:46 +0000 (17:48 +0000)] 
Try to prevent false positives in fuzzinvariants.c due to scalar subqueries.

FossilOrigin-Name: c20be882a62e75abc50fd2dcae26ebbe83a01f09369525392fa22223627a04ea

3 months agoThe optimization at [8bdda827a3d26800] is incorrect for the case where one
drh [Fri, 16 Jan 2026 15:53:20 +0000 (15:53 +0000)] 
The optimization at [8bdda827a3d26800] is incorrect for the case where one
of the two expressions has been commuted such that the collating sequence
has changed.  This check-in fixes the problem.  Problem reported by
[forum:/forumpost/2026-01-16T11:35:28Z|forum post 2026-01-16T11:35:28Z].

FossilOrigin-Name: 9d8fb7a9e23d5ef76d05824401976247debe51be6f658f132609257a068a73de

3 months agoChange the copyright on the tool/dbtotxt.c source code file to the
drh [Fri, 16 Jan 2026 12:13:42 +0000 (12:13 +0000)] 
Change the copyright on the tool/dbtotxt.c source code file to the
standard SQLite blessing.

FossilOrigin-Name: 766c89e009578aa5c1a92cbb2dcc34b3529cf4dd6157f07c84f08470d81942a9

3 months agoFix an error in new test script fts5corrupt9.test.
dan [Thu, 15 Jan 2026 17:17:00 +0000 (17:17 +0000)] 
Fix an error in new test script fts5corrupt9.test.

FossilOrigin-Name: a5918835e172fd4eda6511d297b61368952d617eac33950b67368671e3bd40fe

3 months agoAdd extra test for handling corrupt delta records in rbu. artiphishell
dan [Thu, 15 Jan 2026 17:00:58 +0000 (17:00 +0000)] 
Add extra test for handling corrupt delta records in rbu.

FossilOrigin-Name: 7dba05100fbef3614e6ee8eff39dab7a4713550e5672c2f6cf8f4b490a96aa25

3 months agoFix a buffer overrun that could occur when deleting rows in secure-delete mode from...
dan [Thu, 15 Jan 2026 16:09:35 +0000 (16:09 +0000)] 
Fix a buffer overrun that could occur when deleting rows in secure-delete mode from a strategically corrupted fts5 database.

FossilOrigin-Name: 1e66d6e3276cc6aab4d002a1df13b044e61f3946322bf97cac06d98dbb68e433

3 months agoAdjust the output of the fuzzcheck test program so that testrunner.tcl can
drh [Wed, 14 Jan 2026 19:22:36 +0000 (19:22 +0000)] 
Adjust the output of the fuzzcheck test program so that testrunner.tcl can
capture the number of tests run even when the --slice option is used.

FossilOrigin-Name: dddaeff4ce552f3aa57cc6e18ed35051138b591338242df5f3af39e24006a834

3 months agoUpdate sessions module so that it takes the db mutex before, instead of just after...
dan [Wed, 14 Jan 2026 17:52:27 +0000 (17:52 +0000)] 
Update sessions module so that it takes the db mutex before, instead of just after, opening a savepoint when generating a changeset.

FossilOrigin-Name: 41bbd13d737d2b7879d906b6fa76df42c6ee142f1a7acdafd26da0063bc90baf

3 months agoImprove some of the documentation comments for the new code on this branch.
dan [Wed, 14 Jan 2026 17:02:22 +0000 (17:02 +0000)] 
Improve some of the documentation comments for the new code on this branch.

FossilOrigin-Name: f352485db45a1280f91ec76f661b6dd50bb1d564b74bdff474c92e928860a47d

3 months agoMerge latest trunk changes into this branch.
dan [Wed, 14 Jan 2026 16:01:28 +0000 (16:01 +0000)] 
Merge latest trunk changes into this branch.

FossilOrigin-Name: fae9f376b74ae688dbdb5c0838a38427258d3d14c29c5346a3549e56db79961a

3 months agoAdd tests for edge cases in the new code on this branch.
dan [Wed, 14 Jan 2026 15:27:26 +0000 (15:27 +0000)] 
Add tests for edge cases in the new code on this branch.

FossilOrigin-Name: cd115f0f4437bf254058e40d70ba4e82e87227d2752695aa18f8431c3abc5c0b

3 months agoGuard against oversized index entries in databases larger than 2GiB.
drh [Wed, 14 Jan 2026 13:43:32 +0000 (13:43 +0000)] 
Guard against oversized index entries in databases larger than 2GiB.

FossilOrigin-Name: ed17a878e5a2e0cd1e9b69d528f5ac2ba8452d7c83deaf3cc72ecbff054f5ca3

3 months agoAllow the APIs on this branch to be used to create patchsets as well as changesets.
dan [Tue, 13 Jan 2026 19:59:47 +0000 (19:59 +0000)] 
Allow the APIs on this branch to be used to create patchsets as well as changesets.

FossilOrigin-Name: 8699fe5b24c8aeb5e552aa7f4995f2b50dd33d1febd23ec1c07c8fc72497da72

3 months agoFix integer overflow problems and error reporting memory leaks in
drh [Tue, 13 Jan 2026 02:35:19 +0000 (02:35 +0000)] 
Fix integer overflow problems and error reporting memory leaks in
the zipfile extension.
[forum:/forumpost/2026-01-13T00:09:06Z|Forum post 2026-01-13T00:09:06Z].

FossilOrigin-Name: 8e656a483557bc5385219d560b9155c232e7dc9d62642249abc879fb37bacd2a

3 months agoFix an OOB read in the sessions module that could occur while processing a corrupt...
dan [Mon, 12 Jan 2026 20:16:04 +0000 (20:16 +0000)] 
Fix an OOB read in the sessions module that could occur while processing a corrupt changeset.

FossilOrigin-Name: 3c46295487f089a891f566cae43b67ce97794bb60645d5806285600e05eff456

3 months agoAvoid unsigned integer overflow in the delta_apply() extension function.
drh [Mon, 12 Jan 2026 19:56:00 +0000 (19:56 +0000)] 
Avoid unsigned integer overflow in the delta_apply() extension function.
Not part of any standard deliverable.
[forum:/forumpost/d41879b367c7f7ec|Forum thread d41879b367c7f7ec].

FossilOrigin-Name: b354dd12c25c820c04b08e0be4ba8c095fc648dfb4b71345aacce50a17fd269a

3 months agoFix an infinite loop in the sessions module that could occur when processing a corrup...
dan [Mon, 12 Jan 2026 19:13:09 +0000 (19:13 +0000)] 
Fix an infinite loop in the sessions module that could occur when processing a corrupt changeset blob.

FossilOrigin-Name: d98653bdbc9781970f1c5d66f69c81c93ad14549223ceae02e74c1b99ab05377

3 months agoAdd an API to the sessions module to add changes one at a time to an sqlite3_changegr...
dan [Mon, 12 Jan 2026 16:39:27 +0000 (16:39 +0000)] 
Add an API to the sessions module to add changes one at a time to an sqlite3_changegroup object.

FossilOrigin-Name: 27150a8c22dc5331efa9e97637eae3741682bc14ae993f0b7672ccc63c37f1f9

3 months agowasm: filter the custom Module.instantiateWasm() out of node builds, per request...
stephan [Mon, 12 Jan 2026 15:43:18 +0000 (15:43 +0000)] 
wasm: filter the custom Module.instantiateWasm() out of node builds, per request from the npm project.

FossilOrigin-Name: b57a8215f4259a0aae188b7ee5060f8ff48919303179aae80b58b43ed3b991f5

3 months agoImproved documentation (in the header comment) for tmstmpvfs.c.
drh [Mon, 12 Jan 2026 14:45:55 +0000 (14:45 +0000)] 
Improved documentation (in the header comment) for tmstmpvfs.c.

FossilOrigin-Name: 70b1da718c176b8eb154fe087af4352eb6f55c9c0d1f09fc625d073d9f8075f4

3 months agoAdd sqlite3_carray_bind() to sqlite3_api_routines. [forum:257e642a4c|Forum post 257e6...
stephan [Sun, 11 Jan 2026 21:18:23 +0000 (21:18 +0000)] 
Add sqlite3_carray_bind() to sqlite3_api_routines. [forum:257e642a4c|Forum post 257e642a4c].

FossilOrigin-Name: 7c40dbcec8843f6189549a25dcfa8475f53212de8b0de81e10fd6687ef8fae9e

3 months agoAdd the @preserve tag to the standalone file sqlite3-opfs-async-proxy.js.
stephan [Sun, 11 Jan 2026 16:21:32 +0000 (16:21 +0000)] 
Add the @preserve tag to the standalone file sqlite3-opfs-async-proxy.js.

FossilOrigin-Name: 334b2be57e752672cfcaf764e3bc73e3d00a0a5174e8ef7c3d83c26136bccaf5

3 months agowasm: add @preserve tags to two comment blocks (license header and build version...
stephan [Sun, 11 Jan 2026 14:14:16 +0000 (14:14 +0000)] 
wasm: add @preserve tags to two comment blocks (license header and build version info) so that the npm tools know to retain those comments when minifying.

FossilOrigin-Name: 596f1ea084e78843aa668d3a197690929848d474e55ff7b1444f78bd11f116b1

3 months agoUpdate speedtest.md to point out xdg-open on Linux.
stephan [Sat, 10 Jan 2026 14:12:40 +0000 (14:12 +0000)] 
Update speedtest.md to point out xdg-open on Linux.

FossilOrigin-Name: 47c7fbcb46df5a657ec76dff9a370aea9e7d0d95406b1e124e9fe527cf85350d

3 months agoFix a help text typo in speedtest1.tcl, pointed out off-list by BrickViking.
stephan [Sat, 10 Jan 2026 00:38:00 +0000 (00:38 +0000)] 
Fix a help text typo in speedtest1.tcl, pointed out off-list by BrickViking.

FossilOrigin-Name: 1fd02a75a914f131948fe06fc99f851d3e226f9f1270e25393d79c493c28a347

3 months agoAdd the 'npm' ext/wasm makefile target to create npm-bundle.zip for use by the downst...
stephan [Fri, 9 Jan 2026 19:44:31 +0000 (19:44 +0000)] 
Add the 'npm' ext/wasm makefile target to create npm-bundle.zip for use by the downstream npm package. This target is intended to become their path for pulling npm-relevant deliverables, rather than the canonical downloads, and they have our/my commitment not to break it without involving them first.

FossilOrigin-Name: a4752c18a85bee0cef61ee5ac7911661c1894fb861412c957692069195a001a5

3 months agoFix the wasm snapshot build's zipfile name to include '-snapshot' and correct the...
stephan [Fri, 9 Jan 2026 18:42:27 +0000 (18:42 +0000)] 
Fix the wasm snapshot build's zipfile name to include '-snapshot' and correct the update-docs target for recent build refactoring.

FossilOrigin-Name: 0f53dbf06010f66ba23941ee4269d507efa370f1a8cc0099d274d8baadebdb46

3 months agoFix potential OOB read on the undocumented test function rtreenode() that
drh [Fri, 9 Jan 2026 00:41:35 +0000 (00:41 +0000)] 
Fix potential OOB read on the undocumented test function rtreenode() that
is part of the RTREE extension, as described in
[forum:/forumpost/2026-01-08T23:32:19Z|forum post 2026-01-08T23:32:19Z].
The problem is almost certainly harmless since any memory allocation will
be a multiple of 8 bytes, and once the input buffer size gets rounded up to
the next multiple of 8 bytes, the access will still be within bounds.
Nevertheless, it still needs to be fixed.

FossilOrigin-Name: 9adab8b2bef4130abd358d53384cb5f4dd691b808336bb7102793b0165b1c516

3 months agoEnhance VACUUM INTO so that if a URI filename is used as the target and that
drh [Thu, 8 Jan 2026 20:29:02 +0000 (20:29 +0000)] 
Enhance VACUUM INTO so that if a URI filename is used as the target and that
filename as a reserve=N query parameter with N between 0 and 255, then the
reserve amount for the generated database copy is set to N.  This simplifies
making a copy of a database file with a reduced or reset reserve.

FossilOrigin-Name: a482f9836597de55a9b58fddd3ca2963b8c67ecefef1e34a8c079a2d76f287d0

3 months agoIn the reserve=N query parameter on the VACUUM INTO target file, the reset-reserve
drh [Thu, 8 Jan 2026 20:20:03 +0000 (20:20 +0000)] 
In the reserve=N query parameter on the VACUUM INTO target file, the
parameter is a silent no-op if N is out of range.

FossilOrigin-Name: 48e59a27330932cf29bcbd01080757b82ea4a03f5a9e1fa7da076dbfcb7f60e3

3 months agoChange the name of the log file for tmstmpvfs.c to be an ISO8601 date/time,
drh [Thu, 8 Jan 2026 18:55:49 +0000 (18:55 +0000)] 
Change the name of the log file for tmstmpvfs.c to be an ISO8601 date/time,
for improved readability and situational awareness.

FossilOrigin-Name: 66018b85a92db2f3b6b15f7c5c0d54bac890f8e50a1839c08857507c39ec4af7

3 months agoFix the sqlite3-worker1.mjs (ESM, non-bundler) build and have demo-worker1-promiser...
stephan [Thu, 8 Jan 2026 18:15:23 +0000 (18:15 +0000)] 
Fix the sqlite3-worker1.mjs (ESM, non-bundler) build and have demo-worker1-promiser use that file rather than the vanilla one, as a test case. Delete the global symbol installed by that file in ESM and bundler builds, as it's unnecessary there. The first change should resolve [https://github.com/sqlite/sqlite-wasm/issues/123|downstream sqlite-wasm/issues/123], with thanks to Jure Rotar for his help.

FossilOrigin-Name: 11f5ab0dd8efc68112c3dc5ea0ed486c32bcdb9fde85352180f40a77c6354cac

3 months agoMerge all the latest trunk changes into the reset-reserve branch.
drh [Thu, 8 Jan 2026 18:14:29 +0000 (18:14 +0000)] 
Merge all the latest trunk changes into the reset-reserve branch.

FossilOrigin-Name: 6e5f1fbaec775db5c5e90b29cfa0820c9f4d560b36c063b504ef55a6c3a65bdc

3 months agoFix an off-by-one error in the page number of ELOG_CKPT_PAGE log
drh [Thu, 8 Jan 2026 17:52:42 +0000 (17:52 +0000)] 
Fix an off-by-one error in the page number of ELOG_CKPT_PAGE log
messages in tmstmpvfs.c

FossilOrigin-Name: 6fafd010de2d9820f77ee6d2a5f0a7ab1260872d09e95b6932c959ef017aaa77

3 months agoAdd a missing #if check for SQLITE_OMIT_LOAD_EXTENSION to shell.c.in, trigged by...
stephan [Thu, 8 Jan 2026 15:26:19 +0000 (15:26 +0000)] 
Add a missing #if check for SQLITE_OMIT_LOAD_EXTENSION to shell.c.in, trigged by the fiddle build.

FossilOrigin-Name: 1091f3371f4af75344c2e6da26656c259fa96c8a8da9acde3db79df8aa95fd0a

3 months agoMinor bug fixes in tmstmpvfs.c, showdb.c, and showtmlog.c.
drh [Thu, 8 Jan 2026 15:25:04 +0000 (15:25 +0000)] 
Minor bug fixes in tmstmpvfs.c, showdb.c, and showtmlog.c.

FossilOrigin-Name: 1fee8265f7eab649ee8b28456c37d95198f5cde54e905154e3eccc0b328ece9a

3 months agoRemove an obsolete '32-bit' label from tester1-worker.
stephan [Thu, 8 Jan 2026 15:06:28 +0000 (15:06 +0000)] 
Remove an obsolete '32-bit' label from tester1-worker.

FossilOrigin-Name: e14d9a980351a8d5e935e6991ea02a1c40c9ea8f0ad0fadcabe07d575a9b289c

3 months agoFix the --size X flag for speedtest1.html when X=0 and force the job size to 5 for...
stephan [Thu, 8 Jan 2026 15:03:00 +0000 (15:03 +0000)] 
Fix the --size X flag for speedtest1.html when X=0 and force the job size to 5 for kvvfs so that it doesn't block the main thread for too awful long.

FossilOrigin-Name: e2634e500cce44650ad5dd95b722b993b1f999b9f8b2396ab15154e67cb065c7

3 months agoEnhance the --vfs command-line option to the CLI such that if the argument
drh [Thu, 8 Jan 2026 13:43:15 +0000 (13:43 +0000)] 
Enhance the --vfs command-line option to the CLI such that if the argument
is not a valid VFS name, but is the name of a file, attempt to load that
file as an extension, which presumably adds the desired VFS.

FossilOrigin-Name: 509954b44eb305a4401ddcbcce24d8f9ed5534717290888899d716b9df40c981

3 months agoIn the showdb utility, the -tmstmp option works without -csv for the pgidx
drh [Thu, 8 Jan 2026 13:20:36 +0000 (13:20 +0000)] 
In the showdb utility, the -tmstmp option works without -csv for the pgidx
command.

FossilOrigin-Name: c0aecd2189b431d82eca1c1d6718920cf928d910d443ea506e7b3bf3c5d7e246

3 months agoFix ESCALE typo in shell.c, reported in [forum:b8f6a41c8b|forum post b8f6a41c8b].
stephan [Thu, 8 Jan 2026 12:43:21 +0000 (12:43 +0000)] 
Fix ESCALE typo in shell.c, reported in [forum:b8f6a41c8b|forum post b8f6a41c8b].

FossilOrigin-Name: 6fa09449738af03d096208e26447b795f2825d6aaa397de09590cf18b065f82d

3 months agoDo not show LIKE wildcards on table names in the output of the ".schema"
drh [Thu, 8 Jan 2026 12:39:49 +0000 (12:39 +0000)] 
Do not show LIKE wildcards on table names in the output of the ".schema"
command in the CLI.
[forum:/info/6ebb57b41691293d|Forum post 6ebb57b41691293d].

FossilOrigin-Name: 4c6f646bd2910e6dc80dfec7546a3ed7b47bb9d00402e7c3871ece2c185f4ec0

3 months agoAdd the showtmlog utility for decoding the tmstmpvfs log files.
drh [Thu, 8 Jan 2026 12:22:50 +0000 (12:22 +0000)] 
Add the showtmlog utility for decoding the tmstmpvfs log files.
Fix tmstmpvfs so that it records timestamps in milliseconds since the
Unix epoch, not in JDN milliseconds.

FossilOrigin-Name: 762d3cbf06218f1010425a98a71ebf7623b84b45a90e6419b7dec7f10ad0c5a5

3 months agoImprove showdb so that it does a better job of handling reserve-bytes.
drh [Thu, 8 Jan 2026 01:37:13 +0000 (01:37 +0000)] 
Improve showdb so that it does a better job of handling reserve-bytes.
Add the --tmstmp option that causes pgidx to interpret tmstmpvfs tags
if they are available.

FossilOrigin-Name: d7e6e9a5781f467a5b5f02f46134099cf01607a0cf55510155533d57d4a4618a

3 months agoAdd the tmstmpvfs.c extension to trunk. It is not a part of any deliverable
drh [Thu, 8 Jan 2026 00:41:12 +0000 (00:41 +0000)] 
Add the tmstmpvfs.c extension to trunk.  It is not a part of any deliverable
and can easily be removed later, if found to not be desirable.

FossilOrigin-Name: 869f306592a86d2a78f00266c615f033cd2318a7bff0a97b3dcdd3348d99fc66

3 months agoAdd the --csv option to the "pgidx" option to the "showdb" utility.
drh [Wed, 7 Jan 2026 23:46:44 +0000 (23:46 +0000)] 
Add the --csv option to the "pgidx" option to the "showdb" utility.

FossilOrigin-Name: b6ad93f62eb883ee8f4c43dd90c69b31398be6b13186866a7b05d85fe588d967

3 months agoEnhance the VACUUM INTO command such that if the target file is a URI
drh [Wed, 7 Jan 2026 21:19:42 +0000 (21:19 +0000)] 
Enhance the VACUUM INTO command such that if the target file is a URI
with a reserve=N query parameter, then the reserve_bytes value is set to
N provided that N is within the allowed range.  This can even reduce the
size of the reserve, all the way to zero.  This provides a way to remove
reserve from a database without having to do a complete dump/restore.

FossilOrigin-Name: 9cec3b67d95c145c968c560e8b3d2c33896b4b5b6c86c61350263764bb616c43

3 months agoFix the static build. timestamp-vfs
drh [Wed, 7 Jan 2026 19:06:11 +0000 (19:06 +0000)] 
Fix the static build.

FossilOrigin-Name: 4e1a1b6aeffaa5b8c11e165803c6d33becabd1f646f39e4309dfba6892fd4bd6

3 months agoImprovements to logging. Better log-file names. Log files are in a
drh [Wed, 7 Jan 2026 18:45:23 +0000 (18:45 +0000)] 
Improvements to logging.  Better log-file names.  Log files are in a
subdirectory named after the database.  Only connections that write to
the database create logs.  Better documentation in the header comment.

FossilOrigin-Name: 5b1cf0fe73ba1a40fe4cd8f5f6e8ee5b471f96b60aff52c03c045ad6514c363a

3 months agoEnhance QRF so that it terminates more quickly if it encounters an OOM
drh [Wed, 7 Jan 2026 16:19:18 +0000 (16:19 +0000)] 
Enhance QRF so that it terminates more quickly if it encounters an OOM
or oversize string error, and fix it so that it reports such errors.

FossilOrigin-Name: ebedeb6169cc3bc3708130d4061065af600a8851e896fc3eeaf33c8c83fe3b95

3 months agoAdd the -p or --port option to sqlite3_rsync.
drh [Tue, 6 Jan 2026 21:39:12 +0000 (21:39 +0000)] 
Add the -p or --port option to sqlite3_rsync.

FossilOrigin-Name: 53f806fdab7161e439a165af47bd45332c15233b87bc35c2272621256a2dc337

3 months agoDocumentation tweaks.
drh [Tue, 6 Jan 2026 21:18:42 +0000 (21:18 +0000)] 
Documentation tweaks.

FossilOrigin-Name: b10b0aa7658a04b9354ca09a2dcb807eecd9421451537f3230ba5f47269ec5c1

3 months agoEnhance the timestamp-vfs prototype so that it also keeps an event log.
drh [Tue, 6 Jan 2026 20:51:06 +0000 (20:51 +0000)] 
Enhance the timestamp-vfs prototype so that it also keeps an event log.

FossilOrigin-Name: f087c6c0cdd542ec24b4668fff9cb434f46caf554f8856a49fd062ab3f72014e

3 months agoUpdate to the sqlite3_get_clientdata() documentation. No code changes.
drh [Tue, 6 Jan 2026 13:00:24 +0000 (13:00 +0000)] 
Update to the sqlite3_get_clientdata() documentation.  No code changes.

FossilOrigin-Name: 395b7168b873390c05ea2cc71fe14bafb5bdee77f32a047bec8d7ed6feb9ed90

3 months agoUpdate the regexp extension so that the "-" character may be escaped with a backslash...
dan [Mon, 5 Jan 2026 18:29:07 +0000 (18:29 +0000)] 
Update the regexp extension so that the "-" character may be escaped with a backslash. Forum post [forum:c5e7358f82 | c5e7358f82].

FossilOrigin-Name: 80013129361fb81ce5db1f6390cad640c2cb547e5ba16724dfb55d0aceecdf6d

3 months agoAdd the experimental tmstmpvfs.c extension that adds a timestamp and other
drh [Mon, 5 Jan 2026 17:28:33 +0000 (17:28 +0000)] 
Add the experimental tmstmpvfs.c extension that adds a timestamp and other
debugging information on each page of a database as that page is written,
if the database is configured for exactly 16 bytes of reserve space.

FossilOrigin-Name: 703e593dfc92676a2d44c67ca8282a78a1943b9c1e3f2447c0a9917d70a383c4

3 months agoFix an uninitialized var use reported in [forum:88561a4a1e|forum post 88561a4a1e].
stephan [Sun, 4 Jan 2026 11:05:05 +0000 (11:05 +0000)] 
Fix an uninitialized var use reported in [forum:88561a4a1e|forum post 88561a4a1e].

FossilOrigin-Name: 707c0f6442e946f23de061ee2753eb5994ab55d411c49b232799f309ba0f10cf

3 months agoFix yet another bug in the [/info/e33da6d5dc964db8|EXISTS-to-JOIN]
drh [Sat, 3 Jan 2026 15:11:07 +0000 (15:11 +0000)] 
Fix yet another bug in the [/info/e33da6d5dc964db8|EXISTS-to-JOIN]
optimization, reported by
[forum:/forumpost/2026-01-03T14:05:48z|forum post 2026-01-03T14:05:48z].

FossilOrigin-Name: f60e863e0ca2d8ab853fa5f48d3cd7b062b13167fcddffc4563bde9285b92320

3 months agoMinor change to an #if in the Windows VFS, which I am told will allow
drh [Fri, 2 Jan 2026 19:42:55 +0000 (19:42 +0000)] 
Minor change to an #if in the Windows VFS, which I am told will allow
SQLite to be compiled for 64-bit Windows7.

FossilOrigin-Name: 2afc54b91fe94a37bd3754b5beae6b1f378488b33f7d23eeeebe96d78d120fe3

3 months agoEnsure that loops created by the exists-to-join optimization use unique cursor number...
dan [Fri, 2 Jan 2026 17:10:40 +0000 (17:10 +0000)] 
Ensure that loops created by the exists-to-join optimization use unique cursor numbers, even if the EXISTS expression in the WHERE clause is a copy of an expression from the result-set of the SELECT. dbsqlfuzz 4f6a5213cf74fcf2a8a3e48abc2333100348c38e.

FossilOrigin-Name: 19e57a18cbfad44bb1cb1e62d4485635d26059cb2319f4b7f1244df2638bea43

3 months agoChange the shelltest target on the windows makefile to use testrunner.tcl
drh [Fri, 2 Jan 2026 00:23:22 +0000 (00:23 +0000)] 
Change the shelltest target on the windows makefile to use testrunner.tcl

FossilOrigin-Name: db4d07623500325153c3254c2ad9eaf5e0f1d056637c6799643fcc9bb3a5e84e

3 months agoFurther improvements to testrunner.tcl documentation.
drh [Thu, 1 Jan 2026 21:35:25 +0000 (21:35 +0000)] 
Further improvements to testrunner.tcl documentation.

FossilOrigin-Name: c71402031ce81b4415a793afa3152f5691b197dce634c1322948f39086b8c819

3 months agoUpdates to the testrunner documentation.
drh [Thu, 1 Jan 2026 15:41:50 +0000 (15:41 +0000)] 
Updates to the testrunner documentation.

FossilOrigin-Name: bcac99f962c6403fddfcaeef309ea9f825fa661fee0b3e3fd24f04c861be1d1b

3 months agoVerify the effect of "--titles on" in the "insert" mode in the CLI.
drh [Wed, 31 Dec 2025 20:43:31 +0000 (20:43 +0000)] 
Verify the effect of "--titles on" in the "insert" mode in the CLI.

FossilOrigin-Name: a5f922b0832d9544b083f3d55d4029aa80e320bf5505547c5a1ddb21f4685e3e

3 months agoThe header setting from the legacy ".headers" dot-command takes precedence
drh [Wed, 31 Dec 2025 20:35:16 +0000 (20:35 +0000)] 
The header setting from the legacy ".headers" dot-command takes precedence
over the current ".mode" setting, for backwards compatibility.
[forum:/forumpost/2025-12-31T19:14:24z|Forum post 2025-12-31T19:14:24z].

FossilOrigin-Name: d2c5df41285a9c8a66e9bdea4e28d86fe10665ad01cfbab5a7ce43b8e39b4e34

3 months agoIn the (completely unused, as far as I know) btreeinfo.c extension (not
drh [Wed, 31 Dec 2025 19:45:45 +0000 (19:45 +0000)] 
In the (completely unused, as far as I know) btreeinfo.c extension (not
a part of any standard build) do a better job of detecting corrupt database
files and provide better error messages when corruption is detected.
[forum:/forumpost/e66a458339|Forum post e66a458339].

FossilOrigin-Name: 326d29ac7ecd933d6fca80d3d538783ed46939e7bc6e3aa60ded4b619aa73730

3 months agoUse 64-bit integers to track memory allocation sizes in the CSV extension.
drh [Wed, 31 Dec 2025 18:30:45 +0000 (18:30 +0000)] 
Use 64-bit integers to track memory allocation sizes in the CSV extension.
[forum:/forumpost/e66a458339|Forum post e66a458339].

FossilOrigin-Name: f293a2b3ffcfe20fcda954bd31e88bbfcba18d007e9b5f29a473983f6030f2ce

3 months agoAdd the new "retest" command to testrunner.tcl, which reruns any tests that
drh [Wed, 31 Dec 2025 17:21:30 +0000 (17:21 +0000)] 
Add the new "retest" command to testrunner.tcl, which reruns any tests that
failed or never completed in the previous invocation.  New makefile target
"retest" for both unix and Windows that runs testrunner.tcl with "retest".

FossilOrigin-Name: 9b668d56bf0eca3eb826df3edd6705cc809d920494c192a9949cafda791d83f9

3 months agoEnhance testrunner.tcl so that it can always be run from an ordinary tclsh
drh [Wed, 31 Dec 2025 14:17:51 +0000 (14:17 +0000)] 
Enhance testrunner.tcl so that it can always be run from an ordinary tclsh
as long as that tclsh can load the sqlite3 package.

FossilOrigin-Name: 1a08b85a862e8c9ac56c11e05f76abc25ad98b510fb13ad0716206ba797e53a8

3 months agoFix test/shellB.test so that it works under Device-One. Also bring the
drh [Wed, 31 Dec 2025 11:46:26 +0000 (11:46 +0000)] 
Fix test/shellB.test so that it works under Device-One.  Also bring the
header comment of shellB up to date.

FossilOrigin-Name: 836d02468c7749fa9cdb656c9f80cfef9a41e2eb1321d4bb56c0e0cbc5f37df4

3 months agoUse sqlite3_malloc64() in all places in the compress.c extension to avoid
drh [Wed, 31 Dec 2025 01:19:51 +0000 (01:19 +0000)] 
Use sqlite3_malloc64() in all places in the compress.c extension to avoid
integer overflow.
[forum:/forumpost/2025-12-31T01:04:00z|Forum post 2025-12-31T01:04:00z].

FossilOrigin-Name: 7ceaf1f0c3d9b96d2224ce6526fb3092b9e1673573e3d7dd898b2a135e23027d

3 months agoFix a typo in [0819fe670f9ceec7] that lead to incomplete protection against
drh [Wed, 31 Dec 2025 01:01:14 +0000 (01:01 +0000)] 
Fix a typo in [0819fe670f9ceec7] that lead to incomplete protection against
buffer overflow in the zipfile extension.
[forum:/forumpost/2025-12-30T23:57:19z|Forum post 2025-12-30T23:57:19z]

FossilOrigin-Name: a6abbadacbb88c1ddcc236b40fb34eddf3bb0891189bd00a5af8d34b42871967

3 months agoFix the output from the (undocumented) --test-argv option of the CLi so
drh [Tue, 30 Dec 2025 13:10:10 +0000 (13:10 +0000)] 
Fix the output from the (undocumented) --test-argv option of the CLi so
that it correctly displays UTF8 text on Windows.

FossilOrigin-Name: 39e15ce3d6c42b13d0c1164a161e7b5d5d8382050c2729961733ddef695c9116

3 months agoAdd missing free() to winmain.c
drh [Tue, 30 Dec 2025 13:01:05 +0000 (13:01 +0000)] 
Add missing free() to winmain.c

FossilOrigin-Name: 44dff1a1bb986cd08b729d4b73f09c995cbc67f884caa297674b31fb36805c8b

3 months agoImproved handling of the process entry point in Windows, to translate
drh [Tue, 30 Dec 2025 12:38:43 +0000 (12:38 +0000)] 
Improved handling of the process entry point in Windows, to translate
arguments into UTF8.

FossilOrigin-Name: 1d4ee6c35e69d43e2b801c425308de0ef5d5d9d2d0af9b406b664bf0f9cfa337

3 months agoAvoid signed integer overflow when an fts5 'merge' command is passed -2147483648...
dan [Tue, 30 Dec 2025 11:36:23 +0000 (11:36 +0000)] 
Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter.

FossilOrigin-Name: 52738908b04848b93d54431def37ffaa9723043270ff8ba1e2fa59ab0040afc5

3 months agoFix the change on this branch so that it works with amalgamation builds. fts5-int-overflow-fix
dan [Tue, 30 Dec 2025 11:33:30 +0000 (11:33 +0000)] 
Fix the change on this branch so that it works with amalgamation builds.

FossilOrigin-Name: 7f0b9e7a8bba1b73ef16257e72a055ea84fb10eb5cf0e6431fca81b2f040c5ee

3 months agoAvoid signed integer overflow when an fts5 'merge' command is passed -2147483648...
dan [Tue, 30 Dec 2025 11:19:27 +0000 (11:19 +0000)] 
Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter.

FossilOrigin-Name: 4c5d18d7f5bdcf95efdf96062c7434d5d10584a1fdfd65b18d331b8aae42e26a