bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
30,591 Commits 1,672 Branches 385 Tags
mistake
Commit Graph

30591 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
stephan
f4720e195e Back out [b144f875d6bddce6] and remove strchrnul() from printf.c because it's not as portable as we'd hoped. 
FossilOrigin-Name: fdb0d581134895af7676e8eb1a1c12353fafa0c67732e84214f10d5de89b1456
 2025-10-21 16:10:09 +00:00
drh
d41f5ef7e6 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
 2025-10-19 17:30:07 +00:00
drh
efe8ae567c Use 64-bit memory allocations everywhere in the expert extension. 
FossilOrigin-Name: 6caf793b8f406f5089e3811591bc69384646df16ee18d63bd63760eaaa95d122
 2025-10-18 11:19:02 +00:00
drh
21c57abc53 Increase the range of integer indexes in the the merge() family of 
SQL functions.

FossilOrigin-Name: 8d3943890ef3b533df35c4784c2a42c52503a4d9c3dbe67241510d8b70669b48
 2025-10-18 11:04:03 +00:00
drh
31c86ca0a8 Fix a minor memory leak in the CLI that can occur following an error 
in the ".output" dot-command.

FossilOrigin-Name: d1044bc0616fd20c63ca3b627ad0a116256870a082a72da26f98fb0f59ca44fd
 2025-10-17 10:06:44 +00:00
stephan
9f36870a77 Resolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum post 95edc7a8d7d1de59], with help from Bo Lindbergh. 
FossilOrigin-Name: b144f875d6bddce62e8f2ad42bfe5dfa6c2434f2ef3edb86847fb4c23aa46814
 2025-10-16 23:42:39 +00:00
dan
9c3fcd932d Improve performance of the shell tool ".ar" command when it is given a large number of arguments. 
FossilOrigin-Name: 8fed9de84bce01e88e0e8237e245c0ff9fe9f46394c603887e360658f5ef1ac1
 2025-10-16 14:17:30 +00:00
drh
0a585a64d2 In dbpage.c, disable truncation on any update error, including errors 
in sqlite3PagerWrite().

FossilOrigin-Name: eee5ba5d8a9d01000345185731c531eb84d3cb8e81bf429506c449d962aad843
 2025-10-16 12:43:36 +00:00
stephan
6eaeea0a3b Fix an off-by-one in c-pp-lite.c which could cause @token@-processed output to get one duplicated byte. 
FossilOrigin-Name: aa2f4c51604f4d4286c8a1ec7eaa6251892471e32087af695712513ee620ea46
 2025-10-16 01:44:03 +00:00
stephan
e826aa8e00 Minor JS doc updates. No code changes. 
FossilOrigin-Name: fc2a026901b1a12526b92fff36d7acc226e554c9f351e6261c7ffd4887bcc337
 2025-10-15 23:28:31 +00:00
stephan
ff5d4c348c 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
 2025-10-15 23:13:50 +00:00
dan
f66a0600d8 Improve performance of the shell tool ".ar" command when it is given a large number of arguments. 
FossilOrigin-Name: 0398897067ca5cdedfef0ce7a034ba6d5a2ce6104605ef4ed1c7549499435b44
 2025-10-15 15:54:38 +00:00
drh
34c1e04cbf 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
 2025-10-15 10:52:45 +00:00
drh
f83df5b150 Reestablish APIARMOR for the sqlite3_db_status() interface. 
FossilOrigin-Name: 1738f0bdf5941a70684c82d2040561e53a272595026a837a9f9bab8508a46480
 2025-10-14 19:21:46 +00:00
stephan
d6cb2ccee6 JS/WASM: Expose sqlite3_db_status64(), sqlite3changeset_apply_v3(), sqlite3changeset_apply_v3_strm(), and SQLITE_DBSTATUS_TEMPBUF_SPILL. 
FossilOrigin-Name: b13eafc9b6820517b450041a7e2be573a896b5b9e88b2b28df9f15e3cb91e23d
 2025-10-14 18:23:32 +00:00
drh
e7cf3fe4c8 Add the test/testloadext.c loadable extension to test the ability to use 
the latest APIs using the loadable extension mechanism.

FossilOrigin-Name: a9bd7ed6f77c5e53f9130eac7eb999c662e9158fb229a462d29f18653284d6d0
 2025-10-14 17:50:55 +00:00
drh
efde2f6059 Add the sqlite3_db_status64() interface and the 
SQLITE_DBSTATUS_TEMPSTORE_SPILL option for use in that interface.

FossilOrigin-Name: 9f8739ddea6ec6d8890d0e8f6a0143773a008e4f96bd02a48d4bfebb3f9b72fe
 2025-10-14 17:09:06 +00:00
drh
53a6b7d138 Make the new sqlite3_db_status64() API accessible to extensions. 
FossilOrigin-Name: 2ebd7330312f3ee4674c343b7a19b703f1f89611a6846a0e2be39867f9895522
 2025-10-14 16:57:50 +00:00
stephan
4472c967a6 Fix two links in ext/wasm/README.md. 
FossilOrigin-Name: 0f96eaeaa8c51c20f8d389bfd6d0d6371e8bb29ff7e8eaf3a0bcb35cb2b73338
 2025-10-14 14:07:58 +00:00
drh
abe709be8d Extra defenses against integer overflow in the decimal extension. 
FossilOrigin-Name: 1a7414d9b5be7ce18b23c357fd98cd0e96d78ac626abfa6e4e0dee494b6a1efc
 2025-10-14 14:03:09 +00:00
stephan
5dbbe50758 Add a section to ext/wasm/README.md about the dependency on wabt/wasm-strip for release builds. 
FossilOrigin-Name: 0dbb13863b3ff1da1be664967ac05c79cf34f7a78def05fe4f6407c06cb4322a
 2025-10-14 13:47:40 +00:00
stephan
9f136fc5ed Fix a makefile typo which caused a build directory to not get mkdir'd for the fiddle build. 
FossilOrigin-Name: d98d5abf6d27c5359ff8c797ad57394b96074e47010bc4c24120ba69a967dc3c
 2025-10-14 13:25:02 +00:00
drh
898ac77f55 Merge all the latest trunk enhancements into the dbstatus-spill branch. 
FossilOrigin-Name: 55f2613c1bacddb05902d4d5dac3d2b49b91053e6249dd926bb953c763eafeb0
 2025-10-14 11:18:45 +00:00
dan
264bcad69a 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
 2025-10-13 16:07:28 +00:00
drh
a8bb50ce95 Fix a bug in concat_ws() in which an initial empty string was treated as if 
it was a NULL value.

FossilOrigin-Name: eb2e4e46171c12f59aa5d571eeb310534360b110c3e7bda6eaf68f0e25546264
 2025-10-13 12:36:54 +00:00
drh
c93270ebc7 Enable CLI documentation for .imposter 
FossilOrigin-Name: c639c7be029f86defe6cb8cef094e1126ec8ab3968e12d4d2bf6e6ab23c39821
 2025-10-13 10:35:59 +00:00
drh
94356039d0 Fix broken hyperlinks in the documentation. 
FossilOrigin-Name: 62e6b120c43cd855349bf1b40ad2fb992e31a6e2567e5b145cf1849445849da7
 2025-10-12 19:17:31 +00:00
drh
ee4676b3f7 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
 2025-10-12 10:31:34 +00:00
drh
e4eaf174a5 Remove an unused variable from the generate_series implementation. 
FossilOrigin-Name: a523e4adbf8e60ea8c3351f33aff793c6e425c594038e8578d12564bf47aac03
 2025-10-11 18:44:54 +00:00
dan
59e1ab5576 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
 2025-10-11 16:23:22 +00:00
drh
11878165f6 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
 2025-10-11 15:45:47 +00:00
drh
5013fd1f81 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
 2025-10-10 19:43:03 +00:00
dan
eeb2e03b7b Back out [8bf26c956e]. It is not required following [8e7da8cf50]. 
FossilOrigin-Name: ea29180797aa4bb25180432e75a372277a6f6e2262906a9e765a3bddf8ca79d7
 2025-10-10 16:04:19 +00:00
drh
80f0fcd31d Fix harmless compiler warnings. 
FossilOrigin-Name: 4966d7a1ce42af8b1c50fdd40e651e80d0eeb8cb62dd882950cab275f98aba88
 2025-10-10 14:31:46 +00:00
drh
8c1670642d Makefile updates to suppose carray() and percentile(). Add Carray to 
the CLI and fuzzcheck to support debugging.

FossilOrigin-Name: fe9cf68b513d1e8cfcde90f1982a7f4123f54e3ebb004d961a99bdf6bec03a32
 2025-10-10 14:22:05 +00:00
stephan
e33786f09a Regenerate autoconf/Makefile.msc to squelch a 'make test' warning. 
FossilOrigin-Name: f7f55dce184c433b7774ab569caaeae5994c63421de01e9ea36aa1dbecb2d579
 2025-10-10 14:00:27 +00:00
drh
f9d511319b Fix the carrayfault.test script so that it works in configurations that 
do not support virtual tables.

FossilOrigin-Name: 767a667b91caff2e789179231f13a0d260c9837020c0ce1553b86e88cf9aa352
 2025-10-10 13:43:53 +00:00
drh
ea0d2cebd9 Avoid (apparently harmless) undefined behavior in CARRAY if the rowid 
is used as a constraint in the WHERE clause.

FossilOrigin-Name: 200b3c8f6cebf34428b0b41fc05f7361771dfee3592cfcdce512084abcc99713
 2025-10-10 10:40:37 +00:00
drh
7b34ca9cc1 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
 2025-10-10 00:59:28 +00:00
drh
8080411752 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
 2025-10-10 00:26:46 +00:00
drh
97fa2fe414 Fix carrayfault.test so that it works with the new built-in CARRAY. 
FossilOrigin-Name: 22f694682107036e68b67e48123d606aeff8cd8b7fedc8ab8ed9cc1a9cccd73f
 2025-10-09 19:23:01 +00:00
stephan
b4fdfc2f9a 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
 2025-10-09 15:28:59 +00:00
dan
40d299ae32 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
 2025-10-09 14:50:27 +00:00
drh
0f5a3f16f3 In the CLI, limit column widths specified by the ".width" command to 
have an absolute value not more than 30,000.

FossilOrigin-Name: b3741f1101d25eded57a62b4967ec1bcce532dc9937c4b7b74cb689861efb442
 2025-10-09 14:01:52 +00:00
drh
3be9a9b984 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
 2025-10-08 19:01:00 +00:00
drh
8f2f5e4963 Add the SQLITE_ prefix to the type constants used by sqlite3_carray_bind(). 
FossilOrigin-Name: e11e9913e56d42d2baa07f1b549f212b873fe7343a06825682d843471c4a3640
 2025-10-08 18:51:15 +00:00
stephan
0df9db4921 Make use of the new SQLITE_ENABLE_PERCENTILE in the wasm build. 
FossilOrigin-Name: 937c084c2d9b20fde2d54e48257cb7018bd8c36d6f00ed6f1659b5ecc2f48ed4
 2025-10-08 18:17:19 +00:00
drh
01f5e6e757 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
 2025-10-08 18:11:37 +00:00
drh
ba5cce9f08 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
 2025-10-08 16:29:14 +00:00
drh
cdaff852bf Were we to choose to integrate the carray() table-valued function into the 
amalgamation, that integration might look something like this.

FossilOrigin-Name: 2b43d5d7dcc5aee14a050c824a5e09b6a38a9c78ddcc25a994eba5d4c5ad9ba2
 2025-10-08 15:32:55 +00:00