database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
32,669 Commits 1,782 Branches 392 Tags
static-sql
Commit Graph

32669 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
b1637e5408 Fix the CLI so that it works when compiled using STDCALL on 
Microsoft x86.  Change should not affect other platforms.
[forum:/info/2026-06-02T09:44:12Z|Forum 2026-06-02T09:44:12Z].

FossilOrigin-Name: 83adece349aed73b8d0a3aec141213ea329150eb529f4fd9774ca157b49d02fc
 2026-06-02 10:08:30 +00:00
drh
b48ca02d64 Enhance PRAGMA integrity_check so that it better detects incorrect 
header sizes at the beginning of cells.

FossilOrigin-Name: 08bb2878e7575ab069f8f132537880a47a4d4543a1ac8bffc55e32488223245c
 2026-06-01 20:02:17 +00:00
dan
c28f2d22b6 Disable transitive WHERE constraints when there are explicit COLLATE operators. Fix for report [bugs:/info/ffddcd3617 | 2026-05-31T08:33:10Z]. 
FossilOrigin-Name: 18ee3a17c589cfd34500b6a6547d0cb51aea4dd14b4e1e4b2d0cf0dbfb32378e
 2026-06-01 18:01:13 +00:00
dan
48a591fa6b Minor performance improvement for the patch on this branch. 
FossilOrigin-Name: 2702fecc5c47704bdae535459e59260b55c571ff3b7d09617541e36829d4cf9c
 2026-06-01 17:56:11 +00:00
dan
2c351bbf82 Fix minor problems surrounding transitive WHERE constraints and explicit COLLATE terms. 
FossilOrigin-Name: 9500238a1d603a3f08a8fc0954725d5d217aab339720146ea0bc700e47b81c3c
 2026-06-01 17:40:23 +00:00
drh
ddea119f82 Make sure the authenticator is called for columns that are part of 
a USING in a FULL JOIN.
[bugs:/info/2026-05-31T02:00:37Z|Bug 2026-05-31T02:00:37Z].

FossilOrigin-Name: 4ef88a36f9d9669b0d74c58f79ad497803885ff6078e5f9685f13c96eab397cc
 2026-06-01 16:49:39 +00:00
dan
03aa9a7b50 For expressions of the form "(x, y...) IN (SELECT a, b ...)" where the result is not true, consider the collation sequences of columns "a" and "b" when determinining if the result should be false or NULL. Bug report [bugs:/info/0785f45e67 | 2026-05-31T02:10:44Z]. 
FossilOrigin-Name: 04d7a9d788cf0bb811483baceb9142f67d4a2380d4af409d5300a92f7972472e
 2026-06-01 16:20:40 +00:00
dan
62d17739bc Better handle a (possibly) potential buffer overrun in fts5. Based on the report in [bugs:/info/38e75aa4f9 | 2026-05-31T09:06:13Z]. 
FossilOrigin-Name: 9d0e39408075f22dd56ad5fb50ef458c0cd6a4ec234dd43b3a5f5e0ac4447b61
 2026-06-01 15:03:53 +00:00
stephan
f55434ab30 Remove the data type ANY added to the shell's CSV exports in [aff74e71ea734e1a], as discussed in [forum:2ea4c50f69fc9829|forum post 2026-06-01T12:01:59Z]. 
FossilOrigin-Name: a6a347aec5ff33b24d877ac0f04018f4e93748361da62ed27b1abec77840963e
 2026-06-01 13:14:48 +00:00
drh
0a04687373 Do not allow the argument to a table-valued function to reference a table 
to its right, even if the SELECT is inside a common table expression.
This is a replacement for the fix at [3c0a277e6741c722].  Fix
for multiple dbsqlfuzz reports and probably also a fix
for [bugs:/info/b6c6fad96c|Bug 2026-06-01T07:23:11Z].

FossilOrigin-Name: d96271db6a3a44e50d1a977250c4cc14178612a6c838e7c51c5f79fda45ae19f
 2026-06-01 12:36:28 +00:00
drh
c079bd08a2 Test case to show that the change fixes the original carray problem. 
FossilOrigin-Name: 8df6671ae8211b706b7d4f073c5166f0f41f3c11339bc4d28997e8a205a39545
 2026-06-01 12:30:13 +00:00
drh
5cae890219 Improvements to sqlite3SelectCheckOnClauses() to be more accurate in 
identifying table-valued functions that references tables to the right.

FossilOrigin-Name: e5bae3687dbb470ead7e8d6bf428b1fbb1e9f10c214bc2a91e93e68fb2ae6ff7
 2026-06-01 12:19:30 +00:00
drh
f3eea1efa4 Back out the recent change to carray. The intent is to fix this problem 
in a different way so that it works for all table-valued functions.

FossilOrigin-Name: 43e02dbb0dbe7192304125cd3298b3f4bbac02395d4d03f7f8d5f96b465eb43e
 2026-06-01 12:07:21 +00:00
dan
3040da55a8 Fix an integer overflow that could lead to a buffer overrun in the zipfile extension. Bug [bugs:/info/2026-06-01T10:16:47Z | 2026-06-01T10:16:47Z]. 
FossilOrigin-Name: a8dac6af353c02aed8eaaba5921e036d3f3a6639367ae70e8c75d759c7b4ab52
 2026-06-01 11:52:23 +00:00
dan
1a760748a6 Update new test in zipfile.test so that it does not run if SQLITE_MAX_LENGTH is too small. 
FossilOrigin-Name: cc86820e198db6ee4e62f455d3dd9877d73873aaccad6ceffd0b34452d35c89c
 2026-06-01 11:50:55 +00:00
dan
5481274912 Fix an integer overflow that could lead to a buffer overrun in the zipfile extension. Bug [bugs:/info/2026-06-01T10:16:47Z | 2026-06-01T10:16:47Z]. 
FossilOrigin-Name: 7c740d2cfd22a89258be2221860ca10985f0fc16dc7a17a99fc282d7105dc38e
 2026-06-01 10:56:11 +00:00
drh
6c218ba0ad Extra defenses against integer overflows in the untested, unused, and 
unsupported transliterate() SQL extension function found in the
ext/misc/spellfix.c extension.
[bugs:/info/2026-06-01T10:34:57Z|Bug 2026-06-01T10:34:57Z].

FossilOrigin-Name: 2b073519b6080abc8872b0728c64827cc088d1b43f132cd2aeb396f06de3d36f
 2026-06-01 10:53:28 +00:00
drh
ca8593ce68 Fix the carray virtual table so that it gives no solution if it cannot 
find a usable first parameter.  dbsqlfuzz find.

FossilOrigin-Name: 3c0a277e6741c72281e12c44d85902aa6780890a7f59bacc3ac2b35ba27f7211
 2026-05-31 19:41:16 +00:00
drh
af6fdd2673 Test case to cover the bug fix in the previous check-in. 
FossilOrigin-Name: 5b28d49b61d5edc9fef896e685bf227b7e1716c0cc666fd2ebe0d5ea0d11af06
 2026-05-31 17:01:44 +00:00
drh
1cd9eb3811 Fix the zipfile extension so that ZIP archives containing files whose names 
contain embedded \000 bytes do not cause problems.
[bugs:/info/2026-05-31T11:43:05Z|Bug 2026-05-31T11:43:05Z].

FossilOrigin-Name: c12ff342a90c61a0a82c8e63d2d94fecec10dff498da666873ff6aaa15c23dfd
 2026-05-31 15:49:57 +00:00
drh
7437c19a01 Fiddle should default to using NO_COLOR since the JS console does not 
support ANSI X3.64.

FossilOrigin-Name: bde6190fdeb530bfb92524ab5542f3f4b64adf31c31de1e00fe4430a8e00411f
 2026-05-31 09:38:28 +00:00
drh
d076d98ec8 Fix the format() SQL function so that it reports TOOBIG and NOMEM errors. 
Fix a possible integer overflow on %#Q formatting.
[bugs:/info/2026-05-31T02:00:07Z|Bug 2026-05-31T02:00:07Z].

FossilOrigin-Name: 3bfe0510aecccf113b9d008c308fca3096e9c45c59b919c0b91bb4703415988f
 2026-05-31 09:18:31 +00:00
drh
72f0bd609c Add a test to ensure an application does not try to create a geopoly 
virtual table with too many columns.
[bugs:/info/2026-05-30T12:47:27Z|Bug 2026-05-30T12:47:27Z].

FossilOrigin-Name: 2c605bfb1562d7a3609ad6ffd7446def12f1ac7084e41b9c6723e998c156501d
 2026-05-30 13:23:25 +00:00
drh
7aad2942c2 Harden the diskused.c extension against NULL pointer deferences that 
might have previously occurred when given a corrupt database file.
[bug:/info/2026-05-30T07:08:55Z|Bug 2026-05-30T07:08:55Z].

FossilOrigin-Name: 7487a1c59d3aaea9f8b2569dca76bbccf21948b1e7bd8a1d841e04382db696f4
 2026-05-30 10:24:03 +00:00
drh
07ded24fbb Remove the untested and undocumented "scrub" utility program. It was written 
in 2016, but made obsolete by the [VACUUM INTO] command in 2019.

FossilOrigin-Name: 27d67fb175e839f6e7450f54166b52e0a6137c075758511da32fd82c57c310c4
 2026-05-30 10:09:33 +00:00
drh
5b98467d28 Be sure to do floating-point to text conversions in JSON to the full 
17-digits.

FossilOrigin-Name: 61a776650cdc3fe632bdb1dc39f50f542b00a9e5b468180eb54b69750d0cd70c
 2026-05-29 23:14:22 +00:00
drh
3d006d0d00 Rename the ext/misc/analyze.c extension to ext/misc/diskused.c, to avoid 
confusion with the src/analyze.c file.  The function is now called
"diskused(X)" instead of "analyze(X)".  The CLI command is renamed
from ".dbstat" to ".diskused".

FossilOrigin-Name: c7839f7a1749b38f8a36c06d93a7b59095e91ce753e8dd020de273ca8f73a239
 2026-05-29 14:57:38 +00:00
drh
991cbd78b3 The -csv option to the CLI also sets "-limits off", for legacy 
compatibility, and because that seems to make sense.
[forum:/info/2026-05-28T16:23:36Z|Forum thread 2026-05-28T16:23:36Z].

FossilOrigin-Name: d15cd64160192119a5f12afec14dbfbb30fb38a8557cb9dc559b3f061c15687a
 2026-05-29 12:23:38 +00:00
dan
6a8e887a64 Avoid a resource leak in an error path in the icu extension. 
FossilOrigin-Name: 87c37dab7e53d1bd891f3fed624963b35ab15a785706d0964b5d07ab70421c10
 2026-05-28 11:29:05 +00:00
drh
43ab3c2a84 Fix an infinite loop that can occur in the unused, untested, and 
unsupported ext/misc/btreeinfo.c extension if it is presented with
a corrupt database file.
[bugs:/forumpost/b43c44cc1c|Bug 2026-05-28T05:41:01Z].

FossilOrigin-Name: 646e9b49153ebd7e09e3ef72cc4f64fb685d0cfd8b158ef7d11d37c50c3f0b7e
 2026-05-28 11:16:55 +00:00
dan
9b7ea5700b Fix a problem with shell tool function analyze() and schema objects with name containing "%" characters. 
FossilOrigin-Name: c6d5793d5d2212c979e2fe5eb12c3844bfc1f2029bd8d076fec030a04f6d4bb5
 2026-05-28 11:12:29 +00:00
drh
720d3afa7e Fix potential integer overflow in btree overflow page cache computation, 
reported by Project Fortify.  Test cases in TH3.

FossilOrigin-Name: dfa674d6e6bffdb930dbefa767831db7862c322b6d3c7a6322f0fa0f087aaaf9
 2026-05-28 10:14:25 +00:00
stephan
4cc2dbd54d Patch test/indexexpr1.test to work when built with SQLITE_DQS=0. Addresses [forum:2026-05-26T18:08:20Z|forum post 2026-05-26T18:08:20Z]. 
FossilOrigin-Name: b470a5d69e70d3440467e7792231f8556111d2c1126cf62879bbfd214ac0a9e0
 2026-05-26 19:25:36 +00:00
stephan
b79ffe60b6 Fix an OOM check in shell.c.in. Addresses [forum:2026-05-26T15:02:35Z|forum post 2026-05-26T15:02:35Z]. 
FossilOrigin-Name: e78198e6aec57c28e33a5b1c5ae9943115a35d2fbfa04c8428318567f17eefbe
 2026-05-26 17:15:54 +00:00
dan
6e3e557c81 Fix a potential 1-byte overread in sqlite3changeset_invert() when processing a corrupt buffer. 
FossilOrigin-Name: 78eaa605cb6c14e5bd49a898b4c737957bd60c8714913cc2341f4ffe3bfe81fe
 2026-05-26 15:03:30 +00:00
dan
18bee1617f Fix a 32-bit integer overflow in sqlite3changegroup_change_blob() that could lead to a buffer overwrite. 
FossilOrigin-Name: 8a289158e2baeee8aa5e601bde46b0482361064ede09e4108f519270efdd5f69
 2026-05-26 14:18:50 +00:00
drh
2315f282be Fix QRF so that it works sensibly with "--wrap 1" 
FossilOrigin-Name: 48f950b2a1ef841d915ca733baf324a1af98e644b660f238dd5018015340a6c6
 2026-05-26 13:54:57 +00:00
drh
ce2f503c1c Strength the defense against malicious command-line arguments in the 
sqlite3_rsync utility program.

FossilOrigin-Name: c84d596b6da22061627282d444913c88dc2f9bd82e86957183f7e732f2713b33
 2026-05-26 11:23:00 +00:00
drh
5554aa27e6 Fix HTML ">" quoting in QRF. 
[bugs:/forumpost/f72dfbdeff|Bug f72dfbdeff].

FossilOrigin-Name: 5cee1097b47d850989ebecdb9d2c814e6968240fe3bacb5598ca85067cb95692
 2026-05-25 23:44:37 +00:00
drh
5cfa63e6c8 Fix a minor problem with test case mjournal-3.3. 
FossilOrigin-Name: 80093dc0610438cd506d230eca12e699e05395aecb8048c5bc066379b927e8bb
 2026-05-25 20:45:43 +00:00
drh
0ca827a590 Early malformed JSON errors in json_each() and json_tree() to prevent 
excess output.

FossilOrigin-Name: eb4d7e1b86b1d1bece01f621c9991a11f4812bf515a973b5036b09a1392134e2
 2026-05-25 19:47:58 +00:00
drh
7e20b624db Fix to testrunner.tcl so that it will run on FreeBSD. 
[forum:/info/2026-05-25T18:50:36Z|Forum post 2026-05-25T18:50:36Z]

FossilOrigin-Name: 97b66687b3f772e225e1792194a7f54a2ae187c84de1d76227846503631b5c2f
 2026-05-25 19:32:52 +00:00
drh
94c8755a95 Enhance the defenses against malformed JSONB in the jsonbPayloadSize() 
routine.

FossilOrigin-Name: 32c9f71a989fa4c81a613398ca5c1e68eb88b2a90ac4a4a7bf39e755717f43b1
 2026-05-25 18:46:42 +00:00
dan
8c9071ae4e Use "-encoding iso8859-1" instead of "-encoding binary" in mjournal.test so that the script works with both Tcl 8 and 9. 
FossilOrigin-Name: 897b443fb35d550891315890a5af473d347af3b6ecea11fcafafb5b06a1b50a5
 2026-05-25 18:14:58 +00:00
dan
e1233bb609 Fix a potential 1 byte overwrite that could occur when processing a carefully crafted super-journal file. 
FossilOrigin-Name: b3766c3afd0ac4d31f158ee5938f19d72a047872e422b5f19b1567c60640f54d
 2026-05-25 17:58:07 +00:00
dan
00ba6a6635 Fix a potential buffer overwrite that could occur when in fts5 when handling corrupt records. 
FossilOrigin-Name: de009593f692251c4a033742b1e79c4ddb5ddcb174209d58c4d1bea19ceb360c
 2026-05-25 17:09:37 +00:00
drh
3020203708 Make the /A substitution in the CLI prompt expansion responsive to the 
SQLITE_CLI_APPNAME compile-time option.

FossilOrigin-Name: 624dc12e9e6dece22f7d247b66f0889755295cb2154502ade6553c13b8fecd83
 2026-05-23 12:14:05 +00:00
drh
db7fe319ed Strengthen the statement about not accepting agentic code. 
FossilOrigin-Name: 64b707f4b3177384b611df5f5e4ca7da44d86313f74ff943a00581a6dd924b08
 2026-05-22 17:51:15 +00:00
dan
3eb6a5ee33 Update the session module so that it can apply changesets containing two or more UPDATE changes that form a dependency loop - so that no single UPDATE can be applied independently without violating a constraint. 
FossilOrigin-Name: 32c762bbb187e3bc964dcaad0949ebeb4da21331be842a5868feeac6088790ca
 2026-05-22 14:29:33 +00:00
dan
f380599476 Add the SQLITE_CHANGESETAPPLY_NOUPDATELOOP option to the sqlite3_changeset_apply_v2/3() method. To disable the extra processing to commit changesets that swap two or more values subject to a UNIQUE constraint between rows. 
FossilOrigin-Name: eba02092bcf1713a646ecf8febd53a83bc803cf1b17e2e4fc590c14d886a8d27
 2026-05-22 14:22:14 +00:00