]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
7 months agoNew test cases. two-argument-iif
drh [Tue, 26 Nov 2024 23:30:49 +0000 (23:30 +0000)] 
New test cases.

FossilOrigin-Name: f1cb1a815a09d71eb52d5c7f2f4e5c7689535232dee365e46ac41cce7fd86c01

7 months agoProvide a two-argument version of the iif() function, plus an alternative
drh [Tue, 26 Nov 2024 20:56:03 +0000 (20:56 +0000)] 
Provide a two-argument version of the iif() function, plus an alternative
spelling that only requires a single "i".

FossilOrigin-Name: a251ee645e11e24b67473d8a5bd3f8b72fde1ac9d5fda074f5da2297deb2faa8

7 months agoUpdate fts5 so that the xInstToken() extension API works with prefix queries.
dan [Tue, 26 Nov 2024 20:46:18 +0000 (20:46 +0000)] 
Update fts5 so that the xInstToken() extension API works with prefix queries.

FossilOrigin-Name: 41b79bde4a4b6510b41cc9175ff2527fbd3ca9209812361783754f24cf67ef9e

7 months agoUpdate documentation in fts5.h. fts5-tokendata-prefix
dan [Tue, 26 Nov 2024 20:16:34 +0000 (20:16 +0000)] 
Update documentation in fts5.h.

FossilOrigin-Name: f1e44f703acb415e2ff7d7f87fa05fc874ef1c432095bb3ccb45c6ad2fd085a9

7 months agoPatch autosetup to rename --debug to --autosetup-debug so we can use --debug/--enable...
stephan [Tue, 26 Nov 2024 19:19:12 +0000 (19:19 +0000)] 
Patch autosetup to rename --debug to --autosetup-debug so we can use --debug/--enable-debug for its historical purpose. Update autosetup/README.md with details of the patch.

FossilOrigin-Name: 00dffd10f0c77fed53bdbf1536f6ef9b6076775f1b9a10794b87e3ace33ca1d9

7 months agoPatch autosetup to rename --debug to --autosetup-debug so we can use --debug/--enable... autosetup-debug-flag
stephan [Tue, 26 Nov 2024 19:02:16 +0000 (19:02 +0000)] 
Patch autosetup to rename --debug to --autosetup-debug so we can use --debug/--enable-debug for its historical purpose. --with-debug is now an alias for --enable-debug but can be removed entirely if all scripts which have been adjusted for the autosetup build are edited to (re)use the older flag name.

FossilOrigin-Name: 3296c8d30559eafa20f4748339177149172ecf79b019c42ed0d5ee9cf62a666a

7 months agoMove some of the in-comment configure script help text into the --help text. No funct...
stephan [Tue, 26 Nov 2024 16:12:05 +0000 (16:12 +0000)] 
Move some of the in-comment configure script help text into the --help text. No functional changes.

FossilOrigin-Name: ee8449c482b6f9cfb82fa2417da194fc9aa56f54ef3ac83d368537181634ab1c

7 months agoMinor tweak to ./configure --help output.
drh [Tue, 26 Nov 2024 16:04:02 +0000 (16:04 +0000)] 
Minor tweak to ./configure --help output.

FossilOrigin-Name: 7e634d0569667ce1e17f4a611039cbb726078dc2e6be1f1b19655dc569170ce5

7 months agoReplace some outdated docs re. soname with a link to the soname forum post.
stephan [Tue, 26 Nov 2024 03:15:34 +0000 (03:15 +0000)] 
Replace some outdated docs re. soname with a link to the soname forum post.

FossilOrigin-Name: 9225701cb88cb4629a12b45de5743378448b1d2ddb351916b77cfde638698070

7 months agoCorrect duplicated soname linker flags, one of them mis-named.
stephan [Mon, 25 Nov 2024 17:07:58 +0000 (17:07 +0000)] 
Correct duplicated soname linker flags, one of them mis-named.

FossilOrigin-Name: 87dfd92d3a5a6a09c32c70e724a3f341bc63b9c6dfa0aa94fbbbdd45cc9c29f3

7 months agoFix another issue in argument expansion on Windows for tclsqlite3.c in
drh [Fri, 22 Nov 2024 17:41:00 +0000 (17:41 +0000)] 
Fix another issue in argument expansion on Windows for tclsqlite3.c in
interpreter mode.  Problem introduced by check-in [9b87ea219bce5689] and
unfixed by [cd942dce148c9d8f].

FossilOrigin-Name: 0fe1622cec95b7ebecc127ee57a08113d3da1dadbe72c03a13d6751b3043e50f

7 months agoRemove a flaky JS test which has a result depending on unrepredictable context. That...
stephan [Fri, 22 Nov 2024 16:45:43 +0000 (16:45 +0000)] 
Remove a flaky JS test which has a result depending on unrepredictable context. That same feature is more reliably tested at a later point in the same script.

FossilOrigin-Name: 3d6ae13805bdba4c73b7443f20073264cdd157299cb911228600e1528a136bb1

7 months agoIn order to support package builds, like OpenBSD's, which set a custom soname on...
stephan [Fri, 22 Nov 2024 16:24:55 +0000 (16:24 +0000)] 
In order to support package builds, like OpenBSD's, which set a custom soname on libsqlite3.so, extend the --soname configure flag to allow arbitrary soname values.

FossilOrigin-Name: 9c1c1b99837efe3704778c594a65e0cd4cd0a8ec492044d3bb07f1b37a692c6a

7 months agoMove handling of the tempstore feature flag into the OPT_FEATURE_FLAGS list and remov...
stephan [Fri, 22 Nov 2024 14:18:23 +0000 (14:18 +0000)] 
Move handling of the tempstore feature flag into the OPT_FEATURE_FLAGS list and remove the CFLAGS.libsqlite3 makefile var which exists solely to account for the tempstore being tracked separately from the other feature flags.

FossilOrigin-Name: 2df5065d118ca4abcb4f285d07819e73c5e32f7e470d30eabc7e3d999ec8d0f2

7 months agoMakefile doc cleanups. No functional changes.
stephan [Fri, 22 Nov 2024 14:12:18 +0000 (14:12 +0000)] 
Makefile doc cleanups. No functional changes.

FossilOrigin-Name: 64add0ac706101c53e2d2877fdc0d1ccd071814cae969768d2741cee05f23c01

7 months agoRemove the libsqlite3.so.3 link from the installation process, as it now serves no...
stephan [Fri, 22 Nov 2024 13:47:12 +0000 (13:47 +0000)] 
Remove the libsqlite3.so.3 link from the installation process, as it now serves no functional purpose. We retain libsqlite3.so.0 (A) for compatibility with clients linked against legacy builds and (B) 0 is still valid as the library's ABI version.

FossilOrigin-Name: 91bd9813e04e34e088d5e73bfe2a4f338513363d9a99095a232b811c6b616354

7 months agoAdd links to [/forumpost/5a3b44f510df8ded|the SONAME discussion] at relevant places...
stephan [Fri, 22 Nov 2024 13:22:25 +0000 (13:22 +0000)] 
Add links to [/forumpost/5a3b44f510df8ded|the SONAME discussion] at relevant places in auto.def and the makefiles. No functional changes.

FossilOrigin-Name: c78dcc318a36af123676e54d85fc7f980c21b0ea366d164a96e2d998286d3813

7 months agoFix harmless scanbuild warnings caused by the introduction of the
drh [Fri, 22 Nov 2024 12:29:35 +0000 (12:29 +0000)] 
Fix harmless scanbuild warnings caused by the introduction of the
".dbtotxt" command into the CLI by check-in [b43acf5a8cd4a5ef].

FossilOrigin-Name: 554d8fbd865436ace900859874b6c8c7e1b782184158a86b7788644e27bd1997

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 months agoFix compiler warnings caused by variable shadowing.
dan [Wed, 20 Nov 2024 20:39:18 +0000 (20:39 +0000)] 
Fix compiler warnings caused by variable shadowing.

FossilOrigin-Name: 211b305791980b24c4192ffc57a0471473de3fca32bfc146c0eeacedef7a88aa

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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

7 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