]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
9 months agoBetter job at suppressing harmless scan-build warnings. This time testing
drh [Sat, 11 Jan 2025 14:43:47 +0000 (14:43 +0000)] 
Better job at suppressing harmless scan-build warnings.  This time testing
and working.

FossilOrigin-Name: c847973947de67579fab78a65ecfc90bf59fd5db0b7fa7a9c1abb1fc92213d01

9 months agoFix harmless scan-build warnings.
drh [Sat, 11 Jan 2025 13:59:42 +0000 (13:59 +0000)] 
Fix harmless scan-build warnings.

FossilOrigin-Name: b93af6feb7c0c3af30a47810a7c0e77ce41c386fac164c64bb5871a6c153db7e

9 months agoFix an age-old bug in the lower-level wasm/js helper bits which was (A) caused remova...
stephan [Sat, 11 Jan 2025 09:02:55 +0000 (09:02 +0000)] 
Fix an age-old bug in the lower-level wasm/js helper bits which was (A) caused removal of customized WASM func/argument conversion to siltently fail and (B) triggered a warning in the closure toolchain. Reported in [jaccwabyt ticket c5c296e85a7c01360820|https://fossil.wanderinghorse.net/r/jaccwabyt/info/c5c296e85a7c01360820].

FossilOrigin-Name: 99917a5bb04b5ad6ace95baf86d91e6ce098f9d3001de1a29d3d0b0b817acdce

9 months agoUpdate the makefile so that it puts the amalgamation files in a subdirectory
drh [Thu, 9 Jan 2025 19:57:44 +0000 (19:57 +0000)] 
Update the makefile so that it puts the amalgamation files in a subdirectory
in the amalgamation-zip.
[forum:/forumpost/b8dd1941e1|Forum post b8dd1941e1].

FossilOrigin-Name: cef8e88bedf01dc47012ef1cb878b22117c9966e615edf5a69704486f9cfa56c

9 months agoWhen removing an fts5 in secure-delete mode, defer setting the table version to SECUR...
dan [Thu, 9 Jan 2025 14:10:25 +0000 (14:10 +0000)] 
When removing an fts5 in secure-delete mode, defer setting the table version to SECUREDELETE until flushing data to disk. This prevents problems that can occur if there is a rollback or statement rollback operation.

FossilOrigin-Name: c359e555ceafcaab2ae38074bc4f57cccdc5bc6080d17f82290c09b9e5dd80c2

9 months agoFix another assert() failure in fts5.
dan [Wed, 8 Jan 2025 20:43:03 +0000 (20:43 +0000)] 
Fix another assert() failure in fts5.

FossilOrigin-Name: 6da37893f5b5729ea5fd632e8d98789e867488a67501d4a4dad92f8e7cb6bda0

9 months agoFix a crash in fts5 that could occur if shadow tables are modified or removed.
dan [Wed, 8 Jan 2025 15:54:44 +0000 (15:54 +0000)] 
Fix a crash in fts5 that could occur if shadow tables are modified or removed.

FossilOrigin-Name: c0b691095ae72fc07530777ef6d23688fb4196ce2e0feff14fc3c597c572252d

9 months agoCross-link and otherwise improve the various how-to-compile documents.
drh [Wed, 8 Jan 2025 12:51:28 +0000 (12:51 +0000)] 
Cross-link and otherwise improve the various how-to-compile documents.
No code changes.

FossilOrigin-Name: 5e6ede92afae77ce6023f3b294dc565651631c7976d898d800988f1b3ff2e83f

9 months agoIn the doc/tcl-extension-testing.md document, provide enhanced explanation for
drh [Wed, 8 Jan 2025 12:25:33 +0000 (12:25 +0000)] 
In the doc/tcl-extension-testing.md document, provide enhanced explanation for
why the tcl library needs to be copied into the install directory.

FossilOrigin-Name: cff70c859fff37f886fd622b7335a73836ff8cf15e6cb7aabcff449a7e427fa8

9 months agoFurther refinement to the Tcl extension testing procedure.
drh [Tue, 7 Jan 2025 18:50:19 +0000 (18:50 +0000)] 
Further refinement to the Tcl extension testing procedure.

FossilOrigin-Name: 32b8b078d16b8931afa56e587cf840412c65b68da0bc6fd6280ac773295116cf

9 months agoImprovements to [14b38ae6ab86a314] so that the Tcl interface is better able
drh [Tue, 7 Jan 2025 16:36:47 +0000 (16:36 +0000)] 
Improvements to [14b38ae6ab86a314] so that the Tcl interface is better able
to work with boolean values in both Tcl86 and Tcl90.

FossilOrigin-Name: 4e85343d6107a46682b549667410c296d7f4d17e3ac04ded7357afcbbfbe3e6d

9 months agoFix a memory error in test logic introduced by [8704034254938662].
drh [Tue, 7 Jan 2025 15:39:57 +0000 (15:39 +0000)] 
Fix a memory error in test logic introduced by [8704034254938662].

FossilOrigin-Name: 8a56e98d257e280d308b9fdc26e17e202f00a70fb9a780e30924e87a189fc7f4

9 months agoTypo in the previous check-in.
drh [Tue, 7 Jan 2025 15:00:00 +0000 (15:00 +0000)] 
Typo in the previous check-in.

FossilOrigin-Name: 5872d7a0a7d4959562e1218bbba1115df8b292d980234273d0d38749edf19822

9 months agoEnhancements to the Tcl SQLite extension testing procedures so that they
drh [Tue, 7 Jan 2025 14:55:49 +0000 (14:55 +0000)] 
Enhancements to the Tcl SQLite extension testing procedures so that they
install a full-featured SQLite and so that Tcl is build statically so that
there is no need to worry with LD_LIBRARY_PATH.

FossilOrigin-Name: c8972e652ebe62a8583904b5bc1d96b2d598222c037a714c8ff114ca84b52c7a

9 months agoMake the TCL extension aware of the booleanString type within TCL.
drh [Tue, 7 Jan 2025 12:14:32 +0000 (12:14 +0000)] 
Make the TCL extension aware of the booleanString type within TCL.

FossilOrigin-Name: 14b38ae6ab86a314a63ca9513850b43fcc670864f94d03a2706eff469980da88

9 months agoFix a typo in the previous check-in.
drh [Tue, 7 Jan 2025 11:54:43 +0000 (11:54 +0000)] 
Fix a typo in the previous check-in.

FossilOrigin-Name: 7d41885e85b0e2ef28bac34d663af07c35b21ee3e8b14481d2371f623bce681d

9 months agoMinor fixes to tclsqlite.c to promote portability.
drh [Tue, 7 Jan 2025 00:17:54 +0000 (00:17 +0000)] 
Minor fixes to tclsqlite.c to promote portability.

FossilOrigin-Name: dd934f032fa6fc790a951006512e3ed76a5f2930858932918eafdbe3ceec4620

9 months agoEnhance the makefile to make it easier to build from a read-only source tree.
drh [Mon, 6 Jan 2025 23:33:45 +0000 (23:33 +0000)] 
Enhance the makefile to make it easier to build from a read-only source tree.

FossilOrigin-Name: f99a70eca2fd8a54be3a6629dabd62efc623488706eed5e5a1bd0be577ac1acb

9 months agoFix a problem with tool/mksqlite3h.tcl that prevents it from running out of
drh [Mon, 6 Jan 2025 21:36:16 +0000 (21:36 +0000)] 
Fix a problem with tool/mksqlite3h.tcl that prevents it from running out of
a read-only check-out.

FossilOrigin-Name: cb54f0063edd284996b225183b8e35d71ffcd3c0fb4f56a0e316181f1a186d46

9 months agoFix a minor problem with the sqlite3_get_table_printf() test interface.
drh [Mon, 6 Jan 2025 18:32:53 +0000 (18:32 +0000)] 
Fix a minor problem with the sqlite3_get_table_printf() test interface.
No core changes.

FossilOrigin-Name: a0df29c7a3eb4f558aba00598d827643830591def3101a4d5464543527b8d13c

9 months agoAdd test case for using both SQLITE_CHANGESETAPPLY_IGNORENOOP and SQLITE_CHANGESETAPP...
dan [Mon, 6 Jan 2025 17:01:35 +0000 (17:01 +0000)] 
Add test case for using both SQLITE_CHANGESETAPPLY_IGNORENOOP and SQLITE_CHANGESETAPPLY_FKNOACTION.

FossilOrigin-Name: b1cc53fa3fb2ac3abeadd3282d8751f4d533315754159f16ca7f7f300ccdd8c8

9 months agoFurther refactoring of the TCL extension test procedure document, for
drh [Sun, 5 Jan 2025 19:58:30 +0000 (19:58 +0000)] 
Further refactoring of the TCL extension test procedure document, for
improved clarity and usability.

FossilOrigin-Name: bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a3707291afc0d

9 months agoRefactor the TCL extension test procedure to deal with TCL8.6 and TCL9.0
drh [Sun, 5 Jan 2025 17:16:33 +0000 (17:16 +0000)] 
Refactor the TCL extension test procedure to deal with TCL8.6 and TCL9.0
separately, to simplify the procedures and reduce cognative stress on the
tester.

FossilOrigin-Name: 5281536327d244ba9507548f7ed607e86e59b98a003e63f6da767471411c8ffc

9 months agoFix typo in the tcl-extension-testing.md document.
drh [Sun, 5 Jan 2025 11:40:15 +0000 (11:40 +0000)] 
Fix typo in the tcl-extension-testing.md document.

FossilOrigin-Name: 28150c615cb601dfc9e4f660627228d6a8a715d64c65f7bc77931c9daf8a0dd7

9 months agoImprovements to TCL extension test procedure description. Improvements to
drh [Sun, 5 Jan 2025 11:19:32 +0000 (11:19 +0000)] 
Improvements to TCL extension test procedure description.  Improvements to
the tclextension-list and tclextension-verify makefile targets to suppress
unnecessary output.

FossilOrigin-Name: 3e92fea09af13259d61afd2953fe5f3fc16e3cedfef09e350903aa5299b8e469

9 months agoImprovements to testing and validation of the SQLite TCL extension.
drh [Sat, 4 Jan 2025 20:50:21 +0000 (20:50 +0000)] 
Improvements to testing and validation of the SQLite TCL extension.

FossilOrigin-Name: 9d7597cad4a167aef7688e85513d8695e8d919e41f5cd44909aefee5ddf13345

9 months agoShow the values of $(JIM_TCLSH) and $(VISUALSTUDIOVERSION) in the
drh [Sat, 4 Jan 2025 20:13:54 +0000 (20:13 +0000)] 
Show the values of $(JIM_TCLSH) and $(VISUALSTUDIOVERSION) in the
output of "nmake tcl-env".

FossilOrigin-Name: 4270abc071ced9e7ec1fed3c387262cc1912e321e37e45e547a1088dbb022702

9 months agoAllow the 2nd argument to ".param set" to use previously bound parameters,
drh [Sat, 4 Jan 2025 19:50:44 +0000 (19:50 +0000)] 
Allow the 2nd argument to ".param set" to use previously bound parameters,
as suggested by [forum:/forumpost/823e1bd746|forum post 823e1bd746].

FossilOrigin-Name: 13a35ad792dc0afe1f7b60230aef392ae01e702972b963d732e332f21848f38b

9 months agoFix a problem in the sessions extension allowing changesets containing foreign key...
dan [Sat, 4 Jan 2025 16:30:05 +0000 (16:30 +0000)] 
Fix a problem in the sessions extension allowing changesets containing foreign key violations to be committed under some circumstances.

FossilOrigin-Name: e09a0c022903d88d5d6de34b2527565ef60c6bb049f2fb42f037e1520abf0f93

9 months agoAdd the document describing test procedures for the TCL extension build
drh [Sat, 4 Jan 2025 15:52:40 +0000 (15:52 +0000)] 
Add the document describing test procedures for the TCL extension build
process.  Update the Windows makefile so that it builds the TCL extensions
successfully with a default installation of Tcl8.6.

FossilOrigin-Name: 3263db9249444203b7a9a9f2b0be309c74944315dde7ed192366b709fff93f1b

9 months agoAdjust the Windows Makefile.msc so that it can build the tclextension with test-procedures
drh [Sat, 4 Jan 2025 15:51:30 +0000 (15:51 +0000)] 
Adjust the Windows Makefile.msc so that it can build the tclextension with
Tcl8.6 successfully.  Updates to the tcl-extension test procedure document.

FossilOrigin-Name: 0c2cdc632f26d6acac2d508def4ecfcc97462ebcddc20c84f8847e02e42b3a1d

9 months agoAdd new tcl-extension-testing.md document. The Windows side is not yet
drh [Sat, 4 Jan 2025 14:10:45 +0000 (14:10 +0000)] 
Add new tcl-extension-testing.md document.  The Windows side is not yet
working.

FossilOrigin-Name: 9dc805df1b1c26196ca53baa6b1b8c2f7e59e0150d02ead53228c77a63ad40f4

9 months agoAdd comment to the columnIsGoodIndexCandidate() routine to record the results
drh [Fri, 3 Jan 2025 11:51:50 +0000 (11:51 +0000)] 
Add comment to the columnIsGoodIndexCandidate() routine to record the results
of a failed experiment.  No changes to code.

FossilOrigin-Name: 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf1792739951311a8d3a249d45

9 months agoAvoid using Int32x32To64() with a 64-bit argument in fileio.c - this level of micro...
dan [Fri, 3 Jan 2025 11:22:01 +0000 (11:22 +0000)] 
Avoid using Int32x32To64() with a 64-bit argument in fileio.c - this level of micro-optimization is not really necessary there.

FossilOrigin-Name: 1291b013a8c93e7001fe25783bc98d12f5f7c341d1f728e6852632e18a38af58

9 months agoImprove the treeview output for CteUse objects.
drh [Thu, 2 Jan 2025 21:23:25 +0000 (21:23 +0000)] 
Improve the treeview output for CteUse objects.

FossilOrigin-Name: 2b16d6947ca4a102ddab4d5ba3e340a75e1e5c28e45e874ee5ff52f9b5fb964f

9 months agoImprovements to the display of subqueries in the FROM clause for treeview
drh [Thu, 2 Jan 2025 18:43:29 +0000 (18:43 +0000)] 
Improvements to the display of subqueries in the FROM clause for treeview
output.  (Debug and analysis code only - does not affect production builds.)

FossilOrigin-Name: 4a2d65cdcdd3d21bb7d9ea0efb434484f1b8642c2bb6457db58bc2a5f4fc16e5

9 months agoClose database connections in test/dbpage.test, for Windows.
drh [Thu, 2 Jan 2025 17:56:11 +0000 (17:56 +0000)] 
Close database connections in test/dbpage.test, for Windows.

FossilOrigin-Name: 322d255ed89c1dee08745e89f3c2bcf495283fd87b7526e70d6525a6e96b0ecf

9 months agoFix recent test cases so that they work even when auto_vacuum defaults to on.
drh [Thu, 2 Jan 2025 15:39:54 +0000 (15:39 +0000)] 
Fix recent test cases so that they work even when auto_vacuum defaults to on.

FossilOrigin-Name: 41f6e46695b547dece4daf2f3714e29f231aa04774f57fbd31aeb0a4290c0e7d

9 months agoAdd a test case for ROLLBACK TO of database truncate operations made through the...
dan [Thu, 2 Jan 2025 15:27:15 +0000 (15:27 +0000)] 
Add a test case for ROLLBACK TO of database truncate operations made through the sqlite_dbpage vtab.

FossilOrigin-Name: eb335beb1eb9ebbea4cb793d24f65787d0d9d8539bc6b5971e4e4298fdfce0c2

9 months agoImprovements to the way that truncation is implemented in sqlite_dbpage().
drh [Thu, 2 Jan 2025 15:03:13 +0000 (15:03 +0000)] 
Improvements to the way that truncation is implemented in sqlite_dbpage().

FossilOrigin-Name: ac4bb2e4ecf0bdb0d8ac12b1ccb42d51af02f519a038cfc79faab5c216971056

9 months agoUpdate the build instructions for Windows to note that VS2015 or later is
drh [Thu, 2 Jan 2025 12:14:01 +0000 (12:14 +0000)] 
Update the build instructions for Windows to note that VS2015 or later is
required to avoid the need to install tclsh.exe.

FossilOrigin-Name: da0ef0567be55648413bcbf2e129f348776a908dbad2ac8582ee3e27ac459e3b

9 months agoFix the tool/omittest.tcl script, broken by [d8c0e0184226bdae].
drh [Wed, 1 Jan 2025 18:18:49 +0000 (18:18 +0000)] 
Fix the tool/omittest.tcl script, broken by [d8c0e0184226bdae].

FossilOrigin-Name: 4f6c36a61c2b27e204c00bd7467453098f756c7e596b7e62d47da8784fbd2026

9 months agoFix the vfstrace.c extension so that it supports xFetch and xUnfetch.
drh [Wed, 1 Jan 2025 12:24:01 +0000 (12:24 +0000)] 
Fix the vfstrace.c extension so that it supports xFetch and xUnfetch.

FossilOrigin-Name: c7132b7e62422378f0560dcf0837888db5aa70cded9d783ab389581aa43dc5c8

9 months agoAdd the convenience makefile target (unix-only) "src-archives" that builds
drh [Mon, 30 Dec 2024 21:23:53 +0000 (21:23 +0000)] 
Add the convenience makefile target (unix-only) "src-archives" that builds
the various tarballs and ZIP archives that go on the download page.  This is
intended to make it easier and less error prone to put up new "draft" download
pages for testing.

FossilOrigin-Name: 2b17bc49655c577029919c2d409de994b0d252f8efb5da1ba0913f2c96bee552

9 months agoNew assert() statements to show that the sqlite3_value.db field is initialized
drh [Mon, 30 Dec 2024 13:54:52 +0000 (13:54 +0000)] 
New assert() statements to show that the sqlite3_value.db field is initialized
for MemArrays.

FossilOrigin-Name: 7cd8ccf57d1ae0f597ec5004201395f61ef4750728f3c1b9c4dd52d28916a4f7

9 months agoAdd an extra assert() to releaseMemArray() just to prove that the
drh [Mon, 30 Dec 2024 12:29:18 +0000 (12:29 +0000)] 
Add an extra assert() to releaseMemArray() just to prove that the
sqlite3_value.db field is never NULL.

FossilOrigin-Name: b969ef1def5121c7ff54e3586528274f006ca994b308cf88ccaa9d4f56bf30df

9 months agoFour new assert() statements to help with static analysis.
drh [Sun, 29 Dec 2024 11:54:12 +0000 (11:54 +0000)] 
Four new assert() statements to help with static analysis.

FossilOrigin-Name: e7f7c9d22be8a17b9a4d8f954fcdd40591ba9da5fb674f1184f960bca5f3d30b

9 months agoShow ETC in fuzzcheck with the --spinner option when there is only one input
drh [Sat, 28 Dec 2024 13:04:31 +0000 (13:04 +0000)] 
Show ETC in fuzzcheck with the --spinner option when there is only one input
file.

FossilOrigin-Name: 809699aeaaa4bae67e7ddeae3d42c7133f7deadbb4eb869cfb7e99dd97bdea99

9 months agoFixes to the substr() SQL function so that it can handle ridiculously large
drh [Sat, 28 Dec 2024 12:32:01 +0000 (12:32 +0000)] 
Fixes to the substr() SQL function so that it can handle ridiculously large
numbers in its 2nd and 3rd arguments without signed integer overflows.

FossilOrigin-Name: c1de8f916ea617109a903c436c57d082756fbb2b933ba9ce6998b9b912b12dea

9 months agoIn the (debugging) rtreenode() function, do not override an error coming out
drh [Sun, 22 Dec 2024 21:17:27 +0000 (21:17 +0000)] 
In the (debugging) rtreenode() function, do not override an error coming out
of sqlite3_result_text().

FossilOrigin-Name: 286559dfb3ad01fcf34360991a108dbe6bf81e7919c461ada6c691ee8f43868f

10 months agoFix a test case in sqllimits1.test so that it works with the Apple
drh [Thu, 19 Dec 2024 20:29:36 +0000 (20:29 +0000)] 
Fix a test case in sqllimits1.test so that it works with the Apple
configuration which changes the default SQLITE_MAX_LENGTH.

FossilOrigin-Name: 536fff14acb3335ad00fb1165cfb2f97e7a31c36273b9b97ffdb4b572fe72c08

10 months agoCorrection to check-in [a9759fc78d6cb0df] - printf() parameters values must
drh [Thu, 19 Dec 2024 19:52:13 +0000 (19:52 +0000)] 
Correction to check-in [a9759fc78d6cb0df] - printf() parameters values must
be integers.

FossilOrigin-Name: 2db531d1911369ea932d3559abcc02389e5f9ad72b46b0801dfb6063855aee1b

10 months agoThe BTree mutex must be held when calling sqlite3BtreeLastPage(). This
drh [Thu, 19 Dec 2024 19:02:09 +0000 (19:02 +0000)] 
The BTree mutex must be held when calling sqlite3BtreeLastPage().  This
check-in fixes a bug introduced by [cf8b99e17872c054].

FossilOrigin-Name: e6c30ee52c5cdc193804cec63374d558b45e4d67fc6bde58771ca78485ca0acf

10 months agoFix the sort4.test module so that the first two test cases are omitted
drh [Thu, 19 Dec 2024 14:20:47 +0000 (14:20 +0000)] 
Fix the sort4.test module so that the first two test cases are omitted
when SQLite has been compiled using SQLITE_MAX_WORKER_THREADS=0.

FossilOrigin-Name: 5b96dcf5f6bf41dcb89ced64efd4585e36dce718c428c2324d94e4942905c3bb

10 months agoconfigure script: only set the SQLITE_TEMP_STORE feature flag if --with-tempstore...
stephan [Thu, 19 Dec 2024 14:09:35 +0000 (14:09 +0000)] 
configure script: only set the SQLITE_TEMP_STORE feature flag if --with-tempstore is explicitly set, to avoid colliding with that flag being set by other means via the test fixture scripts.

FossilOrigin-Name: c7839b80972fb31df6ac81af38cf6d04c9542714c20fbaa7457c1eaf955f9222

10 months agoFix the Microsoft makefile so that it does not set SQLITE_TEMP_STORE
drh [Thu, 19 Dec 2024 14:08:06 +0000 (14:08 +0000)] 
Fix the Microsoft makefile so that it does not set SQLITE_TEMP_STORE
unnecessarily.

FossilOrigin-Name: f9b92f9513def690311a5ca46b68cab02bedec7984960d44e7dea5c2d196725a

10 months agoEnhance lemon so that it accepts the -U command-line option that undefines
drh [Thu, 19 Dec 2024 13:36:36 +0000 (13:36 +0000)] 
Enhance lemon so that it accepts the -U command-line option that undefines
a preprocessor macro.

FossilOrigin-Name: e2188a3edf3576963b45e9ffe6ef53e2a85aa68ea3dfb3243b4943d06ffaf829

10 months agoFix additional integer overflow problems in the substr() function.
drh [Thu, 19 Dec 2024 12:08:39 +0000 (12:08 +0000)] 
Fix additional integer overflow problems in the substr() function.

FossilOrigin-Name: 472abb492f1d1553ae6bdf53cc64bebfe75423526335beab7eaff26cc495cd7d

10 months agoFix possible integer oveflow in the second and third argument to substr().
drh [Wed, 18 Dec 2024 20:29:29 +0000 (20:29 +0000)] 
Fix possible integer oveflow in the second and third argument to substr().

FossilOrigin-Name: b04b4006f38f83d36eaf43c4bace7d53866b02b45e0ddcf1704266fed3bfc11c

10 months agoAvoid 32-bit roundoff error on the second argument to round().
drh [Wed, 18 Dec 2024 18:29:19 +0000 (18:29 +0000)] 
Avoid 32-bit roundoff error on the second argument to round().
[forum:/forumpost/170aeab92a|Forum post 170aeab92a].

FossilOrigin-Name: a9759fc78d6cb0df7c81f20c2c5c358729e571ebee50ee2b1441a15239d0b4b6

10 months agoRename some var refs in ext/lsm1/Makefile for the new build process.
stephan [Wed, 18 Dec 2024 03:41:29 +0000 (03:41 +0000)] 
Rename some var refs in ext/lsm1/Makefile for the new build process.

FossilOrigin-Name: 0ce42fa586049e8864c5fd1a1d8703722f8549ba0a20ca748b887b7975ba9eb7

10 months agoDo not attempt to truncate a database in sqlite_dbpage if the database is
drh [Tue, 17 Dec 2024 14:32:37 +0000 (14:32 +0000)] 
Do not attempt to truncate a database in sqlite_dbpage if the database is
not larger than the requested truncation size.

FossilOrigin-Name: cf8b99e17872c054e7ac0832d12633ce497c843dfc67148daf3b17762fd2b424

10 months agoCode formatting changes to make trunk more like wal2.
drh [Mon, 16 Dec 2024 18:04:39 +0000 (18:04 +0000)] 
Code formatting changes to make trunk more like wal2.

FossilOrigin-Name: 8f725472b0fe62359a4cd3237b43d7b834e042d8ce425abde06e3ed6c62dbafa

10 months agoChanges for better alignment with the wal2 branch.
drh [Mon, 16 Dec 2024 13:25:49 +0000 (13:25 +0000)] 
Changes for better alignment with the wal2 branch.

FossilOrigin-Name: 4fab85b3d0d1cad2d185f2456de7ddf281badf8561cc051e10e16655441dcc84

10 months agoRemove unnecessary end-of-line whitespace.
drh [Mon, 16 Dec 2024 12:08:47 +0000 (12:08 +0000)] 
Remove unnecessary end-of-line whitespace.

FossilOrigin-Name: ae580443d210811c12209866112fc8b0b83281e24945504b748a17d93ad84062

10 months agoTiny makefile/configure script doc tweaks. No functional changes.
stephan [Mon, 16 Dec 2024 07:03:12 +0000 (07:03 +0000)] 
Tiny makefile/configure script doc tweaks. No functional changes.

FossilOrigin-Name: ed5e912622839dce76dfb7352b56bb6fc698ecffde195f48db8d3339e9628cb5

10 months agoFix a harmless compiler warning that comes up when using SQLITE_DEBUG in
drh [Fri, 13 Dec 2024 01:29:22 +0000 (01:29 +0000)] 
Fix a harmless compiler warning that comes up when using SQLITE_DEBUG in
separate compilation mode.

FossilOrigin-Name: 52e0f8cab9852538da0778d5f57dd85b0774e764157692111a007aecd963f10a

10 months agoIncrease the maximum number of arguments on an SQL function to 1000 with the
drh [Thu, 12 Dec 2024 15:11:27 +0000 (15:11 +0000)] 
Increase the maximum number of arguments on an SQL function to 1000 with the
capability to increase it further up to 32767 using a compile-time option.

FossilOrigin-Name: e8d7d68ba0bb0bc2f948db5d9966990a5d23597fc3658b7cd0bc99d53c7353a9

10 months agoFix harmless typo in a comment describing the columnMallocFailure() function.
drh [Tue, 10 Dec 2024 12:32:34 +0000 (12:32 +0000)] 
Fix harmless typo in a comment describing the columnMallocFailure() function.

FossilOrigin-Name: 0f3b484fd71fd77947a1de7c24f35f8eed2911d0565d03edb7970b8f3092a5da

10 months agoMake the TCL interface more rebust against very large strings coming
drh [Mon, 9 Dec 2024 20:46:36 +0000 (20:46 +0000)] 
Make the TCL interface more rebust against very large strings coming
out of TCL9.

FossilOrigin-Name: e2bae4143afd07de1ae55a6d2606a3b541a5b94568aa41f6a96e5d1245471653

10 months agoEnhance the ".import" command of the CLI so that it is able to insert into a
drh [Mon, 9 Dec 2024 20:37:18 +0000 (20:37 +0000)] 
Enhance the ".import" command of the CLI so that it is able to insert into a
view that has an instead-of trigger.
[forum:/info/3e03c73150f8b9f8|Forum post 3e03c73150f8b9f8].

FossilOrigin-Name: 7dcc3731a9057a91f1b173fbab2841d8a666a945d9bc61d4c20f8a2a279d5ff1

10 months agoAdd NEVER() around branches that seems to have been made obsolete by
drh [Mon, 9 Dec 2024 13:02:13 +0000 (13:02 +0000)] 
Add NEVER() around branches that seems to have been made obsolete by
[a350ea7c6b89725b].

FossilOrigin-Name: cb5bad5c748b7435c43f3ec051736c1cf91ced2be317b0519e5e22523c137290

10 months agoFurther improvements to the decimal-to-float conversion for values close
drh [Mon, 9 Dec 2024 11:47:28 +0000 (11:47 +0000)] 
Further improvements to the decimal-to-float conversion for values close
to LARGEST_UINT64.

FossilOrigin-Name: 453c949914770e8f7b9b9dd882db492bf8756c212c816f87bb2e3ed98bcd64e3

10 months agoFix an obscure problem with multiple outer joins, ON clauses and query flattening...
dan [Mon, 9 Dec 2024 11:37:37 +0000 (11:37 +0000)] 
Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum [forum:5c8a069d23|thread 5c8a069d23].

FossilOrigin-Name: a350ea7c6b89725ba1a0058c77fc8e918f5cb78e868d100f5425cdee114d1320

10 months agoFix an obscure problem with multiple outer joins, ON clauses and query flattening... forum-5c8a069d23-fix
dan [Mon, 9 Dec 2024 11:12:12 +0000 (11:12 +0000)] 
Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum [forum:5c8a069d23|thread 5c8a069d23].

FossilOrigin-Name: 289daf6cee39625e8f068179cd58efcc1d28242f46064e58ec4175a019cf48ad

10 months agoAdd a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing.
drh [Mon, 9 Dec 2024 10:57:01 +0000 (10:57 +0000)] 
Add a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing.

FossilOrigin-Name: a0a36bad454fab55ff39cbada68bf9ec6494d48dc4fc88496c0f637ab100734c

10 months agoResynchronize autoconf/Makefile.msc makefile-fix
drh [Mon, 9 Dec 2024 10:52:28 +0000 (10:52 +0000)] 
Resynchronize autoconf/Makefile.msc

FossilOrigin-Name: 8f9c640818871c451e69f186224bf276f8a03c8d31a76806d81f34922a169f82

10 months agoAdd a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing...
stephan [Sun, 8 Dec 2024 18:38:40 +0000 (18:38 +0000)] 
Add a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing, as discussed in [forum:903f721f3e7c0d25|forum thread 903f721f3e7c0d25].

FossilOrigin-Name: 229c2f013c171bc220148c78f7db5396578f2c6aac28ad6ff9b687c9fa4998ac

10 months agoYet another iteration of the solution to the floating-point conversion
drh [Sat, 7 Dec 2024 19:57:30 +0000 (19:57 +0000)] 
Yet another iteration of the solution to the floating-point conversion
problem - this what avoids complaints about oversize double values
from -fsanitize.

FossilOrigin-Name: fc6904a508eb732b1cb5cc12321a0d637d97e1e066a022a2c93cb50595f3a86a

10 months agoA cleaner and more robust solution to the floating-point conversion problem
drh [Sat, 7 Dec 2024 19:06:25 +0000 (19:06 +0000)] 
A cleaner and more robust solution to the floating-point conversion problem
originally fixed by [81342fa6dd03fffb].

FossilOrigin-Name: 351de57f80b73045448c71d3402d877ff5d72418b1f5fc34c8147a04f7c5cb78

10 months agoFix more harmless compiler warnings.
drh [Sat, 7 Dec 2024 17:08:13 +0000 (17:08 +0000)] 
Fix more harmless compiler warnings.

FossilOrigin-Name: f5b8fd77635e5e6d2d88a1ce74e1bd6c4311260a2b695e5055b898b880bf5718

10 months agoFix harmless compiler warning caused by the previous check-in.
drh [Sat, 7 Dec 2024 16:53:42 +0000 (16:53 +0000)] 
Fix harmless compiler warning caused by the previous check-in.

FossilOrigin-Name: 462700aeb7c183d739ead4d726ce5384b3297bcf7929abd010987fa3a5f64807

10 months agoOn x64 hardware, round-trip uint64_t→double→uint64_t conversions
drh [Sat, 7 Dec 2024 14:48:55 +0000 (14:48 +0000)] 
On x64 hardware, round-trip uint64_t→double→uint64_t conversions
fail for values greater than UINT64_MAX-2047.  This caused the SQLite
text-to-float converter routine to give incorrect results for values
between '1.8446744073709550592eNNN' and '1.8446744073709551609eNNN' for any
exponent NNN.  This problem was introduced by check-in [761d8fd18b0ee868]
and first appeared in version 3.47.0 and was reported by
[forum:/forumpost/569a7209179a7f5e|forum post 569a7209179a7f5e].  Fixed
by this check-in.

FossilOrigin-Name: 81342fa6dd03fffbe7d4d699ff049dcef4d30344578bb6f91cb58a4e5a4f6036

10 months agoAdd the SQLITE_PREPARE_DONT_LOG option for sqlite3_prepare_v3(), that prevents
drh [Fri, 6 Dec 2024 18:35:16 +0000 (18:35 +0000)] 
Add the SQLITE_PREPARE_DONT_LOG option for sqlite3_prepare_v3(), that prevents
errors in the compilation of the SQL from being sent to sqlite3_log().

FossilOrigin-Name: 870403425493866232cf9e8fa62288861b7d0a4091b15d75727f8bb31da46f94

10 months agoMinor doc update in auto.def. No functional changes.
stephan [Fri, 6 Dec 2024 00:12:43 +0000 (00:12 +0000)] 
Minor doc update in auto.def. No functional changes.

FossilOrigin-Name: d324be296de443bd2853c732b10960178bf3ba9f18c80c509f6b41e2cfb2f3af

10 months agoEnsure that the post-config checks for @UNEXPANDED_VARS@ pass even if --disable-tcl...
stephan [Fri, 6 Dec 2024 00:09:05 +0000 (00:09 +0000)] 
Ensure that the post-config checks for @UNEXPANDED_VARS@ pass even if --disable-tcl is used, as reported in [forum:74ef8059fc|forum post 74ef8059fc].

FossilOrigin-Name: a38606bf44a1b5d0f684f67174c33f8c88c7927e23fc6a715e8d3ae7a6614bbd

10 months agoFix the build of sqlite3_analyzer.exe on Windows that was broken by
drh [Thu, 5 Dec 2024 23:53:16 +0000 (23:53 +0000)] 
Fix the build of sqlite3_analyzer.exe on Windows that was broken by
check-in [80f3bf8c2ee31ba1].

FossilOrigin-Name: 223f47b2db8d80629d60a642942eb8b288611e3e466cf904964285229a5809fc

10 months agoMinor doc correction in ext/misc/shathree.c, as reported in the forum. No functional...
stephan [Wed, 4 Dec 2024 16:01:25 +0000 (16:01 +0000)] 
Minor doc correction in ext/misc/shathree.c, as reported in the forum. No functional changes.

FossilOrigin-Name: 3b82d2c6b732617b9be205efadd07326057c93b71c47ffd42de63fc05093667b

10 months agoImprove the output from the ".testctrl opt" command in the CLI.
drh [Mon, 2 Dec 2024 19:55:39 +0000 (19:55 +0000)] 
Improve the output from the ".testctrl opt" command in the CLI.

FossilOrigin-Name: de7064d118c33aab0fff39d072593b287c291870b843d093045300bde464420f

10 months agoEnsure that the query flattener does not change an ON clause term to a WHERE clause...
dan [Mon, 2 Dec 2024 17:21:52 +0000 (17:21 +0000)] 
Ensure that the query flattener does not change an ON clause term to a WHERE clause term.

FossilOrigin-Name: bdd408a2557ff05c9ea962a94b442f7c078d8e1ec27035aa95bc23d4d2bd5606

10 months agoFix a comment typo on the sqlite3ExprIsSingleTableConstraint() routine.
drh [Mon, 2 Dec 2024 16:24:47 +0000 (16:24 +0000)] 
Fix a comment typo on the sqlite3ExprIsSingleTableConstraint() routine.

FossilOrigin-Name: 346a845bf1cd1c7e542f7bf763d86c197d9a3b4f3ea38ade416790a1cf80e6f2

10 months agoFix a harmless typo in debugging output.
drh [Mon, 2 Dec 2024 16:07:38 +0000 (16:07 +0000)] 
Fix a harmless typo in debugging output.

FossilOrigin-Name: 578f76cfb2e298fe6bfd278b545091fe682d01feb0be56ef57b6c9f2c179ac61

10 months agoReformulate [9e09d5d6] so that memsys5 shows up in the late-config summary as being...
stephan [Mon, 2 Dec 2024 14:14:30 +0000 (14:14 +0000)] 
Reformulate [9e09d5d6] so that memsys5 shows up in the late-config summary as being enabled and does the right thing if both --debug and --memsys3 are used.

FossilOrigin-Name: 447db1cd0a6575432996e9735e78bbb09c83827c5e3080339b34df176ab86af0

10 months agoEnable MEMSYS5 with the --dev configure option.
drh [Mon, 2 Dec 2024 13:47:53 +0000 (13:47 +0000)] 
Enable MEMSYS5 with the --dev configure option.

FossilOrigin-Name: 9e09d5d60ac91423e1dec1169e9eb60a531f84261b48490c550cf4529540e6dc

10 months agoSlighly less confusing output from treeview during debugging.
drh [Mon, 2 Dec 2024 13:29:29 +0000 (13:29 +0000)] 
Slighly less confusing output from treeview during debugging.

FossilOrigin-Name: 7aef0b93050cdb79cae68361e84047cea2e8e7251d0581ce917da03352bb1f16

10 months agoTrim a bit more from the sqlite370.svg border to get it closer in scaled size to...
stephan [Sun, 1 Dec 2024 15:23:40 +0000 (15:23 +0000)] 
Trim a bit more from the sqlite370.svg border to get it closer in scaled size to the logo currently on the docsrc site.

FossilOrigin-Name: 81c7277fc59af833365f0ee5af603db49c19a6ba87bd5f252ecdfe72df252d4e

10 months agoCorrect the fill color for the background of sqlite370.svg - it was slightly darker...
stephan [Sun, 1 Dec 2024 14:20:19 +0000 (14:20 +0000)] 
Correct the fill color for the background of sqlite370.svg - it was slightly darker than it should have been.

FossilOrigin-Name: 732132407b3881aaa7fee151baafb6569664f1d2b82ef7743d89bd0a86cf0a09

10 months agoRe-export sqlite370.svg to retain the gradient part and clip the size using the cutti...
stephan [Sun, 1 Dec 2024 14:14:50 +0000 (14:14 +0000)] 
Re-export sqlite370.svg to retain the gradient part and clip the size using the cutting guides in sqlite370.eps.

FossilOrigin-Name: 12017b01c8e6c12fdd8de3c3c325e56b5be80343a1a392538b6e6ed066e46cee

10 months agoExport a clipped copy of sqlite370.eps as sqlite370.svg, based on discussion in ...
stephan [Sun, 1 Dec 2024 14:02:19 +0000 (14:02 +0000)] 
Export a clipped copy of sqlite370.eps as sqlite370.svg, based on discussion in [forum:1bbd6d17ca|forum post 1bbd6d17ca].

FossilOrigin-Name: dd3a13c1209d0bac3d6eb105826429ef29b36682c347995dc266bf42e46a2193

10 months agoAt the end of the configure script ensure that none of the files which are filtered...
stephan [Sat, 30 Nov 2024 17:48:31 +0000 (17:48 +0000)] 
At the end of the configure script ensure that none of the files which are filtered for @VARS@ contain any unresolved @VAR@ placeholders, failing fatally if any do.

FossilOrigin-Name: 301df5c2beb08e8e2944f7a9e46a10114603518385c05a9c30a838ab436369d4