database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-26 11:28:58 +03:00
Code
29,833 Commits 1,540 Branches 176 Tags
Commit Graph

29833 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
stephan
6c074e5dc4 Summarize known incompatibilities/gotches between JimTCL and canonical TCL, and their workarounds. Doc changes only. 
FossilOrigin-Name: 60c932e67b886d4c050698f36e1d3fc04eb99473d62bb3b1585a97d90e27227e
 2025-02-05 12:56:55 +00:00
stephan
97af1346f0 Upstream JimTCL patch and minor tcl script tweaks to support (fconfigure -translation binary) for better cross-platform build portability. 
FossilOrigin-Name: 0974a17c4565f202777fc6203df20dca19acc1e8740ede15334783f41e3e5054
 2025-02-05 12:49:15 +00:00
drh
b6859b6f2c Attempted improvements to the SQLITE_DBCONFIG_... documentation. 
FossilOrigin-Name: baac853871ad307b67b4d624b9ee47fc1313f1aa62c9f8072fb49e97aa33db94
 2025-02-05 12:02:43 +00:00
drh
802b042f6e Detect and report signed integer overflow in the sumInverse() routine, 
used by window functions.

FossilOrigin-Name: 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2
 2025-02-04 02:38:23 +00:00
drh
e85b2cac0f Test case for the FTS3 fix in the previous check-in. 
FossilOrigin-Name: 459d8f695ef868d0ec09920ab2035eebd36a66051f9905e2605f4600623faa47
 2025-02-03 23:27:27 +00:00
drh
51dd67080a Fix a potential UAF in FTS3. 
FossilOrigin-Name: 75f3d87448793fc7fd68d817874d561842e029a2d6c1ea4abcec39764cd38469
 2025-02-03 23:19:42 +00:00
drh
31615637f3 New dbsqlfuzz case added to fuzzdata8.db. 
FossilOrigin-Name: 7ee20cfc237229dbea7116149c0c35883f7b8087b9ccdce6dca16b6da1c6caf8
 2025-02-03 21:24:40 +00:00
drh
0d9f2a15f2 The Parse.addrExplain field is never even if SQLITE_OMIT_EXPLAIN is defined. 
FossilOrigin-Name: 5d81a984c6aabb9fa9180efde8ca942b40f1ec18ff5a89f2fbb1252734f051d3
 2025-02-03 21:04:21 +00:00
drh
1c68deead7 Enhance fuzzcheck so that the --sqlid and --dbid options can take a range 
of IDs to run.

FossilOrigin-Name: 408fa57f048e05a261fb62b45ae44b8a97c97fc01e3776124cbef6595df579d4
 2025-02-03 18:53:02 +00:00
drh
589796cd89 Fixes and improved documentation to the new --sqlid and --dbid range 
options in fuzzcheck.

FossilOrigin-Name: 59e26632449163a36b803cc7027ed99c1f6b675dda6f0b2b12bbe55884923f08
 2025-02-03 18:49:06 +00:00
drh
dbe48d3c8d Enhance fuzzcheck so that the --sqlid and --dbid options can specify a 
range of tests to be run.

FossilOrigin-Name: cdd0af6f86e49ade1339ad5a3cc444400a9722a9efdf84a30b3ff9428b7ac36d
 2025-02-03 18:36:05 +00:00
drh
c2b446f16a Fix for a potential UAF in FTS5. 
FossilOrigin-Name: e33f2fedda17b4f3678fc23c438093c256b0c125da5f1ac42ecaf3d604d54b6a
 2025-02-03 18:05:54 +00:00
stephan
6e5802fc74 Improve the JS-side sqlite3_set_auxdata() test to also trigger the case that the aux data actually gets reused. Test changes only, no library code. 
FossilOrigin-Name: 9f27379d860518e6e097a2c999da04176812260a61bf11fe495c3efd76971806
 2025-02-03 18:01:42 +00:00
dan
9e639d2490 Fix a use-after-free case in fts5 provoked by fuzzdata8.db. Tcl test case pending. 
FossilOrigin-Name: a4962df665084e423e020be9a2834b6886a8e3feb461cff5358b61398a2a20d2
 2025-02-03 17:54:55 +00:00
drh
c6281e4893 New test case for test/fuzzdata8.db 
FossilOrigin-Name: 8a882f976e22100b91c7ca4119123f16ad5f03311f0a6dc17449bcdcff29618c
 2025-02-03 17:45:41 +00:00
stephan
3cd34ab981 Rework [76c8435a] to eliminate automatic JS-to-WASM function conversions of sqlite3_set_auxdata() destructors because it can leads to leaks on every call of a UDF. This feature never worked before [76c8435a] but fixing it was ill-conceived because of the memory leakage it introduces. WASM function pointers can still be used as destructors in this context. 
FossilOrigin-Name: 3fb993af0caf041da934cea29c039b27c468be0b75bce1537a6425767cf9bf8d
 2025-02-03 17:34:12 +00:00
stephan
c97abeac0b Add a test app to assist in validating the SAHPool digest calculation fix. 
FossilOrigin-Name: a1e304b8020025cc73a658bd8c7697d59b4f3ad96cac0a3e36553a3207d13dc6
 2025-02-03 17:21:54 +00:00
stephan
40ce00b546 Initial work on a fix for the SAHPool VFS's effectively-no-op digest calculation, as reported in [https://github.com/sqlite/sqlite-wasm/issues/97|ticket #97 of the downstream npm subproject]. This requires more testing alongside databases created before this version to ensure that it's backwards-compatible. 
FossilOrigin-Name: 9234c33f92d92bfddc6211c9c587f1072e70837c0ffe1416ef7d84d59bacd364
 2025-02-03 16:26:30 +00:00
stephan
d98689f4d3 Add a more complete test for [76c8435a] and add some commentary about (A) the inability to automatically clean up automatically-generated WASM proxy functions for sqlite3_set_auxdata() destructors and (B) how to deal with (A) to avoid leaking WASM proxy functions. 
FossilOrigin-Name: d693c2dddbd10a2e0b77893b04b11502e30b768f1b06814105f7f35172845fb9
 2025-02-03 14:55:56 +00:00
drh
cf9f841c5e Fix the build process on Windows so that it generates identical sqlite3.c, 
sqlite3.h, and shell.c files on Windows and Unix.  This patch also includes
a change to JS bindings that got caught up in the branch.

FossilOrigin-Name: 91ef45fc2902e46813366ec6b8317209f39f10e4a23c3808e33aceedab9da6c7
 2025-02-03 14:44:16 +00:00
drh
77586831ed Bring the autoconf-tarball Makefile.msc into alignment with the main 
Makefile.msc.

FossilOrigin-Name: 52a7a162d131532de8f4403b099fa122fc72c80f71494fb561afc4e0ff8e6bf4
 2025-02-03 14:40:05 +00:00
stephan
d256b56880 Correct the FuncPtrAdapter signature for the JS binding of sqlite3_set_auxdata(). Reported in [https://github.com/sqlite/sqlite-wasm/issues/92|the npm subproject, ticket #92]. 
FossilOrigin-Name: 76c8435a5f390001038b8ee94322ff478c9d5f29501ed1c5891c952a41e377aa
 2025-02-03 14:04:27 +00:00
drh
3cf467a3ec Adjust the build process to avoid extra CR characters inserted by jimsh 
on Windows.

FossilOrigin-Name: 1f54853932cec9ba20e9be48a59f1817b8b45e4c4d6ef8a06d34f86dd688e28e
 2025-02-03 13:20:11 +00:00
drh
4170780a82 The "clean" target on Makefile.msc should not delete the auto.def file. 
FossilOrigin-Name: 72fbcedfb09febb72fa325cb21d160cd33dca7fe5579817143f47d90a20ec2ef
 2025-02-03 12:42:03 +00:00
drh
f306ca5286 Add a header comment to test/speedtest1.c that outlines how to compile the 
program using historical amalgamation sources, for comparison testing.

FossilOrigin-Name: 602d4dd69ec9a724c69cb41ab15376ec731bfd4894fac0a2b25076b857786c6d
 2025-02-02 18:01:32 +00:00
drh
c229f11817 Update to the "--help" output from speedtest1. 
FossilOrigin-Name: 5216452047eecdd6c0f6ab85b304f975ed05a394a4ad9ae793fb65d645502b12
 2025-02-02 16:52:21 +00:00
stephan
14613b1b1d URL typo fix in code comments. No code changes. 
FossilOrigin-Name: 002a123094e4ef14eb5ec28033adca6083ba2717e1eaa23e80595e37a947e6c2
 2025-02-02 12:15:25 +00:00
drh
c49bfdbbee Add a missing "db2 close" to the ext/session/session_gen.test test module. 
FossilOrigin-Name: 4068f586ddadd3a818645574f7584fcee6d373dbf45805c545100883b495598a
 2025-02-01 23:49:01 +00:00
drh
4b99ec0b8c Fix a comment typo - in a comment used to generate documentation. 
FossilOrigin-Name: b8de75eeded79a8312218d7a543e7c7d11181c9f4004e875495608d11a81ff38
 2025-02-01 23:34:33 +00:00
drh
454a426e31 Remove an ALWAYS() added by [2567298f4b0fdfeb] because dbsqlfuzz found a way 
to reach it.  The test case was added to TH3.

FossilOrigin-Name: d08a7aa8987458a91fcb861d58289e622ba8722936c7874a284f9f2fd782e269
 2025-02-01 23:28:49 +00:00
drh
5c72a39cfb Enable SQLITE_ENABLE_NORMALIZE for several test configurations. 
FossilOrigin-Name: b07c64077a3912ef7cdf23e9411df6387f38baa32f5a11fffec5ba4f93935e27
 2025-02-01 21:06:49 +00:00
drh
de50617bcb Fix an issue with sqlite3_normalized_sql() caused by changes needed to 
support SQLITE_DBCONFIG_ENABLE_COMMENT.

FossilOrigin-Name: 79d287a39443f2d098fcc24199627555a656b34aa5bf5d484f91cb513d83e143
 2025-02-01 20:53:17 +00:00
stephan
fdc17e0bc8 JS doc typo fixes. No functional changes. 
FossilOrigin-Name: e0d9c74c1cdddb2321131255b94f9cda6530be3f2a06aed4abb54dcda092481e
 2025-02-01 09:44:48 +00:00
drh
276d213b2a Tweaks to [4b4f33d791fe4318] to make it easier to test. 
FossilOrigin-Name: 2567298f4b0fdfeb42aa6bba7e0bec3bc8d0b89bf644a79b41893dd6a6c5774c
 2025-01-31 20:18:34 +00:00
drh
45b2669ad3 Fix test case numbering in tests recently added to like3.test. 
FossilOrigin-Name: 6df2098c548b58c2910837726b666a628d5c712c560c0221a771e8181f71fae7
 2025-01-31 18:56:58 +00:00
stephan
82f3052e61 Expose the new SQLITE_DBCONFIG_ENABLE_ATTACH_CREATE/WRITE and SQLITE_DBCONFIG_ENABLE_COMMENTS (from [325e547a21955]) to JS/WASM. 
FossilOrigin-Name: 8da1a9af66f905c683e9c3445d609b5c0e11ac912be192c468ddd79f237837f4
 2025-01-31 18:45:03 +00:00
dan
8fbf400bb0 Remove an assert() that is not true if a trace-callback is deregistered while there are active statements. 
FossilOrigin-Name: 0ecfc4d0ebdb272a69f8f98ddb069c7e0735fb899804027eb16f241d83b3d046
 2025-01-31 18:33:37 +00:00
stephan
cee7609074 Minor cleanups in the opfs-sahpool pause/unpause API demo. 
FossilOrigin-Name: e205cdc468e02eefdeb8d391d921aa2d4d28a8b7b87036d6d937a9928261a413
 2025-01-31 17:47:47 +00:00
stephan
a75321d735 Add the conventional license header to sahpool-worker.js and correct the date on the header in sahpool-pausing.js. 
FossilOrigin-Name: f7c3026b0d2e33cc4e3b906810d860b155b1ff714bbe4e1eb9ee392122217efa
 2025-01-31 16:34:52 +00:00
stephan
cb0da053ed Add a small test app demonstrating cooperative semi-concurrency of the opfs-sahpool VFS using its un/pauseVfs() APIs. 
FossilOrigin-Name: 09570c55a23e5af76dd2153a5b28a493f498d7d4a08b0089f3074d0a2c5d3d29
 2025-01-31 16:25:18 +00:00
dan
f6ca35d88c Fix a problem with LIKE and GLOB processing in utf-16be databases in cases where the utf-8 encoding of a character ends with the byte 0xBF. 
FossilOrigin-Name: 4b4f33d791fe4318c4597bee7d2f9e486ed223e731982af470f5cc0dbdc600fc
 2025-01-31 14:52:36 +00:00
drh
a033790303 If any errors occur while processing sqlite_dbpage changes, cancel 
pending truncate operations.

FossilOrigin-Name: 6138e0dc4e0e4e19cb048fe0cd969156151fdc427eee21188d2a822642aad043
 2025-01-31 14:52:05 +00:00
stephan
654c94d683 Cleanups in the opfs-sahpool VFS pause/unpause feature and its tests. 
FossilOrigin-Name: 184ba37702f63196deca91d273e798ca895fbb301938e6264bc82815a4e33149
 2025-01-31 14:25:38 +00:00
drh
32933278fd Three new options to sqlite3_db_config(): ATTACH_CREATE, ATTACH_WRITE, 
and COMMENTS.

FossilOrigin-Name: 325e547a2195571ece4bb22ca65d67d8c2cb42030618916d37930666cf221917
 2025-01-31 13:32:03 +00:00
stephan
d4bfa3465e Merge trunk into opfs-sahpool-pause branch. 
FossilOrigin-Name: 775a547eca2b0b3dbb6c03990236128a095cc34d28caec44b9a5072510c75b63
 2025-01-31 12:39:07 +00:00
stephan
efbf481541 Minor wasm-specific doc touchups. 
FossilOrigin-Name: 56b618da9073db8b8d5dafa177a3c9e4c4d927bf512e14b0e6d23937f91ce4cf
 2025-01-31 12:30:37 +00:00
drh
824a5bfcf0 Improvements to the SQLITE_DBCONFIG option documentation. 
FossilOrigin-Name: 59f0ba10062a6ccfd56061a16af3436b9e1b9d23378bff3302bcf33bb3137cb9
 2025-01-31 12:09:36 +00:00
stephan
80cf9fa00b Correct a typo in tool/emcc.sh.in which could cause all of the configure-time work to locate the emcc binary to go unused. Reported in [forum:feb325cdde5b6f37|forum post feb325cdde5b6f37]. 
FossilOrigin-Name: f66efd5b531210407ee8f30cdf6684a7610479fd8810a609c54469f7424a0644
 2025-01-31 11:45:55 +00:00
drh
e16b345243 Add the SQLITE_DBCONFIG_ENABLE_COMMENTS setting (default on) to enable or 
disable the ability to include comments in SQL input text.

FossilOrigin-Name: 393749a2e22d5c8eba36e2106a35909420aa6316652d1ab4f18ef699247b6fba
 2025-01-31 01:34:19 +00:00
drh
0911f86abf Merge all the latest trunk changes into the extra-security branch. 
FossilOrigin-Name: 86ba57561a8d8c14e401c06b2345a9417053aa3a5f0c84e52460f23f5e6aa8d0
 2025-01-31 00:54:59 +00:00