bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • 0f08d9586c Changes some legacy testing targets in the makefiles into aliases for "devtest" and "releasetest" drh 2026-03-13 15:03:55 +00:00
  • cb47ca6950 Fix a harmless typo in a comment that results in a typo in the documentation. drh 2026-03-13 14:49:08 +00:00
  • 24a2f8f767 Changes some legacy testing targets in the makefiles into aliases for "devtest" and "releasetest" drh 2026-03-13 14:31:13 +00:00
  • 8efa223736 Merge version 3.51.3 into this branch. wal2-3.51 dan 2026-03-13 14:00:53 +00:00
  • 2062ac5679 Version 3.51.3 for the reuse-schema branch reuse-schema-3.51 drh 2026-03-13 13:13:01 +00:00
  • ce3c70f589 Version 3.51.3 for the begin-concurrent branch begin-concurrent-3.51 drh 2026-03-13 12:48:26 +00:00
  • 15bda34acf Fix the "testfixture" makefile target so that it builds with a static TCL library on Mac-ARM. Fix the "tool-zip" target so that it uses ordinary tclsh rather than testfixture to run the tool/mmktoolzip.tcl script that builds the archive. Makefile changes only. drh 2026-03-13 11:32:52 +00:00
  • a5333afb9a Version 3.51.3 version-3.51.3 drh 2026-03-13 10:38:09 +00:00
  • 58d02a22bf Version 3.51.3 branch-3.52 drh 2026-03-13 10:27:09 +00:00
  • a585374e46 Fix a problems with RIGHT JOINs. drh 2026-03-12 22:55:20 +00:00
  • 6c446015bd Update the canonical JimTcl home page link (it was moved earlier today). stephan 2026-03-12 08:33:14 +00:00
  • 9e572064f3 Replace several comment-based switch-fall-through notices with attribute based ones, as suggested in [forum:b6ab8dc547|forum post b6ab8dc547]. stephan 2026-03-11 15:17:14 +00:00
  • 169f68ed88 Improved defenses against mischief. drh 2026-03-11 14:43:29 +00:00
  • c739d13217 Fix harmless compiler warnings. drh 2026-03-10 22:43:39 +00:00
  • e963fb868d Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. drh 2026-03-10 21:07:07 +00:00
  • 3bd23b0d78 Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. [forum:/forumpost/2026-03-10T19:26:06z|Forum post 2026-03-10T19:26:06z]. drh 2026-03-10 21:01:59 +00:00
  • abc82c49c2 Revamp the QRF insert-mode optimization of [659ff6ab55802507]. The control value is now nMultiInsert. Multiple rows are added to each INSERT statement until the number of bytes in that statement exceeds the nMultiInsert value. The CLI uses a default value of 3000, which provides a good balance between speed and prepare-statement size. The output from ".dump" now loads nearly 2x faster in some cases. drh 2026-03-10 18:13:13 +00:00
  • 2e02f3cad8 Bug fix to the ".dump" command in the CLI: Temporarily disable character limit to QRF so as not to truncate values in the generated output. drh 2026-03-10 15:46:34 +00:00
  • bd10a18f00 Bug fix to the ".dump" command in the CLI: Temporarily disable character limit to QRF so as not to truncate values in the generated output. drh 2026-03-10 15:43:57 +00:00
  • efa8633fd8 Enhance QRF with the mxTuple field, which if greater than 1 causes the QRF_STYLE_Insert style to group as many as mxTuple adjacent rows into a single INSERT statement. The field is accessible using the -mxtuple option in the TCL interface, and the --mxtuple option in ".mode". The output of the ".dump" and ".fullschema" commands responds to the current --mxtuple setting. drh 2026-03-10 14:02:03 +00:00
  • 140cbff0d2 Remove an obsolete pragraph from the header comment on the fileio.c extension. drh 2026-03-09 14:04:34 +00:00
  • e795890d7e In QRF, fix line-wrap indentation for "line" mode when using a non-standard column separator. drh 2026-03-09 13:53:58 +00:00
  • 11a572bc9b Fix a problem with RIGHT JOIN and expressions on indexes. drh 2026-03-09 12:11:50 +00:00
  • 5ed6e4ccd1 Fix a problem with RIGHT JOIN and expressions on indexes. [forum:e3dba5426a | Forum post e3dba5426a]. dan 2026-03-09 11:49:51 +00:00
  • 600a69f118 Fix the completion.c TVF so that the xNext method reports errors it encounters while running queries. drh 2026-03-08 19:36:17 +00:00
  • 016a0ebedc Fix the completion.c TVF so that the xNext method reports errors it encounters while running queries. drh 2026-03-08 19:31:40 +00:00
  • ca79d23108 In the decimal.c extension, set a default MAX_DIGITS to 100 million. Do not allow integer overflow of the N parameter to the internal decimal_round() function. drh 2026-03-08 18:53:10 +00:00
  • 456c7ea715 In the decimal.c extension, set a default MAX_DIGITS to 100 million. Do not allow integer overflow of the N parameter to the internal decimal_round() function. drh 2026-03-08 18:50:35 +00:00
  • 5236bad923 Consolidate the opfs and opfs-wl tester1 tests using the preprocessor. stephan 2026-03-08 17:07:01 +00:00
  • 46a692c08b Upgrade ext/wasm/c-pp-lite.c to its newer sibling because we've reached the older one's limits. This renames c-pp-lite.c to libcmpp.c to maintain both the SCM- and code lineage but that may end up looking a bit weird because the diff between the two is vast. stephan 2026-03-08 16:03:08 +00:00
  • 02cbc96d09 JS doc updates. stephan 2026-03-08 12:42:34 +00:00
  • 1eb335e313 Increase the version number on trunk to 3.53.0 drh 2026-03-08 10:51:47 +00:00
  • 0eba9dfb7b Add parens around an expression in the CLI shell to account for operator precedence, as reported in [forum:856ff7a2f1|forum post 856ff7a2f1]. drh 2026-03-08 10:48:56 +00:00
  • 9ca910973c Continue fixes to 3.52 on a branch. drh 2026-03-08 10:44:28 +00:00
  • 976b50620a Merge opfs-wl into trunk, not so much for the "opfs-wl" VFS, which is stil tentative (working fine but with little perceived benefit), but for the "opfs" VFS cleanups which necessarily happened around it. stephan 2026-03-08 08:32:22 +00:00
  • 303fad1f91 Update the tester1 SEE tests to account for opfs-wl. opfs-wl stephan 2026-03-08 08:09:09 +00:00
  • 03b0f8fc9c Refactor tester1 OPFS test to support both the "opfs" and "opfs-wl" VFSes. stephan 2026-03-08 07:58:02 +00:00
  • 84ad6f302f Add parens around an expression in the CLI shell to account for operator precedence, as reported in [forum:856ff7a2f1|forum post 856ff7a2f1]. stephan 2026-03-08 07:02:46 +00:00
  • 9358070cb3 Expose sqlite3_bind_zeroblob() to JS/WASM. stephan 2026-03-08 05:53:47 +00:00
  • eac7cd634d Use the UINT64_C() macro rather than the LLU suffix on integer literals for portability to older Microsoft compilers. [forum:/forumpost/0a9ffaff6fcdedb3|Forum thread 0a9ffaff6fcdedb3]. drh 2026-03-07 22:37:28 +00:00
  • 13a494fddd Give the fuzzcheck test program access to all the same extensions that dbsqlfuzz has access to. drh 2026-03-07 21:07:18 +00:00
  • 85ee7e15e3 Fix harmless compiler warnings on Windows. drh 2026-03-07 17:50:32 +00:00
  • ac26170191 Minor typo fixes from [forum:8fc8bc34291d6f45|forum post 8fc8bc34291d6f45]. stephan 2026-03-07 15:15:37 +00:00
  • cde22e8806 An attempt to get the CLI build to work with mingw32. [forum:/forumpost/086cb1ef66|Forum post 086cb1ef66]. drh 2026-03-07 12:00:56 +00:00
  • b4f257f5e0 Fix another memory leak following OOM in the decimal extension. drh 2026-03-07 11:23:11 +00:00
  • 237fce8205 Extend the JS pre-bootstrapping configuration to include an option to disable inclusion of any given extension VFS (not the default VFSes, like memdb). The primary motivation for this is to give people who don't use OPFS to a way to keep the OPFS VFSes from loading their proxy workers, which are expensive. stephan 2026-03-07 06:10:29 +00:00
  • 78649bb421 Fix the mangling of the opfs async proxy script's URI caused by both OPFS VFSes modifying it to accound for sqlite3.dir. Add a link to speedtest1 with opfw-wl to index.html. stephan 2026-03-07 04:19:08 +00:00
  • 7d10030d75 Cleanups and docs in the opfs vfs and its concurrency tester. Experimentally add sqlite3.capi.sqlite3_js_retry_busy(), which runs a callback repeatedly until it _stops_ returning (or throwing) an SQLITE_BUSY error. stephan 2026-03-07 03:32:17 +00:00
  • f20c4e650d Elide more of the 64-bit was stuff from the default build target. stephan 2026-03-07 03:29:26 +00:00
  • a0851f1483 Enhancements and fixes to some of the extensions used in the CLI so that they can be fuzzed using dbsqlfuzz. drh 2026-03-07 02:42:27 +00:00
  • 6142524b70 The optional SQLITE_DECIMAL_MAX_DIGIT compile-time option limits the maximum number of digits that the decimal extension will operate on. extfunc-fuzz drh 2026-03-07 02:36:39 +00:00
  • 9be458e611 Cleanups and docs in the new opfs code structure. stephan 2026-03-07 02:19:23 +00:00
  • 57d0fe254a For backwards compatibility, ensure that the "opfs" VFS does not specifically require Atomics.waitAsync() (a new requirement of "opfs-wl"), but make use of it if available. Only apply jitter to the concurrency test runs at random intervals. stephan 2026-03-07 01:01:13 +00:00
  • 3866d01907 Reenable the is_base85() extension function that was disabled by [af18b68978ec9b1f]. drh 2026-03-07 00:14:36 +00:00
  • 02d9860c8e Fix another NULL ptr deref following OOM in the sha1 extension. drh 2026-03-07 00:10:34 +00:00
  • 7f6236bed1 Fix a NULL pointer dereference following OOM in the sha1 extension. drh 2026-03-07 00:03:47 +00:00
  • 56b571780e Fix a NULL pointer dereference following OOM in the decimal extension. drh 2026-03-06 23:58:58 +00:00
  • 84334c941a Fix a memory leak following OOM in the completion extension. drh 2026-03-06 23:56:03 +00:00
  • ac63b524ac Add some jitter and duration info to the opfs concurrency tester. Ensure that Atomics.waitAsync() is available for opfs-wl. Further testing has shown that Web opfs-wl is consistently fairer about doling out contested locks but it's dog slow compared to the original VFS under moderate concurrency. In single-connection use they're effectively on par. stephan 2026-03-06 23:50:44 +00:00
  • 8f65da4574 Fix a memory leak in the decimal extension that follows an OOM. drh 2026-03-06 23:37:45 +00:00
  • 2251f0c4cc Get "opfs" and "opfs-wl" properly split. Speedtest1 and the concurrency tester are happy with opfs-wl but it is not yet plugged in to tester1. stephan 2026-03-06 22:21:06 +00:00
  • 1bf79ca445 Rename the initializer functions for base64() and base85() to include the number at the end. drh 2026-03-06 22:09:39 +00:00
  • 3ed9043c71 Increase the version number to 3.52.1. drh 2026-03-06 21:34:49 +00:00
  • 7c483444a1 Fix a NULL pointer dereference in the (undocumented) two-argument version of the decimal() extension SQL function. [forum:/forumpost/fa9c2dc83f|Forum post fa9c2dc83f]. drh 2026-03-06 21:31:07 +00:00
  • 7cc8db2f5d Small typo fix in the FP_DIGITS API docs. stephan 2026-03-06 19:39:03 +00:00
  • a85d09f1a4 Minor cleanups and docs. Teach the OPFS concurrency tester to deal with SQLITE_BUSY instead of failing. stephan 2026-03-06 19:33:25 +00:00
  • 275e7c7caa Merge fixes that were deferred until after the 3.52.0 release, including: (1) Fix handling of DISTINCT with OUTER JOIN, (2) Enhance configure to auto-detect linenoise, (3) Add recent configuration settings to WASM. drh 2026-03-06 18:51:49 +00:00
  • 88e552f1b9 Fix the linenoise auto-detection added by the previous check-in. pending-3.52 drh 2026-03-06 18:26:50 +00:00
  • ff594d1c55 Version 3.52.0 for the reuse-schema branch drh 2026-03-06 17:33:31 +00:00
  • a98f278f58 This one reliably runs 5 workers. Checking in before subsequent cleanups and debug output removal break it. stephan 2026-03-06 17:10:28 +00:00
  • c008b8fe3e Correct an internal doc falsehood. stephan 2026-03-06 16:15:32 +00:00
  • 7b9cd03c0a This Web Lock impl can reliably run a single OPFS connection but rather unreliably 'loses' workers with higher counts, presumably due to deadlock or deadly embrace (how _all_ of them can deadlock at once is unclear, but clearly a bug). stephan 2026-03-06 16:04:21 +00:00
  • 257fdf8496 Version 3.52.0 version-3.52.0 drh 2026-03-06 16:01:44 +00:00
  • ad2fe531d0 Expose SQLITE_{DBCONFIG_FP_DIGITS,LIMIT_PARSER_DEPTH,PREPARE_FROM_DDL} to WASM and add support for DBCONFIG_FP_DIGITS to the variadic wrapper for sqlite3_db_config(). These unfortunately went overlooked before the 3.52 release. wasm-post-3.52 stephan 2026-03-06 15:41:17 +00:00
  • 3c7a03032f Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. drh 2026-03-06 15:01:02 +00:00
  • 93353c0bc2 Add the new realpath() extension function to the list of functions prohibited in --safe mode of the CLI. drh 2026-03-06 14:33:12 +00:00
  • 544ef18bbd Remove an extraneous OPFS metrics increment. stephan 2026-03-06 11:49:36 +00:00
  • ea595494e2 Uninstall faultsim at the end of the walrestart.test script. dan 2026-03-06 11:18:12 +00:00
  • 891f5a176b A slight simplification/optimization in the OPFS proxy's waitLoop(). stephan 2026-03-06 09:11:47 +00:00
  • 831e233202 Reimplement the OPFS async proxy's wait-forever loop to be more async-friendly for upcoming changes. stephan 2026-03-06 09:06:24 +00:00
  • 7a125b97d7 Fix the build for -DSQLITE_OMIT_FLOATING_POINT. drh 2026-03-05 18:28:43 +00:00
  • d61ecd83b8 Enhance ./configure to automatically detect linenoise in ../linenoise relative to the build directory, or ../linenoise relative to the source directory, or at $HOME/linenoise. drh 2026-03-05 18:16:25 +00:00
  • 21bdb75ac8 Ensure xMutexInit() is called in SQLITE_THREAD_MISUSE_WARNINGS builds. dan 2026-03-05 16:23:04 +00:00
  • 46686ac681 Fix a long-standing problem with DISTINCT LEFT JOIN queries. dan 2026-03-05 14:39:27 +00:00
  • 14b5eadefe Strip the opfs-wl "back to formula", removing the current false starts so that this can be tried again without tripping over any cruft. The current impl is subject, with no obvious way out of it, to starvation in the async proxy. stephan 2026-03-05 11:51:27 +00:00
  • cef3ff74cd The opfs-wl lock hang has been traced to starvation between the WebLock and the tight wait-on-VFS-calls Atomics.wait() loop. This can reportedly be resolved with another level of indirection in which the WebLock takes over the wait-on-VFS-calls part until it's unlocked, returning to the global loop when it's done. That exceeds this morning's ambitions but is next to try out. stephan 2026-03-05 06:30:57 +00:00
  • b4d3df26ba Increate the version number to 3.50.7 branch-3.50 drh 2026-03-05 01:44:06 +00:00
  • e7987a7a2c Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. drh 2026-03-05 01:38:32 +00:00
  • 66170da47a Increase the version number to 3.44.6. branch-3.44 drh 2026-03-05 01:38:19 +00:00
  • 8fe41493b5 Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. (This cherry pick omits testing infrastructure.) drh 2026-03-05 01:24:55 +00:00
  • bef2a1e33e Add a little flexibility to checkpoint sizes in the walrestart.test script. drh 2026-03-05 00:30:05 +00:00
  • 671a6f83f4 Add some debugging output to opfs and track down the breakage to the initial WebLock request, which is never reaching its callback. Still broken, but this is progress. stephan 2026-03-04 21:16:36 +00:00
  • 232446b532 Get opfs-wl plugged in to the concurrency tester. Somewhat ironically, all competing workers fail with locking errors while worker 1 is busy running off the rails somewhere. Stashing for closer investigation later. stephan 2026-03-04 20:33:21 +00:00
  • b85067c568 Consolidate the last 200 lines of common OPFS VFS code. "opfs" still works, "opfs-wl" registers fine but is still otherwise untested. stephan 2026-03-04 19:21:09 +00:00
  • 080da5f56d Factor out about 300 lines of common OPFS VFS bootstrapping code. stephan 2026-03-04 17:54:02 +00:00
  • 691494a93b Consolidate the OPFS VFS's metrics-tracking code. stephan 2026-03-04 16:30:51 +00:00
  • 6ff9fcfad2 Baby steps in consolidating common OPFS VFS code. stephan 2026-03-04 14:33:33 +00:00
  • a97ed7a1d3 Merge all the latest trunk enhancements into the reuse-schema branch. drh 2026-03-04 13:37:20 +00:00
  • 2f7c0da8c3 Merge all the latest trunk enhancements into the bedrock branch. drh 2026-03-04 13:35:36 +00:00
  • 4b3af91fbd Merge the sort-and-merge optimization bug fix into the wal2 branch. drh 2026-03-04 13:24:55 +00:00