Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
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 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. (Leaf 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. (Leaf 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 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 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 Emscripten ticket #24656. (check-in: db96ff7bbc user: stephan tags: branch-3.50) | |
12:11 | Work around the Emscripten 4.10 regression described in 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 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) | |
2025-07-04
| ||
18:38 | Propagate the -ldl and -lpthread flags, if needed, into sqlite3.pc, per request in forum post 44a58c807353162f. This resolves usage of that pkgconf file on some OSes. (check-in: b4db6ddeed user: stephan tags: branch-3.50) | |
18:32 | Add 'reconfigure' target to Makefile.in to re-run the configure script with the same flags it was generated with. (check-in: c60907e77b user: stephan tags: trunk) | |
17:20 | Propagate the -ldl and -lpthread flags, if needed, into sqlite3.pc, per request in forum post 44a58c807353162f. (check-in: 64f5f14322 user: stephan tags: trunk) | |
14:24 | Merge fixes from trunk into the empty-table-optimizations branch (check-in: 6f98b16d21 user: drh tags: empty-table-optimizations) | |
12:25 | Fix harmless compiler warnings. (check-in: 13af4acebe user: drh tags: trunk) | |
11:48 | Remove an ALWAYS() added by [960a8e6fc91f4] that turns out to be false in some cases of malformed SQL. (check-in: cc8171461b user: drh tags: trunk) | |
11:06 | Do not allow the EXISTS-to-JOIN optimization if the EXISTS clause is based on a view, since that view might expand into a join. (check-in: 872c41fedd user: drh tags: empty-table-optimizations) | |
10:26 | Improve the early-termination optimization so that it works in queries which use the LIKE optimization in the outer loop. (check-in: b4e4d14824 user: drh tags: empty-table-optimizations) | |