]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
7 days agoModify the "%realloc" and "%free" commands in Lemon so that the functions parser-stack-size
drh [Tue, 18 Nov 2025 15:40:02 +0000 (15:40 +0000)] 
Modify the "%realloc" and "%free" commands in Lemon so that the functions
they specify take an extra parameter at the end, the %extra_context pointer.
This allows the implementation to distinguish between OOM errors and
failures to increase the stack size because of the stack size limit.

FossilOrigin-Name: 9862c945d9a8531f9bef123aee9ed1fd3f64542250a57beb3a150227bc3c1a12

7 days agoLower the default stack size for the parse to 50.
drh [Tue, 18 Nov 2025 15:20:22 +0000 (15:20 +0000)] 
Lower the default stack size for the parse to 50.

FossilOrigin-Name: 41fe19ab054acda912bc32dd6f9c6412416ab1af6cf55515e96c89fb55b46424

7 days agoAdd the SQLITE_LIMIT_PARSER_DEPTH value for sqlite3_limit(). This isn't
drh [Tue, 18 Nov 2025 14:48:33 +0000 (14:48 +0000)] 
Add the SQLITE_LIMIT_PARSER_DEPTH value for sqlite3_limit().  This isn't
something that many applications will need, but it is useful for testing.

FossilOrigin-Name: 8f0b07f36159225c476f756f8f9b35c75783bc8bed43b578f4d1055fa800ecc9

7 days agoYet another attempt at controlling the parser stack size.
drh [Tue, 18 Nov 2025 13:03:08 +0000 (13:03 +0000)] 
Yet another attempt at controlling the parser stack size.

FossilOrigin-Name: cb19986dc6bc483df21e082e54a14cb6d7540b1734259e6d326d676908ac0172

7 days agoFix incorrect "#line" generation in Lemon.
drh [Tue, 18 Nov 2025 10:38:41 +0000 (10:38 +0000)] 
Fix incorrect "#line" generation in Lemon.

FossilOrigin-Name: 5c0214df2c0a7470ac2edca0c483a3edd3c39ef0739688ab9a06e23882200360

8 days agoAdd api.oo1=0 flag to ext/wasm/GNUmakefile to strip out the sqlite3.oo1 pieces from...
stephan [Mon, 17 Nov 2025 23:55:41 +0000 (23:55 +0000)] 
Add api.oo1=0 flag to ext/wasm/GNUmakefile to strip out the sqlite3.oo1 pieces from the build. Part of the ongoing response to [forum:4b7d45433731d2e0|forum post 4b7d45433731d2e0].

FossilOrigin-Name: ea48567ac54e4949a8b68977a58a5de7946e074ae8737133071d02f40ac97f34

8 days agoFix a harmless compiler warning.
drh [Mon, 17 Nov 2025 19:19:58 +0000 (19:19 +0000)] 
Fix a harmless compiler warning.

FossilOrigin-Name: 6621737cc05cbf8ff5f576775a8a3c64f666b56d42939968ebb55d72a835646b

10 days agoRemove an unused struct.
stephan [Sat, 15 Nov 2025 16:06:03 +0000 (16:06 +0000)] 
Remove an unused struct.

FossilOrigin-Name: 93dd0e62b74a0d99803f680f23953e9fa2429074505ba402ca5ed4610ddef8fb

10 days agoJNI: when validing the eTextRep argument in sqlite3_create_function(), only validate...
stephan [Sat, 15 Nov 2025 15:30:45 +0000 (15:30 +0000)] 
JNI: when validing the eTextRep argument in sqlite3_create_function(), only validate the lower four bits (the high bits are for other flags). Add flags to test functions to ensure this case is triggered.

FossilOrigin-Name: aab640be7bc5829fe16d2582b13f942b7debb271c150ca2471561de6b2d70dc7

10 days agoReplace the JNI binding's internal use of sqlite3ErrorWithMsg() with sqlite3_set_errm...
stephan [Sat, 15 Nov 2025 15:09:04 +0000 (15:09 +0000)] 
Replace the JNI binding's internal use of sqlite3ErrorWithMsg() with sqlite3_set_errmsg() and have it handle OOM in a way consistent with the rest of the JNI bindings.

FossilOrigin-Name: 0899a9eb3af727f310372f3441573ab506ffec31dca4774e850b2b59a4001ee0

10 days agoRandom JS build cleanups and parallel build mkdir race fixes. Reinstate the recently...
stephan [Sat, 15 Nov 2025 13:30:13 +0000 (13:30 +0000)] 
Random JS build cleanups and parallel build mkdir race fixes. Reinstate the recently-removed [a65bd978cbc646ec] after finding a reformulation which works on Emscripten 4.0.19 (and saves about 85kb on the JS deliverables).

FossilOrigin-Name: acb1525a49463de67716638626406ccde9a282907d0de218ab88bf474ba830ee

10 days agoReorder initialization of sqlite3ApiBootstrap()'s bownstrapped config object so that...
stephan [Sat, 15 Nov 2025 11:53:30 +0000 (11:53 +0000)] 
Reorder initialization of sqlite3ApiBootstrap()'s bownstrapped config object so that it's possible to inject the wasm memory and exports via that, to simplify plugging-in of sqlite3-api.js in other builds. Previously the build-provided wasm exports/memory overrode any which a client might want to use.

FossilOrigin-Name: 2bd0addb6068cd2b34f6151a824c578e2253f541a8c55b578219b09c42afd82b

10 days agoGeneric internal JS cleanups towards improving portability of sqlite3-api.js to other...
stephan [Sat, 15 Nov 2025 11:30:45 +0000 (11:30 +0000)] 
Generic internal JS cleanups towards improving portability of sqlite3-api.js to other build systems.

FossilOrigin-Name: 5bc37e5c2fcd83fd0bc40234144072363f1cbf7d811a15b74a0991e397a35eb8

11 days agoMove sqlite3-api-cleanup.js into post-js-footer.js to remove the final direct Emscrip...
stephan [Sat, 15 Nov 2025 09:19:03 +0000 (09:19 +0000)] 
Move sqlite3-api-cleanup.js into post-js-footer.js to remove the final direct Emscripten dependency from the intermediary build product sqlite3-api.js (the whole library, waiting to be bootstrapped). This is partly in response to [forum:4b7d45433731d2e0|forum post 4b7d45433731d2e0], which demonstrates a potential use case for a standalone sqlite3-api.js. This is a build/doc change, not a functional one.

FossilOrigin-Name: 2fcbd8e17d8f1dd7e9d45168805dba718777e46803d9375a4212296d3d0cd89c

11 days agoAPI doc typo fix.
stephan [Sat, 15 Nov 2025 08:05:12 +0000 (08:05 +0000)] 
API doc typo fix.

FossilOrigin-Name: c1e9791fbf9e4c2ca6f9f031ea2c26d8b4bfb4d54850a53853f2b2d9620792ef

11 days agoNew interfaces sqlite3_str_truncate() and sqlite3_str_free(). Version number
drh [Fri, 14 Nov 2025 20:09:01 +0000 (20:09 +0000)] 
New interfaces sqlite3_str_truncate() and sqlite3_str_free().  Version number
increases to 3.52.0.

FossilOrigin-Name: fa85534ed927851dc37a4943e83259bff4509f141449226ffb506f9acc7b2cc5

11 days agoIf SQLITE_EXPERIMENTAL_PRAGMA_20251114 is defined at build-time, send an experimental...
dan [Fri, 14 Nov 2025 17:27:20 +0000 (17:27 +0000)] 
If SQLITE_EXPERIMENTAL_PRAGMA_20251114 is defined at build-time, send an experimental pragma file-control to the VFS if a call to take a SHARED lock is to be immediately followed by one to take a RESERVED.

FossilOrigin-Name: e2b3f1a9480a9be3e06c2d79abcf39f399b5adf2ca882841b3b3fa199c239dd8

11 days agoSlight restructure of the previous checkin.
stephan [Fri, 14 Nov 2025 17:23:24 +0000 (17:23 +0000)] 
Slight restructure of the previous checkin.

FossilOrigin-Name: 8ff98747c072c8c333b1b37cf4ec9344e84f081bd4e6d3b5e75f37b1e1ce9e84

11 days agoIn sqlite3-api-cleanup.js, if no Emscripten module is detected then simply return...
stephan [Fri, 14 Nov 2025 16:56:51 +0000 (16:56 +0000)] 
In sqlite3-api-cleanup.js, if no Emscripten module is detected then simply return, rather than throw. This should enable the generated sqliet3-api.js (normally an intermediary file) to be used as-is, with the caveat that the caller has to bootstrap the library themselves.

FossilOrigin-Name: d64c9cd4c7a1ffe04de6c75126563d7bbb24266e13d41406f6d55720b8199037

11 days agoRemove a harmless duplicated makefile var assignment from mkwasmbuilds.c.
stephan [Fri, 14 Nov 2025 15:03:55 +0000 (15:03 +0000)] 
Remove a harmless duplicated makefile var assignment from mkwasmbuilds.c.

FossilOrigin-Name: 4b4a6fbe20d51689e0abc65beed078bbb9418383e69eb8ec13f0657e2cf13bfd

11 days agoFix a makefile ordering bug which caused certain builds to fail unless others had...
stephan [Fri, 14 Nov 2025 14:42:00 +0000 (14:42 +0000)] 
Fix a makefile ordering bug which caused certain builds to fail unless others had already been built. Remove the superfluous sqlite3-node.wasm from the final deliverables dir (sqlite3-node.mjs uses sqlite3.wasm instead).

FossilOrigin-Name: fd70088284946b9d4315781b3f68133cc0abd4244247f2fce04044feab8a97c0

11 days agoFix a harmless compiler warning in testing code.
drh [Fri, 14 Nov 2025 11:02:49 +0000 (11:02 +0000)] 
Fix a harmless compiler warning in testing code.

FossilOrigin-Name: 5252a2e629e1adb61169d32ca6458c6decd1ec562f358bb9d0b448a2f0243c56

12 days agoA better fix for the issue with RETURNING triggers on eponymous virtual tables and...
dan [Thu, 13 Nov 2025 20:37:09 +0000 (20:37 +0000)] 
A better fix for the issue with RETURNING triggers on eponymous virtual tables and SQLITE_SCHEMA errors first addressed by [45d820ca22].

FossilOrigin-Name: bf399992cb98e5d5f002a90b521328d5c2f113ebab8601653452d78222077bde

12 days agoAdd an OOM test case for the issue with dropping RETURNING triggers when the schema...
dan [Thu, 13 Nov 2025 18:02:22 +0000 (18:02 +0000)] 
Add an OOM test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement that uses an eponymous vtab.

FossilOrigin-Name: dc569288dd63754269e14be7a9937c882531685a3e9caec25f86ec8c01eb9583

12 days agoAdd better test case for the issue with dropping RETURNING triggers when the schema...
dan [Thu, 13 Nov 2025 17:42:55 +0000 (17:42 +0000)] 
Add better test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement.

FossilOrigin-Name: 6a9fdde109865b23888f099d066721404e8b853f3dacd55ce08c8bbda2491ec3

12 days agoGeneric makefile cleanups and doc updates.
stephan [Thu, 13 Nov 2025 17:37:40 +0000 (17:37 +0000)] 
Generic makefile cleanups and doc updates.

FossilOrigin-Name: e8b34b4178be621102dac165b716283055fad90b3edc2394f56a24f9f0149448

12 days agoInternal doc fix (renamed file).
stephan [Thu, 13 Nov 2025 16:38:45 +0000 (16:38 +0000)] 
Internal doc fix (renamed file).

FossilOrigin-Name: cb8fb01fe19ba3af536a662aed894b2b0eb2463c8d34c644c498234fd82122f3

12 days agoJS code reformatting and doc updates. No functional changes.
stephan [Thu, 13 Nov 2025 15:33:44 +0000 (15:33 +0000)] 
JS code reformatting and doc updates. No functional changes.

FossilOrigin-Name: c566c653e4f55afa0660e819ed5b1fd96cb9b24bc78c333adcd8825331a9dd26

12 days agoAdd the #include -raw flag to ext/wasm/c-pp-lite.c to support a pending feature.
stephan [Thu, 13 Nov 2025 14:47:41 +0000 (14:47 +0000)] 
Add the #include -raw flag to ext/wasm/c-pp-lite.c to support a pending feature.

FossilOrigin-Name: 42c30c314969c0f2573bbe36615683ac19a7ba4e30004c7080873459096caaf5

12 days agoFix a problem in the EXISTS-to-JOIN optimization ([e33da6d5dc964db8]) so
drh [Thu, 13 Nov 2025 11:36:48 +0000 (11:36 +0000)] 
Fix a problem in the EXISTS-to-JOIN optimization ([e33da6d5dc964db8]) so
that it works with nested WHERE and EXISTS statements.
[forum:/forumpost/0704c3c41e49631b|Forum post 0704c3c41e4]

FossilOrigin-Name: d1e901eddc25175174d0706238ae0c33bfa5569e0c2ba4f1164b7a9600203442

13 days agomkwasmbuilds.c doc updates. Merge in the parts of [8611cf643b] which are not contentious.
stephan [Thu, 13 Nov 2025 09:03:48 +0000 (09:03 +0000)] 
mkwasmbuilds.c doc updates. Merge in the parts of [8611cf643b] which are not contentious.

FossilOrigin-Name: cb0f0e22241aae65938b4bc7a1b809088466a17cee80344f66ee889a76c422c1

13 days agoTeach c-pp to export its argv as a #define list so that we can embed it in the genera...
stephan [Thu, 13 Nov 2025 08:26:11 +0000 (08:26 +0000)] 
Teach c-pp to export its argv as a #define list so that we can embed it in the generates files.

FossilOrigin-Name: 42f95ea71e5e7e927685de3a6da2ede38abe7cabdd1fc71b9a14bebe9f54a65e

13 days agoDoc typo fix reported in [forum:00e49e9aa1|forum post 00e49e9aa1].
stephan [Thu, 13 Nov 2025 07:07:28 +0000 (07:07 +0000)] 
Doc typo fix reported in [forum:00e49e9aa1|forum post 00e49e9aa1].

FossilOrigin-Name: 36cd33f634a45900f6e52ba07aa20242a5f2b29c7cbe19be968c52ffef34fcde

13 days agoMinor doc correction and a JS error message tweak.
stephan [Thu, 13 Nov 2025 06:49:12 +0000 (06:49 +0000)] 
Minor doc correction and a JS error message tweak.

FossilOrigin-Name: c4ae21c89e5fd40eefd4916df6c6a6c4e27075a434a9d47576d3fcfbc7720588

13 days agoClarify that 'pikchr' is not a typo.
stephan [Wed, 12 Nov 2025 17:25:17 +0000 (17:25 +0000)] 
Clarify that 'pikchr' is not a typo.

FossilOrigin-Name: d7bb2ee6ec23c266c887fb2aeb77b0b17cd8f1429564d341537f57c5478410e2

2 weeks agoImproved concurrency for "make devtest" by splitting fuzzdata1.db and
drh [Mon, 10 Nov 2025 20:01:39 +0000 (20:01 +0000)] 
Improved concurrency for "make devtest" by splitting fuzzdata1.db and
fuzzdata2.db into slices for asan and ubsan testing.

FossilOrigin-Name: 2c31176607f02a73cf2626cda2dd0711ae74bdf0b4520d4c84ff299c860e419e

2 weeks agoAvoid dropping RETURNING triggers when the schema is reset while preparing a statement.
dan [Mon, 10 Nov 2025 19:11:15 +0000 (19:11 +0000)] 
Avoid dropping RETURNING triggers when the schema is reset while preparing a statement.

FossilOrigin-Name: 45d820ca227eb1ade4dda498b0f94b2c5df4bab3fc5fcdd517ee125a43d16f4d

2 weeks agoAvoid dropping RETURNING triggers when the schema is reset while preparing a statement. returning-fix
dan [Mon, 10 Nov 2025 17:37:59 +0000 (17:37 +0000)] 
Avoid dropping RETURNING triggers when the schema is reset while preparing a statement.

FossilOrigin-Name: e26bcef7522a6f6ee8d55fa30e7fe06419566cf4e8c2df0c33c92a4c89f58c05

2 weeks agoFix a missing va_end() call in the intckMprintf() function of the
drh [Mon, 10 Nov 2025 11:05:36 +0000 (11:05 +0000)] 
Fix a missing va_end() call in the intckMprintf() function of the
incremental integrity-check extension.

FossilOrigin-Name: 62ad2350e368dc337ba2d0fb6847d07c40a6f79520dd6414d22b5b54983b0b12

2 weeks agoA more compact fix for the problem first fixed by [5f5a736f88].
dan [Mon, 10 Nov 2025 11:00:41 +0000 (11:00 +0000)] 
A more compact fix for the problem first fixed by [5f5a736f88].

FossilOrigin-Name: 7a644178c8d289ca18631844b2d73b32fddc72afcc80906633dd38c14eba2ca9

2 weeks agoHave sqlite3_set_errmsg() return SQLITE_MISUSE if a NULL db handle is passed to it...
dan [Mon, 10 Nov 2025 10:47:29 +0000 (10:47 +0000)] 
Have sqlite3_set_errmsg() return SQLITE_MISUSE if a NULL db handle is passed to it, as documented.

FossilOrigin-Name: 5f5a736f88bc9bc6c9c83d2cbfd74c0b5357d7417d9993d34a78f0b7317ff796

2 weeks agoReworking of JS internals to support binding of nested C structs (like sqlite3_index_...
stephan [Mon, 10 Nov 2025 07:41:54 +0000 (07:41 +0000)] 
Reworking of JS internals to support binding of nested C structs (like sqlite3_index_constraint and friends) and allow some of the automated JS/C conversions to be plugged in at the struct-binding level, simplifying how struct members, in particular function pointers, can be used from JS.

FossilOrigin-Name: bb4fd5b789cebf2b224c29023fea3e620a86fb36730c36c0d85d9f35880bf643

2 weeks agoFix the ".www" command of the CLI so that it works on unix systems with
drh [Mon, 10 Nov 2025 01:46:06 +0000 (01:46 +0000)] 
Fix the ".www" command of the CLI so that it works on unix systems with
newer web browsers that do not allow access to files in /tmp.

FossilOrigin-Name: 2f918c14bac28c567cc854b3d41dcdd59191a118bb5fdea9373945fe860161f5

2 weeks agoMinor doc typo fix reported in [forum:939d5864df|forum post 939d5864df].
stephan [Sun, 9 Nov 2025 07:11:15 +0000 (07:11 +0000)] 
Minor doc typo fix reported in [forum:939d5864df|forum post 939d5864df].

FossilOrigin-Name: a1f9c977b83fab11c54710070dbedfaea47195050946db74075bdd3ade97a4c8

2 weeks agoCLI shell: ensure that .dump propagates its error code on error. Problem reported...
stephan [Sun, 9 Nov 2025 06:51:32 +0000 (06:51 +0000)] 
CLI shell: ensure that .dump propagates its error code on error. Problem reported in [forum:a4f3873b0a8503cc|forum post a4f3873b0a].

FossilOrigin-Name: 850b92b6347187d702736bf5a574b9b4a49854a33799875f24fc75c50a6bf908

2 weeks agoIn sqlite3.wasm.allocFromTypedArray(), swap the order of the allocation and the acces...
stephan [Sun, 9 Nov 2025 06:32:10 +0000 (06:32 +0000)] 
In sqlite3.wasm.allocFromTypedArray(), swap the order of the allocation and the access to the heap view object to work around an obscure issue when allocating huge blobs. The heap view object could previously become stale via the following allocation if the underlying WebAssembly.Memory object needed to grow. Essentially a realloc()-moves-the-pointer situation but it only comes up with huge allocations under the right circumstances and would trigger a JS exception (as opposed to corrupting the WASM heap). Problem reported in [forum:05b77273be104532|forum post 05b77273be104532].

FossilOrigin-Name: 0f712b6b0516dc151d3bcbb63497661c82e11eae368e639bbdf197e1b3467195

2 weeks agoAdd some UNUSED_PARAMATER()s for the sake of -pedantic -DSQLITE_OMIT_WAL.
stephan [Fri, 7 Nov 2025 11:46:56 +0000 (11:46 +0000)] 
Add some UNUSED_PARAMATER()s for the sake of -pedantic -DSQLITE_OMIT_WAL.

FossilOrigin-Name: 620434a4a276ecaf2ee56d325815ac4e33c95e1190b420a341e376e54ef60278

2 weeks agoFix a harmless static-analyzer warning.
drh [Fri, 7 Nov 2025 11:22:47 +0000 (11:22 +0000)] 
Fix a harmless static-analyzer warning.

FossilOrigin-Name: 9819fc5aa7706fda9d4ec67835ae87eed64d321672873c9d864788b8cf5d27d8

2 weeks agoGet the sqlite3Hwtime() function working on ARM. Enable scanstatus by
drh [Thu, 6 Nov 2025 13:19:50 +0000 (13:19 +0000)] 
Get the sqlite3Hwtime() function working on ARM.  Enable scanstatus by
default on Windows CLI builds.

FossilOrigin-Name: 305bb022368bac9fafd7c2794762299324796903aaea270923d07f2127d8926c

2 weeks agoImprovements to documentation for stmt_scanstatus interfaces.
drh [Thu, 6 Nov 2025 12:25:26 +0000 (12:25 +0000)] 
Improvements to documentation for stmt_scanstatus interfaces.

FossilOrigin-Name: 5f3e883d180d6fb7a1909df284713170f5431ea7afcc1a3eb5912c4620df42b2

3 weeks agoJNI: doc tweaks. Add missing SQLITE_DBSTATUS_TEMPBUF_SPILL export.
stephan [Wed, 5 Nov 2025 10:07:57 +0000 (10:07 +0000)] 
JNI: doc tweaks. Add missing SQLITE_DBSTATUS_TEMPBUF_SPILL export.

FossilOrigin-Name: 2c8938f43f721a2592b0efe36f75ab87aa370654e1a22d646c0a17d58d643295

3 weeks agoTEA extension: add --tcl-stubs config flag, defaulting to zero, because there does...
stephan [Wed, 5 Nov 2025 05:59:53 +0000 (05:59 +0000)] 
TEA extension: add --tcl-stubs config flag, defaulting to zero, because there does not seem to be a universally-valid default for that. Addresses [forum:cd6503fce2|forum post cd6503fce2].

FossilOrigin-Name: 4954b94763052ed60ad2ae610e4f5c18fdba4475a39eb369408e984c89805e97

3 weeks agoRemove stale code from the fileio.c extension.
drh [Tue, 4 Nov 2025 23:47:49 +0000 (23:47 +0000)] 
Remove stale code from the fileio.c extension.

FossilOrigin-Name: d26f115760f16cac1cd28c950d1c0eec199461d2c9a52baafb91ff6b8d5ec151

3 weeks agoMinor wasm build simplifications and extend the JS bindings of sqlite3_column/value_t...
stephan [Tue, 4 Nov 2025 22:01:55 +0000 (22:01 +0000)] 
Minor wasm build simplifications and extend the JS bindings of sqlite3_column/value_text() such that they include embeded NUL bytes in their result strings rather than truncate them at NUL. Consolidate the shell.c build flags from the canonical and autoconf makefiles into the configure script.

FossilOrigin-Name: cee2e2576f5e91911a019bff025ee6071850c0d75941e8746f10d57b56bd830a

3 weeks agoVersion 3.51.0 major-release release version-3.51.0
drh [Tue, 4 Nov 2025 19:38:17 +0000 (19:38 +0000)] 
Version 3.51.0

FossilOrigin-Name: fb2c931ae597f8d00a37574ff67aeed3eced4e5547f9120744ae4bfa8e74527b

3 weeks agoConsolidate the three VFS-specific SEE tests into a shared routine. wasm-post-3.51
stephan [Tue, 4 Nov 2025 01:03:58 +0000 (01:03 +0000)] 
Consolidate the three VFS-specific SEE tests into a shared routine.

FossilOrigin-Name: 8ac0bf125ddb6cc86a6825dcfe8895559835eca85ef14b5ad489f7c8159462e4

3 weeks agoMove the hard-coded SHELL_OPT makefile values from the two main makefiles into their...
stephan [Tue, 4 Nov 2025 00:15:51 +0000 (00:15 +0000)] 
Move the hard-coded SHELL_OPT makefile values from the two main makefiles into their shared configure script.

FossilOrigin-Name: 900885c4fb3071e461bf868e9e68d0d8f3d3e83a1bcbf5c9c68179c701c1fb92

3 weeks agoMerge trunk into wasm-post-3.51 to for some minor config script work.
stephan [Tue, 4 Nov 2025 00:10:10 +0000 (00:10 +0000)] 
Merge trunk into wasm-post-3.51 to for some minor config script work.

FossilOrigin-Name: bf55a4220a74022e8be5f8a0cd7f4ca395a36e1666e14113e7e60c4a94cf0b3a

3 weeks agoAdd tests demonstrating [d0e803b90344].
stephan [Mon, 3 Nov 2025 21:38:34 +0000 (21:38 +0000)] 
Add tests demonstrating [d0e803b90344].

FossilOrigin-Name: 7d22ee947ddecb0dc6c640e79c9a09c0931f8b04f97d3ac89afdbf1736312bf7

3 weeks agoAdd new file missing from [936990cf067a5ebb] (and subsequently deleted by fossil...
stephan [Mon, 3 Nov 2025 21:26:27 +0000 (21:26 +0000)] 
Add new file missing from [936990cf067a5ebb] (and subsequently deleted by fossil clean -x). Have speedtest1 wasm use the user-provided sqlite3.c, rather than forcing the canonical one, so that the wasm exports don't have to be re-generated for that special case. Remove a harmless duplicate -D... flag.

FossilOrigin-Name: 7a592f5cd09699b45051855f6d477def40220b17642cbdb0f35ed74dd32becf1

3 weeks agoUse the same compile-time options for the CLI in the auto-setup tarball
drh [Mon, 3 Nov 2025 15:34:25 +0000 (15:34 +0000)] 
Use the same compile-time options for the CLI in the auto-setup tarball
as are used in the canonical source tree.
[forum:/forumpost/8975130218|Forum post 8975130218].

FossilOrigin-Name: ccabbe06d4e0650eecc91296d6a3040ed7fef06b47e4d63393a2367c8c8f55cf

3 weeks agoAdd new column "cwd" to the jobs table in testrunner.db. For recording the directory...
dan [Mon, 3 Nov 2025 15:29:51 +0000 (15:29 +0000)] 
Add new column "cwd" to the jobs table in testrunner.db. For recording the directory in which the test ran or is running.

FossilOrigin-Name: 334305a469a51ef0d768ba8443d8cab217f45394cc9f720748a489b10703193d

3 weeks agoAdjust the dbstatus2.test module so that it works on 32-bit builds in
drh [Mon, 3 Nov 2025 12:36:52 +0000 (12:36 +0000)] 
Adjust the dbstatus2.test module so that it works on 32-bit builds in
addition to 64-bit builds.

FossilOrigin-Name: dcaaa71e750d56afde3e905aaf10729ec95e0ede00522e1b12af6b6345e744ac

3 weeks agoUpdate test result output from test/dbstatus2.test module so that it
drh [Mon, 3 Nov 2025 11:35:13 +0000 (11:35 +0000)] 
Update test result output from test/dbstatus2.test module so that it
reports the actual value of nTmpSpill when that value is out of range.

FossilOrigin-Name: 382c8440d7a16eae49fa1644513ae045bfceb072d9b4005963f57f1a57fe94b2

3 weeks agoFix the test/speedtest.tcl script so that the CC= command-line option works.
drh [Mon, 3 Nov 2025 10:40:06 +0000 (10:40 +0000)] 
Fix the test/speedtest.tcl script so that the CC= command-line option works.

FossilOrigin-Name: 0de0ba878b9ec572d76d47112a0124df9f234fbb7a69c5f5a76ce8c439b11f6f

3 weeks agoFix a harmless memory leak in the CLI caused by the --cmd option generating
drh [Mon, 3 Nov 2025 10:14:20 +0000 (10:14 +0000)] 
Fix a harmless memory leak in the CLI caused by the --cmd option generating
an error message.

FossilOrigin-Name: ab916bad188b150321e420ec0009d909c287e3790b5d6ec683e2df9ed457ff15

3 weeks agoAdd pedantic OOM detection logic to some disused diagnostic and test code.
drh [Sun, 2 Nov 2025 22:57:26 +0000 (22:57 +0000)] 
Add pedantic OOM detection logic to some disused diagnostic and test code.
No changes to any deliverables.

FossilOrigin-Name: abb6945fc62a1855786bda1f473edef0e937a791c453387a0859a6ce0451635a

3 weeks agoUpdate the test/walthread.test testing script so that it uses a random
drh [Sat, 1 Nov 2025 20:14:43 +0000 (20:14 +0000)] 
Update the test/walthread.test testing script so that it uses a random
database name.

FossilOrigin-Name: ce25a758d4cea1741cb3db6384720f17faef61b352d494ab410a83a41f1721d3

3 weeks agoFix ext/wasm/mkdist.sh to use ./version-info instead of ../../version-info (a recent...
stephan [Sat, 1 Nov 2025 14:49:05 +0000 (14:49 +0000)] 
Fix ext/wasm/mkdist.sh to use ./version-info instead of ../../version-info (a recent build change made to ensure that builds with a custom sqlite3.c embed that version info).

FossilOrigin-Name: d25a92d88923f880d6477a99f2a35528faea83e7db245f2b07db80613b4aeb8e

3 weeks agoUpdates to the compile-for-windows.md document. No changes to code.
drh [Fri, 31 Oct 2025 17:45:59 +0000 (17:45 +0000)] 
Updates to the compile-for-windows.md document.  No changes to code.

FossilOrigin-Name: 652310a9f0ef2a870b5033029278b1fbef28c2ec15405d1b32bf1d51df28266c

3 weeks agoDetect some cases of ambiguous column references in USING clauses that can come up...
dan [Fri, 31 Oct 2025 16:07:31 +0000 (16:07 +0000)] 
Detect some cases of ambiguous column references in USING clauses that can come up with nested joins.

FossilOrigin-Name: 38c993c8b7137d6d5623d387292639634297c17da11befec9029f12a16a472f8

3 weeks agoChange the name of a file-scope constant array in carray.c so that it does
drh [Fri, 31 Oct 2025 15:18:29 +0000 (15:18 +0000)] 
Change the name of a file-scope constant array in carray.c so that it does
not conflict with other variables names in other files when carray.c is
amalgamated.  This is down to resolve a harmless compiler warning.

FossilOrigin-Name: 5afd815ada94d55c9c56efe339235d23ffbf1fb64511a5e460927a2c8deaaaf0

3 weeks agoUpdate the main README.md file to use the robot-safe /rchvdwnld page on the
drh [Fri, 31 Oct 2025 13:44:51 +0000 (13:44 +0000)] 
Update the main README.md file to use the robot-safe /rchvdwnld page on the
server for downloads.

FossilOrigin-Name: c1aa52361b8ede611f64b96f2394174389ce531b1d86b9cfec91d3b03c94f6ea

3 weeks agoFix the output of ".dump" in the CLI so that the sqlite_sequence table
drh [Fri, 31 Oct 2025 11:23:44 +0000 (11:23 +0000)] 
Fix the output of ".dump" in the CLI so that the sqlite_sequence table
is created using correct syntax.

FossilOrigin-Name: 4b9f2e1d4485ad3baf9285aa09b468469be929b18cb308f19af471d7aac66076

3 weeks agoNew assert() statements to help out static analyzers.
drh [Thu, 30 Oct 2025 22:10:41 +0000 (22:10 +0000)] 
New assert() statements to help out static analyzers.

FossilOrigin-Name: ba0c4bf072ed721a507855d68bde7f1c388396a19b69814b6e257b934f8b0fd9

3 weeks agoAdd SQLITE_OMIT_WAL checks around some functions to avoid defining unused statics...
stephan [Thu, 30 Oct 2025 21:11:01 +0000 (21:11 +0000)] 
Add SQLITE_OMIT_WAL checks around some functions to avoid defining unused statics in such builds. Fixes OMIT_WAL builds on msys2 and passes tool/omittest-msvc.tcl.

FossilOrigin-Name: f9b89535dc279acf617f274b6edbad0610fc8e5c76d402fc8b5b9dc656e95caa

3 weeks agoSimplify the EXPORTED_FUNCTIONS lists to use the preprocessor instead of per-list...
stephan [Thu, 30 Oct 2025 20:18:20 +0000 (20:18 +0000)] 
Simplify the EXPORTED_FUNCTIONS lists to use the preprocessor instead of per-list shell commands. (Unrelated) Remove part of the post-compilation JS filtering which breaks with emsdk 4.0.16+, which means the .js files are about 57kb bigger than they really ought to be.

FossilOrigin-Name: 936990cf067a5ebb34f7f662fc2d23d468c50f179afafe47fe0d2ed775f5ef74

3 weeks agoMerge trunk into the wasm-post-3.51 branch.
stephan [Thu, 30 Oct 2025 19:32:46 +0000 (19:32 +0000)] 
Merge trunk into the wasm-post-3.51 branch.

FossilOrigin-Name: dda1735716cf1006b2a5d1d8eb29df3039047be38dcc04249c4ce50c77084fac

3 weeks agoFurther improvements the ".dump" command to handle corner cases.
drh [Thu, 30 Oct 2025 18:52:48 +0000 (18:52 +0000)] 
Further improvements the ".dump" command to handle corner cases.

FossilOrigin-Name: cd0c77934ff32050380c2143bba7d4e6c07d5f08187cb5d5e8e7602854d1cda8

3 weeks agoAnother (void), as per [dd6edfc09434].
stephan [Thu, 30 Oct 2025 18:48:19 +0000 (18:48 +0000)] 
Another (void), as per [dd6edfc09434].

FossilOrigin-Name: 7a822cfd388d7ac5765cffd5bd3d6e5b31abc6a360f9d5e27c0223f83a84237e

3 weeks agoAdd (void) to two places for the sake of SQLITE_OMIT_WAL builds. Why these do not...
stephan [Thu, 30 Oct 2025 18:46:03 +0000 (18:46 +0000)] 
Add (void) to two places for the sake of SQLITE_OMIT_WAL builds. Why these do not complain on tests in this tree, but do on a downstream tree (same machine, same compiler), is a mystery.

FossilOrigin-Name: dd6edfc09434b0d170d5ab462053497043016a4ec6b91a46db565ccf646aee20

3 weeks agowasm: re-add SQLITE_OMIT_WAL to the c-pp-lite build flags.
stephan [Thu, 30 Oct 2025 18:39:28 +0000 (18:39 +0000)] 
wasm: re-add SQLITE_OMIT_WAL to the c-pp-lite build flags.

FossilOrigin-Name: 617f8ac40e073c3fdc1144639b78617ad61113f4e873fc20c99399d2b60e1ceb

3 weeks agoMacro tweaks to get SQLITE_OMIT_WAL building. Remove some nearby stray EOL whitespace.
stephan [Thu, 30 Oct 2025 18:38:14 +0000 (18:38 +0000)] 
Macro tweaks to get SQLITE_OMIT_WAL building. Remove some nearby stray EOL whitespace.

FossilOrigin-Name: c31a944680f18a799c763238dbb0561f8b039905ce442533258905219b33b743

3 weeks agoFix a typo and improve wording in README.md
drh [Thu, 30 Oct 2025 18:33:58 +0000 (18:33 +0000)] 
Fix a typo and improve wording in README.md

FossilOrigin-Name: 34a662ce24930a5e1a142f0b3ce427c4b1b61a306537820dc5e72996f8080d86

3 weeks agoUpdates to the tool/warnings.sh script for better compiler warnings.
drh [Thu, 30 Oct 2025 18:32:32 +0000 (18:32 +0000)] 
Updates to the tool/warnings.sh script for better compiler warnings.

FossilOrigin-Name: c9c64892c76cb9f2efb58428b349d43b075e7595b6a391d4818a7e9fb68b85fd

3 weeks agoFix a harmless compiler warning associated with flexarrays.
drh [Thu, 30 Oct 2025 17:23:17 +0000 (17:23 +0000)] 
Fix a harmless compiler warning associated with flexarrays.

FossilOrigin-Name: f02cdf1d3ea8da8a09d115721845afeff5d6169dd7532ab486d3ed6db69cde2d

3 weeks agoUpdates to the main README.md file.
drh [Thu, 30 Oct 2025 15:43:57 +0000 (15:43 +0000)] 
Updates to the main README.md file.

FossilOrigin-Name: ab10c4cd9f9314bc62aa310ee796f63c82710c35659debe347e8ebcbf34d9e86

3 weeks agoFix the CLI ".dump" command so that it does not make duplicate
drh [Thu, 30 Oct 2025 11:39:49 +0000 (11:39 +0000)] 
Fix the CLI ".dump" command so that it does not make duplicate
sqlite_sequence table entries as described in
[forum:/forumpost/b1674b56ad|forum thread b1674b56ad].

FossilOrigin-Name: c833f26a6780f919551e50c67d308e96293cec8481899354411d805617481f24

3 weeks agoPrevent a harmless signed integer overflow in the CLI if the argument
drh [Thu, 30 Oct 2025 10:36:10 +0000 (10:36 +0000)] 
Prevent a harmless signed integer overflow in the CLI if the argument
to the --skip option of the ".inport" command is -9223372036854775808.

FossilOrigin-Name: 247277d9373cb2614a1bc4c1e08b904315e5e8c0c2a7fbe9c2ac651481601642

3 weeks agoA experiment addressing the embedded-NUL behavior of sqlite3_colum/value_text() in...
stephan [Thu, 30 Oct 2025 02:21:38 +0000 (02:21 +0000)] 
A experiment addressing the embedded-NUL behavior of sqlite3_colum/value_text() in the JS bindings, as discussed in [forum:d77281aec2df9ada|forum post d77281aec2]. This is an experiment only. It works, in that existing tests do not see the difference, but it has implicications which require careful consideration before deploying.

FossilOrigin-Name: d0e803b90344ee972e4b3fb30b77e283599dc4d5c6a3335ce9fea653a1b3f6f0

3 weeks agoRemove an OMIT_WAL from the wasm build because it breaks with the current amalgamatio...
stephan [Thu, 30 Oct 2025 01:43:30 +0000 (01:43 +0000)] 
Remove an OMIT_WAL from the wasm build because it breaks with the current amalgamation (and isn't strictly needed here anyway).

FossilOrigin-Name: a7be7d155aa6f02075f939ab6d26cfdfe2d0832b59da39c8bf4a74fc4845bd05

3 weeks agoFix a logic error introduced by [cea8bf79e18d55a8] which caused
drh [Wed, 29 Oct 2025 20:47:01 +0000 (20:47 +0000)] 
Fix a logic error introduced by [cea8bf79e18d55a8] which caused
"0 OR 2" to be evaluated as "2" instead of as "1".  Problem reported at
[forum:/forumpost/d5f32040c5d50d2d|forum post d5f32040c].

FossilOrigin-Name: 095cc4f22e63c98cbb2acabdbcaf02e59e67ec6d3cc219b5f42a714e3d53a264

4 weeks agoTiny cosmetic tweak to configure script output. No functional changes.
stephan [Tue, 28 Oct 2025 22:09:43 +0000 (22:09 +0000)] 
Tiny cosmetic tweak to configure script output. No functional changes.

FossilOrigin-Name: e2c20aa5929e5b79aabca8a51fb3e32e0533526d64d7576d3caf1c847fff58b4

4 weeks agoTypo fixes in LICENSE.md from BrickViking.
stephan [Tue, 28 Oct 2025 19:57:15 +0000 (19:57 +0000)] 
Typo fixes in LICENSE.md from BrickViking.

FossilOrigin-Name: 26ddec291696dd99c7f84a21b2dd272ce9bf32598ca38413ac89432d45527f8d

4 weeks agoFix an signed integer overflow problem that can occur when using an oversize
drh [Tue, 28 Oct 2025 13:24:50 +0000 (13:24 +0000)] 
Fix an signed integer overflow problem that can occur when using an oversize
value for the SQLITE_MAX_LENGTH compile-time option together with
multi-gigabyte operands to the OP_Concat operator.

FossilOrigin-Name: 724f2299f206cc9e7f830f984c50a8fc4ac1c17210d71d9affe657b45252b060

4 weeks agoAdd enhanced resistance to corruption after posix advisory locks on the
drh [Tue, 28 Oct 2025 10:50:55 +0000 (10:50 +0000)] 
Add enhanced resistance to corruption after posix advisory locks on the
database file been unintentionally broken on unix by running
close(open(DBFILE)) from a separate thread.

FossilOrigin-Name: 6385a1962c69c69ca4775888f034a4eb892aa013689c000f3de6422da7c3c695

4 weeks agoEnhance the CLI so that it can handle inputs larger than 2 billion lines.
drh [Tue, 28 Oct 2025 10:44:26 +0000 (10:44 +0000)] 
Enhance the CLI so that it can handle inputs larger than 2 billion lines.

FossilOrigin-Name: 5daebf2d6013e73d89c9feb796e15b67c39577e5a9e9c86fa260995f4118f04b

4 weeks agoAdditional comments explaining what unixIsSharingShmNode() does. No broken-lock-defense-1
drh [Tue, 28 Oct 2025 01:28:20 +0000 (01:28 +0000)] 
Additional comments explaining what unixIsSharingShmNode() does.  No
changes to code.

FossilOrigin-Name: 819fc87385fd5be8a847492478f4c4f247f64edf7c7161b641bfbac6b658bec5

4 weeks agoOmit unnecessary branches from the unixIsSharingShmNode() implementation.
drh [Mon, 27 Oct 2025 23:57:57 +0000 (23:57 +0000)] 
Omit unnecessary branches from the unixIsSharingShmNode() implementation.

FossilOrigin-Name: 2d5623bc27073c407ec63e401f095d12f0025dd276a0bdc26d8b94b1f13c9a36

4 weeks agoThe unixIsSharingShmNode() function should always return false for the
drh [Mon, 27 Oct 2025 15:44:16 +0000 (15:44 +0000)] 
The unixIsSharingShmNode() function should always return false for the
unix-excl VFS.

FossilOrigin-Name: 770f35dae47a98554b18f8a7aa9f6b6e39ae2b3aa8dce8d75b5bed0c6f0f9c21