]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
5 months agoUse sqlite3_malloc64() in all places in the compress.c extension to avoid
drh [Wed, 31 Dec 2025 10:59:40 +0000 (10:59 +0000)] 
Use sqlite3_malloc64() in all places in the compress.c extension to avoid
integer overflow.

FossilOrigin-Name: 15400ce39b83ebc384b5eb17eba87452b937c0b00117c1575a51c6e6139fe3b1

5 months agoFix a typo in check-in 0819fe670f9ceec7 that lead to incomplete protection against
drh [Wed, 31 Dec 2025 01:11:36 +0000 (01:11 +0000)] 
Fix a typo in check-in 0819fe670f9ceec7 that lead to incomplete protection against
buffer overflow in the zipfile extension.

FossilOrigin-Name: a3f135c0709b2ed2953d2e449107abc53b538b384bcd9bae5e370e3c9de8618a

5 months agoFix a memory leak in the fileio extension on windows. Other changes to
drh [Fri, 19 Dec 2025 23:47:07 +0000 (23:47 +0000)] 
Fix a memory leak in the fileio extension on windows.  Other changes to
makefiles and similar to get zipfile testing working on Windows.

FossilOrigin-Name: 121b327f1f3941a9a44ab2d98e60f6e25b928ca9b54bbaa109239ba9012b3c3c

5 months agoEnhance the unixIsSharingShmNode() code (check-in [6385a1962c69c69c]) to avoid
dan [Mon, 15 Dec 2025 14:56:57 +0000 (14:56 +0000)] 
Enhance the unixIsSharingShmNode() code (check-in [6385a1962c69c69c]) to avoid
possible deadlocks with threads in findResuableFd().

FossilOrigin-Name: f65aa46796068800905f6ff25efcb6338f864ce5bf8dcf6c7b9f5613b3973ab2

5 months agoFix an incorrect answer that might arise if a scalar query is both
drh [Tue, 9 Dec 2025 13:29:08 +0000 (13:29 +0000)] 
Fix an incorrect answer that might arise if a scalar query is both
DISTINCT and contains an OFFSET clause.

FossilOrigin-Name: 35b306565a10c16737ee433728ca188852f01c12dfae0cc9212d21db932486fb

5 months agoIncrease the patch number to 3.51.2
drh [Fri, 5 Dec 2025 01:43:23 +0000 (01:43 +0000)] 
Increase the patch number to 3.51.2

FossilOrigin-Name: 58a2a8417f2e0baade43e4da1c74893ab991cfbb34e5e5767d82f201c0b0b389

5 months agoEnsure that the EXISTS-to-JOIN break happens even if the inner loop is
drh [Fri, 5 Dec 2025 01:38:59 +0000 (01:38 +0000)] 
Ensure that the EXISTS-to-JOIN break happens even if the inner loop is
a "no-op" loop that never executes more than once because it is controlled
by a UNIQUE index.

FossilOrigin-Name: 0cf6211f0994474dc23ba5f38d2e6d0984360039798293eca757047e66d00c58

6 months agoFix a potential UAF in sqlite3.oo1.DB.exec()'s teardown pieces.
stephan [Mon, 1 Dec 2025 19:20:20 +0000 (19:20 +0000)] 
Fix a potential UAF in sqlite3.oo1.DB.exec()'s teardown pieces.

FossilOrigin-Name: 59e0b8a2812f9969402a719174506a20a231a66a15818e6e8830956de2d365e6

6 months agoVersion 3.51.1 version-3.51.1
drh [Fri, 28 Nov 2025 17:28:25 +0000 (17:28 +0000)] 
Version 3.51.1

FossilOrigin-Name: 281fc0e9afc38674b9b0991943b9e9d1e64c6cbdb133d35f6f5c87ff6af38a88

6 months agoA better fix for the issue with RETURNING triggers on eponymous
drh [Fri, 28 Nov 2025 13:04:31 +0000 (13:04 +0000)] 
A better fix for the issue with RETURNING triggers on eponymous
virtual tables and SQLITE_SCHEMA errors.

FossilOrigin-Name: 40ddaca3fb752425c26570365a9f31820786d21d043c1c0a4b49746ff9bc0782

6 months agoFix a buffer overread in fts5 that might occur while processing a corrupt db.
drh [Fri, 28 Nov 2025 12:36:04 +0000 (12:36 +0000)] 
Fix a buffer overread in fts5 that might occur while processing a corrupt db.

FossilOrigin-Name: 712e31c59254f82e62a19e41d3b6ac15391dd6e9df966cacadfa9ae79415b243

6 months agoFix a problem in the xFilter() method of the fts5_vocab virtual table causing it...
drh [Fri, 28 Nov 2025 12:00:14 +0000 (12:00 +0000)] 
Fix a problem in the xFilter() method of the fts5_vocab virtual table causing it to omit some result rows in some cases where a virtual cursor is used more than once by SQLite.

FossilOrigin-Name: 0c836387518dee719eaac8992c63da955630ac073a5e4ba4d887160dff42b898

6 months agoCLI shell: ensure that .dump propagates its error code on error.
drh [Thu, 13 Nov 2025 12:22:14 +0000 (12:22 +0000)] 
CLI shell: ensure that .dump propagates its error code on error.

FossilOrigin-Name: 61222410c503916b832c1b76b028f1c73f4839a2067902f5db1d6a4a4459cb2b

6 months agoFix a problem in the EXISTS-to-JOIN optimization so
drh [Thu, 13 Nov 2025 11:42:16 +0000 (11:42 +0000)] 
Fix a problem in the EXISTS-to-JOIN optimization so
that it works with nested WHERE and EXISTS statements.

FossilOrigin-Name: 728fac52017de1309c84c96e33ed99d6472d6b4831587312944b8d85a68d3343

6 months agoMerge various minor code and documentation fixes from trunk into the
drh [Thu, 13 Nov 2025 11:34:38 +0000 (11:34 +0000)] 
Merge various minor code and documentation fixes from trunk into the
patch branch for 3.51.

FossilOrigin-Name: 9a00fe5eb69050ddc569d2a857309c2779a48414135f0967531999b7afd84283

6 months agoKick off branch-3.51: bump version to 3.51.1 and cherrypick [0f712b6b0516dc151d].
stephan [Sun, 9 Nov 2025 06:38:48 +0000 (06:38 +0000)] 
Kick off branch-3.51: bump version to 3.51.1 and cherrypick [0f712b6b0516dc151d].

FossilOrigin-Name: 1b908c439a4d2614cb6a4cec36d8d876eec68b1e2e80d6aad7e21d61d159df7d

6 months agoVersion 3.51.0 version-3.51.0
drh [Tue, 4 Nov 2025 19:38:17 +0000 (19:38 +0000)] 
Version 3.51.0

FossilOrigin-Name: fb2c931ae597f8d00a37574ff67aeed3eced4e5547f9120744ae4bfa8e74527b

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7 months agoIncrease the range of integer indexes in the the merge() family of
drh [Sat, 18 Oct 2025 11:04:03 +0000 (11:04 +0000)] 
Increase the range of integer indexes in the the merge() family of
SQL functions.

FossilOrigin-Name: 8d3943890ef3b533df35c4784c2a42c52503a4d9c3dbe67241510d8b70669b48

7 months agoFix a minor memory leak in the CLI that can occur following an error
drh [Fri, 17 Oct 2025 10:06:44 +0000 (10:06 +0000)] 
Fix a minor memory leak in the CLI that can occur following an error
in the ".output" dot-command.

FossilOrigin-Name: d1044bc0616fd20c63ca3b627ad0a116256870a082a72da26f98fb0f59ca44fd

7 months agoResolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum...
stephan [Thu, 16 Oct 2025 23:42:39 +0000 (23:42 +0000)] 
Resolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum post 95edc7a8d7d1de59], with help from Bo Lindbergh.

FossilOrigin-Name: b144f875d6bddce62e8f2ad42bfe5dfa6c2434f2ef3edb86847fb4c23aa46814

7 months agoImprove performance of the shell tool ".ar" command when it is given a large number...
dan [Thu, 16 Oct 2025 14:17:30 +0000 (14:17 +0000)] 
Improve performance of the shell tool ".ar" command when it is given a large number of arguments.

FossilOrigin-Name: 8fed9de84bce01e88e0e8237e245c0ff9fe9f46394c603887e360658f5ef1ac1