]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
9 days 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

10 days 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

10 days 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

10 days 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

10 days 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

11 days 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

12 days 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

13 days 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

13 days 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

13 days 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

13 days 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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

2 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks agoDocumentation tweaks.
drh [Tue, 6 Jan 2026 21:18:42 +0000 (21:18 +0000)] 
Documentation tweaks.

FossilOrigin-Name: b10b0aa7658a04b9354ca09a2dcb807eecd9421451537f3230ba5f47269ec5c1

3 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

4 weeks agoFix the new .import logic in the CLI so that it honors ".bail on".
drh [Mon, 29 Dec 2025 23:56:05 +0000 (23:56 +0000)] 
Fix the new .import logic in the CLI so that it honors ".bail on".
[forum:/forumpost/6c1c0e213d|Forum post 6c1c0e213d].

FossilOrigin-Name: d58846e74b6971a5fd80e5f030985273b7dfa0087c2f3c9d0c088c248e183f8a

4 weeks agoFix error messages associated with .import, along with corresponding
drh [Mon, 29 Dec 2025 21:39:48 +0000 (21:39 +0000)] 
Fix error messages associated with .import, along with corresponding
test cases.

FossilOrigin-Name: 2084e805d0d9da8f419b8506fccd652a7d20262bd95729250a2d2eabfdd079ad

4 weeks agoIncremental improvements to .import, and new test cases.
drh [Mon, 29 Dec 2025 19:04:41 +0000 (19:04 +0000)] 
Incremental improvements to .import, and new test cases.

FossilOrigin-Name: 5a1e931b19c346bdc8d1a51fa6ef8ee04b7371cdf5df2ee32e1333226c42d327

4 weeks agoUpdate to the unix build documentation.
drh [Mon, 29 Dec 2025 12:46:35 +0000 (12:46 +0000)] 
Update to the unix build documentation.

FossilOrigin-Name: 004cf4ad3cb0c05e501a464bee55e8ed168c4825cf419902890593468ca4d588

4 weeks agoFix the "testfixture" makefile target so that it builds with a static TCL
drh [Mon, 29 Dec 2025 12:34:37 +0000 (12:34 +0000)] 
Fix the "testfixture" makefile target so that it builds with a static TCL
library on Mac-ARM.  Fix the "tool-zip" target so that it uses ordinary
tclsh rather than testfixture to run the tool/mmktoolzip.tcl script that
builds the archive.

FossilOrigin-Name: adf5d624cf109ebd05952e5df62f143f40829070cbcbe43280d371a60db7470b

4 weeks agoTest cases for .import, as well as minor enhancements to .import and to .check.
drh [Sun, 28 Dec 2025 21:37:58 +0000 (21:37 +0000)] 
Test cases for .import, as well as minor enhancements to .import and to .check.

FossilOrigin-Name: 0252ac1c946cd2101f0084f11951b1aeea330dea23b707934c8852d9abe136b9

4 weeks agoIf the filename argument to the .import command is of the form
drh [Sun, 28 Dec 2025 14:32:28 +0000 (14:32 +0000)] 
If the filename argument to the .import command is of the form
"<<endmark" then the content is read from the script (or stdin) until
the first line that begins with "endmark".

FossilOrigin-Name: 6e8ab51fbe0ee918bce6ab960c9fb078764aa9721ef41d39818127eb98045d46

4 weeks agoImprovements to the .import command of the CLI.
drh [Sun, 28 Dec 2025 14:01:52 +0000 (14:01 +0000)] 
Improvements to the .import command of the CLI.

FossilOrigin-Name: 436ed7937bcd3b5781539d883ff2957b81d74abccb75f65a2ffb7446a5944522

4 weeks agoChange a single integer variable to 64-bit in the tokenizer to avoid
drh [Sat, 27 Dec 2025 19:57:59 +0000 (19:57 +0000)] 
Change a single integer variable to 64-bit in the tokenizer to avoid
any possibility of an integer overflow.

FossilOrigin-Name: 69cf692a24d714305b2e4c8c4c40f70dc6510c26b8db7e5249f32a53e44c7e5c

4 weeks agoWork around the Windows "Worst-Fit" bug in the "sqldiff.exe" program.
drh [Fri, 26 Dec 2025 20:13:32 +0000 (20:13 +0000)] 
Work around the Windows "Worst-Fit" bug in the "sqldiff.exe" program.

FossilOrigin-Name: f41851587328f8b434e66987765324b7bf5746ecdf3a9f2869000276e0f79401

4 weeks agoTo ensure that the sqlite3_hard_heap_limit() call it makes is effective, add "sqlite3...
dan [Fri, 26 Dec 2025 17:23:25 +0000 (17:23 +0000)] 
To ensure that the sqlite3_hard_heap_limit() call it makes is effective, add "sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 1);" to fuzzcheck.c.

FossilOrigin-Name: f7736af849d910f04d8622ed7c6e705d84cf22f0a73dca0f30eead9bd1f28bc7

5 weeks agoDoc typo fixes in the configure script pieces.
stephan [Wed, 24 Dec 2025 18:12:08 +0000 (18:12 +0000)] 
Doc typo fixes in the configure script pieces.

FossilOrigin-Name: 8ab37d9fb909dc6bfbede004f342e6c1625c99df9b316807dc77a9a636ee6873

5 weeks agoEnhance the omit-noop-join optimization so that it is able to omit a
drh [Wed, 24 Dec 2025 14:03:15 +0000 (14:03 +0000)] 
Enhance the omit-noop-join optimization so that it is able to omit a
chain of noop-joins.  Optimization improvement suggested by
[forum:/forumpost/11a53f2bad|forum post 11a53f2bad].

FossilOrigin-Name: 5a85b83b9f21ad88938e273bb35b398e91133424683e915836f322b69f277673

5 weeks agoAdditional changes to support the ".schema" command on builds that omit
drh [Tue, 23 Dec 2025 17:24:10 +0000 (17:24 +0000)] 
Additional changes to support the ".schema" command on builds that omit
virtual tables.

FossilOrigin-Name: 6b5c0374fa81cf069263bebf9b740573de4f82fde3c4e5796af80dcbe6a1a2e7

5 weeks agoFix the ".schema" command in the CLI so that it works on builds that
drh [Tue, 23 Dec 2025 16:51:49 +0000 (16:51 +0000)] 
Fix the ".schema" command in the CLI so that it works on builds that
omit virtual table support.

FossilOrigin-Name: b4e3c8170a107b2018fe5374495dbec14c851ccbf7419cd382991b2fe68c45e4

5 weeks agoHarmless typo fixes in shell.c
drh [Tue, 23 Dec 2025 11:13:52 +0000 (11:13 +0000)] 
Harmless typo fixes in shell.c

FossilOrigin-Name: 519877cdbde80071ac08f2e467ef8b9679816dc486cf6eb87ec2d9a38c819f88

5 weeks agoAPI documentation enhancements.
drh [Mon, 22 Dec 2025 17:06:37 +0000 (17:06 +0000)] 
API documentation enhancements.

FossilOrigin-Name: 99ac94cb9a7a76312cda2d236dcc0c92b2ca269456daed06a1c2674c4f326867

5 weeks agoAdd the SQLITE_PREPARE_FROM_DDL flag to sqlite3_prepare_v3(). Use this to prevent...
dan [Mon, 22 Dec 2025 15:22:02 +0000 (15:22 +0000)] 
Add the SQLITE_PREPARE_FROM_DDL flag to sqlite3_prepare_v3(). Use this to prevent fts3/4 tables in non-trusted schemas from calling unsafe SQL functions.

FossilOrigin-Name: 26f39ac806a5582fab1497e38a4ce68dad2b79df8c8aade43c4e21eed7576931