]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
13 months agoRemove tool/tclConfigShToAutoDef.sh, as that functionality was moved into autosetup...
stephan [Sun, 23 Mar 2025 22:49:00 +0000 (22:49 +0000)] 
Remove tool/tclConfigShToAutoDef.sh, as that functionality was moved into autosetup/proj.tcl so that it can be reused in, e.g., autoconf/tea.

FossilOrigin-Name: c9c5a15d4d8141aae68d6643869f74879ae053cb86538b805058099af2cec16b

13 months agoInternal configure refactoring to support an ongoing conversion of ./autoconf/tea...
stephan [Sun, 23 Mar 2025 21:38:28 +0000 (21:38 +0000)] 
Internal configure refactoring to support an ongoing conversion of ./autoconf/tea to autosetup.

FossilOrigin-Name: e1d483e342670092c3579f2f0975e49a0c74516ae34103a63b4cde156bf5e92b

13 months agoFix the generate_series() enhancement from check-in [d50b784807333c54]
drh [Sat, 22 Mar 2025 22:55:33 +0000 (22:55 +0000)] 
Fix the generate_series() enhancement from check-in [d50b784807333c54]
so that it works even if the number that "value" is being compared against
is a non-integer floating point number.  Bug reported by
[forum:/forumpost/0d5d63257e3ff4f6|forum post 0d5d63257].

FossilOrigin-Name: c113e31b818d16770bec1edc980f6833dfb27c4d74178e66a778fbb5671c3a13

13 months agoReplace use of autosetup/lib/*.auto for sqlite-custom-... features to avoid the possi...
stephan [Sat, 22 Mar 2025 19:07:54 +0000 (19:07 +0000)] 
Replace use of autosetup/lib/*.auto for sqlite-custom-... features to avoid the possibility of multiple files being loaded (in an unpredictable order) for that purpose. Instead look for autosetup/sqlite-custom.tcl and source it if it exists. The intent is that sqlite-custom.tcl only ever be added in vendor-specific branches and never in the trunk.

FossilOrigin-Name: f3c0071284fbe1c0a8c3fe73792a79f9df6be983e5c9bd1a7e2fe71ba7b2d400

13 months agoIn the post-configure validation, ensure than no more than one autosetup/lib/*.auto...
stephan [Sat, 22 Mar 2025 18:41:48 +0000 (18:41 +0000)] 
In the post-configure validation, ensure than no more than one autosetup/lib/*.auto file is found, for reasons explained in the validation's error message.

FossilOrigin-Name: 50bbd69a684988a1df4c9c7616b76ae62bc4eb755cde18616de58aa0880fd4a7

13 months agoSlight corrections to the new docs in autosetup/README.md.
stephan [Sat, 22 Mar 2025 17:56:20 +0000 (17:56 +0000)] 
Slight corrections to the new docs in autosetup/README.md.

FossilOrigin-Name: 55029e41e03d9b61b8a53f86d7f69afe71459846f3a1a1723f6934e0d37ca77f

13 months agoDocument the new configuration customization approach and extend it to enable sqlite...
stephan [Sat, 22 Mar 2025 17:28:29 +0000 (17:28 +0000)] 
Document the new configuration customization approach and extend it to enable sqlite-custom-flags to return an empty string to denote that it does not require any new flags (it may still customize flag default values in such cases).

FossilOrigin-Name: b0c7800b0106e90cb7bf7e5d9f48d21f9b058eff6e42339a1621d713ab2dd03c

13 months agoTeach mkautoconfamal.sh to avoid copying autosetup/local.tcl and autosetup/*.auto...
stephan [Sat, 22 Mar 2025 17:00:32 +0000 (17:00 +0000)] 
Teach mkautoconfamal.sh to avoid copying autosetup/local.tcl and autosetup/*.auto except for autosetup/lib/CURRENT-BRANCH-NAME.auto (if any), the intent being to use lib/CURRENT-BRANCH-NAME.auto for branch-specific configuration customizations.

FossilOrigin-Name: dfe24f13c446de5fdd736ed52fec0fca4637b4151ba008de7a598a2fc9398816

13 months agoAdd a mechanism to the configure script to allow certain client-specific builds to...
stephan [Sat, 22 Mar 2025 16:14:34 +0000 (16:14 +0000)] 
Add a mechanism to the configure script to allow certain client-specific builds to extend or override the configure options without having to edit sqlite-config.tcl, the goal being to reduce merge conflicts in those builds when updating sqlite-config.tcl from the canonical copy.

FossilOrigin-Name: bafab4ee5545c6cf6eafc5e352a7f25dfcbc7e58d4cc9064d05658c39de2af0d

13 months agoConfigure script internal cleanups and re-orgs. No functional changes.
stephan [Sat, 22 Mar 2025 12:43:22 +0000 (12:43 +0000)] 
Configure script internal cleanups and re-orgs. No functional changes.

FossilOrigin-Name: f619e40fb05d3e09dca2ad9d9bbf38c66b4b93dd3d4e7c2071db28e671ee6a9c

13 months agoIn the autoconf bundle, do not strip binaries during installation, for parity with...
stephan [Sat, 22 Mar 2025 12:15:13 +0000 (12:15 +0000)] 
In the autoconf bundle, do not strip binaries during installation, for parity with the canonical build and the legacy build. Discussed in [forum:9a67df63eda9925c|forum post 9a67df63eda9925c]. A potential TODO here is to add a configure flag which either enables or disables stripping.

FossilOrigin-Name: 6d2e57bd34c562a9cd618c178c3f92b869bf5420907057b8d2438b16a7f91d46

13 months agoSlightly simplify proj-current-proc-name.
stephan [Fri, 21 Mar 2025 22:14:30 +0000 (22:14 +0000)] 
Slightly simplify proj-current-proc-name.

FossilOrigin-Name: 6a0ca9f2360d29272d7be97fe9f516c3ac88864f3e729ba65da1ef6211908775

13 months agoFix a multi-arg expr call in proj-current-proc-name (must be single-arg for portability).
stephan [Fri, 21 Mar 2025 21:13:44 +0000 (21:13 +0000)] 
Fix a multi-arg expr call in proj-current-proc-name (must be single-arg for portability).

FossilOrigin-Name: 914768f3f5d63a891e1cd578afc676960376fc28ee0fa452fcd32cec0ea5cdaf

13 months agoTeach the CLI that VT100-escape codes that do things like change font
drh [Fri, 21 Mar 2025 18:15:13 +0000 (18:15 +0000)] 
Teach the CLI that VT100-escape codes that do things like change font
colors have zero-width for the purpose of laying out the columns of a
table.

FossilOrigin-Name: 2d0a8a6c38981552748ff5fc2eeba86590e0f116abac260a7fc9318de0a0dbda

13 months agoFlesh out the new proc-debug and its infrastructure a bit.
stephan [Fri, 21 Mar 2025 16:49:32 +0000 (16:49 +0000)] 
Flesh out the new proc-debug and its infrastructure a bit.

FossilOrigin-Name: ba7f1ff0d7d1d3fb79fc298d99fd27b65f639fb1691a1a9cdc9c006b8ff41212

13 months agoProxy configure's msg-debug with proc-debug, which works the same except that it...
stephan [Fri, 21 Mar 2025 16:06:16 +0000 (16:06 +0000)] 
Proxy configure's msg-debug with proc-debug, which works the same except that it prepends the name of the calling proc to the debug message. No functional changes.

FossilOrigin-Name: f0298c773d3490ad3a5b53d2ceeff1bd90e1a7bb5deeba2d24f681ec1bc10510

13 months agoTeach the configure script to be able find a default installation of libreadline...
stephan [Thu, 20 Mar 2025 13:41:08 +0000 (13:41 +0000)] 
Teach the configure script to be able find a default installation of libreadline on Haiku OS.

FossilOrigin-Name: 260e9884118172ef76457a34042ace301f20abab4ced172f6b6135010c446a68

13 months agoFix a problem in the sqlite_dbpage() table-valued function when it is
drh [Thu, 20 Mar 2025 11:47:39 +0000 (11:47 +0000)] 
Fix a problem in the sqlite_dbpage() table-valued function when it is
trying to truncate a file in locking-mode=EXCLUSIVE and the file was
obtained via sqlite3_deserialize().  Problem found by dbsqlfuzz.

FossilOrigin-Name: 346cf9794c6ce82ac32f7ccabc67240309306626709951593720abd198b103e3

13 months agoCorrect part of [505d9e49f7] and [7126a51ed8] to get sessioninvert tests working...
stephan [Wed, 19 Mar 2025 15:21:21 +0000 (15:21 +0000)] 
Correct part of [505d9e49f7] and [7126a51ed8] to get sessioninvert tests working on cygwin.

FossilOrigin-Name: 83c34decbe336c76062e6b1bfe4c2e8f786841a4b6efa001747e786e872c8c71

13 months agoCorrect part of [04075517] which changed the implicit return value of a test function.
stephan [Wed, 19 Mar 2025 14:57:32 +0000 (14:57 +0000)] 
Correct part of [04075517] which changed the implicit return value of a test function.

FossilOrigin-Name: 505d9e49f7af619eda9e46e7ed19c4446c64628233528e1ab3f70264e1640ace

13 months agoAdd some explicit db close calls to work around a process-reaping timing problem...
stephan [Wed, 19 Mar 2025 14:52:39 +0000 (14:52 +0000)] 
Add some explicit db close calls to work around a process-reaping timing problem on cygwin builds.

FossilOrigin-Name: 7126a51ed8a1b90b7f4cf3f1c13f7a1d560ff7a3ae73897ce8d9194df40356ed

13 months agoTest script patches from Jan Nijtmans: always use -DUSE_TCL_STUBS in buildtclext...
stephan [Wed, 19 Mar 2025 13:49:34 +0000 (13:49 +0000)] 
Test script patches from Jan Nijtmans: always use -DUSE_TCL_STUBS in buildtclext.tcl and improvements in how TRG is populated in testrunner.tcl.

FossilOrigin-Name: aa192203aa1aa188866fe00a5d40dc7b7c72b4f38b06da8708ed0a6c8b8638a6

13 months agoMerge trunk into the cygwin-fixes branch for the shell test improvements on Windows...
stephan [Wed, 19 Mar 2025 13:13:12 +0000 (13:13 +0000)] 
Merge trunk into the cygwin-fixes branch for the shell test improvements on Windows. An MSC build's make test now has zero failures.

FossilOrigin-Name: 2de4efe10c2591192edca3833fc9e2fae10ebc925fb556f5b53ad483b491b5b3

13 months agoAvoid running test cases involving ANSI control characters or Unicode on Windows...
stephan [Wed, 19 Mar 2025 11:53:46 +0000 (11:53 +0000)] 
Avoid running test cases involving ANSI control characters or Unicode on Windows in a slave interpreter, as that combination does not work.

FossilOrigin-Name: c7fd71c77f1716c9c85d0f41a07ebd7c96f2e9d5e4c1392fefa1fb53f3cbb746

13 months agoMerge trunk into the cygwin-fixes branch.
stephan [Wed, 19 Mar 2025 10:14:46 +0000 (10:14 +0000)] 
Merge trunk into the cygwin-fixes branch.

FossilOrigin-Name: 34eadd374b3c0a8c9e1f5f4a1c60fda8f16b1c56213b8c4047f96390c676b695

13 months agoChange the generate_series() table-valued function so that its rowid is just an
drh [Tue, 18 Mar 2025 20:15:16 +0000 (20:15 +0000)] 
Change the generate_series() table-valued function so that its rowid is just an
alias for its value.  This allows it to be used as the RHS operand of a
RIGHT JOIN.  This fixes the issue raised by
[forum:/forumpost/1e17219c88|forum post 1e17219c88].

FossilOrigin-Name: 77db4d85e70fbf358ae2321c2601966666bdb4d971d7c113ce30a3e541458ee8

13 months agoFix a problem that could occur when the RHS of an IN operator was a compound SELECT...
dan [Tue, 18 Mar 2025 19:21:04 +0000 (19:21 +0000)] 
Fix a problem that could occur when the RHS of an IN operator was a compound SELECT featuring an ORDER BY on a subquery that was flattened into one of the component SELECTs introduced by [baa83b460c677c21]. Forum post [/forumpost/1e17219c88].

FossilOrigin-Name: 7101ccd5331e36fd1a539f540e79ce0ce159be76ec422e1d9436eec6f3908c6e

13 months agoInternal doc touchups in ext/wasm/mkwasmbuilds.c. No functional changes.
stephan [Tue, 18 Mar 2025 13:52:53 +0000 (13:52 +0000)] 
Internal doc touchups in ext/wasm/mkwasmbuilds.c. No functional changes.

FossilOrigin-Name: 47d34260e74912eeae704bff7c4314b893af86ee66dd96a1bc6f450d3e290702

13 months agoVery slight simplification of the run-fuzzcheck rules.
stephan [Tue, 18 Mar 2025 12:31:09 +0000 (12:31 +0000)] 
Very slight simplification of the run-fuzzcheck rules.

FossilOrigin-Name: c858a39fad30c46aec6a1f81b2d4e56c18ecf7f5cb6d2fe4a32c4b3bb1a6ed64

13 months agoGeneral updates to autosetup/README.md.
stephan [Tue, 18 Mar 2025 11:36:15 +0000 (11:36 +0000)] 
General updates to autosetup/README.md.

FossilOrigin-Name: be8ad5cf579662c54b7e7bc492d8ca03b1f9032c5dad9a6b20590ca1ac00840b

13 months agoUpdate the docs in tool/mkccode.tcl to reflect that it's more generic than it was...
stephan [Tue, 18 Mar 2025 10:28:56 +0000 (10:28 +0000)] 
Update the docs in tool/mkccode.tcl to reflect that it's more generic than it was when the docs were written. Change the shebang line to use /bin/env tclsh instead of a hard-coded tclsh path.

FossilOrigin-Name: 9300f7f42dfd143f77fd51aa9e080099540854d36b6997ab1a16be7d77f78d8e

13 months agoPrevent integer overflow when parsing NEAR queries in FTS5.
drh [Mon, 17 Mar 2025 15:13:47 +0000 (15:13 +0000)] 
Prevent integer overflow when parsing NEAR queries in FTS5.

FossilOrigin-Name: 1a5283d7dab210badb8a33eac29f44dc8c1c210ffb5ef84f43e348170aa406a6

13 months agoAdd support for the --with-wasi-sdk configure flag to the autoconf build.
stephan [Mon, 17 Mar 2025 14:59:55 +0000 (14:59 +0000)] 
Add support for the --with-wasi-sdk configure flag to the autoconf build.

FossilOrigin-Name: 44880fa3f0748604ef50b942c28390e041138759efea1d076dfcaa1da48970cb

13 months agoFix a long-standing filename digest computation bug in the OPFS SAHPool VFS which...
stephan [Sun, 16 Mar 2025 14:05:42 +0000 (14:05 +0000)] 
Fix a long-standing filename digest computation bug in the OPFS SAHPool VFS which caused all VFS-stored filenames to have a digest value of 0. See [/forumpost/042d53c928382021] and for full details.

FossilOrigin-Name: 493cbe74504e8eb1ca8f2edf49fdab6bebc7fe36ffab06932a4b8c5a4eea86cd

13 months agoAdd --asan-fsanitize=... configure flag to the canonical build to optionally set...
stephan [Sun, 16 Mar 2025 13:09:21 +0000 (13:09 +0000)] 
Add --asan-fsanitize=... configure flag to the canonical build to optionally set -fsantize flags for the fuzzcheck-asan tool. Teach proj-check-fsanitiz to fail for flags which the compiler emits any warning for, for reasons described in its comments.

FossilOrigin-Name: 013730e9b92af39cb7fd2871df9b4bc81b8990f918892bd79370704421672da0

13 months agoConfigure-internal doc cleanups. No functional changes.
stephan [Sun, 16 Mar 2025 12:27:21 +0000 (12:27 +0000)] 
Configure-internal doc cleanups. No functional changes.

FossilOrigin-Name: be3a2e631100b711996b9524a54fc604966513a62d83fc916270a6226da7adab

13 months agoConsolidate some much-duplicated run-fuzzcheck recipe code in main.mk.
stephan [Sun, 16 Mar 2025 11:24:32 +0000 (11:24 +0000)] 
Consolidate some much-duplicated run-fuzzcheck recipe code in main.mk.

FossilOrigin-Name: c0d9b9fad3a2f23941927f1be2abded3bde2f2b04f7a5f3cc0a54a978020ebaa

13 months agoRework the run-fuzzcheck makefile target so that it better exploit parallelism.
drh [Sun, 16 Mar 2025 00:13:29 +0000 (00:13 +0000)] 
Rework the run-fuzzcheck makefile target so that it better exploit parallelism.
Test case "<tt>make -j16 run-fuzzcheck FUZZDB=20250222.db</tt>"
went from 596 seconds down to 107 seconds.

FossilOrigin-Name: 18bda13e197e4b4ec7464b3e70012f71edc05f73d8b14bb48bad452f81c7e185

13 months agoEnhance the fuzzcheck testing tool with new command-line options:
drh [Sat, 15 Mar 2025 23:42:32 +0000 (23:42 +0000)] 
Enhance the fuzzcheck testing tool with new command-line options:
--brief, and --slice M N.

FossilOrigin-Name: e64132723db0c4f2b9a58932a93beb1671e42006eebc1aeaa8f320e717043051

13 months agoMake use of the C99 flexible array feature, when available, so that
drh [Sat, 15 Mar 2025 19:55:19 +0000 (19:55 +0000)] 
Make use of the C99 flexible array feature, when available, so that
the -fsanitize=bounds-strict option can be used, when available.
[forum:/forumpost/311dbf9a1cadfae6|Forum thread 311dbf9a1c].

FossilOrigin-Name: d4307a0d43f42e96ec06ad2c1d8d0f5c8ecae759bae8231b1998633089809f49

13 months agoWork around compilers that do not understand flexible arrays, in the flex-array
drh [Sat, 15 Mar 2025 19:00:46 +0000 (19:00 +0000)] 
Work around compilers that do not understand flexible arrays, in the
recovery extension and in the fuzzcheck test module.

FossilOrigin-Name: f101c46cf83e532fd33034abccba496bf395ef10c161af003211614d6581d5eb

13 months agoFix alignment problems on Linux with -m32 and on Mac PPC.
drh [Sat, 15 Mar 2025 18:26:27 +0000 (18:26 +0000)] 
Fix alignment problems on Linux with -m32 and on Mac PPC.

FossilOrigin-Name: 8a91aeca60548d5cd19add128cf65b9c3815c9103b1ef8ff6bc02711b6d709de

13 months agoSpeed up parsing of very long fts3 query expressions.
dan [Sat, 15 Mar 2025 16:58:39 +0000 (16:58 +0000)] 
Speed up parsing of very long fts3 query expressions.

FossilOrigin-Name: 2dd5b6895a3b23c2b9cbf0c1c1e802faf8f2b41ef60819eea25d609755266e64

13 months agoConfigure-internal build cleanups (no functional changes). Add EXTRA_SRC to the deps...
stephan [Sat, 15 Mar 2025 15:19:42 +0000 (15:19 +0000)] 
Configure-internal build cleanups (no functional changes). Add EXTRA_SRC to the deps of sqlite3.c.

FossilOrigin-Name: 8afb8bbce8654d6f76207fb136e79dc52b6724a71eae82a4c098690a68eb75a1

13 months ago-fsanitize is a CFLAG, not LDFLAG, so rename some vars accordingly and simplify the...
stephan [Sat, 15 Mar 2025 13:50:07 +0000 (13:50 +0000)] 
-fsanitize is a CFLAG, not LDFLAG, so rename some vars accordingly and simplify the feature check to not run the linker.

FossilOrigin-Name: 44f2c64ec16f4720dc538be30410863c4138ea4ce41c94521bd7980535261735

13 months agoFor fuzzcheck-asan, dynamically determine the list of -fsanitize flags to use based...
stephan [Sat, 15 Mar 2025 13:36:01 +0000 (13:36 +0000)] 
For fuzzcheck-asan, dynamically determine the list of -fsanitize flags to use based on configure-time feature tests.

FossilOrigin-Name: b70f9cc81516e57e73960bed4b4d2abdcf3dab0ad4a400ca1aed49365c25231e

13 months agoOmit the -fsanitize=bounds-strict for now, as that is still not widely
drh [Sat, 15 Mar 2025 13:11:24 +0000 (13:11 +0000)] 
Omit the -fsanitize=bounds-strict for now, as that is still not widely
implemented.  In particular, it does not work on Macs.

FossilOrigin-Name: 3e1c2ac7817e73ea736a39bb0c0ec8212ceedbc89b265b4caf1b53871d27d7c0

13 months agoUse flexible arrays in the recovery extension and in the fuzzcheck test program.
drh [Sat, 15 Mar 2025 13:04:16 +0000 (13:04 +0000)] 
Use flexible arrays in the recovery extension and in the fuzzcheck test program.
Adjust the unix makefile to use -fsanitize=bounds-strict when building
fuzzcheck-asan.

FossilOrigin-Name: 6ea6a6b211fed1a14d7bec1ab1790dec09e2a00423860498a60b760c4a4561fa

13 months agoUse flexible arrays whereever appropriate in FTS5.
drh [Sat, 15 Mar 2025 12:22:39 +0000 (12:22 +0000)] 
Use flexible arrays whereever appropriate in FTS5.

FossilOrigin-Name: 16dfc415b6e98a2acae79a24bb0afd401e60efc27cbdd1603a426fd33e17d427

13 months agoConvert the Fts5Sorter.aIdx field to a flexible array.
drh [Sat, 15 Mar 2025 00:11:22 +0000 (00:11 +0000)] 
Convert the Fts5Sorter.aIdx field to a flexible array.

FossilOrigin-Name: 28ac776a23da2753265a7fe2ee2ebb09964815fc9058e69c08275fc217842edc

13 months agoTurn Fts5Colset.aiCol into a flexible array.
drh [Fri, 14 Mar 2025 23:57:53 +0000 (23:57 +0000)] 
Turn Fts5Colset.aiCol into a flexible array.

FossilOrigin-Name: 0c4d9c74741794468adc444908f6024f016738aa2852d3a646f2c28d079d9446

13 months agoIn FTS3, rename the MatchinfoBuffer.aMatchinfo field to aMI, to avoid confusing
drh [Fri, 14 Mar 2025 23:20:12 +0000 (23:20 +0000)] 
In FTS3, rename the MatchinfoBuffer.aMatchinfo field to aMI, to avoid confusing
it with MatchInfo.aMatchinfo.  Make aMI a flexiable array.

FossilOrigin-Name: bb00b973980d259ca85af84c054501cae78b3a9d33ccffa54d7034235dd8d50d

13 months agoFix one of two flexible arrays in FTS3.
drh [Fri, 14 Mar 2025 21:15:11 +0000 (21:15 +0000)] 
Fix one of two flexible arrays in FTS3.

FossilOrigin-Name: ddfa87c17906ecf7fd5639a87bbfa9a87d17ab688159acd2fd80cc5b6f25f09b

13 months agoUse flexible arrays for RTREE.
drh [Fri, 14 Mar 2025 20:19:49 +0000 (20:19 +0000)] 
Use flexible arrays for RTREE.

FossilOrigin-Name: 2b41776179c726586e3ff836edcf235938cf02f7c5e33c1d6954b84d4061b8d5

13 months agoKeyInfo is now an indeterminate size, so we cannot declare a variable of that
drh [Fri, 14 Mar 2025 19:07:11 +0000 (19:07 +0000)] 
KeyInfo is now an indeterminate size, so we cannot declare a variable of that
type, only a pointer to an instance of that type.

FossilOrigin-Name: 37b687dc2d3b9dc82ed09a9c5b2c00e576b1eebe358a20d18a3da190347b644e

13 months agoMake use of the flexible-array feature of C99, when available, to try to
drh [Fri, 14 Mar 2025 18:10:02 +0000 (18:10 +0000)] 
Make use of the flexible-array feature of C99, when available, to try to
pacify -fsanitize=strict-bounds.  This check-in fixes the core. There is
more yet to do in FTS3, RTREE, and in FTS5.

FossilOrigin-Name: 6fd6b32d06bd6a705e5140cd613af823b8183a6f6a9ceeeedfcf5e8b50821d68

13 months agoFix an internal doc typo reported in [forum:e25e581f917|forum post e25e581f917].
stephan [Fri, 14 Mar 2025 12:37:36 +0000 (12:37 +0000)] 
Fix an internal doc typo reported in [forum:e25e581f917|forum post e25e581f917].

FossilOrigin-Name: fa6f6ccdffc50024624306900efd2538c7415d8bdd0f02835b2e9c05adab3cf1

13 months agoMinor doc corrections for the sahpool-digest fix and merge in current trunk. sahpool-digest
stephan [Fri, 14 Mar 2025 11:14:52 +0000 (11:14 +0000)] 
Minor doc corrections for the sahpool-digest fix and merge in current trunk.

FossilOrigin-Name: 500f2e6ec74b4c0e4ac0365ba4e0d81ed6df8dd09dc0f8af65d294c3453f8865

13 months agoCherrypick the [2b582c0097e33] doc addition, which was initially committed to the...
stephan [Fri, 14 Mar 2025 09:34:09 +0000 (09:34 +0000)] 
Cherrypick the [2b582c0097e33] doc addition, which was initially committed to the wrong branch.

FossilOrigin-Name: f786de8d1873cd27b1bf83273a1e100e9d481144674888ccf65974e003a3caad

13 months agoFix the generate_series extension for the case where the termination value
drh [Thu, 13 Mar 2025 18:51:18 +0000 (18:51 +0000)] 
Fix the generate_series extension for the case where the termination value
is not an even multiple of the step from the start value and there is also
a value=NNN constraint in the WHERE clause.
[forum:/info/bf2dc8e909983511|Forum post bf2dc8e9]

FossilOrigin-Name: 75e72e3b0d0d689d39e00a01dc361dd6ce2649e68d200bf501ddcf04063041b2

13 months agoThe --echo flag on the CLI also echos dot-commands provided on the command-line.
drh [Wed, 12 Mar 2025 15:17:13 +0000 (15:17 +0000)] 
The --echo flag on the CLI also echos dot-commands provided on the command-line.

FossilOrigin-Name: 6ec0c03b954cf705da076d035a1cc2e784233ae28857385379e44a59af6c5ec4

13 months agoDocument that sqlite_update_hook() can unset the current hook by passing a NULL callb...
stephan [Wed, 12 Mar 2025 11:41:12 +0000 (11:41 +0000)] 
Document that sqlite_update_hook() can unset the current hook by passing a NULL callback, to address [forum:652aef4747|forum post 652aef4747].

FossilOrigin-Name: 2b582c0097e3374beb280dfa6b03e0dacb9911da1bceb0dce0468e6b7291e74f

13 months agoAvoid running test cases involving ANSI control characters or Unicode windows-ansi
drh [Tue, 11 Mar 2025 15:46:23 +0000 (15:46 +0000)] 
Avoid running test cases involving ANSI control characters or Unicode
on Windows in a slave interpreter, as that combination does not work.

FossilOrigin-Name: f6745a7355c62ee64c08e23b795f437dd74add903b55e1255c1d03f9a811170d

13 months agoThe substitute "puts" command used by the Windows implementation of
drh [Tue, 11 Mar 2025 12:19:27 +0000 (12:19 +0000)] 
The substitute "puts" command used by the Windows implementation of
sqlite3_analyzer must invoke fflush() after each line of output.  Otherwise
the output can be truncated when redirected into a file.

FossilOrigin-Name: ba058ce90a2ba9ebc4d8fb289108c04f80fa85da01c0b8bd58855681836ba83d

13 months agoTeach testrunner.tcl to distinguish Cygwin from Windows. This gets it running but...
stephan [Tue, 11 Mar 2025 11:24:52 +0000 (11:24 +0000)] 
Teach testrunner.tcl to distinguish Cygwin from Windows. This gets it running but then all downstream tests fail, at least in part because of the build target name discrepancies between the platform which requires .exe and those which do not.

FossilOrigin-Name: 2861788e479aea12354f2d34d8e6a2706d193642674ef1f4f852f24c877e0140

13 months agoEnsure that the TEMP database has been initialized at the beginning of
drh [Mon, 10 Mar 2025 22:31:55 +0000 (22:31 +0000)] 
Ensure that the TEMP database has been initialized at the beginning of
a call to sqlite3_open_blob() for the TEMP database.  Fix for the issue
reported by [forum:/forumpost/0a556d619b|forum post 0a556d619b].

FossilOrigin-Name: 2cfccdbe08b7b14a6b255f7157ac20d0807327adefcb33fcffeeed14c7603fe1

13 months agoMerge trunk into the cygwin-fixes branch.
stephan [Mon, 10 Mar 2025 17:35:00 +0000 (17:35 +0000)] 
Merge trunk into the cygwin-fixes branch.

FossilOrigin-Name: f3d14433f24f89558e72a9085c950bc72440e9933d6b4ff59d6e603d25e39422

13 months agoAdd an explicit db close to test/walsetlk.test to work around an unjustified test...
stephan [Mon, 10 Mar 2025 17:28:43 +0000 (17:28 +0000)] 
Add an explicit db close to test/walsetlk.test to work around an unjustified test failure on Windows when the walsetlk tests are run in the same invocation of testfixture.exe in Windows.

FossilOrigin-Name: f418de109335cd7cb29d2b587540c163bbaaa7129c662c2908ef67492139b2d7

13 months agoPatch an unnecessary size_t-to-int conversion which warns on some compilers.
stephan [Mon, 10 Mar 2025 15:35:43 +0000 (15:35 +0000)] 
Patch an unnecessary size_t-to-int conversion which warns on some compilers.

FossilOrigin-Name: 8681dfdb59d3258663ec176daafd7a52446a207db21fbd1a4d151508092dcbc5

13 months agoEnsure that the 'clean' target for Makefile.msc cleans up the testdir dir, analog...
stephan [Mon, 10 Mar 2025 15:27:17 +0000 (15:27 +0000)] 
Ensure that the 'clean' target for Makefile.msc cleans up the testdir dir, analog to how the canonical makefile works, as stale files there have been leading to test failures.

FossilOrigin-Name: a591c018558af70e0ddfdd2d4d61905f030bac01df19ac9b204aed09d44517be

13 months agoReimplement pathname conversion on Cygwin. MSC test passes/failures are on par with...
stephan [Mon, 10 Mar 2025 15:15:13 +0000 (15:15 +0000)] 
Reimplement pathname conversion on Cygwin. MSC test passes/failures are on par with trunk and 'make test' running on cygwin is down to a single failure.

FossilOrigin-Name: 57a4de09149663ac001848773c9dffe53e30f9263e4dacc792a0267401147d25

13 months agoTweak [6f24da264cf8d] so that it has no side-effects on autoconf/Makefile.msc.
stephan [Mon, 10 Mar 2025 14:10:46 +0000 (14:10 +0000)] 
Tweak [6f24da264cf8d] so that it has no side-effects on autoconf/Makefile.msc.

FossilOrigin-Name: d3d322f122e88ea7d7f086f1c7d3ba8ab5ba7c2899d6d1e18b0b593001f01dcf

13 months agoDisable the [d1ba200234f40b84|count-of-view optimization] if any subquery
drh [Mon, 10 Mar 2025 10:32:31 +0000 (10:32 +0000)] 
Disable the [d1ba200234f40b84|count-of-view optimization] if any subquery
is DISTINCT, as the optimization does not work in that case.
Bug reported by [forum/forumpost/a860f5fb2e|forum post a860f5fb2e].

FossilOrigin-Name: d7013b63932b2f5750572ae6bdd259a2b6e6548c20fb9a5559edd22d2f2fc6cb

13 months agoAdd tf.bat target to Makefile.msc to facilitate running of individual test scripts...
stephan [Mon, 10 Mar 2025 09:54:01 +0000 (09:54 +0000)] 
Add tf.bat target to Makefile.msc to facilitate running of individual test scripts via testfixture.exe.

FossilOrigin-Name: 6f24da264cf8d4c9fef706e6ab89e8c002ac4abfb79516f65ff4eb806f864959

13 months agoTest app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel...
stephan [Sat, 8 Mar 2025 06:53:06 +0000 (06:53 +0000)] 
Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

FossilOrigin-Name: 84d8fcfca19cd183d05a702d0eb1742bfae462d3383a3db72741a48cefac1058

13 months agoos_win.c patches for Cygwin (described in the cygwin-fixes branch wiki page). Makefil...
stephan [Fri, 7 Mar 2025 06:54:04 +0000 (06:54 +0000)] 
os_win.c patches for Cygwin (described in the cygwin-fixes branch wiki page). Makefile.msc's test target on trunk fails the same 13 tests as this branch.

FossilOrigin-Name: 655c60d1926adb552d37441bf9857263eae92e3806a8524e8443b81fdfd8c258

13 months agoMerge trunk into the cygwin-fixes branch (which was inadvertently branched too early).
stephan [Thu, 6 Mar 2025 14:40:45 +0000 (14:40 +0000)] 
Merge trunk into the cygwin-fixes branch (which was inadvertently branched too early).

FossilOrigin-Name: a7863b2e2fbea0ea11c494016b99921f70aae09607868aa65af988cbd173b31a

13 months agoCygwin-centric test script tweaks from Jan Nijtmans.
stephan [Thu, 6 Mar 2025 13:49:27 +0000 (13:49 +0000)] 
Cygwin-centric test script tweaks from Jan Nijtmans.

FossilOrigin-Name: 9868615b7d41179672dde2eafff878d50cf9d647c7050ccf5103e385fd182fc2

13 months agoCygwin-centric fixes from Jan Nijtmans.
stephan [Thu, 6 Mar 2025 13:38:07 +0000 (13:38 +0000)] 
Cygwin-centric fixes from Jan Nijtmans.

FossilOrigin-Name: 205979813c7300debb5f1ba270583ef2f08e069d6d01865b5910702889a5c1ed

13 months agoBack out the most significant part of [5c28a17253e2f], as Cygwin is a hybrid. With...
stephan [Thu, 6 Mar 2025 09:29:15 +0000 (09:29 +0000)] 
Back out the most significant part of [5c28a17253e2f], as Cygwin is a hybrid. With SQLITE_OS_UNIX it will use POSIX locking, which will misinteract with apps using Windows-style locking.

FossilOrigin-Name: 44adf8f38761a0d756c047f93fc76fc1d0aba8cc209970e3ba13e7040dd14b13

13 months agoVarious typo fixes reported by Daniel Dumitriu. No functional changes.
stephan [Thu, 6 Mar 2025 09:08:38 +0000 (09:08 +0000)] 
Various typo fixes reported by Daniel Dumitriu. No functional changes.

FossilOrigin-Name: 37e6ec777445d8ef81acecbb66f86ae78f2ae67ef0bfd3fbd089da51fff35cc9

13 months agoAdditional 'array index is signed char' warning cleanups for the shell and its embedd...
stephan [Thu, 6 Mar 2025 07:48:45 +0000 (07:48 +0000)] 
Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d].

FossilOrigin-Name: f31042595b8f8a378db9778c9a8223b07ec02cf2f528581ba43bf72b5b03c964

13 months agoFix a tcl typo in the previous checkin which triggers an error on one machine but...
stephan [Thu, 6 Mar 2025 07:09:50 +0000 (07:09 +0000)] 
Fix a tcl typo in the previous checkin which triggers an error on one machine but not another.

FossilOrigin-Name: 646c2821ad434058db7760e699d21a47c7feb5976199cbe4b58d54c902720cbf

13 months agoHave the configure script report cygwin as SQLITE_OS_UNIX instead of SQLITE_OS_WIN...
stephan [Thu, 6 Mar 2025 06:25:45 +0000 (06:25 +0000)] 
Have the configure script report cygwin as SQLITE_OS_UNIX instead of SQLITE_OS_WIN, per off-list discussion with Jan Nijtmans.

FossilOrigin-Name: 5c28a17253e2fe56d7fd97cc43345b3fd8bd59fccea3fb1547ed87f7902f76f5

13 months agoHave the recover module add "PRAGMA foreign_keys = off" to SQL output. Have the shell...
dan [Wed, 5 Mar 2025 19:39:02 +0000 (19:39 +0000)] 
Have the recover module add "PRAGMA foreign_keys = off" to SQL output. Have the shell tool add ".dbconfig defensive off".

FossilOrigin-Name: dcfe3d3292851aa48a085a2c68623b049e2786c8dc7154ccc78508443973b5a1

13 months agoAlways ignore comments in the schema of a database, even if
drh [Wed, 5 Mar 2025 18:18:17 +0000 (18:18 +0000)] 
Always ignore comments in the schema of a database, even if
SQLITE_DBCONFIG_ENABLE_COMMENTS is turned off.

FossilOrigin-Name: 373ae3f4de526c636c35db03d6b5c84526d6f144c1c3bebcbb257e52f563a203

13 months agoUpdate the recovery extension so that it works with encrypted databases.
dan [Wed, 5 Mar 2025 17:26:56 +0000 (17:26 +0000)] 
Update the recovery extension so that it works with encrypted databases.

FossilOrigin-Name: b0b66f21159b47e1950ca63a01f92fe4f621efb9a2962b310d65fa7ebdbb43b3

13 months agoUse AtomicRead() and AtomicWrite() to access the pcache1_g.bUnderPressure
drh [Wed, 5 Mar 2025 17:12:42 +0000 (17:12 +0000)] 
Use AtomicRead() and AtomicWrite() to access the pcache1_g.bUnderPressure
global, to forestall unnecessary angst from thread analyzers.

FossilOrigin-Name: 41ec85637a7fac710a3986ee78ed25a96d331a03653069bae4d9f826cc6f944a

13 months agoImprovement output for ".schema --indent" in the CLI when the schema contains
drh [Wed, 5 Mar 2025 16:35:51 +0000 (16:35 +0000)] 
Improvement output for ".schema --indent" in the CLI when the schema contains
partial indexes with long and complicated WHERE clauses.

FossilOrigin-Name: defd7187ff8c4388f8b5467ed168462ec48215a1f4263bc4128b8e4d89a0bb2a

13 months agoMinor configure script cleanups which started out as cygwin-specific fixes but ended...
stephan [Tue, 4 Mar 2025 21:37:40 +0000 (21:37 +0000)] 
Minor configure script cleanups which started out as cygwin-specific fixes but ended up just being minor platform-agnostic cleanups.

FossilOrigin-Name: 2cda90410ac62843fa3cf5a9592b2b25564cf9d829e107c85854e8167d4fe46d

13 months agoRoll back part of [6d87a8efe]: the check for tclsh90.exe (as opposed to tclsh9.0...
stephan [Tue, 4 Mar 2025 21:31:18 +0000 (21:31 +0000)] 
Roll back part of [6d87a8efe]: the check for tclsh90.exe (as opposed to tclsh9.0.exe) is incorrect on these platforms (it's an msvc build). Also remove an unused function added in that checkin.

FossilOrigin-Name: dc84976a7c0d0028b7c576d54e18d1b8e1fc2376bc7b0504f1c86e82c1f7c814

13 months agotclsqlite3 patch from Christian Werner: replace FILE handles with TCL channels for...
stephan [Tue, 4 Mar 2025 21:25:18 +0000 (21:25 +0000)] 
tclsqlite3 patch from Christian Werner: replace FILE handles with TCL channels for the db copy command.

FossilOrigin-Name: ea1f7f8de4abb80fe41a115c9f601ff27cd728493640c6d47d868913feec28dc

13 months agoTeach autosetup how to find tclsh v9.0 on cygwin.
stephan [Tue, 4 Mar 2025 19:38:38 +0000 (19:38 +0000)] 
Teach autosetup how to find tclsh v9.0 on cygwin.

FossilOrigin-Name: 6d87a8efe5611102eac150e5dc1e9d9602318ab8b96046b29c66602e7c3d12fa

13 months agoMakefile doc updates. Remove a couple extraneous targets. No functional changes.
stephan [Tue, 4 Mar 2025 07:29:28 +0000 (07:29 +0000)] 
Makefile doc updates. Remove a couple extraneous targets. No functional changes.

FossilOrigin-Name: 5a3e22999f8da075f7ca3e039f10386fb85295a2457c9495d2c48b7137a84296

13 months agoMinor doc typo fixes via [forum:65bd941da8|forum post 65bd941da8].
stephan [Tue, 4 Mar 2025 06:29:03 +0000 (06:29 +0000)] 
Minor doc typo fixes via [forum:65bd941da8|forum post 65bd941da8].

FossilOrigin-Name: 6f6a03e93cf58eaee79603de0b28ad34c872fb4b4b7d9c4e7fe35c698b27618a

13 months agoDocument the EXTRA_SRC makefile var and add --amalgamation-extra-src=list to the...
stephan [Tue, 4 Mar 2025 05:16:10 +0000 (05:16 +0000)] 
Document the EXTRA_SRC makefile var and add --amalgamation-extra-src=list to the canonical-build configure script as the formal way to pass that at configure-time.

FossilOrigin-Name: 44de0ec29a86f91a227132f7af8898108d555463b754b299eace0ee8475bad57

13 months agoInternal configure script cleanups. Resolve an as-yet-hypothetical corner case involv...
stephan [Mon, 3 Mar 2025 14:15:13 +0000 (14:15 +0000)] 
Internal configure script cleanups. Resolve an as-yet-hypothetical corner case involving the --dev flag mixed with custom CFLAGS containing SQLITE_ENABLE... or SQLITE_OMIT... flags. Fix an unrelated API doc typo reported in [forum:606ea661df|forum post 606ea661df].

FossilOrigin-Name: 0554c00f32b7cc81d35340080df10ea6d66c9ff07fe749ea76cc523a4149b5c8

13 months agoMinor configure script doc tweaks. This is also a note that the basic elements of...
stephan [Mon, 3 Mar 2025 11:48:09 +0000 (11:48 +0000)] 
Minor configure script doc tweaks. This is also a note that the basic elements of the build run as-is on Haiku OS Beta 5 but the tcl bits do not (for lack of tclConfig.sh).

FossilOrigin-Name: acf9babf0efc346b26c8ac02c0bd973498bf1604b47fe320de14027f9b21ed33

13 months agoEnsure that detection of control characters by comparison against 0x1f
drh [Sun, 2 Mar 2025 20:29:49 +0000 (20:29 +0000)] 
Ensure that detection of control characters by comparison against 0x1f
uses unsigned characters. [forum:/forumpost/4c344ca61f|Forum post 4c344ca61f].

FossilOrigin-Name: b7c5ce84216cc7f5a3ba07404572edb94fd628b3a7421111cd5f5333f3e56ea8

13 months agoUse SQLITE_EXTRA_INIT_MUTEXED instead of SQLITE_EXTRA_INIT for the SQLITE_WASM_EXTRA_...
stephan [Sat, 1 Mar 2025 23:44:11 +0000 (23:44 +0000)] 
Use SQLITE_EXTRA_INIT_MUTEXED instead of SQLITE_EXTRA_INIT for the SQLITE_WASM_EXTRA_INIT feature, as suggested in [forum:14183b98fc0b1dea|forum post 14183b98fc0b1dea]. This doesn't make a functional difference now - this is in the name of future-proofing against eventual threading support in wasm.

FossilOrigin-Name: 46479c2e30b9676e0fa8da117ba67f673671fb340c9bea38ece19a1b2371a57b