]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
10 months agoFix some harmless scanbuild warnings in the shell.
drh [Fri, 22 Nov 2024 12:07:21 +0000 (12:07 +0000)] 
Fix some harmless scanbuild warnings in the shell.

FossilOrigin-Name: 9ba1c9b505d459366274043c1c5327f1a9d4e15d3564d99f8a15926af1d6d247

10 months agoFix harmless compiler warning caused by [c77a4a42f2e3d164].
drh [Fri, 22 Nov 2024 12:00:31 +0000 (12:00 +0000)] 
Fix harmless compiler warning caused by [c77a4a42f2e3d164].

FossilOrigin-Name: 063690d2c5cc2a887055b9141d3fcdb4fd2fa35d069c9a39b81903c531c73fcf

10 months agoMake ".scanstatus" an undocumented alternative name for ".scanstats" in the CLI.
drh [Thu, 21 Nov 2024 20:57:11 +0000 (20:57 +0000)] 
Make ".scanstatus" an undocumented alternative name for ".scanstats" in the CLI.

FossilOrigin-Name: f20688efc2bc54648618b0aa2593a771f455ee8cc703b52273452d15e680b67c

10 months agoFix a bug-in-waiting (one too few list elements) in [b6bd25bd769e].
stephan [Thu, 21 Nov 2024 20:10:38 +0000 (20:10 +0000)] 
Fix a bug-in-waiting (one too few list elements) in [b6bd25bd769e].

FossilOrigin-Name: e527dcd016fbeb55b0e613a0b3b95350bbc8b3ee601bbadfedaf6bd5458b3570

10 months agoAdd the --scanstatus configure flag to set -DSQLITE_ENABLE_STMT_SCANSTATUS.
stephan [Thu, 21 Nov 2024 20:07:01 +0000 (20:07 +0000)] 
Add the --scanstatus configure flag to set -DSQLITE_ENABLE_STMT_SCANSTATUS.

FossilOrigin-Name: b6bd25bd769e4286ad0b8ca5059bc9da52188cefe92525d8994aa921768aa750

10 months agoFix a JS test which was broken when OMIT_PROGRESS_CALLBACK was _not_ used.
stephan [Thu, 21 Nov 2024 15:53:31 +0000 (15:53 +0000)] 
Fix a JS test which was broken when OMIT_PROGRESS_CALLBACK was _not_ used.

FossilOrigin-Name: fba23150b5b57980f8ed2656a2325f95215ca1e13fc3449b5eec804831dd65c8

10 months agoDocument that -nofollow does not work on Windows. Fix Windows symlink
drh [Thu, 21 Nov 2024 01:50:01 +0000 (01:50 +0000)] 
Document that -nofollow does not work on Windows.  Fix Windows symlink
test cases for when the test suite is run as administrator.

FossilOrigin-Name: 4de8a75ec5a2e3655a2d0c5a9333b58f8b48b681255f0a01866b610ae6249bc2

10 months agoNew configuration option --dynlink-tools causes some command-line tools like
drh [Wed, 20 Nov 2024 16:21:34 +0000 (16:21 +0000)] 
New configuration option --dynlink-tools causes some command-line tools like
sqldiff and sqlite3_analyzer to link against the libsqlite3.so system library
rather than being built-in.  Caution:  sqlite3_analyzer requires the
SQLITE_ENABLE_DBSTAT_VTAB compile-time option on its SQLite library in order
to work, so do not use --dynlink-tools to build sqlite3_analyzer without it.

FossilOrigin-Name: 314c606dd36e03d2ded899c536585ea21250af56b553fa4c96dc714cb5099522

10 months agoUse shared-library flags, not shared-object flags, to create shared libraries. link-tools-dynamically
drh [Wed, 20 Nov 2024 16:17:01 +0000 (16:17 +0000)] 
Use shared-library flags, not shared-object flags, to create shared libraries.
This makes no difference on Linux, but is required for Mac.

FossilOrigin-Name: bfaa3ee7588b6f6be9799882c6ed6472357d988fac31512d5e92fe28f57029c6

10 months agoBug fix in the SubrtnSig logic from [c9a3498113074bbc], if a subquery is
drh [Wed, 20 Nov 2024 14:59:32 +0000 (14:59 +0000)] 
Bug fix in the SubrtnSig logic from [c9a3498113074bbc], if a subquery is
copied and then changes are made to the copy, be sure to give the copy
a unique Select.selId value so that the original will not be substituted
in place of the modified copy.
[forum:/forumpost/0b9ded2f8428ac00|Forum post 0b9ded2f8428ac00].

FossilOrigin-Name: 19d1bede5654bcfa9f7a151b9b2616a3d10873b8e3f8cf54a3a7e810da08f844

10 months agoProvide the sqlite3ShowWhereTerm() interface callable interactively from
drh [Wed, 20 Nov 2024 14:19:44 +0000 (14:19 +0000)] 
Provide the sqlite3ShowWhereTerm() interface callable interactively from
a debugger, when compiling with SQLITE_DEBUG.

FossilOrigin-Name: c77a4a42f2e3d16427a69295436efe36335e56e97abd0efba814092498a8dea8

10 months agoDo not report an sqlite3_error_offset() for errors that occur inside of
drh [Wed, 20 Nov 2024 11:34:16 +0000 (11:34 +0000)] 
Do not report an sqlite3_error_offset() for errors that occur inside of
views or triggers, since the text of those elements is not part of the
original query.

FossilOrigin-Name: bf66c6dfc25c2562a4e6a5b24dd1660213a8fefbb5763e7583b87fb06dbaaf43

10 months agoAdd fix from [bfab759611b0] to sqltclsh. Remove some now-unneeded has_tclsh84/5 check...
stephan [Tue, 19 Nov 2024 21:19:12 +0000 (21:19 +0000)] 
Add fix from [bfab759611b0] to sqltclsh. Remove some now-unneeded has_tclsh84/5 checks in cases where jimsh can be used.

FossilOrigin-Name: 9d389b998317c5006876f2f40d56cd763d1555bbeaf48b2bca9bd46dcd02b80e

10 months agoAdd missing $TCL_LIBS to the link for sqlite3_analyzer.
drh [Tue, 19 Nov 2024 21:14:48 +0000 (21:14 +0000)] 
Add missing $TCL_LIBS to the link for sqlite3_analyzer.

FossilOrigin-Name: bfab759611b0562837d8733ce56591854db08c122956524799dc1d5b3e2d0279

10 months agoRename --link-tools-dynamically to --dynlink-tools, per discussion.
stephan [Tue, 19 Nov 2024 20:21:40 +0000 (20:21 +0000)] 
Rename --link-tools-dynamically to --dynlink-tools, per discussion.

FossilOrigin-Name: 50b9f6fde44f9afda27e47badde6115ab6d9ccd5e22b446a8d8127499848815f

10 months agoMove the in-comment-code commentary about --with-debug, from [7b14309be4], into the...
stephan [Tue, 19 Nov 2024 20:14:31 +0000 (20:14 +0000)] 
Move the in-comment-code commentary about --with-debug, from [7b14309be4], into the --help text for that flag, where it's readily visible.

FossilOrigin-Name: c938e5d783b3f015b2a1b9f3711664b13497c4b71e4a890c65d6665539522ff8

10 months agoGet sqlite3_analyzer optionally linking against libsqlite3.so instead of embedding...
stephan [Tue, 19 Nov 2024 19:47:51 +0000 (19:47 +0000)] 
Get sqlite3_analyzer optionally linking against libsqlite3.so instead of embedding sqlite3.c. Patch mkccode.tcl to accept digits in its IFDEF/IFNDEF checks and sqlite3_analyzer.c.in to only include sqlite3.c if -DINCLUDE_SQLITE3_C is passed to mkccode.tcl.

FossilOrigin-Name: 80f3bf8c2ee31ba1ab9187d64d5dcbbf97a61845a21b036f89ea9133153575c0

10 months agoMerge trunk into this branch. Fix a small jimtcl/tclsh regex incompatibility in mkcco...
stephan [Tue, 19 Nov 2024 19:16:58 +0000 (19:16 +0000)] 
Merge trunk into this branch. Fix a small jimtcl/tclsh regex incompatibility in mkccode.tcl.

FossilOrigin-Name: 7fb3ebfec634e0508267049fddb2b513201dbefce4d378ca3ec261c5d8336d7f

10 months agoEnhancements to tool/mkccode.tcl such that it recognizes -D command line
drh [Tue, 19 Nov 2024 18:26:47 +0000 (18:26 +0000)] 
Enhancements to tool/mkccode.tcl such that it recognizes -D command line
arguments and can use them in internal IFDEF and IFNDEF macros.  Update
the tool/sqlite3_analyzer.c.in script such that it omits the SQLite amalgamation
if -DSQLITE_ENABLE_DBSTAT_VTAB is defined.

FossilOrigin-Name: 7fec209290aa1a6dbbca8de154edaac5d8d0ce042bc0617d27fb2095c8d580f1

10 months agoRevert linking the shell to the dll for reasons explained in new makefile comments...
stephan [Tue, 19 Nov 2024 17:41:13 +0000 (17:41 +0000)] 
Revert linking the shell to the dll for reasons explained in new makefile comments. Move the --with-debug configure flag into the developer options set and add commentary about why it should never be used for production builds.

FossilOrigin-Name: 7b14309be42be4204c4d30e9741d56d75ab8ec34686791d032612337fe1c4dcf

10 months agoReformulate sqldiff deps and rules so that the target matches the resulting file...
stephan [Tue, 19 Nov 2024 16:40:49 +0000 (16:40 +0000)] 
Reformulate sqldiff deps and rules so that the target matches the resulting file name, to avoid rebuilding it on every make invocation. Apply the same treatment to the sqlite3 CLI shell.

FossilOrigin-Name: 9a17b83f859ef14629cb78d8c9af1b3f2493b0c8756bc2ebcf92f0872fb507c3

10 months agoInitial configure support for linking certain binaries to libsqlite3.so instead of...
stephan [Tue, 19 Nov 2024 15:20:47 +0000 (15:20 +0000)] 
Initial configure support for linking certain binaries to libsqlite3.so instead of embedding it dynamically (which they typically do). This currently applies only to sqldiff, but support for adding the same for other tools is planned. This requires disabling the soname because setting it causes the build to link to whatever libsqlite3.so.0 is installed system-wide, so the soname now defaults to off.

FossilOrigin-Name: 9192c146e2898456a6b8ea43a6f02c0227ddce5b584374fbeb2d63bd2ecd5d8c

10 months agoFix a problem handling OOM errors in fts3 that could occur when parsing multi-token...
dan [Tue, 19 Nov 2024 11:58:32 +0000 (11:58 +0000)] 
Fix a problem handling OOM errors in fts3 that could occur when parsing multi-token strings.

FossilOrigin-Name: 4c4d1db00bd2c522165876dcf1606116a72525d9ffc891b266213704e25cde55

10 months agoReduce divergence from begin-concurrent.
drh [Mon, 18 Nov 2024 18:45:31 +0000 (18:45 +0000)] 
Reduce divergence from begin-concurrent.

FossilOrigin-Name: 84d41e9d04c62601e84621e8edb3b81abbacc366a6b5e7059f8b6796fade7ffa

10 months agoAttempt to reduce divergence with the wal2 branch.
drh [Mon, 18 Nov 2024 17:05:45 +0000 (17:05 +0000)] 
Attempt to reduce divergence with the wal2 branch.

FossilOrigin-Name: e0d8f9916c2d899094b71af74f44e089a97db6d80f09eb80a5d8be733c1bf942

10 months agoAttempt to reduce divergence with begin-concurrent.
drh [Mon, 18 Nov 2024 16:44:26 +0000 (16:44 +0000)] 
Attempt to reduce divergence with begin-concurrent.

FossilOrigin-Name: f783d90187fb326faa3d0244b30138b023c4a8483486f260b7a022a927c13f3a

10 months agoRemove the .POSIX entries from the makefiles because they cause portability problems...
stephan [Mon, 18 Nov 2024 14:15:08 +0000 (14:15 +0000)] 
Remove the .POSIX entries from the makefiles because they cause portability problems rather than solve them.

FossilOrigin-Name: e1330ecf170436678c5c235557fb95b8acbf4fad62583edba4af03aff49afbc5

10 months agoFix a "applying zero offset to null pointer" usan error in the fts5 trigram tokenizer.
dan [Mon, 18 Nov 2024 14:08:42 +0000 (14:08 +0000)] 
Fix a "applying zero offset to null pointer" usan error in the fts5 trigram tokenizer.

FossilOrigin-Name: 9b79b999d4192a3a250bf343825f61e9cb83203e4d94dcfa20c320d5f1386d69

10 months agoFix minor problems in testrunner.tcl that pop up when the command-line arguments
drh [Mon, 18 Nov 2024 13:29:16 +0000 (13:29 +0000)] 
Fix minor problems in testrunner.tcl that pop up when the command-line arguments
are such that no tests are run.

FossilOrigin-Name: 321ded32f67550e964cd64d61aa0cbc0029ce2fdee4588a46b01dbb5aa87150b

10 months agoMake the --vfstrace output from the CLI go to the same output channel as
drh [Sun, 17 Nov 2024 11:42:43 +0000 (11:42 +0000)] 
Make the --vfstrace output from the CLI go to the same output channel as
everything else.

FossilOrigin-Name: f71d4900205ae6ee41f849c4026d0fe4d6cf281dfc3bac8105fc8e242d128b67

10 months agobuildtclext.tcl: add docs explaining the DESTDIR check and break out of the auto_path...
stephan [Sun, 17 Nov 2024 09:49:53 +0000 (09:49 +0000)] 
buildtclext.tcl: add docs explaining the DESTDIR check and break out of the auto_path search loop early if the DESTDIR is not writable, rather than re-checking that repeatedly.

FossilOrigin-Name: d07be336eaeb9a5d56ac6e1b63f4d8e50d3ac236f5953cc178ef34542a7cd8fa

10 months agoCall fflush() on ".echo" output from the shell, so that the output to
drh [Sat, 16 Nov 2024 18:54:46 +0000 (18:54 +0000)] 
Call fflush() on ".echo" output from the shell, so that the output to
stdout is aligned with output to stderr.

FossilOrigin-Name: c38b9db3c4f71706a7d211424da64311e6e5daf64b224565a6d82d4b1a68e261

10 months agoFix argument expansion in sqlite-tclsh on Windows such that if an argument
drh [Sat, 16 Nov 2024 17:39:34 +0000 (17:39 +0000)] 
Fix argument expansion in sqlite-tclsh on Windows such that if an argument
does not match a filename even after glob expansion, it is appended to the
argument list verbatim.

FossilOrigin-Name: cd942dce148c9d8f5a94cee61923aad8d1b732b807e004005f78323be30c02e7

10 months agoHandle DESTDIR at an earlier phase in buildtclext.tcl to account for the is-writable...
stephan [Sat, 16 Nov 2024 17:09:55 +0000 (17:09 +0000)] 
Handle DESTDIR at an earlier phase in buildtclext.tcl to account for the is-writable-dir check and to filter out //zipfs: dirs as (im)possible installation targets.

FossilOrigin-Name: d2e8c161a14fbbcc52c50dfd9274c9969e3c273e2cb7cbf2f865541af9f39ead

10 months agoAdd the --destdir flag to the tclextension-install makefile target.
stephan [Sat, 16 Nov 2024 14:30:43 +0000 (14:30 +0000)] 
Add the --destdir flag to the tclextension-install makefile target.

FossilOrigin-Name: d1663cf05f7dcaafd479bacf083b6b774f34fd3db89012b49599d30817eb174f

10 months agoAdd --destdir flag support to buildtclext.tcl, but do not yet add that to the makefil...
stephan [Sat, 16 Nov 2024 14:29:51 +0000 (14:29 +0000)] 
Add --destdir flag support to buildtclext.tcl, but do not yet add that to the makefile (so that this change can be cherrypicked to the 3.47 build).

FossilOrigin-Name: 67a3ca0c013b6a9da3b2c50ffc86b96b14454d1e45fa90d3b0a238488a783e79

10 months agoRename tool/tclConfigShToTcl.sh to tool/tclConfigShToAutoDef.sh in the name of pedant...
stephan [Sat, 16 Nov 2024 10:42:33 +0000 (10:42 +0000)] 
Rename tool/tclConfigShToTcl.sh to tool/tclConfigShToAutoDef.sh in the name of pedantic correctness.

FossilOrigin-Name: a7dd196d99ee7c75b92a03915f2b370e3f4c598eb8521b90af1cb5dd7f9ee49c

10 months agoconfigure: tiny simplification of proj-assert.
stephan [Sat, 16 Nov 2024 09:00:31 +0000 (09:00 +0000)] 
configure: tiny simplification of proj-assert.

FossilOrigin-Name: bfdc416b561937aa74483bf96c042e701e6f98997150f1f1a6b165cddd40d8d1

10 months agoEnhance the vfstrace extension such that the output can be controlled using
drh [Fri, 15 Nov 2024 20:39:41 +0000 (20:39 +0000)] 
Enhance the vfstrace extension such that the output can be controlled using
the "PRAGMA vfstrace('...');" statement.  See header comment on the source code
for details.

FossilOrigin-Name: 96105d33597765c23dbd490b3aa0c2273731d1970d7041720e9f043dbe3517b3

10 months agoIn the interest of minimizing downstream disruption, set the soname of libsqlite3...
stephan [Fri, 15 Nov 2024 19:42:49 +0000 (19:42 +0000)] 
In the interest of minimizing downstream disruption, set the soname of libsqlite3.so to (by default) its legacy value of libsqlite3.so.0 and unconditionally create (or replace) a symlink with that name at install-time, in addition to the newer-named symlinks.

FossilOrigin-Name: 0773677b553e032e992266c6c75e10565729238df3ef52b56602a92cf651bea7

10 months agoGeneric auto.def cleanups. No functional differences.
stephan [Fri, 15 Nov 2024 16:35:24 +0000 (16:35 +0000)] 
Generic auto.def cleanups. No functional differences.

FossilOrigin-Name: 02aceb8c138b5b8f38c75aa0792efa12f14b002083df6141cf56ea0602d3174b

10 months agobuildtclext.tcl: work around a case, reported in [forum:0683a49cb02f31a1|forum post...
stephan [Fri, 15 Nov 2024 15:31:13 +0000 (15:31 +0000)] 
buildtclext.tcl: work around a case, reported in [forum:0683a49cb02f31a1|forum post 0683a49cb0], in which package maintainers edit their copy of tclConfig.sh to change the TCL_SHLIB_LD command.

FossilOrigin-Name: e24a3efec8c168b69d665ab20e8d715210208e6cf291ac93549fdd175a9009d6

10 months agoconfigure: add optional pkg-config support for detecting ICU.
stephan [Fri, 15 Nov 2024 10:53:57 +0000 (10:53 +0000)] 
configure: add optional pkg-config support for detecting ICU.

FossilOrigin-Name: 3e5b8077c6c6ce72ecab3110eb45943b9765372df789088982dbd6046a7c2523

10 months agoWhen checking pkg-config for ICU support use icu-io instead of icu-uc, as that contai... autosetup-icu-pkg-config
stephan [Fri, 15 Nov 2024 10:47:11 +0000 (10:47 +0000)] 
When checking pkg-config for ICU support use icu-io instead of icu-uc, as that contains all requires libs on Linux and BSD.

FossilOrigin-Name: 6ca457542e1dceac2d68fe3d29ff1f0beb31a77ca3073bd7d8a6c62faabcdc1d

10 months agoconfigure script doc additions for the ICU feature check.
stephan [Fri, 15 Nov 2024 10:12:03 +0000 (10:12 +0000)] 
configure script doc additions for the ICU feature check.

FossilOrigin-Name: 1925a68fc2323f0788aac9c3c2bb3005182eb3286037bc383181b6aa150d4270

10 months agoAn experiment in optionally using pkg-config to determine the libs to link in for...
stephan [Fri, 15 Nov 2024 10:07:57 +0000 (10:07 +0000)] 
An experiment in optionally using pkg-config to determine the libs to link in for ICU support, but its ldflags is missing one required lib on both Linux and OpenBSD. Keeping this for later reference, as it demonstrates how to use pkg-config from autosetup.

FossilOrigin-Name: 09caa94c9e846f9b3669b3f1acbb26b24b8bfcc9e512f17ea074dd92745c2597

10 months agoFix typo in the handling of the new --dev flag which caused it to set the --debug...
stephan [Thu, 14 Nov 2024 19:34:28 +0000 (19:34 +0000)] 
Fix typo in the handling of the new --dev flag which caused it to set the --debug flag instead of the --with-debug flag (the former is for autosetup's internal use).

FossilOrigin-Name: 81202d2ab5963fdcf20555b6d0b31cc955ac27f1cd87656faea5c0611c9a2ee8

10 months agoRemove $prefix/include from the default -I path because it can cause the build to...
stephan [Thu, 14 Nov 2024 19:25:23 +0000 (19:25 +0000)] 
Remove $prefix/include from the default -I path because it can cause the build to pick up an unintended copy of sqlite3.h. Extend the ICU configure support (the origin of -I$prefix/include) to enable fetching the -I path from icu-config and apply it only to those objects which need it.

FossilOrigin-Name: f778dfdd6d6a4975c903d8ca0ebfb4fa917d543289136ea0ab740cb47d2510c1

10 months agoAdd new makefile target "sqlite3d" (where the "d" means either "development" or
drh [Thu, 14 Nov 2024 19:06:00 +0000 (19:06 +0000)] 
Add new makefile target "sqlite3d" (where the "d" means either "development" or
"debug") that always uses separate source files, regardless of the
--disable-amalgmation setting.

FossilOrigin-Name: 91da205beb7e5cab7a76be98e4cfddc4fb4c07022825ea645bc97f331c6bcdaa

10 months agoAdd --enable-dev configure flag which sets various other flags.
stephan [Thu, 14 Nov 2024 17:52:59 +0000 (17:52 +0000)] 
Add --enable-dev configure flag which sets various other flags.

FossilOrigin-Name: ea79c363a42484357ac4ac3422f3466e5bc5cb56e5b2a06a3dc4ec90fea1c190

10 months agoRemove unused sqlite_cfg.h.in from the build.
stephan [Thu, 14 Nov 2024 16:06:36 +0000 (16:06 +0000)] 
Remove unused sqlite_cfg.h.in from the build.

FossilOrigin-Name: bba54e26de56ddf804990f5cd9a1978a14580f06c5771a79803907013df8491e

10 months agoFix a state makefile dependency which refered to the now-removed sqlite_cfg.h.in. makefile-simplification
stephan [Thu, 14 Nov 2024 16:00:45 +0000 (16:00 +0000)] 
Fix a state makefile dependency which refered to the now-removed sqlite_cfg.h.in.

FossilOrigin-Name: 9a726b4be8ddd4b388478024a0952cfd4f0b9f665ab69119a6de0b996ac72216

10 months agoRemove some obsolete macros from the CLI.
drh [Thu, 14 Nov 2024 15:55:19 +0000 (15:55 +0000)] 
Remove some obsolete macros from the CLI.

FossilOrigin-Name: 5c4eb625709eda24b11a0437b150a60fc1497c136a4a2ab2b9d559d893dd397a

10 months agoRemove unused sqlite_cfg.h.in (sqlite_cfg.h gets generated without an input template).
stephan [Thu, 14 Nov 2024 15:25:05 +0000 (15:25 +0000)] 
Remove unused sqlite_cfg.h.in (sqlite_cfg.h gets generated without an input template).

FossilOrigin-Name: 6148f2d39237a85edb399e5c2beb305dccd99ca8c0cf143e8c2ddc0fc1d9e916

10 months agoFix a problem with window functions min() and max() when used with a FILTER clause...
dan [Thu, 14 Nov 2024 14:38:16 +0000 (14:38 +0000)] 
Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

FossilOrigin-Name: d15fb0f75e64bbfdb8df0c0d0358aafbbd7d5e2048df676dafe1abd5e9917f2a

10 months agoDocument the if block at the end of sqlite-check-tcl.
stephan [Thu, 14 Nov 2024 12:23:05 +0000 (12:23 +0000)] 
Document the if block at the end of sqlite-check-tcl.

FossilOrigin-Name: 6bfd09408b9a51c0cbdb28f901a79c9774da755294d7eb67d88e4c42c5652830

10 months agoconfigure: avoid performing multiple checks for -lm on behalf of --enable-fts4 and...
stephan [Thu, 14 Nov 2024 12:09:09 +0000 (12:09 +0000)] 
configure: avoid performing multiple checks for -lm on behalf of --enable-fts4 and --enable-fts5.

FossilOrigin-Name: 6940caa192fa0cc84dbd24191a940aec96c304c68e60ead8f239e85d093e01e0

10 months agoEnhance the vfstrace.c extension to show symbolic names for the various
drh [Wed, 13 Nov 2024 18:23:18 +0000 (18:23 +0000)] 
Enhance the vfstrace.c extension to show symbolic names for the various
SHM locks.

FossilOrigin-Name: c0dd7de8f1e8eb745a8beff086d8b40b289c2dd75fe099a86ccc2bd0581f5e9a

10 months agoFix a memory leak in the ".dump" command of the CLI that can occur if an
drh [Wed, 13 Nov 2024 18:04:49 +0000 (18:04 +0000)] 
Fix a memory leak in the ".dump" command of the CLI that can occur if an
error other than database corruption is seen while trying to query the
database.

FossilOrigin-Name: 2560cc7072c923f534a5de1e15d2b0dd4ac5faf0a8876d9e3bf9804345585444

10 months agoAdd the test/fork-test.c test program.
drh [Wed, 13 Nov 2024 16:08:02 +0000 (16:08 +0000)] 
Add the test/fork-test.c test program.

FossilOrigin-Name: 0611e2b0cf3f33c28cc9ff6c5da7ebba2033bcbda5b1072a30021a3e1fb4e738

10 months agoAdd the SQLITE_FCNTL_NULL_IO file-control.
drh [Wed, 13 Nov 2024 14:58:35 +0000 (14:58 +0000)] 
Add the SQLITE_FCNTL_NULL_IO file-control.

FossilOrigin-Name: f0e917fcf51b59f8ccfe5b9341937341d0e6016eb275d6c33dcb10b0b301a9da

10 months agoEnsure that the sqlite3_index_info.idxStr string coming back from FTS5
drh [Tue, 12 Nov 2024 13:37:00 +0000 (13:37 +0000)] 
Ensure that the sqlite3_index_info.idxStr string coming back from FTS5
is always zero-terminated, even if the xBestIndex call fails with an
SQLITE_CONSTRAINT error.

FossilOrigin-Name: a4e976a030851357049e672bbc0ff66d9cc152b3d5f8e03fff36a7c6f060a755

10 months agoClarify the documentation to make it clear that rows inserted by a
drh [Mon, 11 Nov 2024 21:11:02 +0000 (21:11 +0000)] 
Clarify the documentation to make it clear that rows inserted by a
CREATE TABLE AS SELECT statement are not counted by sqlite3_count64().
[forum:/forumpost/1e6cde5648|Forum post 1e6cde5648].

FossilOrigin-Name: 5c5982e3937acdcda43d6c5b46a95b82bc1839c3558a4b9ae9022384e0f13f04

10 months agoFix the fts5 trigram tokenizer so that it handles non-nul-terminated strings.
dan [Mon, 11 Nov 2024 19:49:26 +0000 (19:49 +0000)] 
Fix the fts5 trigram tokenizer so that it handles non-nul-terminated strings.

FossilOrigin-Name: 84f4e37178a65e3128ac0240d37ac40df08b4050ab070d10707e35d11dcbeb10

10 months agoAdd the ".dbtotxt" command to the CLI.
drh [Mon, 11 Nov 2024 19:07:58 +0000 (19:07 +0000)] 
Add the ".dbtotxt" command to the CLI.

FossilOrigin-Name: b43acf5a8cd4a5efbb90b71af7710084f49bb90ffe4f56de168e8c3a6b679124

10 months agoWrap some exceptionally long lines in main.mk. Add option to override LDFLAGS on...
stephan [Mon, 11 Nov 2024 18:15:50 +0000 (18:15 +0000)] 
Wrap some exceptionally long lines in main.mk. Add option to override LDFLAGS on the sqlite3.dll target. Audit: all targets for which it is hypothetically relevant can now inherit user-supplied LDFLAGS, but only those provided to the configure script, not at make-time, in order to mimic the historical build's restriction in that regard.

FossilOrigin-Name: 073080cae3ea0d12b133d9c9ae98413bb32870a9738c98b89bc345181be81f23

10 months agoUse Win32 APIs to read/write the console in Windows unless the
drh [Mon, 11 Nov 2024 17:02:29 +0000 (17:02 +0000)] 
Use Win32 APIs to read/write the console in Windows unless the
SQLITE_USE_STDIO_FOR_CONSOLE option is defined.  This is an attempt to get
the build working on MinGW.

FossilOrigin-Name: abfe488ed67e2e3510c230e656ecf203afa549ebd1d1872442f1fadc97d0817e

10 months agoDoc update to account for [05073350087b].
stephan [Mon, 11 Nov 2024 09:53:40 +0000 (09:53 +0000)] 
Doc update to account for [05073350087b].

FossilOrigin-Name: b81976c520fbad0bbdbbb877fe85691bcda25c12cf5597cfe224fb6306cd65b3

10 months agoRename proj-define-if-opt-truthy to the more accurate, and less verbose, proj-define...
stephan [Mon, 11 Nov 2024 09:37:19 +0000 (09:37 +0000)] 
Rename proj-define-if-opt-truthy to the more accurate, and less verbose, proj-define-for-opt.

FossilOrigin-Name: 05073350087b368312515134bdf9a266eb8289a065f208421fe08aa38b562d4b

10 months agoFix a case in fts3 where a corrupt database record was not being handled correctly.
dan [Sat, 9 Nov 2024 17:54:51 +0000 (17:54 +0000)] 
Fix a case in fts3 where a corrupt database record was not being handled correctly.

FossilOrigin-Name: cbcb53759b9510379e2159d14b73c9746e611df550b0bd05887bd4a480b519a8

10 months agoFix a deps problem, introduced in [1bd9de719], which breaks the build on systems...
stephan [Sat, 9 Nov 2024 14:34:20 +0000 (14:34 +0000)] 
Fix a deps problem, introduced in [1bd9de719], which breaks the build on systems where HAVE_TCL=0.

FossilOrigin-Name: 7953a8bdcba7242c98f786283270d7b3f8830058a29f2d810457eef697855325

10 months agoSimplify usage of proj-assert by making the expr prefix implicit. Add an optional...
stephan [Sat, 9 Nov 2024 10:23:04 +0000 (10:23 +0000)] 
Simplify usage of proj-assert by making the expr prefix implicit. Add an optional description arg to proj-assert, defaulting to the body of the assertion script.

FossilOrigin-Name: ada7b36c37c59ea02e54462b0eb8b93ff6ab45863edfd67b19f1e1a7bb2f97de

10 months agoRemove three unused files from autosetup/.
stephan [Sat, 9 Nov 2024 09:19:29 +0000 (09:19 +0000)] 
Remove three unused files from autosetup/.

FossilOrigin-Name: 906563a7e07fca81effb31a77ee5d7cdacd4cc6157e16e1139da70c92716869a

10 months agoRemove an unused lib import from auto.def.
stephan [Sat, 9 Nov 2024 06:35:09 +0000 (06:35 +0000)] 
Remove an unused lib import from auto.def.

FossilOrigin-Name: 53a71981abf5aaca01e86ff87c3779d7dcc6661c80e1f2bf74515f49993b6a0d

10 months agoIncrease the minimum SQLITE_LENGTH_LIMIT from 1 to 30 to avoid problems doing
drh [Fri, 8 Nov 2024 20:57:45 +0000 (20:57 +0000)] 
Increase the minimum SQLITE_LENGTH_LIMIT from 1 to 30 to avoid problems doing
simple things like converting strings into integers.  See also
[8fd5b8ec4ab9b555].

FossilOrigin-Name: 6aa01707af4bd96f0f173f9e87f2398be7e6f246f59baa117092849a626b2d61

10 months agoFix an assert() failure in sqlite3recover.c.
dan [Fri, 8 Nov 2024 20:44:16 +0000 (20:44 +0000)] 
Fix an assert() failure in sqlite3recover.c.

FossilOrigin-Name: f52bb19281b189508f5c31305cbd4a5651f3e036a4ee753c64488b0c7e5d2e4d

10 months agoRemove one dep from .tclenv.sh which is only valid for configure-driven builds, not...
stephan [Fri, 8 Nov 2024 14:34:33 +0000 (14:34 +0000)] 
Remove one dep from .tclenv.sh which is only valid for configure-driven builds, not static makefiles.

FossilOrigin-Name: 22986767da8f086daaa6dc760c15e6aedcc5d2d6033937ac2f112ee5750d7fdb

10 months agoAdd 'tcl' makefile target which builds all but tclextension (which does not have...
stephan [Fri, 8 Nov 2024 13:37:00 +0000 (13:37 +0000)] 
Add 'tcl' makefile target which builds all but tclextension (which does not have a well-defined name and dependencies). Improve the deps for .tclenv.sh to avoid getting a stale tclsh when re-configuring with a different --with-tcl(sh).

FossilOrigin-Name: 1bd9de719b0944fdceec32103da3131a7d387820850ab03f652f813d840355b8

10 months agoAdd missing CFLAGS.intree_includes to T.compile.tcl to fix build of tclsqlite3.
stephan [Fri, 8 Nov 2024 08:01:56 +0000 (08:01 +0000)] 
Add missing CFLAGS.intree_includes to T.compile.tcl to fix build of tclsqlite3.

FossilOrigin-Name: bb3c6dc126896528328bb9f51a28a1d46d4549e687c93c16f2d164230c6b1684

10 months agoMore closely emulate the legacy build's handling of LDFLAGS, permitting them to be...
stephan [Fri, 8 Nov 2024 07:37:12 +0000 (07:37 +0000)] 
More closely emulate the legacy build's handling of LDFLAGS, permitting them to be passed to configure but not to make. We cannot 100% enforce that because main.mk is not filtered by the configure script, so we instead add a level of indirection to make passing of LDFLAGS=... to make a no-op.

FossilOrigin-Name: d1af9f31831dc99a808b916df4d414943f5d56796c8342411ee4a57abfde85e2

10 months agoSupport clients passing in LDFLAGS to configure/make, but in a more limited form...
stephan [Fri, 8 Nov 2024 06:22:15 +0000 (06:22 +0000)] 
Support clients passing in LDFLAGS to configure/make, but in a more limited form than the legacy build it (i.e. only to select targets rather than all targets). Rename make-side internal uses of CFLAGS to CFLAGS.env for consistency with the new LDFLAGS.env. See discussion in [forum:5fcbea40f3|forum thread 5fcbea40f3].

FossilOrigin-Name: a5e07e8063ad50f2cf46b6be568717adc9604bd6dbf926a526de43bda2996ad0

10 months agoDisable setting of the SONAME (enabled by [2a2419ef742]), as it's not clear whether...
stephan [Fri, 8 Nov 2024 05:26:26 +0000 (05:26 +0000)] 
Disable setting of the SONAME (enabled by [2a2419ef742]), as it's not clear whether blindly setting the SONAME, which now differs from its historical value, will cause more grief than it solves. Add a (disabled) experiment which permits setting (or not) the SONAME to the legacy or current values. This change is up for further change as experimentation proves whether we truly need/want the SONAME. See discussion in/around [forum:0c6fc6f46b2cb3|forum post 0c6fc6f46b2cb3].

FossilOrigin-Name: d931456805e7d5c3379ca68b97a0a1d4ab1eb80c5e90c169cf43fc8239247d25

10 months agoFix an OOB write that could occur in fts3 when dealing with corrupt database records.
dan [Thu, 7 Nov 2024 17:34:53 +0000 (17:34 +0000)] 
Fix an OOB write that could occur in fts3 when dealing with corrupt database records.

FossilOrigin-Name: 108863ec7998e0a35569e3c6534b538f00d4ef87fdb316bd6a4a9a7a272bba47

10 months agoExtend the set of --flags which get cleared/unset when using --with-wasi-sdk.
stephan [Thu, 7 Nov 2024 16:59:15 +0000 (16:59 +0000)] 
Extend the set of --flags which get cleared/unset when using --with-wasi-sdk.

FossilOrigin-Name: 2a2419ef742c9f37c32be04d417337c1fa22503305d2df154fa38b2b69eae943

10 months agoDoc touchups in the line-editing feature check code.
stephan [Thu, 7 Nov 2024 15:23:54 +0000 (15:23 +0000)] 
Doc touchups in the line-editing feature check code.

FossilOrigin-Name: bb5656bdc905947df205432e108ca6724393061a27028e23bf35b4bf48505d4f

10 months agotcl configuration: --with-tcl=prefix is equivalent to passing the --prefix dir to...
stephan [Thu, 7 Nov 2024 15:04:15 +0000 (15:04 +0000)] 
tcl configuration: --with-tcl=prefix is equivalent to passing the --prefix dir to it. If --with-tcl or --enable-tcl are explicitly passed in and tclConfig.sh is not found, fail fatally. When TCL is either explicitly disabled or default search for it fails non-fatally, be more explicit about which components are not available.

FossilOrigin-Name: c5389d39a90047683e80ae9081d5d10aaa95da00dfc8a133b4a1a6949a11620d

10 months agoFurther improvements to the ".mode json" output in the CLI.
drh [Thu, 7 Nov 2024 12:03:53 +0000 (12:03 +0000)] 
Further improvements to the ".mode json" output in the CLI.

FossilOrigin-Name: 6201b5707f8c895028f9c08cb4f83d33a16a91bf04ed3830ac51aa763d6b7205

10 months agoAutosetup doc touchups.
stephan [Thu, 7 Nov 2024 10:07:20 +0000 (10:07 +0000)] 
Autosetup doc touchups.

FossilOrigin-Name: 574515290058ddfaf39a4221fa0f7a99222c4b040dd455348550816b18492c20

10 months agoExtend the list of "truthy" config values to include "true". Related doc updates.
stephan [Thu, 7 Nov 2024 09:36:01 +0000 (09:36 +0000)] 
Extend the list of "truthy" config values to include "true". Related doc updates.

FossilOrigin-Name: 4455718e485a31100ce3eb4ac5aeb7437c667d7994c6d2abfb38ad8bd1976d6e

10 months agoAdd some internal docs to auto.def explaining certain passages.
stephan [Thu, 7 Nov 2024 08:57:38 +0000 (08:57 +0000)] 
Add some internal docs to auto.def explaining certain passages.

FossilOrigin-Name: 4749967e1b85675580eda2e92f4463c022e3ff929390a8f5b59f614f3975e158

10 months agoDocument the purpose of a global auto.def var added in [0d558318172d].
stephan [Thu, 7 Nov 2024 08:29:58 +0000 (08:29 +0000)] 
Document the purpose of a global auto.def var added in [0d558318172d].

FossilOrigin-Name: f5b6604716826b2057e969a8c0d099325b22eac42f1da65ec367671fc6625639

10 months agoWhen --with-linenoise refers to the msteveb flavor and jimsh is the TCL used for...
stephan [Thu, 7 Nov 2024 07:31:25 +0000 (07:31 +0000)] 
When --with-linenoise refers to the msteveb flavor and jimsh is the TCL used for code generation, enable linenoise in jimsh. Remove some dead auto.def code.

FossilOrigin-Name: 0d558318172dddc8d5c5842625ddf09866ae09cac9cf28731be44db86b5e0fb1

10 months agoAdd mention of file-isexec in autosetup/README.md.
stephan [Thu, 7 Nov 2024 06:02:05 +0000 (06:02 +0000)] 
Add mention of file-isexec in autosetup/README.md.

FossilOrigin-Name: f469356749b62b3ce4161b40ed105d60867a366a389efa583fe9607a13426803

10 months agoChange several 'file exists' checks for tclsh to file-isexec because that checks...
stephan [Thu, 7 Nov 2024 06:00:14 +0000 (06:00 +0000)] 
Change several 'file exists' checks for tclsh to file-isexec because that checks for .exe extensions on Windows.

FossilOrigin-Name: 052a1b4d7cb43b7f65028c41e9a7a17b533c834d8f620fbc7bc0adddb1fdb843

10 months agoFor platforms where tclsh is found but tclConfig.sh is not, set HAVE_TCL to 0. We...
stephan [Thu, 7 Nov 2024 05:26:09 +0000 (05:26 +0000)] 
For platforms where tclsh is found but tclConfig.sh is not, set HAVE_TCL to 0. We can't build the TCL components on those. Problem reported in [forum:5106aee3a8|forum post 5106aee3a8].

FossilOrigin-Name: 04d2576b2e516fc5f5ba719d6bb01d25fd3b06b1c2d26acbec32bcdd65e9a01c

10 months agoFix an FTS3 corruption test case that depends on the specific pseudo-random
drh [Wed, 6 Nov 2024 19:19:49 +0000 (19:19 +0000)] 
Fix an FTS3 corruption test case that depends on the specific pseudo-random
byte sequence generated by sqlite3_randomness(), which is different on
big-endian platforms than it is on little-endian platforms.

FossilOrigin-Name: 6216bfcb74273b7893735e265d3f04d1362fa625cd60cebccb866ce7d6c50e01

10 months agoRe-phrase some (#if !SQLITE_CORE) to (#ifndef SQLITE_CORE), as discussed in forum...
stephan [Wed, 6 Nov 2024 12:58:31 +0000 (12:58 +0000)] 
Re-phrase some (#if !SQLITE_CORE) to (#ifndef SQLITE_CORE), as discussed in forum:cea40371c5e34b09 | for post cea40371c5e34b09].

FossilOrigin-Name: 5495b12569c318d5020b4b5a625a392ef8e777b81c0200624fbbc2a6b5eddef9

10 months agoElaborate on how autosetup selects a tclsh to use.
stephan [Wed, 6 Nov 2024 12:13:04 +0000 (12:13 +0000)] 
Elaborate on how autosetup selects a tclsh to use.

FossilOrigin-Name: d3887895a33742fb1fc97235cf897d295b237a9fb5a84031826f9c1018106f18

10 months agoFix typo in the LICENSE.md file.
drh [Wed, 6 Nov 2024 10:09:21 +0000 (10:09 +0000)] 
Fix typo in the LICENSE.md file.

FossilOrigin-Name: 0588cc5c2fad980aa67402f4fe959a499d711ff23903a521af1b1abc4586c802

10 months agoMinor doc tweaks.
stephan [Wed, 6 Nov 2024 08:29:47 +0000 (08:29 +0000)] 
Minor doc tweaks.

FossilOrigin-Name: 2919a61bd4f8cb4f53462d4807cbc04ac5f71dd437cd693538754cf3f17d00cc