database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
29,914 Commits 1,570 Branches 184 Tags
wrong-branch
Commit Graph

29914 Commits

Author SHA1 Message Date
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
drh
49906e8e4b The reuse-subroutine optimization [c9a3498113074bbc] might have generated 
byte-code that loops forever.  This check-in fixes the problem.

FossilOrigin-Name: 0cc4ed8c6e53aca1f5e94c132bedbc7f561c04a77f1a30b965ffe7560634bfeb
 2025-01-30 21:12:58 +00:00
dan
df54ecb1bf Fix a problem causing the write-lock to be held when it should not be in some circumstances following a SEH exception. 
FossilOrigin-Name: 7eb5accb7cf937fc967dcd86da0af813fb18a2697348bd231fbefd3c09b930ab
 2025-01-30 17:04:28 +00:00
drh
8bffd498ea Remove an unused parameter from an internal-use subroutine in the TCL interface. 
FossilOrigin-Name: a700692b39e24f5ca9ea6f879d413e20c2ad2b85f62c867407dafe111f13d931
 2025-01-30 16:07:51 +00:00
drh
000e39e9a8 Improvements to the TCL interface for Tcl9 as suggested by Jan Nijtmans. 
FossilOrigin-Name: d76c5db866de2732b68401a4c3e39acddc7a99bed965160c1796477c062b478a
 2025-01-30 16:00:28 +00:00
dan
462888819e Have sqlite3_enable_setlk(-1) configure indefinite blocking locks where they are supported. 
FossilOrigin-Name: 62009565d2f2a2c4d347e1da0d5b4ad43056742df47fd6ddb92e62f53a2b57f1
 2025-01-30 15:26:16 +00:00
drh
8dacf71043 Updates to the compile-for-windows.md document. 
FossilOrigin-Name: bcd22ed686954657ba820d53dec255d33797924f76e57b931016813581e04e06
 2025-01-30 13:54:32 +00:00
stephan
73dcf45a3d Minor code de-duplication across the top-level auto.def and autoconf/auto.def. 
FossilOrigin-Name: 3c990d77cb83ab371d92c97e0528f790ab6126c60f48ff77e48bd166d7834cf0
 2025-01-30 12:19:30 +00:00
drh
1392ff5533 Disable a test case that (intentionally) does use-after-free, as it does 
occasionally cause problems even for non-sanitizer builds.

FossilOrigin-Name: 23c7d5bea351c04785153ddb30e19c1236db9d11054ab8229893531026b53655
 2025-01-30 12:01:24 +00:00
stephan
00d6b7abfc Fix build regression, introduced in [d2fe6b05f38d9d] (3.48.0), in which SQLITE_OMIT and SQLITE_ENABLE flags passed to configure via CFLAGS were not propagated to the OPT_FEATURE_FLAGS list. Reported in [forum:9801e54665afd728|forum post 9801e54665afd728]. 
FossilOrigin-Name: ec71d9dcd582188d7fb4ab945187de1023eaaecffeeb2903a6fcc49650bd21e9
 2025-01-30 11:19:16 +00:00
dan
4f8f1965f7 Fix bug in sessions handling of FK constraints introduced by [e09a0c02] (released in 3.48.0). Bug was preventing a changeset containing FK violations from being applied even when the xConflict(CHANGESET_FOREIGN_KEY) returned OMIT. 
FossilOrigin-Name: d7c07581203a0a88456588e49e51b40a8341b0e7121809f75be0ee882d91650f
 2025-01-29 18:53:19 +00:00
stephan
cb46f1bb95 Simplify how OpfsSAHPoolUtil.unpauseVfs()'s returned promise is handled. 
FossilOrigin-Name: d651b8da5a84cd54d71f15bd34e4db685674ef73f26f5cc26b7af5321a2ec05e
 2025-01-29 11:28:18 +00:00
stephan
8883deb30e Add experimental support to pause/unpause an SAHPool OPFS VFS, as discussed in [forum:fe8cdb8431c32455|forum post fe8cdb8431c32455], the intent being enable a page to relinquish, perhaps temporarily, the VFS such that the VFS's storage can be accessed by another page/tab. 
FossilOrigin-Name: 1d2683fe9e4be01c3137e750900f54d287e7d96185e66924d24b50f4647e7ef1
 2025-01-29 11:08:11 +00:00
drh
36279c256b Enhance the if() and iif() SQL functions so that they support any 
number of arguments greater than or equal to two.
Suggested by [forum:/forumpost/40f7867f75f80|forum post 40f7867f75f80].

FossilOrigin-Name: fb76d184ee5afc41009c4023bb68b3ddd42c9235a79ec9695c26f5bbe9a1aa25
 2025-01-28 20:32:48 +00:00
dan
9dcf3d08c9 Fix sessions module handling of tables with generated columns. 
FossilOrigin-Name: 437fb316389bc3c24c5cdb4d01edfc81e2c2e9f2b399fc2a95b05d279361d8ec
 2025-01-28 19:03:37 +00:00
drh
0424f255ef Fix a copy/paste typo in the output of vfstrace for xDlClose(). 
FossilOrigin-Name: 1d57b57c85bb8cb9b8a1808b771bb91eeb8150efd14f9064a390e533e715bab7
 2025-01-28 18:03:22 +00:00
drh
8b62a82ae3 Simplifh the IdList object to remove unnecessary fields. Performance 
increases by about 0.8%.

FossilOrigin-Name: a4625bb995dd5582d1f3cf0c2e54eb3f01f1cc1405811dda86ebd38b2b858994
 2025-01-28 12:50:17 +00:00
drh
b0c8b08874 Fix typo in speedtest.md. 
FossilOrigin-Name: 984a9cc22c7c8492bf4fae482749663899b0e33a25c32e6ae5c5e98fc12bb83e
 2025-01-28 10:56:22 +00:00
drh
50637ca5c5 Apparently I got the logic of [abfe488ed67e2e35] confused, even backwards. 
Change it so that the SQLITE_USE_W32_FOR_CONSOLE_IO macro causes Win32 APIs
to be used for console I/O and for stdio to be used otherwise.  This is
reported to be necessary for builds that use a C-language runtime other than
the one provided by Microsoft.  This changes if for Windows only.  It is a
bug fix, though we don't have a test case that will demonstrate a malfunction.

FossilOrigin-Name: 925e97e6f4238f02259a0c95b1fc668ae32a95329242f8eeae236ef207aca112
 2025-01-28 01:10:45 +00:00
drh
d8c37bbc54 Remove an ALWAYS() in the star-query heuristic that is sometimes false if you 
have a corrupt database.  dbsqlfuzz c37ba7728d79859b79c8341b59297e88fba017d3.
Test case in TH3.

FossilOrigin-Name: 6b9a339628eb8bfb6dfbee02000a6ac91cc8a9ae16bd990e62c4142b9f912c36
 2025-01-28 00:48:01 +00:00
drh
44980e8169 Use hashing to accelerate column matching on INSERT statements. Code is 
smaller and about 1.8% faster overall according to test/speedtest.tcl.

FossilOrigin-Name: 8be956383e0344fb613ec2e56fce7b518f439ae34bf9ddb424de2bd9b31c9889
 2025-01-27 21:18:13 +00:00