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
e12c6f2590 Updates to build instructions, especially on Windows. Fix a harmless 
compiler working in debug builds on Windows.

FossilOrigin-Name: be245e136a550faa7c84694156c40dc9778f50b00016892c29a2314bef14b6b7
 2026-08-01 15:08:48 +00:00
drh
f034d515b4 The use of sqlite3_set_clientdata() to limit recursion in [4687e04d948b787c] 
is incorrect.  Fixed here.

FossilOrigin-Name: bf44a08adc94b8c7c69921a1292d56bec0cbd9f3ac772e31d8ea5866e9f46063
 2026-07-31 22:45:45 +00:00
stephan
648be9e67f Update ext/wasm/libcmpp.c for build portability improvements and doc updates. 
FossilOrigin-Name: 48fdf51b53e9314f938fb0107ba04f6051d6c47b743c47e30c18a1be0da4015c
 2026-07-30 12:17:33 +00:00
drh
db30b1cbc3 Enforce the 1GiB size limit on appendvfs files. 
[bugs:/info/2026-07-29T06:29:52Z|Bug 2026-07-29T06:29:52Z]

FossilOrigin-Name: 180e75e07630b4fa7abdd28ad889e27031071555078989c40a8c10a1d2905338
 2026-07-29 23:47:55 +00:00
drh
9274a8d14e Fix the detection ON clauses using tables to the right so that it does 
not depend on the order of cursor allocation, which is inconsistent with
recursive CTEs.  Problem introduced by [d96271db6a3a44e5]. Reported by
[bugs:/info/2026-07-29T17:50:40Z|Bug 2026-07-29T17:50:40Z].

FossilOrigin-Name: 5a22150bf812774825ffc5bd8adcb5aa6d2177d5fe7eb95cb4130e4a44a706c6
 2026-07-29 23:28:56 +00:00
drh
8782e0b5be Improve comments. Move a variable outside of a loop. 
FossilOrigin-Name: f26831158e28a46805466da71b3fc04e19c2199545cc8c5d68281867f8110ef3
 2026-07-29 21:09:37 +00:00
dan
817458fe70 Avoid assuming that cursor numbers were allocated in order for all SrcList objects when detecting ON clauses that refer to tables to their right. Possible fix for [bugs:/info/2026-07-29T17:50:40Z | 2026-07-29T17:50:40Z]. 
FossilOrigin-Name: ebfea8cfb03e0578364bb1f5f8f44c55127f2155d9a0999865a811098f69e9f4
 2026-07-29 19:17:40 +00:00
drh
9c94fcbea8 In the experimental and unsupported amatch.c extension, raise an error 
if a cost value is out of range even if the rule that the cost applies
to will never be used.
[bugs:/info/2026-07-29T06:30:13Z|Bug 2026-07-29T06:30:13Z]

FossilOrigin-Name: 86b7a62c5ccf41479a9556e705e3c43973a4033c2db42d298050dcfce121ee05
 2026-07-29 18:03:45 +00:00
drh
9b6fbaf4ca Do not allow recursion in extension functions sha1_query() or sha3_query(). 
[bugs:/info/2026-07-29T06:29:33Z|Bug 2026-07-29T06:29:33Z].

FossilOrigin-Name: 4687e04d948b787cee748279b13774ee1389bb179f8762720631a540f5cd9136
 2026-07-29 17:36:16 +00:00
drh
a44c884677 Turn redundant loads of the experimental vfsstat.c extension from a 
stack overflow into a harmless no-op.
[bugs:/info/2026-07-29T06:28:47Z|Bug 2026-07-29T06:28:47Z].

FossilOrigin-Name: add89fba2ffe9da5b0305182c97f8408e0dd7d2c3d81f40e0a84f6f79154c5a3
 2026-07-29 17:19:00 +00:00
drh
d14c3f15ff Turn redundant registrations of the cksumvfs extension from a stack 
overflow into a harmless no-op.
[gugs:/info/2026-07-29T06:28:31Z|Bug 2026-07-29T06:28:31Z]

FossilOrigin-Name: d6453bc80e6e717813f2f5d4a40548cbc25e83e09c209793cacfddb94a408053
 2026-07-29 17:08:52 +00:00
dan
88a179e9eb Return an empty string if an fts3 snippet() is requested for an out-of-range column index. Bug [bugs:/info/2026-07-29T06:30:35Z | 2026-07-29T06:30:35Z]. 
FossilOrigin-Name: 5c645d5e241f6055c8dd45936a52245ecb2476a6603e06b793912bf897e42239
 2026-07-29 16:55:36 +00:00
dan
3ba939e640 Always take a copy of a value used to drive an index as part of a RIGHT JOIN loop. Otherwise, the RIGHT JOIN loop and the body of the loop it jumps back into may interfere with each other. Fix for [bugs:/info/2026-07-29T05:33:50Z | 2026-07-29T05:33:50Z]. 
FossilOrigin-Name: 8d626b31ae058de1eebb50d9b6e777318bd9d3a4c75e9f5ada4faba88a1e0188
 2026-07-29 15:57:29 +00:00
dan
7932ea0f9a Always take a copy of a value used to drive an index as part of a RIGHT JOIN loop. Otherwise, the RIGHT JOIN loop and the body of the loop it jumps back into may interfere with each other. Possible fix for [bugs:/info/2026-07-29T05:33:50Z | 2026-07-29T05:33:50Z]. 
FossilOrigin-Name: d7ad2d0a91b7b837b09b04f78e617fe80eb5ae48f178446c942c2a84e0e0201a
 2026-07-29 15:49:38 +00:00
dan
3bc026df6e Avoid apply an affinity to a register that might be the result of a TK_AGG_COLUMN expression, as it might be reused. Fix for bug [bugs:/info/2026-07-29T05:51:06Z | 2026-07-29T05:51:06Z]. 
FossilOrigin-Name: b9ecd9caf755dd33f1de952ac8e5e2d731c20880a0872f10494f92ecf8cae331
 2026-07-29 15:13:41 +00:00
dan
98c319e259 Avoid apply an affinity to a register that might be the result of a TK_AGG_COLUMN expression, as it might be reused. Possible fix for bug [bugs:/info/2026-07-29T05:51:06Z | 2026-07-29T05:51:06Z]. 
FossilOrigin-Name: e5cce8a0026e71985f3afd07aba4b3f550871a1079d18234efa19438eed15d2d
 2026-07-29 14:23:30 +00:00
drh
37275bc277 Block deep recursion in test extension functions test_eval() and eval(). 
Does not affect deliverable code.
[bugs:/info/2026-07-29T06:29:11Z|Bug 2026-07-29T06:29:11Z]

FossilOrigin-Name: 3e99c27fe3db76a146bb4a77c08007e6c4598cda7975dd40d4f7f14c3bd914b5
 2026-07-29 13:00:37 +00:00
stephan
77ef17960c Add long-missing sqlite3_backup bindings to JS/WASM, in response to [forum:dc96ed27b3fdb202|forum thread dc96ed27b3]. This does not yet include tests. 
FossilOrigin-Name: 90e599757416059044c643121631fc56eab2b6eea76d04b2d99eae49b8adef44
 2026-07-29 12:51:52 +00:00
drh
d565536731 Improved comments clarifying operation of the ext/misc/noop.c testing 
extension.
[bugs:/info/2026-07-29T06:31:22Z|Bug 2026-07-29T06:31:22Z].

FossilOrigin-Name: c9bb594059c5e7ad6fd04f1b8087910833d89f05ddf1b6eea6bd5590c851c790
 2026-07-29 11:28:07 +00:00
drh
67cfb59334 Fix the sha1() extension function so that it interprets zero-length 
BLOBs as BLOBs and not as NULL.  Also add a few test cases for that
extension function, which was previously completely untested.
[bugs:/info/2026-07-29T06:31:41Z|Bug 2026-07-29T06:31:41Z].

FossilOrigin-Name: 978d12de384fef985d0363633566304bb20f452dfe8ceb836ca1d353a135f30a
 2026-07-29 10:28:44 +00:00
dan
5a9c01b01a Further fixes for running [make devtest] with Fil-C. 
FossilOrigin-Name: 1ed5e5bed26e3d38dd09541ce73dc68188574e236ecb60142260a0c40bf8902a
 2026-07-28 14:16:52 +00:00
dan
924626e603 Remove a stray reference to "sqlite3_checker.exe" from Makefile.msc. sqlite3_checker was removed from the tree here [213b1c6608]. 
FossilOrigin-Name: 86bc7c8648fa6df303cd6953e377227d8a778b7becca984332bb6f623cb52cec
 2026-07-27 14:22:55 +00:00
drh
43306f881e The MREMAP_FIXED macro (added by [4d60798b20a560be]) is not available 
on all platforms.

FossilOrigin-Name: 8afa7a1d40eef6fd5e9d6a2c250822de607cb211b301547a3317bdb9e942c937
 2026-07-27 11:19:44 +00:00
drh
35db2d60d3 Use snprintf() rather than sprintf() in the dtostr() test function of 
the CLI. [forum:/info/2026-07-27T09:44:11Z|Forum 2026-07-27T09:44:11Z].

FossilOrigin-Name: c0681a6cb72c3bf012a253206ba4ef30db039cdfb01d53758cdb184b67ff954f
 2026-07-27 10:19:50 +00:00
drh
d9305a65c8 Add reference counting to the EditDist3Config object in the spellfix 
extension.  This should prevent possible UAF following OOM as
described by [bugs:/info/2026-07-26T07:55:13Z|Bug 2026-07-26T07:55:13Z].

FossilOrigin-Name: 37364eaecc148133de4e5b329e10c70922e65829244b4abd448c0adb5ca40877
 2026-07-26 18:45:54 +00:00
stephan
53d99267bb Add a JS test for [d5d8ee76d3] resp. [012550c089]. 
FossilOrigin-Name: f28494eeafc37320932a932044ecd66b6900632a1eccd45a9f8bed653cee3466
 2026-07-26 16:05:47 +00:00
stephan
76a15f2b95 Factor an extranous local var out of the previous check-in. 
FossilOrigin-Name: 422b4303dae214e23a53b181e5cdf7888d159da33e1675fd8317cbe66834b78e
 2026-07-26 15:56:06 +00:00
stephan
bdde38eb0c Remove some extraneous I/O in kvvfs. Reported off-list by Jure Rotar. 
FossilOrigin-Name: ce09bfe406728312761a9f227b3f82cbee7cc176dddac1a499e10480a7ee2c1c
 2026-07-26 15:47:56 +00:00
stephan
fdb802581c Fix a JS container API misuse in sqlite3.oo1.DB.close() which caused its fallback cleanup of still-open statements to not actually do so. Reported off-list by Jure Rotar. 
FossilOrigin-Name: d5d8ee76d337820f765cea7b279f2e5644a24d4f0e76d53b35b4d52277edb767
 2026-07-26 15:39:18 +00:00
drh
701092f4a5 Improved optimization of "expr OR TRUE" and "expr OR FALSE". 
[bugs:/info/2026-07-25T08:36:25Z|Bug 2026-07-25T08:36:25Z].

FossilOrigin-Name: 2f0bde4bc89c2b088c8f821719d7e457d9129c0493032152b8f4472673973e58
 2026-07-25 18:56:31 +00:00
dan
536ec8a991 Avoid opening cursors only required for reads that are optimized away by the exists-to-join optimization. Addresses report [bugs:/info/2026-07-25T08:39:23Z | 2026-07-25T08:39:23Z]. 
FossilOrigin-Name: c81ec73a3780cf7a44965f1763f1e6e2c324b60132197756fdb351e98052fd02
 2026-07-25 17:13:30 +00:00
dan
c571cec033 Ignore any DISTINCT qualifier on a SELECT statement on the RHS of an IN(...) expression. Forum post [bugs:/info/2026-07-25T08:40:13Z | 2026-07-25T08:40:13Z]. 
FossilOrigin-Name: c54858eab45f71a77249c8ecdc8e107cf631e743b8b883f2b6db60e0bf7e908a
 2026-07-25 14:49:40 +00:00
dan
7d3a41d1f8 Fix an incompatibility with Tcl 9 in scanstatus2.test. 
FossilOrigin-Name: 2f1f4f73535386549c12694dc57cfe555eec689ae6824c6241aaf8d5befcd74d
 2026-07-24 16:28:47 +00:00
drh
5694c3bb2a Fix a bug in the check-in [bbd69ce274620008] causing that bug-fix 
check-in to fail to completely fix the original bug.  This fix is in response
to the follow-up report at
[bugs:/info/2026-07-24T02:52:08Z|Bug 2026-07-24T02:52:08Z].

FossilOrigin-Name: 2cb22877683680c1f89bcc9edb47bd1a4a8755d4a6b846a1a20136a657dacdcc
 2026-07-24 14:53:59 +00:00
dan
b047809309 Fix a problem in test1.c causing test script win32lock.test to fail. 
FossilOrigin-Name: 8f6d25b3f0171a40be8a5cb646739f54e496aaf9d4829c24c243ec4b71e0caa8
 2026-07-24 14:10:00 +00:00
drh
2273627228 Fix to the interaction between indexes-on-expressions, subtypes, and 
the unary "+" operator.  This is a continuation of the prior fix from
check-in [d75c08c8416bde3f].  This enhanced fix is prompted by
[bugs:/info/2026-07-24T08:42:47Z|Bug 2026-07-24T08:42:47Z].

FossilOrigin-Name: 5398c6a2b6b218461ce1f6437791c62c1ee125fba195660e0d6d1ad97ed6d14c
 2026-07-24 13:36:44 +00:00
dan
5f5fb71834 In test_syscall.c, assume SQLite always calls the 4 (not 5) argument form of mremap(). This fixes a problem with Fil-C and mmap2.test. 
FossilOrigin-Name: 4d60798b20a560beb945afe7e2998714aa7e5a83a9db078d4431040f0b6e7350
 2026-07-24 10:38:27 +00:00
drh
1f2f8741b7 Fix some test cases on Windows. 
FossilOrigin-Name: d2d6363f31ecbae353a1e80810f42d9e2f0f8db0fe6294c7deadf0c58669b9d0
 2026-07-24 00:39:41 +00:00
drh
1a2ed04399 Enhance Bloom-filter support so that it works with blob values and with 
text values as long as the collating sequence is binary.

FossilOrigin-Name: a67bff640c9e4ffdf2f48c049eaf829b9e43d167a1055bf8780ff29c910bbade
 2026-07-23 21:34:16 +00:00
drh
bed078a865 New test cases for Bloom filter use on text keys as long as the 
collating sequence is binary.

FossilOrigin-Name: 98ced971bfd48aedf862fa0f8674744723e36eeda2ad600e91062fc8b7d9da9e
 2026-07-23 20:23:04 +00:00
dan
6f9ef2245e Change the way pointers are passed between C code and Tcl test scripts. This allows tests to be run with Fil-C builds. 
FossilOrigin-Name: ba919ea1d4fe84526a4c844b3f901e5e8b1650dcdee647e4d46da2d33ced1710
 2026-07-23 20:04:20 +00:00
drh
b4ca411eb6 Improved Bloom-filter invariant checking. 
FossilOrigin-Name: f38f4167110df11ba54816932126f695dc6e114d4001d0261669807a55ad7966
 2026-07-23 18:55:12 +00:00
drh
bc9d2a9515 Fix the new filterHash() function so that it works correctly for zeroblobs. 
FossilOrigin-Name: 3013d6ab4afd4f63fa63a773778adcf07821cfcb33e3ae42752aea13fd2b6224
 2026-07-23 17:41:10 +00:00
drh
83f39c1788 Add the ability for Bloom filters to work on text values, as long as 
the collating sequence is BINARY.

FossilOrigin-Name: 2577edc796505a0a6dabccbcc1bb6a828457092caa4d074561da5e58a6f065a2
 2026-07-23 16:00:10 +00:00
drh
7bc7e25cc7 CLI improvement: New command-line option "--cmdline-edit BOOLEAN" to 
enable/disable command-line editing.  Command-line editing is disabled
by default if either stdin or stdout is not a tty.

FossilOrigin-Name: 675ed9a486fecc734a6aad2e80fd800183c33f72dce1435a193f0e4cf4ede944
 2026-07-23 12:12:37 +00:00
stephan
70c687859e Fix an error handling case in #base64. 
FossilOrigin-Name: f8c408f66257881937ed18b77e274f71dba2d97dd44546372fa0b0a9629efbd2
 2026-07-22 14:16:33 +00:00
stephan
7d1796e488 Add (#base64 -f filename) support to the preprocessor and slightly simplify the wasm embedding with it. Fix a bug in the preprocessor's @token@ call expansion when the length of the configured @ is greater than 1 byte. 
FossilOrigin-Name: 1e90bedec99054f4856bfb89efc4d676486504db67bd1304c45d14c638ddfc7e
 2026-07-22 14:06:41 +00:00
drh
9c20fed370 Do not cache the results of getenv() in the temporary filename generation 
logic as that might result in a UAF if an environment variable value is
modified using setenv() or similar.

FossilOrigin-Name: cefd5807d8be41f8ff0ce1ce487064dcbcf2f05583b86dbe68a3ae1960b13d9f
 2026-07-22 12:55:23 +00:00
drh
33510c5020 Improvements to the unix temporary filename generator so that it continues 
to work even after SQLITE_TMPDIR or TMPDIR environment variables are
changed by the application.  Similar changes are needed for Windows.

FossilOrigin-Name: 82e522ff1429e7eed2ffb0e960badc5757fd015023b7c0679ba32108e44e4abd
 2026-07-22 11:24:48 +00:00
drh
a01ed0c10a Remove an unnecessary munmap() from the unix interface. 
FossilOrigin-Name: 5fc1ede8b2e559db8a5d783d1065b1f1b2eef73054486552b700706208cbdfd1
 2026-07-21 23:54:01 +00:00