Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins that include changes to files matching 'src/*'
2025-07-19
| ||
20:10 | Factor out the unusual encoding-change case from vdbeCompareMemString() for a performance improvement in the common case, and a small size reduction. (Leaf check-in: cbd46ab8a8 user: drh tags: trunk) | |
19:54 | Small performance optimization in sqlite3VdbeRecordUnpack(). (check-in: eae168def2 user: drh tags: trunk) | |
18:46 | Split the (internal) sqlite3VdbeCheckFk() routine into two variants, sqlite3VdbeCheckFkImmediate() and sqlite3VdbeCheckFkDeferred(), which run faster than the combined general-purpose variant. (check-in: 872b1b52ed user: drh tags: trunk) | |
18:17 | Use fewer CPU cycles to commit a read transaction. (check-in: 861e55656a user: drh tags: trunk) | |
2025-07-18
| ||
19:17 | Fix a minor comment inaccuracy. (check-in: b66fcb61a1 user: drh tags: trunk) | |
17:40 | Increase the precision of the "real time" output from the ".timer" command in the CLI from milliseconds to microseconds. (check-in: c5dbe93114 user: drh tags: trunk) | |
12:22 | Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. Also increment the version number. (Leaf check-in: 53711bf9f6 user: drh tags: branch-3.50) | |
12:10 | Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. This fixes a problem introduced by [663f5dd32d9db832] and found by dbsqlfuzz. Test cases in TH3. (check-in: 235cf6586b user: drh tags: trunk) | |
2025-07-17
| ||
15:38 | Merge the latest trunk enhancments into the reuse-schema branch. (Leaf check-in: 12dbb05b84 user: drh tags: reuse-schema) | |
15:31 | Merge all of the trunk enchancements into the bedrock branch. (Leaf check-in: ba2174bdca user: drh tags: bedrock) | |
15:24 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: 69794955d8 user: drh tags: wal2) | |
15:18 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 0b2979f0c0 user: drh tags: begin-concurrent) | |
14:02 | Merge the 3.50.3 changes into the reuse-schema-3.50 branch (Leaf check-in: 5a70ffd63c user: drh tags: reuse-schema-3.50) | |
2025-07-16
| ||
09:27 | Teach the sqlite3 CLI shell to look in XDG_STATE_HOME for the CLI history file before falling back to its historical location in the user's home directory. (check-in: 1e663374c3 user: stephan tags: trunk) | |
09:20 | Squelch a legitimate but harmless 'discards const' warning. (Closed-Leaf check-in: 73539fe093 user: stephan tags: shell-xdg-vars) | |
2025-07-15
| ||
19:00 | Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. (check-in: 9f184f8dfa user: dan tags: trunk) | |
17:03 | Have SQLite request a plan with no setup-cost from xBestIndex if the plan in question may only be used as the outermost loop of the query. (Leaf check-in: c3740ef6e4 user: dan tags: vtab-setup-cost) | |
2025-07-14
| ||
18:59 | Add comments to sqlite.h.in describing the change on this branch. (check-in: 19038620cd user: dan tags: vtab-setup-cost) | |
18:03 | Merge latest trunk changes into this branch. (check-in: 8f9d6acaf7 user: dan tags: vtab-setup-cost) | |
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]. (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
| ||
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) | |
2025-07-10
| ||
09:27 | Minor internal doc correction in vdbeInt.h. (check-in: c3a2ef639c user: stephan tags: trunk) | |
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) | |
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) | |
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) | |
2025-07-07
| ||
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. (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) | |
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
| ||
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
| ||
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) | |
10:17 | Merge trunk into column-text-blob-v2 branch. (check-in: f73460d4f0 user: stephan tags: column-text-blob-v2) | |
10:10 | Tweak for coverage testing of valueToTextV2(). This changes passes through coverage testing but doesn't look quite right to me, in that this part now differs from its counterpart in valueToText() (which doesn't need this to get coverage for what amounts to the same path). (check-in: dae572912f user: stephan tags: column-text-blob-v2) | |
2025-07-03
| ||
20:51 | Merge the latest trunk fixes and enhancements into the empty-table-optimizations branch (check-in: d4f47e04f5 user: drh tags: empty-table-optimizations) | |
16:05 | Fix a few cases where LIMIT clauses that were part of scalar sub-queries on virtual tables were not being passed to xBestIndex methods correctly. (check-in: 960a8e6fc9 user: dan tags: trunk) | |