]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
10 months agoRemove stray tab characters from source files.
drh [Mon, 19 May 2025 12:46:08 +0000 (12:46 +0000)] 
Remove stray tab characters from source files.

FossilOrigin-Name: 298ff5a1dc5dbccaf6acd91731044f478a5ce522745332801708ceee996b01e6

10 months agoFix a harmless comment typo
drh [Mon, 19 May 2025 12:34:11 +0000 (12:34 +0000)] 
Fix a harmless comment typo

FossilOrigin-Name: c4d25acec3c1e28e5a4664a74c263cc0d00e118a6db4b26b51cb0d42d0f2b26f

10 months agoAdjust the tool/warnings.sh script so that it works on the latest versions
drh [Mon, 19 May 2025 11:08:30 +0000 (11:08 +0000)] 
Adjust the tool/warnings.sh script so that it works on the latest versions
of clang on Mac.

FossilOrigin-Name: 05a3dd9a179193d00968329152c8ffe6532f0cbdad7d19b47af32aebc0cd0d9e

11 months agoLatest teaish pieces, most significantly for tcl portability fixes. Move autoconf...
stephan [Sat, 17 May 2025 11:06:02 +0000 (11:06 +0000)] 
Latest teaish pieces, most significantly for tcl portability fixes. Move autoconf/teaish/autosetup/... to autosetup/teaish/. to simplify maintenance and deployment via the autoconf bundle.

FossilOrigin-Name: 381d3e82e831bedee56108fb585880d802c4d7d50b0804d909a33ff15a3be185

11 months agoMinor tcl doc update. tea-cleanups
stephan [Sat, 17 May 2025 10:35:11 +0000 (10:35 +0000)] 
Minor tcl doc update.

FossilOrigin-Name: 43259e8c3fab13b4597cdd1c670df00ec756a6fefdeb7d4ba2e0644e4ad47113

11 months agoRename feature-tests.tcl to feature.tcl. Haiku tcl portability fixes.
stephan [Sat, 17 May 2025 10:32:48 +0000 (10:32 +0000)] 
Rename feature-tests.tcl to feature.tcl. Haiku tcl portability fixes.

FossilOrigin-Name: 15bd9e581a6d6ebe281b091adc04dca4d1c7fa9bbb582bcbab8c401b4f976753

11 months agoLatest upstream teaish pieces for minor fixes. Restructure this copy of teaish to...
stephan [Sat, 17 May 2025 07:02:06 +0000 (07:02 +0000)] 
Latest upstream teaish pieces for minor fixes. Restructure this copy of teaish to simplify maintenance and the autoconf bundle build.

FossilOrigin-Name: 2b8d9b75ec5fe96cb5d06a3464fd4eb9a53018b7b548fedcd6cdbc46cdb55bdc

11 months agoImproved version of the previous check-in.
drh [Fri, 16 May 2025 18:19:11 +0000 (18:19 +0000)] 
Improved version of the previous check-in.

FossilOrigin-Name: 036c97e36cb36a2ac765a8e8539433dcb63f69155d4c24857f84faa44eed6eb5

11 months agoFix the optimization of check-in [663f5dd32d9db832] that strives to avoid
drh [Fri, 16 May 2025 17:30:20 +0000 (17:30 +0000)] 
Fix the optimization of check-in [663f5dd32d9db832] that strives to avoid
duplicate compuations in the GROUP BY clause so that it works even if the
GROUP BY term is a subquery on the RHS of a LEFT JOIN.  Problem found
by dbsqlfuzz.  Test cases in TH3.

FossilOrigin-Name: 955a026996b93e530ca5b566689cc646b31d3b9b5a5837897a58452d70f6d942

11 months agoAdd the --enablefk option to the "changeset apply" command of the
drh [Thu, 15 May 2025 18:50:19 +0000 (18:50 +0000)] 
Add the --enablefk option to the "changeset apply" command of the
changeset program.

FossilOrigin-Name: e98d46d436f8d251ae0da5ee85fd856aca3b57cd48d1be31fa6ca88fe72cad00

11 months agoEnhance the "changeset" utility program with new command-line options for
drh [Thu, 15 May 2025 17:33:32 +0000 (17:33 +0000)] 
Enhance the "changeset" utility program with new command-line options for
the "changeset apply" command.

FossilOrigin-Name: 428daca4f1b3e1a33b7e2f5acf114fa6136d46555e9947e2e88ea107bfec5e4f

11 months agoRework the showHelp() function in the CLI implementation so that its
drh [Thu, 15 May 2025 11:20:54 +0000 (11:20 +0000)] 
Rework the showHelp() function in the CLI implementation so that its
purpose and operation are well described by the header commit.  Omit
the use of enums that cause issues for MSVC 2025.

FossilOrigin-Name: 336ceeccc6f85bd78f4a26648af7edf9056d569a767b4120f125a02b2090a349

11 months agoBack out the "low-quality index" query planner hack of check-in
drh [Wed, 14 May 2025 16:40:05 +0000 (16:40 +0000)] 
Back out the "low-quality index" query planner hack of check-in
[bcac937526d9a6ef].  Subsequent query planner enhancements for dealing
with star-queries make that change unnecessary and the change was recently
found to cause a performance regression in an unrelated query.
Also fix a typo in a debugging message.

FossilOrigin-Name: e7dcf25efae364b7cdf9eb8265803c816c8b8557e4a7684da428badc6ffb3875

11 months agoFix trunk fork.
drh [Tue, 13 May 2025 19:06:11 +0000 (19:06 +0000)] 
Fix trunk fork.

FossilOrigin-Name: 53644c42c5ee40e905a72bb014515e5e30265577d543eeca09139800822b5b42

11 months agoAdjust the strftime() test in test/date4.test to remove flags not supported in musl...
stephan [Tue, 13 May 2025 18:58:56 +0000 (18:58 +0000)] 
Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected.

FossilOrigin-Name: fc254c1eb784c79a371bf961945a18a680982cdcd3fdcd7e6bb481712fe21cf8

11 months agoFirst cut at enhancing the fsdir virtual table so that it works with
drh [Tue, 13 May 2025 16:58:36 +0000 (16:58 +0000)] 
First cut at enhancing the fsdir virtual table so that it works with
unicode characters on Windows.

FossilOrigin-Name: c9e04dadfdf6c860631ce5603693add565ff2033aa25af5736302af7045fc91e

11 months agoOmit the unused readdir_r() routine from test_windirent.c
drh [Tue, 13 May 2025 15:09:13 +0000 (15:09 +0000)] 
Omit the unused readdir_r() routine from test_windirent.c

FossilOrigin-Name: f9a216e3ad1b3bc9be350aad5ef3dc8b3534d3ee67d160bfedda81a61295320c

11 months agoSession extension doc typo fix reported in [forum:75e9408acb|forum post 75e9408acb].
stephan [Mon, 12 May 2025 19:12:50 +0000 (19:12 +0000)] 
Session extension doc typo fix reported in [forum:75e9408acb|forum post 75e9408acb].

FossilOrigin-Name: b96cfff52b4f364388f168198e999ae2407c4afbc7b020f8bb350ab103ffb55c

11 months agoFix a coding mistake in vfstrace.
drh [Mon, 12 May 2025 11:48:39 +0000 (11:48 +0000)] 
Fix a coding mistake in vfstrace.

FossilOrigin-Name: f0054cc0bce4ed735796da1ea68b7773a582042bdd60fdae4e1af4c592104d15

11 months agoRemove a redundant typedef from the sqlite3_rsync.c source file.
drh [Sun, 11 May 2025 10:48:10 +0000 (10:48 +0000)] 
Remove a redundant typedef from the sqlite3_rsync.c source file.

FossilOrigin-Name: b4c37c6bcc644e21a29955e31151ea22a07627e524ce913afd3d2d6eeb7e0bb6

11 months agoProvide the SQLITE_BUG_COMPATIBLE_20250510 compile-time option that restores
drh [Sat, 10 May 2025 17:09:53 +0000 (17:09 +0000)] 
Provide the SQLITE_BUG_COMPATIBLE_20250510 compile-time option that restores
the JSON5 bug fixed in the previous check-in, in case some applications need
it for legacy compatibility.

FossilOrigin-Name: 491cf31904fdbc9567b838d1ba27901e75f8ea3a117043017d08354bb09f9711

11 months agoAdd enforcement of the obscure JSON5 syntax rule that the \0 escape
drh [Sat, 10 May 2025 15:53:17 +0000 (15:53 +0000)] 
Add enforcement of the obscure JSON5 syntax rule that the \0 escape
sequence must not be followed by a digit.
[forum:/forumpost/c061e87faf7d1c55|Forum post c061e87faf].

FossilOrigin-Name: 83c7477f2b9b0d6cb54cf6b14bf3c8ef4807e4bddc7986d275cf6717da8606b7

11 months agoFix PRAGMA trusted_schema=OFF and similar so that it restricts the kinds
drh [Thu, 8 May 2025 16:18:18 +0000 (16:18 +0000)] 
Fix PRAGMA trusted_schema=OFF and similar so that it restricts the kinds
of functions in CHECK constraints that the documentation says it does.  It
was letting through some function that it ought not have.  This is a
defect in [5720924cb07766cd].  See
[forum:/forumpost/3fa9d44c0b381342|forum thread 2025-05-08T08:50Z].
Additional test cases will be added separately.

FossilOrigin-Name: 25920beebf71ebc9a1bb9f56932280c9e03390f26fe9da2258f950979b238ce6

11 months agoInternal doc typo fix. No code changes.
stephan [Thu, 8 May 2025 13:51:55 +0000 (13:51 +0000)] 
Internal doc typo fix. No code changes.

FossilOrigin-Name: ac2aa39f7e3ae7ac921fac6566186939a1282f80ced5b3e3d5006a77ecf583ff

11 months agoFix a harmless warning about and oversize shift operation on malformed JSONB
drh [Wed, 7 May 2025 17:13:30 +0000 (17:13 +0000)] 
Fix a harmless warning about and oversize shift operation on malformed JSONB
inputs.  [https://issues.oss-fuzz.com/issues/415850463|OSSFuzz 415850463].

FossilOrigin-Name: cf8b55b3b6f0b73158e21731a206d5a8d8d9892989d91171a11c6dbbee34b338

11 months agoAdd test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix.
dan [Tue, 6 May 2025 17:56:32 +0000 (17:56 +0000)] 
Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix.

FossilOrigin-Name: 6eb2939a6093c0796910645172d80c53055559dd57c012f1dc815d89fbf84447

11 months agoFix a bug in the NOT NULL/IS NULL optimization of check-in [cb94350185f555c3]
drh [Tue, 6 May 2025 17:53:27 +0000 (17:53 +0000)] 
Fix a bug in the NOT NULL/IS NULL optimization of check-in [cb94350185f555c3]
that can cause invalid data to be used for a column if that column has a
CHECK constraint that includes the NOT NULL or IS NULL operator.
Problem discovered by the
[https://issues.chromium.org/issues/415397143|Chromium fuzzer].  Never
seen in the wild, as far as anybody knows.

FossilOrigin-Name: 2adaee9aa90f280a406007695fbc4a314806584c93d6b62b46c031492b31ec27

11 months agoFix the sqlite3VdbeTypeofColumn() function so that it works correctly
drh [Tue, 6 May 2025 16:28:44 +0000 (16:28 +0000)] 
Fix the sqlite3VdbeTypeofColumn() function so that it works correctly
even when SQLITE_DEBUG is defined.

FossilOrigin-Name: 1d5021533ed688d7a815ce75b338c72f577c14554027f88a21419935a9e68239

11 months agoFix console-I/O on Windows for DEBUG=3 builds. Broken by
drh [Tue, 6 May 2025 15:39:39 +0000 (15:39 +0000)] 
Fix console-I/O on Windows for DEBUG=3 builds.  Broken by
[925e97e6f4238f02].

FossilOrigin-Name: ccef4f7058928943be9204b2e53baaf791021e78e538396ba9f2a1d76323e8cf

11 months agoEnhance sqlite3_rsync so that if the first attempt to invoke a copy
drh [Sat, 3 May 2025 15:17:21 +0000 (15:17 +0000)] 
Enhance sqlite3_rsync so that if the first attempt to invoke a copy
of itself on the remote system using ssh fails, try again after
augmenting the PATH.  This enables sqlite3_rsync to work without the
--exe option when the remote system is a Mac.

FossilOrigin-Name: 38d4c94d8c7802101ef3bfb411002f9497fdbbbd2b4d3514cef5b76ffd66f75b

11 months agoFix a harmless redundant variable declaration in sqlite3_rsync.
drh [Sat, 3 May 2025 10:55:47 +0000 (10:55 +0000)] 
Fix a harmless redundant variable declaration in sqlite3_rsync.

FossilOrigin-Name: f8f15eff6ae50d569ed13a3b18f33eaa43453c0cb80b6007df38e880b62f45d0

11 months agoAddition summary results output when using -vvv on sqlite3_rsync.
drh [Sat, 3 May 2025 10:49:39 +0000 (10:49 +0000)] 
Addition summary results output when using -vvv on sqlite3_rsync.

FossilOrigin-Name: c702999cfac37fdcae64d261408e58d1f49fee65434fe346db6a2a6c7f8ac54e

11 months agoPromote the --protocol option to sqlite3_rsync from being an undocumented
drh [Sat, 3 May 2025 10:35:32 +0000 (10:35 +0000)] 
Promote the --protocol option to sqlite3_rsync from being an undocumented
debug option to being a supported and user-visible option.  This is
sometimes needed to work around bugs in prior versions running on the
remote.

FossilOrigin-Name: 4855e04e44e8fce2d6e37dd468eb6e9f4565c36cbc964156e65ac0449d7c212f

11 months agoEnhance sqlite3_rsync (in a backwards-compatible way) so that it has the
drh [Sat, 3 May 2025 08:17:46 +0000 (08:17 +0000)] 
Enhance sqlite3_rsync (in a backwards-compatible way) so that it has the
ability to send hashes for blocks of pages in addition to individual pages.
By judicious use of this capability, network bandwidth requirement to sync two
similar databases is reduced.

FossilOrigin-Name: e5d87aaa8fe1e8c8cb63813d26851183e77809a3d36e4c16c37f88b4b4724d6d

11 months agoImprovements to protocol negotiation. faster-rsync
drh [Sat, 3 May 2025 07:00:51 +0000 (07:00 +0000)] 
Improvements to protocol negotiation.

FossilOrigin-Name: 4f5a06e42010c3e047429f736ffb8e2e89a1eb599277c176945b57710f6713ca

11 months agoClean up command-line parsing. Add the undocumented
drh [Fri, 2 May 2025 23:50:30 +0000 (23:50 +0000)] 
Clean up command-line parsing.  Add the undocumented
-protocol option for debugging.

FossilOrigin-Name: 2a52b174e6e91cd7cfca0b20b39cdd231f377c7bc073f4223574556b94b16aa5

11 months agoNow appears to be working. More testing needed. Refinement of the
drh [Fri, 2 May 2025 22:25:40 +0000 (22:25 +0000)] 
Now appears to be working.  More testing needed.  Refinement of the
version-2 algorithm needed.

FossilOrigin-Name: cb035181d9fb5909696b8ec8f9c3eeb7a7dfb4b50e82e1d3f2d5ad150afcc0ff

11 months agoBug fixes. Added new debugging features to better visualize the
drh [Fri, 2 May 2025 18:32:46 +0000 (18:32 +0000)] 
Bug fixes.  Added new debugging features to better visualize the
protocol.

FossilOrigin-Name: c70330668690e7c3c55ae34137d5b2c91871432004b82b2b23a89fc3f1322a62

11 months agoThis is the start of an experiment in getting sqlite3_rsync to use less
drh [Fri, 2 May 2025 17:39:21 +0000 (17:39 +0000)] 
This is the start of an experiment in getting sqlite3_rsync to use less
bandwidth when the two databases are very similar, by sending hashes
over blocks of pages initially, rather than over individual pages, then
requesting more detail when hashes do not match.

FossilOrigin-Name: 266b4b8f0104bd4b1cff87ed78b0223006bf661a9650294a2b330d50c7ee8a0c

11 months agoDo not allow sqlite3_rsync to convert the replica from WAL-mode into
drh [Fri, 2 May 2025 11:18:09 +0000 (11:18 +0000)] 
Do not allow sqlite3_rsync to convert the replica from WAL-mode into
DELETE-mode, as that can disrupt existing clients on the replica side.
DELETE-mode to WAL-mode conversions are allowed, however.  See
[forum:/forumpost/6b575b66156673ee|forum thread 6b575b66156].

FossilOrigin-Name: 660a035b6ce6684d429b882133e032181cc1664f4efadf1bc0e4ae27d45071c4

11 months agoEnhance sqlite3_rsync so that, by default, it will sync non-WAL-mode
drh [Thu, 1 May 2025 18:07:27 +0000 (18:07 +0000)] 
Enhance sqlite3_rsync so that, by default, it will sync non-WAL-mode
database files.  Add a new command-line option --wal-only that restricts
the sync to WAL-mode databases only (the former default).  Improve
command-line option parsing so that only a single "-" is required before
each option.

FossilOrigin-Name: 4b53603fe468c0c28b818762917e41bdd870de6d4cc143688f1cdea3136c81a4

11 months agoAllow sqlite3_rsync to work on non-WAL-mode databases, as long as the rsync-non-wal-mode
drh [Thu, 1 May 2025 16:07:52 +0000 (16:07 +0000)] 
Allow sqlite3_rsync to work on non-WAL-mode databases, as long as the
--wal-only flag is not used.

FossilOrigin-Name: e4126dcd1eba4f040a7c07102d34692287b74b41a3437a3b9d15c4f8c9d4e6fd

11 months agoFix a harmless problem in the CLI in which SQL errors that occur during
drh [Wed, 30 Apr 2025 14:37:00 +0000 (14:37 +0000)] 
Fix a harmless problem in the CLI in which SQL errors that occur during
the ".schema" command are properly ignored, yes still appear in the ".log"
output. [forum:/forumpost/42fe6520b803be51|Forum post 42fe6520b8]

FossilOrigin-Name: 20abf1ec107f942e4527901685d61283c9c2fe7bcefad63dbf5c6cbf050da849

11 months agoFix an issue in Bloom filters on RHS subsqueries to IN operators.
drh [Wed, 30 Apr 2025 12:48:20 +0000 (12:48 +0000)] 
Fix an issue in Bloom filters on RHS subsqueries to IN operators.
See [forum:/forumpost/792a09cb3df9e69f|forum post 792a09cb3d] for
a description of the problem.  Also improve comments related
to [baa83b460c677c21] which was origin of the problem.

FossilOrigin-Name: cdef486e212fe4b26605065d9cff08f608cb80df48ee64e4be63637769bdfacc

11 months agoUpstream teaish for a tcl portability fix on Haiku and a much nicer impl of proj...
stephan [Tue, 29 Apr 2025 17:30:51 +0000 (17:30 +0000)] 
Upstream teaish for a tcl portability fix on Haiku and a much nicer impl of proj-tclConfig-sh-to-autosetup.

FossilOrigin-Name: ca0d30a43b3dfb95dd6b491f592031a053b0b5e95361ffe01ec8bd56d5e2d110

11 months agoRemove the run-fuzzcheck makefile targets, since testrunner now
drh [Tue, 29 Apr 2025 16:30:58 +0000 (16:30 +0000)] 
Remove the run-fuzzcheck makefile targets, since testrunner now
accomplishes that for us, and does a better job of it.

FossilOrigin-Name: 3ffd867ed31cd0779aa92b5e8b71592a8e7224977f9da8e5d6793a78bbb80070

11 months agoAdd the "--fuzzdb FILENAME" to testrunner.tcl as an alternative to setting
drh [Tue, 29 Apr 2025 14:23:21 +0000 (14:23 +0000)] 
Add the "--fuzzdb FILENAME" to testrunner.tcl as an alternative to setting
the FUZZDB environment variable (as that can be awkward to do on Windows).
Further improvements to the testrunner.tcl documentation.

FossilOrigin-Name: 6fb84156a262ff89d1a2d1df6fbfac4c1a43fb55b9d15205508662e2c9b0894f

11 months agoUpdate testrunner.tcl documentation. Fix typo in testrunner.tcl output.
drh [Tue, 29 Apr 2025 11:35:51 +0000 (11:35 +0000)] 
Update testrunner.tcl documentation.  Fix typo in testrunner.tcl output.

FossilOrigin-Name: ba8800b4ba0a690c89d9fb96bb9a0d8789d04160ff9c47ea9afb2b403bec7f0b

11 months agoImproved --explain display of FUZZDB test plans in testrunner.tcl.
drh [Tue, 29 Apr 2025 10:41:16 +0000 (10:41 +0000)] 
Improved --explain display of FUZZDB test plans in testrunner.tcl.

FossilOrigin-Name: 42bdd7262ec4f8163263e0535c2cc35b526754d77e1f3ccf5b73b0f44d470d9c

11 months agoDo not run FUZZDB on either Windows-Memdebug or Windows-Win32Heap.
drh [Tue, 29 Apr 2025 10:29:35 +0000 (10:29 +0000)] 
Do not run FUZZDB on either Windows-Memdebug or Windows-Win32Heap.

FossilOrigin-Name: 10d8401d59136dda7051af0da398b06a18031560f2734f4fa347d339765d2089

11 months agoMake testrunner.tcl more restrictive about which configurations run
drh [Tue, 29 Apr 2025 01:37:31 +0000 (01:37 +0000)] 
Make testrunner.tcl more restrictive about which configurations run
fuzzcheck-asan and fuzzcheck-ubsan.

FossilOrigin-Name: 785599394dde0fb36ae2e07d611f9523a05a0817dbd8c416582b3b682dbfa4ff

11 months agoTestrunner.tcl now runs fuzzcheck-asan and fuzzcheck-ubsan tests.
drh [Mon, 28 Apr 2025 19:15:46 +0000 (19:15 +0000)] 
Testrunner.tcl now runs fuzzcheck-asan and fuzzcheck-ubsan tests.

FossilOrigin-Name: 3d8f3a255843c063157265702b76d40c38c774d29d658eea2d77efac92ac8789

11 months agoIf the FUZZDB environment variable is set when running testrunner.tcl and
drh [Mon, 28 Apr 2025 17:56:23 +0000 (17:56 +0000)] 
If the FUZZDB environment variable is set when running testrunner.tcl and
that env-var points to a fuzzcheck database, then suppliment the fuzzcheck
tests with that extra database.

FossilOrigin-Name: c08530dd6a71cb547d164e2313657c917f280e7988211bf199c8776e78a4e2a6

11 months agoEnhance testrunner.tcl so that it does not build testfixture unnecessarily -
drh [Mon, 28 Apr 2025 16:28:00 +0000 (16:28 +0000)] 
Enhance testrunner.tcl so that it does not build testfixture unnecessarily -
if the pattern does not match any TCL test.

FossilOrigin-Name: 896d767f1cba64bda7b91b0daebd60ebe4457a58d762da443bf61cf5b39ad2d9

11 months agoFix testrunner.tcl so that it honors pattern matches in non-testfixture
drh [Mon, 28 Apr 2025 16:17:17 +0000 (16:17 +0000)] 
Fix testrunner.tcl so that it honors pattern matches in non-testfixture
tests, such as fuzzcheck and sessionfuzz.

FossilOrigin-Name: 81857474fe90f50b760c22d61a6ad477642dabe1052390cd1614dcec8adb1376

11 months agoRemove a stray blank line from the test/testrunner.tcl script.
drh [Mon, 28 Apr 2025 15:00:28 +0000 (15:00 +0000)] 
Remove a stray blank line from the test/testrunner.tcl script.

FossilOrigin-Name: 7d6005b0d17d86d72757f3578872e82fd12f61ac9160a0277e397df09f6338a9

11 months agoRemove long-obsolete performance testing scripts from the tools/ folder.
drh [Mon, 28 Apr 2025 13:32:46 +0000 (13:32 +0000)] 
Remove long-obsolete performance testing scripts from the tools/ folder.
The test/speedtest.tcl script is what should be used these days.  This
is just cruft clean-up.

FossilOrigin-Name: 956af8c294ae5b826a5b645922df07dad360290d19bf2b6a7f74d0a783a3e692

11 months agotea: pull in upstream teaish. Consolidate the build definition from the upstream...
stephan [Mon, 28 Apr 2025 09:25:19 +0000 (09:25 +0000)] 
tea: pull in upstream teaish. Consolidate the build definition from the upstream build and this one to ease maintenace. Improve compatibility with historical TEA usage of --with-tcl=... (it insists on a /lib suffix for that path).

FossilOrigin-Name: 0ea5993dd8549056d73f3d5447e0a810495ece23a75be8add78fba6842125d85

11 months agoproj.tcl: correct the auto-reconfigure rules to include any X=Y passed to configure...
stephan [Sun, 27 Apr 2025 06:01:26 +0000 (06:01 +0000)] 
proj.tcl: correct the auto-reconfigure rules to include any X=Y passed to configure. Improve handling of quoted CFLAGS.

FossilOrigin-Name: 7a2f4f319c90b768c6acc96671a3173c0ef0493180f3c4d5443f1ca03d92f6b4

11 months agoautoconf/tea: the default value of --threadsafe=X is now based on a pkgconfig query...
stephan [Sun, 27 Apr 2025 04:21:27 +0000 (04:21 +0000)] 
autoconf/tea: the default value of --threadsafe=X is now based on a pkgconfig query using the target tclsh, which is much more reliable than grepping Tcl's linker flags. Doc touchups.

FossilOrigin-Name: 4aeec30443b282f10353cdb9415fdce436287280f0f5d5d6b9917da831744898

11 months agoFix an off-by-one error in an assert(), discovered by oss-fuzz. This is a
drh [Fri, 25 Apr 2025 12:39:32 +0000 (12:39 +0000)] 
Fix an off-by-one error in an assert(), discovered by oss-fuzz.  This is a
harmless error in as much as assert()s are disabled in production builds, and
because the off-by-one only occurs on nonsensical CREATE INDEX statements.

FossilOrigin-Name: 3e627d66ebdef8dfe41bd12a0474d1afca9f50051771774679d25bd1833e69ae

11 months agoTeaish internal API tweaks and ensure that -encoding utf-8 is used when source'ing...
stephan [Fri, 25 Apr 2025 11:27:13 +0000 (11:27 +0000)] 
Teaish internal API tweaks and ensure that -encoding utf-8 is used when source'ing test scripts.

FossilOrigin-Name: f878f578f8fac95a939e3eabe8b64d5627d2ccd98de1e28081b9bca42ffee027

11 months agoUpstream teaish fixes and improvements.
stephan [Wed, 23 Apr 2025 14:54:13 +0000 (14:54 +0000)] 
Upstream teaish fixes and improvements.

FossilOrigin-Name: 235ea2c0e1823fe4324c3890069a9131ebb6de14e55eb56c0e9f42a7e491a699

11 months agoFix a problem in the fts5matchinfo.test file that prevented it from
drh [Tue, 22 Apr 2025 18:45:40 +0000 (18:45 +0000)] 
Fix a problem in the fts5matchinfo.test file that prevented it from
working on Mac.

FossilOrigin-Name: 5a411c609ba0ee17b1ce5bd0b40b9ded92d76f35933f92b2e02a58a3f169c715

11 months agoLatest upstream jimtcl to fix rare segfault cases.
stephan [Tue, 22 Apr 2025 09:29:53 +0000 (09:29 +0000)] 
Latest upstream jimtcl to fix rare segfault cases.

FossilOrigin-Name: b6c5516940851bd17706435148253325d1b912a44ae138d2b8ca33e5167418c7

11 months agoGeneric cleanups and fixes in the teaish build.
stephan [Tue, 22 Apr 2025 01:01:19 +0000 (01:01 +0000)] 
Generic cleanups and fixes in the teaish build.

FossilOrigin-Name: 734823a5a8e073b511ebc3f37df3542c1bb734b9b1e1bd50ca3e9df12c4bb89e

11 months agoRemove an extra conditional that was inserted earlier today and which
drh [Mon, 21 Apr 2025 23:44:55 +0000 (23:44 +0000)] 
Remove an extra conditional that was inserted earlier today and which
is unreachable.

FossilOrigin-Name: 5ea56af2d27611c5a8ea275316d21a02e70032f93243549ae776e9a89edc6229

11 months agoFurther improvements to the decision of whether or not a BLOB input
drh [Mon, 21 Apr 2025 20:58:49 +0000 (20:58 +0000)] 
Further improvements to the decision of whether or not a BLOB input
is JSONB.

FossilOrigin-Name: 6538813cb89f6109727481e29633e2e98f98e0257c58695e3b53e8ce237d9195

11 months agoDo a better job of providing bug compatibility with SQLite 3.44.0. See
drh [Mon, 21 Apr 2025 19:53:12 +0000 (19:53 +0000)] 
Do a better job of providing bug compatibility with SQLite 3.44.0.  See
[forum:/forumpost/07e206fcd6|forum thread 07e206fcd6] for background.

FossilOrigin-Name: 614d061b32c3bdf4825323d6f8e8a98624e4eeeb96dd442d8e365527122ed3bc

11 months agoUpdate to comments in sqlite3session.h.
dan [Sat, 19 Apr 2025 20:08:04 +0000 (20:08 +0000)] 
Update to comments in sqlite3session.h.

FossilOrigin-Name: ea9acb5573f4d71a314e4467d30477a1d01c8db648985750a42b3c047f404c9c

11 months agoAdd an appropriate _declspec to the declaration of the sqlite3_dbdata_init()
drh [Fri, 18 Apr 2025 14:47:56 +0000 (14:47 +0000)] 
Add an appropriate _declspec to the declaration of the sqlite3_dbdata_init()
function in the recovery extension.

FossilOrigin-Name: 00313d15270b36fce44f7784c97ddc42517e23c209c1ccc4d814ef06b11528c0

12 months agoUpstream teaish, which simplifies how extension metadata are initialized and shrinks...
stephan [Thu, 17 Apr 2025 19:41:37 +0000 (19:41 +0000)] 
Upstream teaish, which simplifies how extension metadata are initialized and shrinks proj.tcl by 4k.

FossilOrigin-Name: c72c00d34d70b36f847af19a2382299746448b5dd94a616f6b567389c5694c17

12 months agoWhen logging errors using sqlite3_log() and the error text includes the
drh [Thu, 17 Apr 2025 19:01:54 +0000 (19:01 +0000)] 
When logging errors using sqlite3_log() and the error text includes the
text of an SQL statement, but the SQL statement text at the end so that if
the error message buffer overflows it is the SQL statement text that gets
truncated, not the statement of the problem.

FossilOrigin-Name: de0968226effb79f9d25539da7882fa5475e4ff2410870b45a63a6545deb5979

12 months agoIncrease the size of the output buffer for sqlite3_log().
drh [Thu, 17 Apr 2025 17:46:28 +0000 (17:46 +0000)] 
Increase the size of the output buffer for sqlite3_log().

FossilOrigin-Name: a64e8491c9863f890daa9f5d8f678728dc0d00bc1f3c238b50214ec545450fcf

12 months agoAdd docs explaining how to test the teaish build.
stephan [Wed, 16 Apr 2025 22:25:02 +0000 (22:25 +0000)] 
Add docs explaining how to test the teaish build.

FossilOrigin-Name: b53619ddb74fa250f03564d04e732248b4161d4d10d6f02268b7c95382d110ff

12 months agoLatest upstream teaish. Most notably it adds the ability for the extension to specify...
stephan [Wed, 16 Apr 2025 21:53:01 +0000 (21:53 +0000)] 
Latest upstream teaish. Most notably it adds the ability for the extension to specify a minimum Tcl version, and this build now enforces a minimum Tcl of 8.6.

FossilOrigin-Name: c86315e538f4d75161faa72673927cde8be080c983f04a98491d1add14615038

12 months agoUpdate doc/tcl-extension-testing.md for Unix systems, consolidating the Tcl 8.x and...
stephan [Wed, 16 Apr 2025 17:47:16 +0000 (17:47 +0000)] 
Update doc/tcl-extension-testing.md for Unix systems, consolidating the Tcl 8.x and 9.x sections.

FossilOrigin-Name: c4c5dcb79c57f6e38cfe9b68b00e60e42d03ef30aeaefc5bf9dafed994849e1d

12 months agoAttempt to provide EBCDIC translations to the tables in the JSON
drh [Wed, 16 Apr 2025 17:36:26 +0000 (17:36 +0000)] 
Attempt to provide EBCDIC translations to the tables in the JSON
implementation.  The SQLite developers do not have access to any
computers using EBCDIC and so have no way to test this patch, and
cannot vouch for its accuracy.

FossilOrigin-Name: 84e698f38429c142caaa66ac086410f2035691b2ad39ad2fc4e0ebc31dd58a5b

12 months agoChange the target libdir name in the teaish build to match historical tea builds.
stephan [Wed, 16 Apr 2025 15:40:40 +0000 (15:40 +0000)] 
Change the target libdir name in the teaish build to match historical tea builds.

FossilOrigin-Name: 8ae437301ed0cf71ef0e07be07917d9702221d27bdc98491209d8f28c7a500e2

12 months agoA portability fix for proj.tcl: some Tcl builds do not like (array set x $someArray...
stephan [Wed, 16 Apr 2025 14:21:48 +0000 (14:21 +0000)] 
A portability fix for proj.tcl: some Tcl builds do not like (array set x $someArray). Also better --mandir handling on Haiku (where the former problem was found).7

FossilOrigin-Name: 849534499d9b2056c0eabef7f3e65f79f58e8a6fefb3f7603de44774da7166b5

12 months agoLatest upstream teaish for fixes and improvements.
stephan [Wed, 16 Apr 2025 12:48:27 +0000 (12:48 +0000)] 
Latest upstream teaish for fixes and improvements.

FossilOrigin-Name: 8f9148b33e01aa7963140704ef16e4304799e5842fa60e55373ccdabe8e3616d

12 months agoCorrectly handle the case of a multi-column UNIQUE constraint that contains
drh [Tue, 15 Apr 2025 21:59:38 +0000 (21:59 +0000)] 
Correctly handle the case of a multi-column UNIQUE constraint that contains
the ROWID as one of it columns, and then the columns of that UNIQUE are
used in a row-value IN operator as a WHERE clause constraint.  Reported by
[forum:/forumpost/b9647a113b465950|forum post b9647a113b].  Problem
introduced by [723f1be3d4a905a6], part of ticket [da78413751863].

FossilOrigin-Name: d22475b81c4e26ccc50f3b5626d43b32f7a2de34e5a764539554665bdda735d5

12 months agoFix a minor typo in a code comment.
drh [Tue, 15 Apr 2025 19:53:36 +0000 (19:53 +0000)] 
Fix a minor typo in a code comment.

FossilOrigin-Name: 158e8c4fd7bdfc1cd4c0135abecd0d00994cd4027cf74ce6e5cf73d76475ae95

12 months agoCleanups and refactoring in proj.tcl and teaish.
stephan [Tue, 15 Apr 2025 15:20:30 +0000 (15:20 +0000)] 
Cleanups and refactoring in proj.tcl and teaish.

FossilOrigin-Name: 6b7ca8176e8c1b5e99e177c3daaba47b0674fa2f82d91754e7a8f66460ca8419

12 months agoAvoid a potential integer overflow in non-default builds of the fts3 matchinfo()...
dan [Tue, 15 Apr 2025 11:06:37 +0000 (11:06 +0000)] 
Avoid a potential integer overflow in non-default builds of the fts3 matchinfo() function.

FossilOrigin-Name: aecc0100cef3ea83feed558dbe34dd6313721fa54052ee1ed529741cec8cacda

12 months agoFurther cleanups and code consolidation between teaish.tcl and sqlite-config.tcl...
stephan [Tue, 15 Apr 2025 02:02:36 +0000 (02:02 +0000)] 
Further cleanups and code consolidation between teaish.tcl and sqlite-config.tcl parts.

FossilOrigin-Name: 07e9ceee51380ee25e580178fa82030be5d2b65d4f4b4dc86c94b21f7f04f291

12 months agoSlight simplifications in the teaish build.
stephan [Tue, 15 Apr 2025 00:47:31 +0000 (00:47 +0000)] 
Slight simplifications in the teaish build.

FossilOrigin-Name: 6b2d0e09e4806b5731764192782ec7e1ad595c529202a684d23bcfe2fae559d7

12 months agoUpdate teaish to the latest upstream copy. Move some of its utility code into proj...
stephan [Mon, 14 Apr 2025 23:52:11 +0000 (23:52 +0000)] 
Update teaish to the latest upstream copy. Move some of its utility code into proj.tcl for reuse in the top-level configure bits.

FossilOrigin-Name: 921c5ea76925be911222ac5f2887b8a967ff47b1aa43e196231e6168a3f9cb88

12 months agoImproved estimate on the number of output rows in a recursive common table expression
drh [Mon, 14 Apr 2025 19:43:30 +0000 (19:43 +0000)] 
Improved estimate on the number of output rows in a recursive common table expression
that uses the UNION operator.  Follow-up to [f911f1c4977fbcae] and it's output row
estimate changes associated with DISTINCT queries.

FossilOrigin-Name: 92513f6bce7ecc778e78af3a77bc66ff65585fffa2e3138f8acb9e617121eeb0

12 months agoJNI: part 3 (of 3) of typos and Java style tweaks suggested in [forum:99ac7961d82f57f...
stephan [Mon, 14 Apr 2025 13:31:18 +0000 (13:31 +0000)] 
JNI: part 3 (of 3) of typos and Java style tweaks suggested in [forum:99ac7961d82f57f3|forum post 99ac7961d82f57f3]. Tested with jdk v8 and v21.

FossilOrigin-Name: 914d4c9d6c26536ca14be80eee6c54af4311eac6bf88b327738075275f4b77da

12 months agoJNI: part 2 of typos and Java style tweaks suggested in [forum:99ac7961d82f57f3|forum...
stephan [Mon, 14 Apr 2025 12:09:24 +0000 (12:09 +0000)] 
JNI: part 2 of typos and Java style tweaks suggested in [forum:99ac7961d82f57f3|forum post 99ac7961d82f57f3].

FossilOrigin-Name: 5e6e9aee5b43e6ae98e78293a0da30e82ad18c3c9c03fc6298240233ddadb2a2

12 months agoJNI: part 1 of typos and Java style tweaks suggested in [forum:99ac7961d82f57f3|forum...
stephan [Mon, 14 Apr 2025 11:31:10 +0000 (11:31 +0000)] 
JNI: part 1 of typos and Java style tweaks suggested in [forum:99ac7961d82f57f3|forum post 99ac7961d82f57f3].

FossilOrigin-Name: ab00af4e48501b0413650df31147866a805c34b7ecf506d1e208bc3ae6c2ef28

12 months agoDoc/help text tweaks in autoconf/tea.
stephan [Mon, 14 Apr 2025 10:20:41 +0000 (10:20 +0000)] 
Doc/help text tweaks in autoconf/tea.

FossilOrigin-Name: d6889f6b9aa70bc90f71883b3e7ba359162477afe5048dacb7dfa11733ad1e5a

12 months agoMinor cleanups and fixes in the autoconf/tea pieces.
stephan [Mon, 14 Apr 2025 10:18:40 +0000 (10:18 +0000)] 
Minor cleanups and fixes in the autoconf/tea pieces.

FossilOrigin-Name: 4d6536bd0ad333854309e825feaca26fdd13ac4458c7ccfbe77fc76cc5a968bc

12 months agoLatest upstream teaish, which restructures the teaish files a bit.
stephan [Sun, 13 Apr 2025 16:22:58 +0000 (16:22 +0000)] 
Latest upstream teaish, which restructures the teaish files a bit.

FossilOrigin-Name: 4f54f7d07d31938f271bc5d04a40cb1f7b5e6ea48e78ad06b7cc65483533f54e

12 months agotea build: use autosetup's file-normalize instead of Tcl's (file normalize) because...
stephan [Sat, 12 Apr 2025 21:47:18 +0000 (21:47 +0000)] 
tea build: use autosetup's file-normalize instead of Tcl's (file normalize) because the latter throws on cygwin for names like '.' and './'. Update a doc URL.

FossilOrigin-Name: 0fe77341a0f1e869a909623cdd07b03355b90d302b4f8a875e520befab88ce35

12 months agoPort autoconf/tea from the autotools to autosetup.
stephan [Sat, 12 Apr 2025 21:24:10 +0000 (21:24 +0000)] 
Port autoconf/tea from the autotools to autosetup.

FossilOrigin-Name: 691708642bf1cac562274a6df427d7c631aa4401dfbe98711963cf89203fb104

12 months agoMove the post-configure dot-in-file validation from sqlite-config.tcl to proj.tcl...
stephan [Sat, 12 Apr 2025 19:26:18 +0000 (19:26 +0000)] 
Move the post-configure dot-in-file validation from sqlite-config.tcl to proj.tcl for reuse in the tea port and other downstream trees.

FossilOrigin-Name: 0bac496d5c92c979295e702efc01803f6985b54d3d8ca30dce077c9776f7dcf2

12 months agoDoc typo fix. teaish
stephan [Sat, 12 Apr 2025 18:37:53 +0000 (18:37 +0000)] 
Doc typo fix.

FossilOrigin-Name: 10b917040b167de6aba6ee434b4e982580e690bbfe80521e34236b29d8e00b7d

12 months agoEliminate a duplicate -lz flag in the teaish build.
stephan [Sat, 12 Apr 2025 10:33:12 +0000 (10:33 +0000)] 
Eliminate a duplicate -lz flag in the teaish build.

FossilOrigin-Name: 5efb372c9b0d46625cb17aa3e48ead0da2483ca9d04d1507c9d728763f1ee959