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].
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.
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.
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].
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).
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.
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.
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.
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.
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].
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.
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].
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.
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.
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.
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.
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.
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.
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.
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.
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].
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.