]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
4 days agoReduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test
drh [Sun, 19 Oct 2025 17:30:07 +0000 (17:30 +0000)] 
Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test
module to avoid false-positive infinite loop reports from OSS-Fuzz based
on long and complex fuzzer-generated LIKE/GLOB patterns that are not actually
infinite loops, but which do take a long time to resolve.

FossilOrigin-Name: 53edea286b0a38f4f9c7017276f3a826037919144d517f8c89ef0f35b65af5f1

5 days agoUse 64-bit memory allocations everywhere in the expert extension.
drh [Sat, 18 Oct 2025 11:19:02 +0000 (11:19 +0000)] 
Use 64-bit memory allocations everywhere in the expert extension.

FossilOrigin-Name: 6caf793b8f406f5089e3811591bc69384646df16ee18d63bd63760eaaa95d122

5 days agoIncrease the range of integer indexes in the the merge() family of
drh [Sat, 18 Oct 2025 11:04:03 +0000 (11:04 +0000)] 
Increase the range of integer indexes in the the merge() family of
SQL functions.

FossilOrigin-Name: 8d3943890ef3b533df35c4784c2a42c52503a4d9c3dbe67241510d8b70669b48

6 days agoFix a minor memory leak in the CLI that can occur following an error
drh [Fri, 17 Oct 2025 10:06:44 +0000 (10:06 +0000)] 
Fix a minor memory leak in the CLI that can occur following an error
in the ".output" dot-command.

FossilOrigin-Name: d1044bc0616fd20c63ca3b627ad0a116256870a082a72da26f98fb0f59ca44fd

7 days agoResolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum...
stephan [Thu, 16 Oct 2025 23:42:39 +0000 (23:42 +0000)] 
Resolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum post 95edc7a8d7d1de59], with help from Bo Lindbergh.

FossilOrigin-Name: b144f875d6bddce62e8f2ad42bfe5dfa6c2434f2ef3edb86847fb4c23aa46814

7 days agoImprove performance of the shell tool ".ar" command when it is given a large number...
dan [Thu, 16 Oct 2025 14:17:30 +0000 (14:17 +0000)] 
Improve performance of the shell tool ".ar" command when it is given a large number of arguments.

FossilOrigin-Name: 8fed9de84bce01e88e0e8237e245c0ff9fe9f46394c603887e360658f5ef1ac1

7 days agoIn dbpage.c, disable truncation on any update error, including errors
drh [Thu, 16 Oct 2025 12:43:36 +0000 (12:43 +0000)] 
In dbpage.c, disable truncation on any update error, including errors
in sqlite3PagerWrite().

FossilOrigin-Name: eee5ba5d8a9d01000345185731c531eb84d3cb8e81bf429506c449d962aad843

7 days agoFix an off-by-one in c-pp-lite.c which could cause @token@-processed output to get...
stephan [Thu, 16 Oct 2025 01:44:03 +0000 (01:44 +0000)] 
Fix an off-by-one in c-pp-lite.c which could cause @token@-processed output to get one duplicated byte.

FossilOrigin-Name: aa2f4c51604f4d4286c8a1ec7eaa6251892471e32087af695712513ee620ea46

8 days agoMinor JS doc updates. No code changes.
stephan [Wed, 15 Oct 2025 23:28:31 +0000 (23:28 +0000)] 
Minor JS doc updates. No code changes.

FossilOrigin-Name: fc2a026901b1a12526b92fff36d7acc226e554c9f351e6261c7ffd4887bcc337

8 days agoResolve a valgrind-reported error in ext/wasm/c-pp-lite.c caused by successful exit...
stephan [Wed, 15 Oct 2025 23:13:50 +0000 (23:13 +0000)] 
Resolve a valgrind-reported error in ext/wasm/c-pp-lite.c caused by successful exit colliding with the atexit() handler. Add -e SCRIPT support to c-pp-lite to facilitate testing.

FossilOrigin-Name: 7801c7225a18ccb2216b01663b30e3eb90a961e3d165af73f964c515b74fe745

8 days agoImprove performance of the shell tool ".ar" command when it is given a large number... ar-performance-improvement
dan [Wed, 15 Oct 2025 15:54:38 +0000 (15:54 +0000)] 
Improve performance of the shell tool ".ar" command when it is given a large number of arguments.

FossilOrigin-Name: 0398897067ca5cdedfef0ce7a034ba6d5a2ce6104605ef4ed1c7549499435b44

8 days agoFix memory allocation in the ".table" command of the .cli when the number
drh [Wed, 15 Oct 2025 10:52:45 +0000 (10:52 +0000)] 
Fix memory allocation in the ".table" command of the .cli when the number
of tables in the database file approaches 2 billion.

FossilOrigin-Name: 5cbccab499bc3983aac1f57355552db607dee6c7ef4eb00d794dbee89c18db70

9 days agoReestablish APIARMOR for the sqlite3_db_status() interface.
drh [Tue, 14 Oct 2025 19:21:46 +0000 (19:21 +0000)] 
Reestablish APIARMOR for the sqlite3_db_status() interface.

FossilOrigin-Name: 1738f0bdf5941a70684c82d2040561e53a272595026a837a9f9bab8508a46480

9 days agoJS/WASM: Expose sqlite3_db_status64(), sqlite3changeset_apply_v3(), sqlite3changeset_...
stephan [Tue, 14 Oct 2025 18:23:32 +0000 (18:23 +0000)] 
JS/WASM: Expose sqlite3_db_status64(), sqlite3changeset_apply_v3(), sqlite3changeset_apply_v3_strm(), and SQLITE_DBSTATUS_TEMPBUF_SPILL.

FossilOrigin-Name: b13eafc9b6820517b450041a7e2be573a896b5b9e88b2b28df9f15e3cb91e23d

9 days agoAdd the test/testloadext.c loadable extension to test the ability to use
drh [Tue, 14 Oct 2025 17:50:55 +0000 (17:50 +0000)] 
Add the test/testloadext.c loadable extension to test the ability to use
the latest APIs using the loadable extension mechanism.

FossilOrigin-Name: a9bd7ed6f77c5e53f9130eac7eb999c662e9158fb229a462d29f18653284d6d0

9 days agoAdd the sqlite3_db_status64() interface and the
drh [Tue, 14 Oct 2025 17:09:06 +0000 (17:09 +0000)] 
Add the sqlite3_db_status64() interface and the
SQLITE_DBSTATUS_TEMPSTORE_SPILL option for use in that interface.

FossilOrigin-Name: 9f8739ddea6ec6d8890d0e8f6a0143773a008e4f96bd02a48d4bfebb3f9b72fe

9 days agoMake the new sqlite3_db_status64() API accessible to extensions. dbstatus-spill
drh [Tue, 14 Oct 2025 16:57:50 +0000 (16:57 +0000)] 
Make the new sqlite3_db_status64() API accessible to extensions.

FossilOrigin-Name: 2ebd7330312f3ee4674c343b7a19b703f1f89611a6846a0e2be39867f9895522

9 days agoFix two links in ext/wasm/README.md.
stephan [Tue, 14 Oct 2025 14:07:58 +0000 (14:07 +0000)] 
Fix two links in ext/wasm/README.md.

FossilOrigin-Name: 0f96eaeaa8c51c20f8d389bfd6d0d6371e8bb29ff7e8eaf3a0bcb35cb2b73338

9 days agoExtra defenses against integer overflow in the decimal extension.
drh [Tue, 14 Oct 2025 14:03:09 +0000 (14:03 +0000)] 
Extra defenses against integer overflow in the decimal extension.

FossilOrigin-Name: 1a7414d9b5be7ce18b23c357fd98cd0e96d78ac626abfa6e4e0dee494b6a1efc

9 days agoAdd a section to ext/wasm/README.md about the dependency on wabt/wasm-strip for relea...
stephan [Tue, 14 Oct 2025 13:47:40 +0000 (13:47 +0000)] 
Add a section to ext/wasm/README.md about the dependency on wabt/wasm-strip for release builds.

FossilOrigin-Name: 0dbb13863b3ff1da1be664967ac05c79cf34f7a78def05fe4f6407c06cb4322a

9 days agoFix a makefile typo which caused a build directory to not get mkdir'd for the fiddle...
stephan [Tue, 14 Oct 2025 13:25:02 +0000 (13:25 +0000)] 
Fix a makefile typo which caused a build directory to not get mkdir'd for the fiddle build.

FossilOrigin-Name: d98d5abf6d27c5359ff8c797ad57394b96074e47010bc4c24120ba69a967dc3c

9 days agoMerge all the latest trunk enhancements into the dbstatus-spill branch.
drh [Tue, 14 Oct 2025 11:18:45 +0000 (11:18 +0000)] 
Merge all the latest trunk enhancements into the dbstatus-spill branch.

FossilOrigin-Name: 55f2613c1bacddb05902d4d5dac3d2b49b91053e6249dd926bb953c763eafeb0

10 days agoAvoid integer overflows (a) when dealing with zeroblob(N) calls when 2*N is larger...
dan [Mon, 13 Oct 2025 16:07:28 +0000 (16:07 +0000)] 
Avoid integer overflows (a) when dealing with zeroblob(N) calls when 2*N is larger than 2^31, and (b) in fts5 when a corrupt record is close to 2^31 bytes in size. Both of these require special builds with SQLITE_MAX_LENGTH set to a non-default value.

FossilOrigin-Name: 27927519696dcb78ff72e245158ea6d33a1b2c3d4da314d4d0283c47d847c3da

10 days agoFix a bug in concat_ws() in which an initial empty string was treated as if
drh [Mon, 13 Oct 2025 12:36:54 +0000 (12:36 +0000)] 
Fix a bug in concat_ws() in which an initial empty string was treated as if
it was a NULL value.

FossilOrigin-Name: eb2e4e46171c12f59aa5d571eeb310534360b110c3e7bda6eaf68f0e25546264

10 days agoEnable CLI documentation for .imposter
drh [Mon, 13 Oct 2025 10:35:59 +0000 (10:35 +0000)] 
Enable CLI documentation for .imposter

FossilOrigin-Name: c639c7be029f86defe6cb8cef094e1126ec8ab3968e12d4d2bf6e6ab23c39821

11 days agoFix broken hyperlinks in the documentation.
drh [Sun, 12 Oct 2025 19:17:31 +0000 (19:17 +0000)] 
Fix broken hyperlinks in the documentation.

FossilOrigin-Name: 62e6b120c43cd855349bf1b40ad2fb992e31a6e2567e5b145cf1849445849da7

11 days agoFix order of operations in the OP_Concat operator of the byte-code engine
drh [Sun, 12 Oct 2025 10:31:34 +0000 (10:31 +0000)] 
Fix order of operations in the OP_Concat operator of the byte-code engine
to avoid any possibility of an integer overflow.

FossilOrigin-Name: 765e6569824ccc34292d6df16a6cd682e6503f20adebe0a43cd2118d69072a63

12 days agoRemove an unused variable from the generate_series implementation.
drh [Sat, 11 Oct 2025 18:44:54 +0000 (18:44 +0000)] 
Remove an unused variable from the generate_series implementation.

FossilOrigin-Name: a523e4adbf8e60ea8c3351f33aff793c6e425c594038e8578d12564bf47aac03

12 days agoFix an assert() that could fail when reading a blob or text value larger than 1GiB...
dan [Sat, 11 Oct 2025 16:23:22 +0000 (16:23 +0000)] 
Fix an assert() that could fail when reading a blob or text value larger than 1GiB from the database (requires a non-default build configuration). This is an assert() fix only, production builds were functioning correctly.

FossilOrigin-Name: 3e5ec5731f0c8c5f7da357c63d315aae5a2aca5c1b3567bc8c9386ccc2a798cf

12 days agoImprovements to the (rarely used) home-grown varients of seriesCeil()
drh [Sat, 11 Oct 2025 15:45:47 +0000 (15:45 +0000)] 
Improvements to the (rarely used) home-grown varients of seriesCeil()
and seriesFloor() based on ideas from
[forum:/forumpost/2025-10-11T12:36:56z|forum post 2025-10-11T12:36:56z].

FossilOrigin-Name: e6b9bfdb6f8f86d4d2891d65fee4274dcbc61c9e998d81f90232153c05788cab

13 days agoProvide alternative implementations of ceil() and floor() to the
drh [Fri, 10 Oct 2025 19:43:03 +0000 (19:43 +0000)] 
Provide alternative implementations of ceil() and floor() to the
generate_series() function so that it will build even when SQLite is
compiled using --disable-math.
[forum:/forumpost/91690fa646|Forum post 91690fa646].

FossilOrigin-Name: 97d6fd2c99578adb6a1e9b879ba5ae5ad798a8ef8f0646bf0102747d52148bff

13 days agoBack out [8bf26c956e]. It is not required following [8e7da8cf50].
dan [Fri, 10 Oct 2025 16:04:19 +0000 (16:04 +0000)] 
Back out [8bf26c956e]. It is not required following [8e7da8cf50].

FossilOrigin-Name: ea29180797aa4bb25180432e75a372277a6f6e2262906a9e765a3bddf8ca79d7

13 days agoFix harmless compiler warnings.
drh [Fri, 10 Oct 2025 14:31:46 +0000 (14:31 +0000)] 
Fix harmless compiler warnings.

FossilOrigin-Name: 4966d7a1ce42af8b1c50fdd40e651e80d0eeb8cb62dd882950cab275f98aba88

13 days agoMakefile updates to suppose carray() and percentile(). Add Carray to
drh [Fri, 10 Oct 2025 14:22:05 +0000 (14:22 +0000)] 
Makefile updates to suppose carray() and percentile().  Add Carray to
the CLI and fuzzcheck to support debugging.

FossilOrigin-Name: fe9cf68b513d1e8cfcde90f1982a7f4123f54e3ebb004d961a99bdf6bec03a32

13 days agoRegenerate autoconf/Makefile.msc to squelch a 'make test' warning.
stephan [Fri, 10 Oct 2025 14:00:27 +0000 (14:00 +0000)] 
Regenerate autoconf/Makefile.msc to squelch a 'make test' warning.

FossilOrigin-Name: f7f55dce184c433b7774ab569caaeae5994c63421de01e9ea36aa1dbecb2d579

13 days agoFix the carrayfault.test script so that it works in configurations that
drh [Fri, 10 Oct 2025 13:43:53 +0000 (13:43 +0000)] 
Fix the carrayfault.test script so that it works in configurations that
do not support virtual tables.

FossilOrigin-Name: 767a667b91caff2e789179231f13a0d260c9837020c0ce1553b86e88cf9aa352

13 days agoAvoid (apparently harmless) undefined behavior in CARRAY if the rowid
drh [Fri, 10 Oct 2025 10:40:37 +0000 (10:40 +0000)] 
Avoid (apparently harmless) undefined behavior in CARRAY if the rowid
is used as a constraint in the WHERE clause.

FossilOrigin-Name: 200b3c8f6cebf34428b0b41fc05f7361771dfee3592cfcdce512084abcc99713

13 days agoFix the sqlite3_bind_blob() interface so that it sets the encoding of the
drh [Fri, 10 Oct 2025 00:59:28 +0000 (00:59 +0000)] 
Fix the sqlite3_bind_blob() interface so that it sets the encoding of the
underlying sqlite3_value object to the database encoding.  Fix for the
problem reported by
[forum:/forumpost/2025-10-07T12:47:25z|forum post 2025-10-07T12:47:25z].

FossilOrigin-Name: 8e7da8cf506059dde98000db2731b8c47951344263df680a12b7c95aaece2568

2 weeks agoFix the xBestIndex method on carray so that it gives a coherient query plan
drh [Fri, 10 Oct 2025 00:26:46 +0000 (00:26 +0000)] 
Fix the xBestIndex method on carray so that it gives a coherient query plan
in a join when some of the arguments to carray() come from other table
in the join.

FossilOrigin-Name: c8417b3261b2c9f20dcc38c482b9fc43acb97d933eb723c2f6698a7435a192eb

2 weeks agoFix carrayfault.test so that it works with the new built-in CARRAY.
drh [Thu, 9 Oct 2025 19:23:01 +0000 (19:23 +0000)] 
Fix carrayfault.test so that it works with the new built-in CARRAY.

FossilOrigin-Name: 22f694682107036e68b67e48123d606aeff8cd8b7fedc8ab8ed9cc1a9cccd73f

2 weeks agoUpdate c-pp.c and rename it to c-pp-lite.c to match its new upstream name. Adapt...
stephan [Thu, 9 Oct 2025 15:28:59 +0000 (15:28 +0000)] 
Update c-pp.c and rename it to c-pp-lite.c to match its new upstream name. Adapt the JS files and mkwasmbuilds.c for c-pp syntactic changes.

FossilOrigin-Name: bb13e46ddfcd1d3ca73845430d9a91c0ea3913762d39bbd94127783d77e4f63b

2 weeks agoAvoid corrupting the fts5 index if a value that was inserted via sqlite3_bind_blob...
dan [Thu, 9 Oct 2025 14:50:27 +0000 (14:50 +0000)] 
Avoid corrupting the fts5 index if a value that was inserted via sqlite3_bind_blob() in a non-utf8 db is deleted.

FossilOrigin-Name: 8bf26c956e199762d55c159392c2e3813a9e12b914d3ca33000bf332cd946cb0

2 weeks agoIn the CLI, limit column widths specified by the ".width" command to
drh [Thu, 9 Oct 2025 14:01:52 +0000 (14:01 +0000)] 
In the CLI, limit column widths specified by the ".width" command to
have an absolute value not more than 30,000.

FossilOrigin-Name: b3741f1101d25eded57a62b4967ec1bcce532dc9937c4b7b74cb689861efb442

2 weeks agoMove the carray() extension and the percentile extension into the
drh [Wed, 8 Oct 2025 19:01:00 +0000 (19:01 +0000)] 
Move the carray() extension and the percentile extension into the
amalgamation.  Both are still turned off by default and must be
enable using SQLITE_ENABLE_CARRAY and SQLITE_ENABLE_PERCENTILE compile-time
options, so there is no increase in object code size.  However, these
extensions are now more easily available.

FossilOrigin-Name: 2d40dc2173ac394024ae267419bd8d3621f15d4cd2449c9c2f7310acc3b190f0

2 weeks agoAdd the SQLITE_ prefix to the type constants used by sqlite3_carray_bind(). ext-to-core
drh [Wed, 8 Oct 2025 18:51:15 +0000 (18:51 +0000)] 
Add the SQLITE_ prefix to the type constants used by sqlite3_carray_bind().

FossilOrigin-Name: e11e9913e56d42d2baa07f1b549f212b873fe7343a06825682d843471c4a3640

2 weeks agoMake use of the new SQLITE_ENABLE_PERCENTILE in the wasm build.
stephan [Wed, 8 Oct 2025 18:17:19 +0000 (18:17 +0000)] 
Make use of the new SQLITE_ENABLE_PERCENTILE in the wasm build.

FossilOrigin-Name: 937c084c2d9b20fde2d54e48257cb7018bd8c36d6f00ed6f1659b5ecc2f48ed4

2 weeks agoAdd ENABLE compile-time options to enable carray() and median(). Hence
drh [Wed, 8 Oct 2025 18:11:37 +0000 (18:11 +0000)] 
Add ENABLE compile-time options to enable carray() and median().  Hence
there is no new code and no increase in library size without the ENABLE
macros.

FossilOrigin-Name: 7dec290b413ca1bc67694743d8b771e1634fd85251f1a23d60aaf36c63f0f366

2 weeks agoThis is how the percentile() family of functions might be integrated into
drh [Wed, 8 Oct 2025 16:29:14 +0000 (16:29 +0000)] 
This is how the percentile() family of functions might be integrated into
the amalgamation, should we elect to do such a thing.

FossilOrigin-Name: c2cfc9c92e35105e26a4c0887b0401ace15a874fd18046135de4b375ba968795

2 weeks agoWere we to choose to integrate the carray() table-valued function into the
drh [Wed, 8 Oct 2025 15:32:55 +0000 (15:32 +0000)] 
Were we to choose to integrate the carray() table-valued function into the
amalgamation, that integration might look something like this.

FossilOrigin-Name: 2b43d5d7dcc5aee14a050c824a5e09b6a38a9c78ddcc25a994eba5d4c5ad9ba2

2 weeks agoFix harmless integer overflow in the CLI when arguments to --lookaside are
drh [Wed, 8 Oct 2025 12:37:01 +0000 (12:37 +0000)] 
Fix harmless integer overflow in the CLI when arguments to --lookaside are
ridiculously large.

FossilOrigin-Name: 8bf337e6e609dd38de6002f2d3d3ebf52dd0462ed98a50e4b002a7c6860d30c5

2 weeks agoFix an uninitialized variable problem in test1.c.
dan [Wed, 8 Oct 2025 11:00:04 +0000 (11:00 +0000)] 
Fix an uninitialized variable problem in test1.c.

FossilOrigin-Name: 059203f658273712597d45d9b4a9cf1aea20368fe51224b38e28797b045fb6b8

2 weeks agoThe ".dbtotxt" command in the CLI should not fail if the database is
drh [Wed, 8 Oct 2025 09:52:52 +0000 (09:52 +0000)] 
The ".dbtotxt" command in the CLI should not fail if the database is
uninitialized.  It should instead be a no-op.

FossilOrigin-Name: 2818ef64d9233095b065101392768071fbd95729cde060b954f48ea821fc549a

2 weeks agoFunction name doc typo fixes for sqlite3_source_id() (sic.).
stephan [Wed, 8 Oct 2025 02:05:15 +0000 (02:05 +0000)] 
Function name doc typo fixes for sqlite3_source_id() (sic.).

FossilOrigin-Name: 03c3f12853163ce542239a98bdf8e830db2fc7ccf1edb2f9c783fcfdca858879

2 weeks agoAdd test cases for the carray module.
dan [Tue, 7 Oct 2025 21:02:37 +0000 (21:02 +0000)] 
Add test cases for the carray module.

FossilOrigin-Name: dcfc0164a95eddb5e924c606850fe2015e8f2f516d36b380cbb79d6bdfe034fc

2 weeks agoImprove the invariant checker module so that so that it added "+" before
drh [Tue, 7 Oct 2025 18:06:05 +0000 (18:06 +0000)] 
Improve the invariant checker module so that so that it added "+" before
"column ISNULL" in queries where the base query contains a GROUP BY, to
prevent the ISNULL term from being pushed down into the subquery, since
that can cause ambiguities if column is UNIQUE.

FossilOrigin-Name: b4ff920fbeef9a8590219596d73c09976da3da53c08a685be56f6b2cd2cdc70c

2 weeks agoFix some integer overflow warnings in the base64 and base85 extensions.
dan [Tue, 7 Oct 2025 15:14:03 +0000 (15:14 +0000)] 
Fix some integer overflow warnings in the base64 and base85 extensions.

FossilOrigin-Name: 06b4bd2aba22c57f5a5fed606c3bee225dee6fdc13bb16cc58194040ef0d7d85

2 weeks agoFix a minor problem with building sqlite3.c without manifest.tags.
dan [Mon, 6 Oct 2025 20:11:18 +0000 (20:11 +0000)] 
Fix a minor problem with building sqlite3.c without manifest.tags.

FossilOrigin-Name: 140f0f9fd389c99dc6ba1fdca7658c43d8dc3f3c128484fbafa7d67c33fe1001

2 weeks agoAvoid attempting to delete a file that is still open in sessionnoop2.test.
dan [Mon, 6 Oct 2025 17:52:52 +0000 (17:52 +0000)] 
Avoid attempting to delete a file that is still open in sessionnoop2.test.

FossilOrigin-Name: 56f6d6c538fd4e0da8a7c4e4c4d1bd0b8cd83ffd126ae24daaf30fdf808e1a78

2 weeks agoAvoid using randomblob() in walckptnoop.test, as it produces different results for...
dan [Mon, 6 Oct 2025 17:20:26 +0000 (17:20 +0000)] 
Avoid using randomblob() in walckptnoop.test, as it produces different results for different test permutations.

FossilOrigin-Name: 94ceb0f0cfef1da89ea2a7420f508024897d9b7c19ef9be9af88d3e6f48c297c

2 weeks agoChange the testrunner.tcl option from "--case" (singular) to "--cases".
drh [Mon, 6 Oct 2025 16:57:49 +0000 (16:57 +0000)] 
Change the testrunner.tcl option from "--case" (singular) to "--cases".
Allow the argument to be a glob pattern, to pick up multiple cases.

FossilOrigin-Name: e205f87f5cf97b82781af690da1a3fbf3dc75f590783074e5a72c1d7e3bebbad

2 weeks agoFix typo in the previous check-in that prevented the script from running. testrunner-enhancements
drh [Mon, 6 Oct 2025 16:56:12 +0000 (16:56 +0000)] 
Fix typo in the previous check-in that prevented the script from running.

FossilOrigin-Name: 797664700701effefbf4d87a791febae3bb68544bac23470351a11bcb3a87651

2 weeks agoAdd info from the SQLITE_SCM_... macros to tool/version-info.c's --json output, promp...
stephan [Mon, 6 Oct 2025 16:54:45 +0000 (16:54 +0000)] 
Add info from the SQLITE_SCM_... macros to tool/version-info.c's --json output, prompted by [forum:0c513ae3fca7d55c|forum post 0c513ae3fc].

FossilOrigin-Name: 951882aa4e1684b7b0f7e10590de81eae1ddb8c5ac21588e3f9b9cd4cb9f0f51

2 weeks agoUpdate testrunner.tcl so that the new option is --cases rather than singular
drh [Mon, 6 Oct 2025 16:50:37 +0000 (16:50 +0000)] 
Update testrunner.tcl so that the new option is --cases rather than singular
--case, and so that it is a glob pattern.

FossilOrigin-Name: 9488b4f00c9278de8c03f4a3cbd4f54e48e71c1eff45de4454f8bd49c080a930

2 weeks agoFix typo in the "testprefix" for walckptnoop.test
drh [Mon, 6 Oct 2025 16:23:31 +0000 (16:23 +0000)] 
Fix typo in the "testprefix" for walckptnoop.test

FossilOrigin-Name: ff205f29934417e8150b5243245fb70389717b219e35bd8d60791a8485b69b33

2 weeks agoNew testrunner.tcl option "--case DISPLAYLNAME" only runs the single case
drh [Mon, 6 Oct 2025 15:53:52 +0000 (15:53 +0000)] 
New testrunner.tcl option "--case DISPLAYLNAME" only runs the single case
(and its build dependencies) that exactly matches DISPLAYNAME.

FossilOrigin-Name: 8ea2e097b731514c284f255f12b08e15f63c7f49641a698e61ee7e47cc9d3c45

2 weeks agoFix testrunner.tcl so that --help output goes to stdout, not stderr.
drh [Mon, 6 Oct 2025 14:30:22 +0000 (14:30 +0000)] 
Fix testrunner.tcl so that --help output goes to stdout, not stderr.

FossilOrigin-Name: 441a759c225d4e710a693339402624e7ba52852c08aa64439ed4568c193ad529

2 weeks agoFix a subtle problem with short-circuit evaluation introduced by
drh [Mon, 6 Oct 2025 11:50:35 +0000 (11:50 +0000)] 
Fix a subtle problem with short-circuit evaluation introduced by
[cea8bf79e18d55a8] and detected by the dbsqlfuzz fuzzer.  Test cases
in TH3.

FossilOrigin-Name: d71cd722c478288601c70df8cec8c242cc623d2147b30f4f68dad57c75b3ee4a

2 weeks agoAnother small performance increase in the text format by using strchr() to
drh [Sun, 5 Oct 2025 22:41:32 +0000 (22:41 +0000)] 
Another small performance increase in the text format by using strchr() to
search for '%'.

FossilOrigin-Name: 59ad89ba07dd7b127f03f62a647f7328f08dbc0aa1b88b2b4529eb5b4c677775

2 weeks agoFix a syntax error in the tcl script part of [199b6567bb41cd].
stephan [Sun, 5 Oct 2025 19:56:57 +0000 (19:56 +0000)] 
Fix a syntax error in the tcl script part of [199b6567bb41cd].

FossilOrigin-Name: a7ed85f27066b74263dbd3dfcefe5d378e524cc56cd3abac4032bc23f83b5d21

2 weeks agoPerformance optimization in text formatter by using a hash table to look up
drh [Sun, 5 Oct 2025 19:30:05 +0000 (19:30 +0000)] 
Performance optimization in text formatter by using a hash table to look up
the operator character that follows %-subsitutions.

FossilOrigin-Name: 199b6567bb41cd41977e28b3e06e8c26c3300b3873f226a4699ec251a7bf8883

2 weeks agoMinor clarifications to the JSONB format documentation.
drh [Fri, 3 Oct 2025 18:17:13 +0000 (18:17 +0000)] 
Minor clarifications to the JSONB format documentation.

FossilOrigin-Name: 0fc708b41fe99b315b32e4a6ac8d48d8250195f7de1ab1d9f6eaf50290781286

3 weeks agoRemove the memvfs.c extension, to prevent it from being misused.
drh [Thu, 2 Oct 2025 22:48:08 +0000 (22:48 +0000)] 
Remove the memvfs.c extension, to prevent it from being misused.
See [forum:/forumpost/91811439aa|forum post 91811439aa] for the complaint
that prompted me to take down this demonstration code.  I have other things
to do rather than argue about posts such as the foregoing, so it is easier
to just take the code down.  If you need this code, you can downloading older
check-ins.  The beauty of DAG-based version control systems like Fossil
(and Git) is that nothing is ever lost; it is just stops appearing on
trunk.

FossilOrigin-Name: eb79110dcac80dde3bcca0929d67a8f8f6d2eea5695184b2b7c6788283f06902

3 weeks agoFix typo in the previous check-in. Remove surplus end-of-line whitespace
drh [Thu, 2 Oct 2025 19:35:58 +0000 (19:35 +0000)] 
Fix typo in the previous check-in.  Remove surplus end-of-line whitespace
from the ext/misc/fossildelta.c extension.

FossilOrigin-Name: cc87551805dc1fcb05598339e526b304401b64a4eaaa2148a9d837b1423484ce

3 weeks agoHarden the debugging vtab "delta_parse()" which is part of the
drh [Thu, 2 Oct 2025 19:19:40 +0000 (19:19 +0000)] 
Harden the debugging vtab "delta_parse()" which is part of the
ext/misc/fossildelta.c extension against malicious inputs.
[forum:/forumpost/be139437c3|forum post be139437c3].

FossilOrigin-Name: 4be6deee646f2c0f591ba81f902182ca9302050a7fb2729c7f64981307058b8b

3 weeks agoIn the ".open" command of the CLI if using the --new option with a URI
drh [Thu, 2 Oct 2025 18:31:19 +0000 (18:31 +0000)] 
In the ".open" command of the CLI if using the --new option with a URI
filename, then decode the URI to extract the actual filename prior to
trying to delete that file.

FossilOrigin-Name: 14ee3c1f03de274e5fa1efb471816a0001762623614253c24d58f41ea6af0628

3 weeks agoFix -DSQLITE_OS_OTHER=0 builds.
dan [Thu, 2 Oct 2025 14:48:27 +0000 (14:48 +0000)] 
Fix -DSQLITE_OS_OTHER=0 builds.

FossilOrigin-Name: 2971d7470110fcd43bdc8ad5d09d1f2f63f5a3bccda41810948a683e310ad908

3 weeks agoCorrection to [ae303dab2f534e2c] to use the right loop over the solver.
drh [Thu, 2 Oct 2025 11:28:27 +0000 (11:28 +0000)] 
Correction to [ae303dab2f534e2c] to use the right loop over the solver.

FossilOrigin-Name: 22b2700ac20bb8e5883d484bfd0aee7a0fbc99b92696d8ca850cd129e2ccbb43

3 weeks agoFix a buffer overrun in the zipfile extension that could occur while processing zip...
dan [Thu, 2 Oct 2025 11:16:22 +0000 (11:16 +0000)] 
Fix a buffer overrun in the zipfile extension that could occur while processing zip archives with extremely long file-names and comment fields.

FossilOrigin-Name: c284fda848038a61972fd1df5796f608a24ead109170aafe562a5d5787c46488

3 weeks agoAdd the --ifexists option to the CLI and to the ".open" command of the CLI.
drh [Wed, 1 Oct 2025 20:41:02 +0000 (20:41 +0000)] 
Add the --ifexists option to the CLI and to the ".open" command of the CLI.
Also the undocumented and unsupported --exclusive option on the same.

FossilOrigin-Name: 9a1947814d235d270dec265bb85db37e75cc077289e444d3d00f8345016c683e

3 weeks agoPrevent embedded 0x00 characters in the output strings from confusing
drh [Wed, 1 Oct 2025 19:01:19 +0000 (19:01 +0000)] 
Prevent embedded 0x00 characters in the output strings from confusing
the completion extension and causing it to read past the end of an array.
[forum:/forumpost/88a08b3201|Forum post 88a08b3201].

FossilOrigin-Name: 26f6d41f9d3ab656129af333d54a8645c6890314919bcae90351ba0c2240ceef

3 weeks agoFix a buffer overread in demo code in ext/misc/memvfs.c.
dan [Wed, 1 Oct 2025 14:28:48 +0000 (14:28 +0000)] 
Fix a buffer overread in demo code in ext/misc/memvfs.c.

FossilOrigin-Name: 90f7318308ca8372cbd9f183d88ff6cb884446f6df0695294c9a9955c5109f72

3 weeks agoEnable the CLI to be compiled with SQLITE_OMIT_AUTHORIZATION.
drh [Tue, 30 Sep 2025 19:11:00 +0000 (19:11 +0000)] 
Enable the CLI to be compiled with SQLITE_OMIT_AUTHORIZATION.

FossilOrigin-Name: afb2feb38043fef3c286030f9d1238c132f338e54233f2e4655323b388455c72

3 weeks agoFix various compiler warnings.
drh [Tue, 30 Sep 2025 17:37:18 +0000 (17:37 +0000)] 
Fix various compiler warnings.

FossilOrigin-Name: 24ee6c25b4745c8fd671d845b48b9ab98a787ccb348d560ad70f19d035e7990e

3 weeks agoFix the new generate_series() to correctly deal with an explicit 0 as the step.
drh [Tue, 30 Sep 2025 17:12:39 +0000 (17:12 +0000)] 
Fix the new generate_series() to correctly deal with an explicit 0 as the step.

FossilOrigin-Name: b059413c440d1b831c9a462f7165a350001ba7a8cc77ca2a0a8f2bb73c830aba

3 weeks agoFix another potential buffer overread in the zipfile extension.
dan [Tue, 30 Sep 2025 11:17:40 +0000 (11:17 +0000)] 
Fix another potential buffer overread in the zipfile extension.

FossilOrigin-Name: 0819fe670f9ceec79f84eb09c234dc29f6581332f86a53d6a0547697404efff1

3 weeks agoStrengthen the fts5_locale() function against integer overflow attacks,
drh [Tue, 30 Sep 2025 10:11:44 +0000 (10:11 +0000)] 
Strengthen the fts5_locale() function against integer overflow attacks,
even when SQLite is compiled with oversize values for
SQLITE_MAX_LENGTH.

FossilOrigin-Name: f0dbd9d22f558dd002e2132381de3c82d55a670399b3e527b5962b025141676a

3 weeks agoFix a problem with the merge at [cb604efdb40da95a].
drh [Mon, 29 Sep 2025 20:40:50 +0000 (20:40 +0000)] 
Fix a problem with the merge at [cb604efdb40da95a].

FossilOrigin-Name: ee6102d4fe35b7b914aa2dc7c7dd37460910efedc9b2d192c2fb8cb0e6a1fd4e

3 weeks agoChange the name to SQLITE_DBSTATUS_TEMPBUF_SPILL.
drh [Mon, 29 Sep 2025 19:57:43 +0000 (19:57 +0000)] 
Change the name to SQLITE_DBSTATUS_TEMPBUF_SPILL.

FossilOrigin-Name: 4a60a9c63534f5d2f16af2c3c6581abe7ecf7adfdb39f17e557e73997ae03396

3 weeks agoFix a buffer overread in the zipfile extension code.
dan [Mon, 29 Sep 2025 18:55:05 +0000 (18:55 +0000)] 
Fix a buffer overread in the zipfile extension code.

FossilOrigin-Name: 70c2c99b6f12a3467c23b44adcaf2d7d780ba8317b72de2f6730b1d892cf0c85

3 weeks agoMerge the latest trunk enhancements into the dbstatus-spill branch
drh [Mon, 29 Sep 2025 18:48:00 +0000 (18:48 +0000)] 
Merge the latest trunk enhancements into the dbstatus-spill branch

FossilOrigin-Name: cb604efdb40da95a759e2eeb9d73608859a94acde9d9782ca82757d3a1c15303

3 weeks agoImprove whereSolver() so that it always finds a unique solution.
drh [Mon, 29 Sep 2025 18:17:19 +0000 (18:17 +0000)] 
Improve whereSolver() so that it always finds a unique solution.

FossilOrigin-Name: ae303dab2f534e2c5132112b61fa5a097e7010fd8b652badee669fbe9df5cf53

3 weeks agoFix JSONB logic so that it correctly interprets large JSON5 hexadecimal
drh [Mon, 29 Sep 2025 14:09:43 +0000 (14:09 +0000)] 
Fix JSONB logic so that it correctly interprets large JSON5 hexadecimal
integer literals as positive numbers.

FossilOrigin-Name: 0ad5d77fc0a9d205cc061ee4923d885f6f28f77c1efef3cc10297036ce164e6d

3 weeks agoLarge JSON5 hexadecimal integer literals are positive unless preceded by json5-hex-fix
drh [Mon, 29 Sep 2025 13:43:10 +0000 (13:43 +0000)] 
Large JSON5 hexadecimal integer literals are positive unless preceded by
a negative sign.

FossilOrigin-Name: 5a93d9dce2d134ca450955bb272baba43dfc76beb540b643bf4bd31f7eb9e0b9

3 weeks agoBack out check-in [9abaa0ac2b304934] as the code removed there is necessary
drh [Sun, 28 Sep 2025 23:10:54 +0000 (23:10 +0000)] 
Back out check-in [9abaa0ac2b304934] as the code removed there is necessary
after all.

FossilOrigin-Name: 27ae98629406bbaee2857f75c069b2ccd4757b247f0742e51b9e619e96b6dc45

3 weeks agoRevamp the implementation of generate_series to simplify and improve
drh [Sun, 28 Sep 2025 18:25:59 +0000 (18:25 +0000)] 
Revamp the implementation of generate_series to simplify and improve
long-term maintainability.

FossilOrigin-Name: 9041ca8543ff3d2a617ce4df696aa53269a7803716caaf55a8e61e59ee667040

3 weeks agoRemove the long-defunct wasmfs build of speedtest1 from index.html and re-enable...
stephan [Sun, 28 Sep 2025 18:03:29 +0000 (18:03 +0000)] 
Remove the long-defunct wasmfs build of speedtest1 from index.html and re-enable the wasmfs scratchpad app (which still works). Fix the CFLAGS for the wasmfs build and the path to the wasm file for one of the JS.

FossilOrigin-Name: acaaf8cce9e780bf937436b4c987ed284aa0bba6f5ca9508d9dbad598af2991d

3 weeks agoMinor bug fixes. Many new test cases. series-refactor
drh [Sun, 28 Sep 2025 17:24:42 +0000 (17:24 +0000)] 
Minor bug fixes.  Many new test cases.

FossilOrigin-Name: 86dcc68d1816d970d8d5fb158696c3fe6c5ddcac2c255823110d656372503885

3 weeks agoUse new c-pp features to simplify generation of the tester1 family of files.
stephan [Sun, 28 Sep 2025 12:47:09 +0000 (12:47 +0000)] 
Use new c-pp features to simplify generation of the tester1 family of files.

FossilOrigin-Name: f7cab028c97b2c9ac9b561a4c33475aadd3f71cbd48ec4dd6e09c1bb19ec00cb

3 weeks agoAll legacy tests are passing. Want to add new test cases before merging.
drh [Sun, 28 Sep 2025 11:01:05 +0000 (11:01 +0000)] 
All legacy tests are passing.  Want to add new test cases before merging.

FossilOrigin-Name: adb80761d2319e16b6db2b5e35fedc239fad0ed5d26d629a5ea659c90881f76a

3 weeks agoThe generate_series rewrite is working better now, but is still not
drh [Sun, 28 Sep 2025 10:36:23 +0000 (10:36 +0000)] 
The generate_series rewrite is working better now, but is still not
completely correct.

FossilOrigin-Name: 6c41d14707e6890ca6d0460c72178ccb710d7f41dead76f222f1382c5cbd5a9a