]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
6 hours agoAdd some UNUSED_PARAMATER()s for the sake of -pedantic -DSQLITE_OMIT_WAL. master
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

6 hours 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

29 hours 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

29 hours 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

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

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

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

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

2 days 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 days 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 days 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 days 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 days agoAdd tests demonstrating [d0e803b90344].
stephan [Mon, 3 Nov 2025 21:38:34 +0000 (21:38 +0000)] 
Add tests demonstrating [d0e803b90344].

FossilOrigin-Name: 7d22ee947ddecb0dc6c640e79c9a09c0931f8b04f97d3ac89afdbf1736312bf7

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

11 days agoImplement an experimental defensive measure to try to prevent the -wal and
drh [Mon, 27 Oct 2025 14:24:02 +0000 (14:24 +0000)] 
Implement an experimental defensive measure to try to prevent the -wal and
-shm files of an active WAL-mode database connection from being deleted out
from under the database connection in the case where the database SHARED
lock has been released by an accidental call to close() in a different
thread, or similar.

FossilOrigin-Name: ed1b9206640f66cb8abff444809ccab8a4a5157b5c90e9aacddc422210e63423

11 days agoFix a minor over-allocation of heap memory in wal.c.
dan [Mon, 27 Oct 2025 11:39:07 +0000 (11:39 +0000)] 
Fix a minor over-allocation of heap memory in wal.c.

FossilOrigin-Name: 1803cb9bb6a13fb66956f729066b6eae64c3a1c0715102fb1a9994e395c12ba9

11 days agoFix sanitizer complaints in the regexp extension.
dan [Mon, 27 Oct 2025 11:20:47 +0000 (11:20 +0000)] 
Fix sanitizer complaints in the regexp extension.

FossilOrigin-Name: 6ff9ecb89d769bc2a27f8a57130f28ec7478979d3e35ba765c16017b5bdf775d

11 days agoMerge the OPFS/SEE tests into trunk (where they should have been committed).
stephan [Sun, 26 Oct 2025 21:58:41 +0000 (21:58 +0000)] 
Merge the OPFS/SEE tests into trunk (where they should have been committed).

FossilOrigin-Name: f8a4d7abf0d1c9c92fa102165d08aed76fd766d49615e3d347b5547580355574

11 days agoDemonstrate the opfs-sahpool VFS with SEE.
stephan [Sun, 26 Oct 2025 21:45:02 +0000 (21:45 +0000)] 
Demonstrate the opfs-sahpool VFS with SEE.

FossilOrigin-Name: b4cffc00f3a18906867e8f070fbc49293ac5c038bad58e96ea74948591f31013

11 days agoAdd a test which uses SEE via the "opfs" VFS. "opfs-sahpool" is pending.
stephan [Sun, 26 Oct 2025 21:30:29 +0000 (21:30 +0000)] 
Add a test which uses SEE via the "opfs" VFS. "opfs-sahpool" is pending.

FossilOrigin-Name: 1eb5a7ea394aa5b7e8594d73ce31f4b9bef55f2fa977dc26810c0bfba1cc39f7

11 days agoMerge trunk into the wasm-post-3.51 branch.
stephan [Sun, 26 Oct 2025 18:43:04 +0000 (18:43 +0000)] 
Merge trunk into the wasm-post-3.51 branch.

FossilOrigin-Name: be5d2bae508a681628d4f84528e37db4e8a39b16e580b0d6ab4cd844566e973f

11 days agoA better/cleaner fix for [1c80ff88c0ce].
stephan [Sun, 26 Oct 2025 18:36:57 +0000 (18:36 +0000)] 
A better/cleaner fix for [1c80ff88c0ce].

FossilOrigin-Name: 6138043bdde09224a764b5d5f18a9e2776c761c424f41b0d69427d92d47ec41c

12 days agoc-pp-lite: Fix another newline-related off-by-one which could cause newlines to get...
stephan [Sun, 26 Oct 2025 17:59:30 +0000 (17:59 +0000)] 
c-pp-lite: Fix another newline-related off-by-one which could cause newlines to get lost in @token@ filtering. Problem found in out-of-tree testing.

FossilOrigin-Name: 1c80ff88c0ce3d1c168c9bda734cf52114c35efdcf46a6da78f0ed9adc794eb8

12 days agoDoc typo fix reported in the forum. No code changes.
stephan [Sun, 26 Oct 2025 12:34:13 +0000 (12:34 +0000)] 
Doc typo fix reported in the forum. No code changes.

FossilOrigin-Name: 6e065b6aa099f31493cfea22a729f92bb312147d8584f663fb75630a25772e43

12 days agoAdd the SQLITE_FCNTL_FILESTAT file control and the sqlite_filestat() SQL
drh [Sat, 25 Oct 2025 22:22:58 +0000 (22:22 +0000)] 
Add the SQLITE_FCNTL_FILESTAT file control and the sqlite_filestat() SQL
function.

FossilOrigin-Name: 9870afcb2a360dff83e211009710bc85db238d9a6993afcc1eb38ca7699fb4a5

12 days agoRename the file control to SQLITE_FCNTL_FILESTAT. Rename the SQL function file-info
drh [Sat, 25 Oct 2025 20:46:09 +0000 (20:46 +0000)] 
Rename the file control to SQLITE_FCNTL_FILESTAT.  Rename the SQL function
to sqlite_filestat().  Rename the enable macro to SQLITE_ENABLE_FILESTAT.

FossilOrigin-Name: ee797fec4eeace78caa2c5e463108bf1a6568db7c33d94d9fe6624cfc6b0d4fe

12 days agoFix a bug in sqlite_file_info() output: It was showing the "pal" for
drh [Sat, 25 Oct 2025 19:51:16 +0000 (19:51 +0000)] 
Fix a bug in sqlite_file_info() output:  It was showing the "pal" for
the main file descriptor when traversing other unused file descriptors
for the same inode.

FossilOrigin-Name: 3c4020d76e29c39483f6b92857ea470245afcd514870c63bd3373e0e213cd355

12 days agoNew --normal option for the ".open" command in the CLI. Also, when opening
drh [Sat, 25 Oct 2025 19:36:12 +0000 (19:36 +0000)] 
New --normal option for the ".open" command in the CLI.  Also, when opening
the database for deduceDatabaseType(), use the same open-flags that will
be used subsequently for the official open, to avoid creating unusable
file descriptors that need to be held until all database instances close.

FossilOrigin-Name: 5e20a0435b1bd84d90c9a419219afe794fdf8ea73213f4c7ae5612c0375bed55

12 days agoAdd additional information about unix file descriptors to the same database file
drh [Sat, 25 Oct 2025 19:26:16 +0000 (19:26 +0000)] 
Add additional information about unix file descriptors to the same database file
in the sqlite_file_info() output.

FossilOrigin-Name: 64045f0a4d71ef068d64f2f25799cf1ae79c3cdb94039c73f1066290e3dbc943

12 days agoAdjust unixPosixAdvisorLocks() to use redirectable system calls so that
drh [Sat, 25 Oct 2025 18:40:18 +0000 (18:40 +0000)] 
Adjust unixPosixAdvisorLocks() to use redirectable system calls so that
it can be tested.

FossilOrigin-Name: eafe88b782875cd839fc27da509830e3e1d95781c686e27242a2844910203a42

12 days agoMerge the CLI deduceDatabaseType fix from trunk.
drh [Sat, 25 Oct 2025 18:36:14 +0000 (18:36 +0000)] 
Merge the CLI deduceDatabaseType fix from trunk.

FossilOrigin-Name: 82f907016ee75ca288d8ac0664d5c147fbfad42c5f8222211acc3220bd0eb609

12 days agoFix the CLI so that it does not try to open what might be an SQLite
drh [Sat, 25 Oct 2025 18:35:29 +0000 (18:35 +0000)] 
Fix the CLI so that it does not try to open what might be an SQLite
database using open() in the deduceDatabaseType() routine, as this can
lead to broken posix advisory locks.

FossilOrigin-Name: 2a3a02715fa53673531575fa13aee056711139b409367cccc18654e82720c4e6

13 days agoAdditional information about the unixShm shown.
drh [Sat, 25 Oct 2025 14:06:36 +0000 (14:06 +0000)] 
Additional information about the unixShm shown.

FossilOrigin-Name: 85846c7fbeeaf5fccfcbe11a4b87c4ee49781456ccb4da1d090b7823d7b456d6

13 days agoDo not attempt to show posix-advisory-locking status on journal files.
drh [Sat, 25 Oct 2025 13:55:49 +0000 (13:55 +0000)] 
Do not attempt to show posix-advisory-locking status on journal files.

FossilOrigin-Name: 7f8baf64bb722d7dfdfca22d4f11a72113d5ed2b36d6cc6020fb0acf8185b3e7

13 days agoThe sqlite_file_info() function should always return JSON, unless there
drh [Sat, 25 Oct 2025 13:16:41 +0000 (13:16 +0000)] 
The sqlite_file_info() function should always return JSON, unless there
is an OOM.

FossilOrigin-Name: 65aed79c29bf1aac0934475c02b358b916f413b20d2475ec7b631011f21f4e2b

13 days agoNew symbolic representation of posix advisory locking information
drh [Sat, 25 Oct 2025 12:53:03 +0000 (12:53 +0000)] 
New symbolic representation of posix advisory locking information

FossilOrigin-Name: b7d991ae04da1d6731b67fbdca65df996ec1c14a9530880fb7dbeeaef2575d14

13 days agoMerge trunk enhancements into the file-info branch.
drh [Sat, 25 Oct 2025 11:47:04 +0000 (11:47 +0000)] 
Merge trunk enhancements into the file-info branch.

FossilOrigin-Name: 73e1e081e9f7fc0ece98222669d13abde16197f0befc3343246a9e7da7856f02

13 days agoStricter assert() statements on unixShmSystemLock().
drh [Sat, 25 Oct 2025 11:37:54 +0000 (11:37 +0000)] 
Stricter assert() statements on unixShmSystemLock().

FossilOrigin-Name: ed01ed337c04cce4cdbb6e80628b6f716d537e072b80067bd2bd6c5d18a1454f

13 days agoImprovements to the design of the /proc lock analysis.
drh [Fri, 24 Oct 2025 23:12:33 +0000 (23:12 +0000)] 
Improvements to the design of the /proc lock analysis.

FossilOrigin-Name: f2809dd3b266c0a6a6eb4ed62812a907493fb4006d26f8905df7ff2b1ca01a5e

13 days agoRandom tiny tweaks in internal JS and flesh out the tester1 test selection list to...
stephan [Fri, 24 Oct 2025 21:01:23 +0000 (21:01 +0000)] 
Random tiny tweaks in internal JS and flesh out the tester1 test selection list to include both 32-/64-bit entries for all tester1XYZ.html combinations. For after the 3.51 release.

FossilOrigin-Name: c087a1d23deac84ac46e769332ec167c5b38fc8e525fd90484d3fa0b6d304ffa

13 days agoMake it particularly clear in the wasm build output that unsupported builds are exact...
stephan [Fri, 24 Oct 2025 20:29:12 +0000 (20:29 +0000)] 
Make it particularly clear in the wasm build output that unsupported builds are exactly that. Cosmetic tweak only, no functional changes.

FossilOrigin-Name: 86f53a2eb37d8ec98bc9d4c6b00253cc00d798e79c7d409e65d608354a556e19

13 days agoEasier to read /proc lock interpretation.
drh [Fri, 24 Oct 2025 20:26:13 +0000 (20:26 +0000)] 
Easier to read /proc lock interpretation.

FossilOrigin-Name: d7bcc54beb6463501c0559333455bd2a378798b58cb48f35590e9026d07acd2f

13 days agoFlesh out the sqlite_file_info() function further, and in particular
drh [Fri, 24 Oct 2025 20:04:16 +0000 (20:04 +0000)] 
Flesh out the sqlite_file_info() function further, and in particular
show locks based in /proc/PID/fdinfo/FD, when that information is
available.

FossilOrigin-Name: ce75111cced8a03f05cf47ef809b9f017f2dac3c64c6008d595f28dbfec32057

2 weeks agoNew diagnostic SQL function "sqlite_file_info()" and its associated
drh [Fri, 24 Oct 2025 17:42:03 +0000 (17:42 +0000)] 
New diagnostic SQL function "sqlite_file_info()" and its associated
file-control SQLITE_FCNTL_GET_INFO.

FossilOrigin-Name: 56ab9692583d5b64e1ab727e08a01c0a65b4e318b455c94397663ef8d3d7b6b8

2 weeks agoFix a duplicate SQLITE_API on sqlite3_carray_bind(), as reported in [forum:7499e8a19e...
stephan [Fri, 24 Oct 2025 17:16:00 +0000 (17:16 +0000)] 
Fix a duplicate SQLITE_API on sqlite3_carray_bind(), as reported in [forum:7499e8a19edc8908|forum post 7499e8a19e].

FossilOrigin-Name: 62917cd4297e734477d3201481548ddb7f79ec977b9da7d9313bc7f1c0091187

2 weeks agoext/wasm: dependencies fix for parallel builds attempted immediately after a distclea...
stephan [Fri, 24 Oct 2025 16:39:58 +0000 (16:39 +0000)] 
ext/wasm: dependencies fix for parallel builds attempted immediately after a distclean. Add version-info to the distclean rules.

FossilOrigin-Name: b99233fe3d901714c4369ba25c510050fb7a8a85c1168780108595e9639a6d15

2 weeks agoext/wasm/GNUmakefile: (A) When using a custom sqlite3.c, use sqlite3.h from the same...
stephan [Fri, 24 Oct 2025 16:25:23 +0000 (16:25 +0000)] 
ext/wasm/GNUmakefile: (A) When using a custom sqlite3.c, use sqlite3.h from the same directory instead of the top of this tree. (B) Re-add preprocessor flags for SEE which were misplaced during recent build refactoring.

FossilOrigin-Name: 1b1e530a9149ce62d3d53f5c558e358d4e6d1b00e0cce8bb04cb6b13d1841538

2 weeks agoFix [4e713558f6c6ea3d] so that it supports separate builds of rtree.
drh [Fri, 24 Oct 2025 16:01:55 +0000 (16:01 +0000)] 
Fix [4e713558f6c6ea3d] so that it supports separate builds of rtree.

FossilOrigin-Name: d030e955d703772e1637ef2c07d29816fc869ead0a15a85ec8b4633e5ca08e0a

2 weeks agoDocument minor discrepancies in how sqlite3_bind_pointer() and sqlite3_carray_bind...
stephan [Fri, 24 Oct 2025 15:18:13 +0000 (15:18 +0000)] 
Document minor discrepancies in how sqlite3_bind_pointer() and sqlite3_carray_bind() react to the SQLITE_TRANSIENT and SQLITE_STATIC finalizers.

FossilOrigin-Name: b92478c389a9ff57302c021444ced09aef067ab55394dcda38cde97a3f2628d4

2 weeks agoMake explicit that sqlite3_bind_pointer() and sqlite3_carray_bind() call the provided...
stephan [Fri, 24 Oct 2025 14:30:42 +0000 (14:30 +0000)] 
Make explicit that sqlite3_bind_pointer() and sqlite3_carray_bind() call the provided destructor even if those routines fail, per [forum:6d81b10952|forum feedback].

FossilOrigin-Name: 1fcb0b60798c708fec53d9d69a65cca2e37a9af7a5fa654c7b2bba97056cd461

2 weeks agoUpdate the MSVC makefile for the amalgamation distribution.
drh [Fri, 24 Oct 2025 13:23:43 +0000 (13:23 +0000)] 
Update the MSVC makefile for the amalgamation distribution.

FossilOrigin-Name: 440ce1cff2b7519912fec87f440894592e901d730bf74cf99479e7b1d047bf02

2 weeks agoEnhance the tokenizer so that it is able to deal with individual tokens
drh [Fri, 24 Oct 2025 13:18:31 +0000 (13:18 +0000)] 
Enhance the tokenizer so that it is able to deal with individual tokens
larger than 2GiB.

FossilOrigin-Name: 4e713558f6c6ea3dfbc97d2eb0a328955ef6ad6f2ad05517efe9ed4a60181440

2 weeks agoIn the CLI, improved error messages on input errors. Limit the size of a
drh [Fri, 24 Oct 2025 12:32:32 +0000 (12:32 +0000)] 
In the CLI, improved error messages on input errors.  Limit the size of a
single SQL statement to a little more than 2GB.

FossilOrigin-Name: 0b50e7e10aae3d57f1cbd38d02be50cfbd2d5148ab4a9be712afd8678787b7bd

2 weeks agoLimit the size of --hexdb files in the CLI to 2 billion lines, to avoid
drh [Fri, 24 Oct 2025 09:24:56 +0000 (09:24 +0000)] 
Limit the size of --hexdb files in the CLI to 2 billion lines, to avoid
overflowing the line number counter.

FossilOrigin-Name: 2adfd0f47b028b8378e6cc08dc22abf1606036bbd285a7bc3a0de0eaf6feeb8f

2 weeks agoAdditional defenses against over-sized inputs in the (unused) amatch.c
drh [Thu, 23 Oct 2025 14:05:58 +0000 (14:05 +0000)] 
Additional defenses against over-sized inputs in the (unused) amatch.c
demonstration code.

FossilOrigin-Name: b9f6ae0767ce5d9cbc6fca6d63c929f919473fa669e50a0a460627e5fde2628c

2 weeks agoFix a faulty error message in the ext/misc/fileio.c extension.
drh [Thu, 23 Oct 2025 13:10:34 +0000 (13:10 +0000)] 
Fix a faulty error message in the ext/misc/fileio.c extension.

FossilOrigin-Name: 1fdef271cd15d0960a7933253a10f288e26771cdcf34b5cd22adbc49d6341bc5

2 weeks agoAdjust some of the markdown in the LICENSE.md file so that it will hopefully
drh [Wed, 22 Oct 2025 00:38:28 +0000 (00:38 +0000)] 
Adjust some of the markdown in the LICENSE.md file so that it will hopefully
work better on GitHub.

FossilOrigin-Name: 773f9d3dcf1ac7a9ce7f0911f46301f3e0e01d699f73a264cab692299a8d615e

2 weeks agoBack out [b144f875d6bddce6] and remove the former check for strchrnul() from the...
stephan [Tue, 21 Oct 2025 16:15:53 +0000 (16:15 +0000)] 
Back out [b144f875d6bddce6] and remove the former check for strchrnul() from the configure script.

FossilOrigin-Name: f4e059b2243c6db37b4dd201b03f0c1916baec5e9e1a660815fcd7eeaf530367

2 weeks agoReduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test
drh [Sun, 19 Oct 2025 17:30:07 +0000 (17:30 +0000)] 
Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test
module to avoid false-positive infinite loop reports from OSS-Fuzz based
on long and complex fuzzer-generated LIKE/GLOB patterns that are not actually
infinite loops, but which do take a long time to resolve.

FossilOrigin-Name: 53edea286b0a38f4f9c7017276f3a826037919144d517f8c89ef0f35b65af5f1

2 weeks agoUse 64-bit memory allocations everywhere in the expert extension.
drh [Sat, 18 Oct 2025 11:19:02 +0000 (11:19 +0000)] 
Use 64-bit memory allocations everywhere in the expert extension.

FossilOrigin-Name: 6caf793b8f406f5089e3811591bc69384646df16ee18d63bd63760eaaa95d122