]>
git.ipfire.org Git - thirdparty/sqlite.git/log
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
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
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
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
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
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
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
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
stephan [Wed, 15 Oct 2025 23:28:31 +0000 (23:28 +0000)]
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
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
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
drh [Tue, 14 Oct 2025 19:21:46 +0000 (19:21 +0000)]
Reestablish APIARMOR for the sqlite3_db_status() interface.
FossilOrigin-Name:
1738f0bdf5941a70684c82d2040561e53a272595026a837a9f9bab8508a46480
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
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
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
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
stephan [Tue, 14 Oct 2025 14:07:58 +0000 (14:07 +0000)]
drh [Tue, 14 Oct 2025 14:03:09 +0000 (14:03 +0000)]
Extra defenses against integer overflow in the decimal extension.
FossilOrigin-Name:
1a7414d9b5be7ce18b23c357fd98cd0e96d78ac626abfa6e4e0dee494b6a1efc
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
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
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
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
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
drh [Mon, 13 Oct 2025 10:35:59 +0000 (10:35 +0000)]
drh [Sun, 12 Oct 2025 19:17:31 +0000 (19:17 +0000)]
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
drh [Sat, 11 Oct 2025 18:44:54 +0000 (18:44 +0000)]
Remove an unused variable from the generate_series implementation.
FossilOrigin-Name:
a523e4adbf8e60ea8c3351f33aff793c6e425c594038e8578d12564bf47aac03
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
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
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
dan [Fri, 10 Oct 2025 16:04:19 +0000 (16:04 +0000)]
drh [Fri, 10 Oct 2025 14:31:46 +0000 (14:31 +0000)]
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
dan [Wed, 8 Oct 2025 11:00:04 +0000 (11:00 +0000)]
Fix an uninitialized variable problem in test1.c.
FossilOrigin-Name:
059203f658273712597d45d9b4a9cf1aea20368fe51224b38e28797b045fb6b8
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
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
dan [Tue, 7 Oct 2025 21:02:37 +0000 (21:02 +0000)]
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
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
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
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
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
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
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
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
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
drh [Mon, 6 Oct 2025 16:23:31 +0000 (16:23 +0000)]
Fix typo in the "testprefix" for walckptnoop.test
FossilOrigin-Name:
ff205f29934417e8150b5243245fb70389717b219e35bd8d60791a8485b69b33
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
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
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
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
stephan [Sun, 5 Oct 2025 19:56:57 +0000 (19:56 +0000)]
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
drh [Fri, 3 Oct 2025 18:17:13 +0000 (18:17 +0000)]
Minor clarifications to the JSONB format documentation.
FossilOrigin-Name:
0fc708b41fe99b315b32e4a6ac8d48d8250195f7de1ab1d9f6eaf50290781286
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
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
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
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
dan [Thu, 2 Oct 2025 14:48:27 +0000 (14:48 +0000)]
drh [Thu, 2 Oct 2025 11:28:27 +0000 (11:28 +0000)]
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
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
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
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
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
drh [Tue, 30 Sep 2025 17:37:18 +0000 (17:37 +0000)]
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
dan [Tue, 30 Sep 2025 11:17:40 +0000 (11:17 +0000)]
Fix another potential buffer overread in the zipfile extension.
FossilOrigin-Name:
0819fe670f9ceec79f84eb09c234dc29f6581332f86a53d6a0547697404efff1
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
drh [Mon, 29 Sep 2025 20:40:50 +0000 (20:40 +0000)]
drh [Mon, 29 Sep 2025 19:57:43 +0000 (19:57 +0000)]
Change the name to SQLITE_DBSTATUS_TEMPBUF_SPILL.
FossilOrigin-Name:
4a60a9c63534f5d2f16af2c3c6581abe7ecf7adfdb39f17e557e73997ae03396
dan [Mon, 29 Sep 2025 18:55:05 +0000 (18:55 +0000)]
Fix a buffer overread in the zipfile extension code.
FossilOrigin-Name:
70c2c99b6f12a3467c23b44adcaf2d7d780ba8317b72de2f6730b1d892cf0c85
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
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
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
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
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
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
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
drh [Sun, 28 Sep 2025 17:24:42 +0000 (17:24 +0000)]
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
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
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