Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
2025-07-14
| ||
18:59 | Add comments to sqlite.h.in describing the change on this branch. (Leaf check-in: 19038620cd user: dan tags: vtab-setup-cost) | |
18:27 | Add the snapshot-zip makefile targets for both Windows and Posix. (Leaf check-in: 8c73c0c593 user: drh tags: trunk) | |
18:03 | Merge latest trunk changes into this branch. (check-in: 8f9d6acaf7 user: dan tags: vtab-setup-cost) | |
16:05 | Enhance the "mktoolzip.tcl" script (used by the "tool-zip" makefile target) so that it uses "fossil test-filezip" to build the ZIP archive if available, and so that it also generates windows-dll-*.zip on Windows platforms. (check-in: 63ddc215eb user: drh tags: trunk) | |
15:40 | In rtree.c, ensure that the pReadAux statement is reset whenever the bAuxValid flag is cleared. Fix for [forum:/forumpost/3e45ed31d8 | forum post 3e45ed31d8]. (check-in: 3c0afda372 user: dan tags: trunk) | |
15:34 | In rtree.c, ensure that the pReadAux statement is reset whenever the bAuxValid flag is cleared. Possible fix for [forum:/forumpost/3e45ed31d8 | forum post 3e45ed31d8]. (Closed-Leaf check-in: 1740f9a098 user: dan tags: rtree-aux-column-fix) | |
14:51 | Add new sessions function sqlite3changeset_apply_v3() and its streaming equivalent. This allows changesets to be filtered on a per-change basis, not just per-table. (check-in: 10ebd7a119 user: dan tags: trunk) | |
09:41 | Fix harmless compiler warnings in builds that use SQLITE_OMIT_DATETIME_FUNCS. (check-in: e11fbf9fd6 user: drh tags: trunk) | |
2025-07-12
| ||
18:14 | Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Possible fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. (Leaf check-in: 18ba07c152 user: dan tags: vtab-leftjoin-fix) | |
16:35 | Experimental change to allow virtual table xBestIndex() methods to specify an initial setup cost for a plan. (check-in: b67babf1ab user: dan tags: vtab-setup-cost) | |
2025-07-11
| ||
19:52 | wasm: introduce the sqlite3.oo1.DB.wrapHandle() and Stmt.wrapHandle() APIs, which enable clients to wrap (sqlite3*) resp. (sqlite3_stmt*) pointers in their oo1 API counterparts, optionally with or without taking over ownership of the pointer. (check-in: e5d0795495 user: stephan tags: trunk) | |
19:44 | Clearer docs for the unowned db/stmt handle mechanism. (Closed-Leaf check-in: 53401b5435 user: stephan tags: oo1-unowned-handles) | |
19:34 | Correct a one-too-many-exclamation-points bug which caused the opposite of intended semantics in oo1.Stmt.pointer ownership. (check-in: 91e709f36d user: stephan tags: oo1-unowned-handles) | |
17:02 | Additional header comment documentation in the ext/misc/vtablog.c test extension. (check-in: 3656acfaa3 user: drh tags: trunk) | |
14:18 | Merge trunk into column-text-blob-v2 branch. (Leaf check-in: a5369e67f7 user: stephan tags: column-text-blob-v2) | |
12:56 | Add column/value_text/blob_v2() to the sqlite3_api object. (check-in: ae29cc3135 user: stephan tags: column-text-blob-v2) | |
11:06 | speedtest1: in WASM builds, disable the "app" test set by default because that one set is triggering file-not-found errors for the db file for reasons not yet understood. (check-in: 9d68971c58 user: stephan tags: trunk) | |
10:27 | Do not export the numerous Emscripten HEAPxy symbols and remove the last remaining JS code which references them. They have long-since been replaced by internal equivalents and a specific feature check on one of them (which is also no longer needed) is triggering an exception from Emscripten. More details are in [https://github.com/emscripten-core/emscripten/issues/24656 | Emscripten ticket #24656], noting that this is not an Emscripten bug but an Emscripten behavior change brought it to light. (check-in: b9462dc146 user: stephan tags: trunk) | |
2025-07-10
| ||
20:45 | Improve the accuracy of the ETC on both devtest and releasetest. (check-in: a3f96cafdc user: drh tags: trunk) | |
17:19 | Add the estkey column to the jobs table of testrunner.db. The plan is to use this to collect measurements that will help generate improved ETAs for a test run. (check-in: 9eccf5267c user: drh tags: trunk) | |
09:27 | Minor internal doc correction in vdbeInt.h. (check-in: c3a2ef639c user: stephan tags: trunk) | |
09:25 | Minor JS doc tweaks. (check-in: 34d893b483 user: stephan tags: oo1-unowned-handles) | |
2025-07-09
| ||
20:11 | Fix the empty-table optimization on INTERSECT so that it does not try to use an uninitialized register for LIMIT processing. (check-in: 6918ada008 user: drh tags: trunk) | |
13:43 | wasm: DB.wrapHandle() no longer accepts a DB object as its first argument, as there's no apparent use case for proxying one DB object with another. Doc improvements for the new code. (check-in: 0ee19db02a user: stephan tags: oo1-unowned-handles) | |
13:13 | wasm: add a few tests demonstrating that oo1.Stmt.paramaterCount's new impl does not change visible behaviors. Add the c-pp-filtered files to 'make clean'. (check-in: 3fe6154596 user: stephan tags: oo1-unowned-handles) | |
2025-07-08
| ||
22:11 | Fix a possible user-after free following OOM in the EXISTS-to-JOIN optimization. (check-in: 498ee8d514 user: drh tags: trunk) | |
20:28 | Adjustments to test/incrblob4.test so that it works on both Linux and Mac in spite of error message differences between those platforms. Minor change to termIsEquivalent() to provide 100% MC/DC. (check-in: 720387f860 user: drh tags: trunk) | |
19:53 | New optimizations to detect early when queries return no rows due to tables being empty. This includes the EXISTS-to-JOIN optimization that tries to transform EXISTS constraints into additional terms of the FROM clause. (check-in: e33da6d5dc user: drh tags: trunk) | |
19:02 | Fix a problem with the fix in [5cb8e342e1]. (check-in: 043ff54fb7 user: dan tags: trunk) | |
18:44 | Fix another problem with running fts5 integrity-check in SQLITE_DEBUG builds, this one causing an assert() failure. (check-in: 5cb8e342e1 user: dan tags: trunk) | |
17:28 | Enable the EXISTS-to-JOIN optimization if the outer query has no FROM clause. (Closed-Leaf check-in: 1b9b124f9a user: drh tags: empty-table-optimizations) | |
14:54 | If SQLITE_DEBUG is defined, fts5 does extra checks as part of integrity-check. Ensure that errors from these extra checks are only reported if the other, normal, tests all pass. This fixes a test case in fts5corrupt3.test that was failing if SQLITE_DEBUG was defined. (check-in: 98a53fb276 user: dan tags: trunk) | |
12:37 | Fix test case results in FTS5 that were changed error message improvements in [48044a6b57c0a16c] but which were omitted from that check-in. (check-in: e1f8e0240b user: drh tags: trunk) | |
2025-07-07
| ||
20:47 | Only run preupdate-hook tests in incrblob4.test if the preupdate-hook is enabled in the build. (check-in: 56314b6b53 user: dan tags: trunk) | |
19:03 | Small performance optimization in the resolver. (check-in: 840646df06 user: drh tags: empty-table-optimizations) | |
18:35 | Merge the latest trunk enhancements and fixes into the empty-table-optimizations branch. (check-in: f15cdf0757 user: drh tags: empty-table-optimizations) | |
16:28 | Rework the fix to the problem described by forum post b9647a113b so that it provides a more complete fix that covers cases that were not resolved by the original fix, and so that it does not cause performance regressions. (Leaf check-in: 4084ac20f4 user: drh tags: branch-3.50) | |
16:19 | Rework the fix to the problem described by [forum:/forumpost/b9647a113b465950|forum post b9647a113b] so that it provides a more complete fix that covers cases that were not resolved by the original fix, and so that it does not cause performance regressions. (check-in: 28db0d152d user: drh tags: trunk) | |
15:40 | Simplifications to the row-value IN operator logic. Do not let the query planner accept a WhereLoop for a row-value IN operator that uses the same index column more than once. (Closed-Leaf check-in: d2adf61f21 user: drh tags: redundant-idx-columns) | |
14:42 | Work around the Emscripten 4.10 regression described in [https://github.com/emscripten-core/emscripten/issues/24656 | Emscripten ticket #24656]. (check-in: db96ff7bbc user: stephan tags: branch-3.50) | |
12:11 | Work around the Emscripten 4.10 regression described in [https://github.com/emscripten-core/emscripten/issues/24656 | Emscripten ticket #24656]. Problem reported off-list by BrickViking. (check-in: c385475b25 user: stephan tags: trunk) | |
11:37 | Avoid invoking the preupdate hook from within sqlite3_blob_write() if the cursor is already invalid. (check-in: 9f335b9a4e user: dan tags: trunk) | |
10:54 | Back out the fix at [ba7d5bad32ad6aac] because it does not always work and because it causes a performance regression. Add new test cases for row-value lookups of indexes that contain redundant columns, three of which are currently failing. This branch is seeking an improved solution to the redundant index column problem for row-value lookups. (check-in: ad8ddcefab user: drh tags: redundant-idx-columns) | |
02:23 | Fix a parsing error introduced by the addition of the ability to disable comments. (check-in: 602f8a639c user: drh tags: branch-3.50) | |
02:18 | Fix parser error introduced by [325e547a2195571e]. See [forum:/forumpost/095dbfc06e5b1f7e|forum post 095dbfc06e5]. (check-in: 4eefab4494 user: drh tags: trunk) | |
2025-07-06
| ||
15:36 | Remove some dead JS code and some extraneous debug output from test code. (check-in: 6e73770a7f user: stephan tags: oo1-unowned-handles) | |
15:13 | JS doc additions. (check-in: 7933505f0c user: stephan tags: oo1-unowned-handles) | |
15:01 | Experimentally add sqlite3.oo1.DB/Stmt.wrapHandle(), which allow DB/Stmt instances to wrap a (sqlite3*)/(sqlite3_stmt*) optionally with or without taking ownership of it. The intent is to enable mix-and-match use of the C API, the oo1 API, and any other hypothetical API which exposes those pointers. oo1.Stmt.parameterCount is now a property access interceptor like Stmt.columnCount is, but that doesn't change how it's used. (check-in: 1227543b87 user: stephan tags: oo1-unowned-handles) | |
01:19 | Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN. (check-in: 6b1ecbaa2e user: drh tags: empty-table-optimizations) | |
2025-07-05
| ||
23:33 | Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueries that do not have a WHERE clause, and so that it works on nested EXISTS subqueries. (check-in: c1d5295724 user: drh tags: empty-table-optimizations) | |