SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent check-ins that include changes to files matching 'src/*'

2025-06-30
16:41
Strive to skip the evaluation of scalar subqueries that are part of a larger expression if the result from the scalar subquery does not change the result of the overall expression. (Leaf check-in: 0083d5169a user: drh tags: trunk)
15:56
Correct ~/.local/config/... to ~/.config/... when looking for sqliterc when XDG_CONFIG_HOME is not set. Internal doc touchups. (Leaf check-in: ebb346c5aa user: stephan tags: shell-xdg-vars)
15:21
Add support for using $XDG_STATE_HOME/sqlite_history or ~/.local/state/sqlite_history before fallback back to the historical default of ~/.sqlite_history. Update sqlite3.1 (man page) with the new semantics. (check-in: 6b780655cc user: stephan tags: shell-xdg-vars)
12:14
For all binary operators, try to avoid computing subquery operands if the other operand is NULL. (Closed-Leaf check-in: d86eb16283 user: drh tags: optimize-null-values)
11:46
Preliminary refactoring of the XDG_CONFIG_HOME support to support the pending addition of other XDG-configurable options. In response to forum post 31db1a23f9. (check-in: 69b9244e3a user: stephan tags: shell-xdg-vars)
11:04
Slightly smaller and faster version of the previous check-in. (check-in: f6e6fd02f4 user: drh tags: optimize-null-values)
11:01
Minor API doc typo fixes from brickviking. (Leaf check-in: 581a088df7 user: stephan tags: branch-3.50)
11:00
Minor API doc typo fixes from brickviking. (check-in: b48d951916 user: stephan tags: trunk)
10:30
Factor out the code that tries to avoid evaluating subquery operands if the other operand is NULL into a subroutine, so that it can be more easily reused by other parts of the code generator. (check-in: 3c6c71bcea user: drh tags: optimize-null-values)
2025-06-29
07:32
Minor API doc typo fixes from brickviking. (check-in: 45acc26bb0 user: stephan tags: branch-3.50)
07:32
Minor API doc typo fixes from brickviking. (check-in: c7cf9dcb69 user: stephan tags: trunk)
2025-06-28
17:59
Improve the bytecode generated for comparisons so that if one operand is a subquery and the other operand evaluates to NULL, the subquery operand is not even computed. This fixes 5 of the 11 slow queries described in forum post 52651713ac. (check-in: f147bc0477 user: drh tags: optimize-null-values)
14:36
Merge all the latest trunk fixes and enhancements into the reuse-schema branch. (Leaf check-in: 6e1f97d99b user: drh tags: reuse-schema)
14:35
Merge the 3.50.2 changes into the reuse-schema-3.50 branch. (Leaf check-in: b66f853a24 user: drh tags: reuse-schema-3.50)
14:30
Merge the latest trunk fixes and enhancements into the bedrock branch. (Leaf check-in: a6f6fbe617 user: drh tags: bedrock)
14:24
Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: e7867c3992 user: drh tags: wal2)
14:16
Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 1ae8d60237 user: drh tags: begin-concurrent)
2025-06-27
19:56
Raise an error right away if the number of aggregate terms in a query exceeds the maximum number of columns. (check-in: 4ae45291e6 user: drh tags: branch-3.50)
19:02
Raise an error right away if the number of aggregate terms in a query exceeds the maximum number of columns. (check-in: 5508b56fd2 user: drh tags: trunk)
12:51
API doc typo fixes and closing DD element tags from brickviking. (check-in: 6113572247 user: drh tags: branch-3.50)
12:46
API doc typo fixes and closing DD element tags from brickviking. (check-in: c9ddd15b01 user: stephan tags: trunk)
2025-06-26
18:57
Work around an apparent GCC UBSAN bug. See forum thread 1d7c25d4a2d for details. (check-in: 23056532e5 user: drh tags: trunk)
15:41
Minor API doc fixes sent off-list from brickviking. (check-in: a9e9cefd05 user: drh tags: branch-3.50)
2025-06-25
20:42
Minor API doc fixes sent off-list from brickviking. (check-in: cb4d05633a user: stephan tags: trunk)
2025-06-24
18:27
Similar fix to the previous check-in, but this time for sqlite3_preupdate_new(). (check-in: 9aaff764d5 user: drh tags: trunk)
15:58
Range check the column index on the sqlite3_preupdate_old() interface and return SQLITE_MISUSE if too large. Forum post b617e49728. (check-in: 6a5701e6c7 user: drh tags: trunk)
07:38
API doc typo fixes and one rephrasing improvement from brickviking. (check-in: 85e8060c47 user: stephan tags: trunk)
2025-06-23
19:00
Fix an SQL typo introduced by the previous check-in. (check-in: 72a81d247b user: drh tags: trunk)
16:51
Escape the "_" character in LIKE patterns in the CLI. Forum post 6a89702f5d. (check-in: cf61cd359e user: drh tags: trunk)
13:42
Fix a harmless compiler warning injected by [c978aed3b6f82b3d]. (check-in: f46500247b user: drh tags: trunk)
13:28
Improved "statement aborts at ..." log-file messages that identify the trigger that caused the abort. (check-in: 7691264fe3 user: drh tags: trunk)
2025-06-22
12:04
API doc typo fixes from brickviking. (check-in: 18e07f8f53 user: stephan tags: trunk)
2025-06-21
06:07
Numerous small doc typo from BrickViking. (check-in: 3aab4415de user: stephan tags: trunk)
2025-06-20
13:12
Enhance sqlite3BtreeSetPageSize() so that it detects early if no changes are needed and exists with SQLITE_OK. (check-in: c978aed3b6 user: drh tags: trunk)
2025-06-19
20:00
Improve the accuracy of sqlite3BtreeRowCountEst(). (check-in: e553fb538e user: drh tags: trunk)
19:33
Generalize the indexCellCompare() so that works on any index page, not just the current page that a cursor is pointing to. (check-in: b305a7f5db user: drh tags: trunk)
13:48
Cherry-pick of documentation updates from trunk - no code changes. (check-in: c53906260e user: drh tags: branch-3.50)
12:35
A slight doc rephrasing for clarity, suggested in the forum. (check-in: 0d6084a398 user: stephan tags: trunk)
10:46
Doc typo fixes from forum post 0bce273669. (check-in: 8f97e3f00d user: stephan tags: trunk)
2025-06-18
19:04
Extend the pedantic enforcement of type in STRICT tables to cover VIRTUAL columns. (check-in: b734c74e55 user: drh tags: trunk)
16:17
Enforce judgmental typing on STORED generated columns for STRICT tables. Forum post 6caf195248. (check-in: 5e9279bff0 user: drh tags: trunk)
14:14
Change the definition of SQLITE_DYNAMIC to a function that has exactly the same type as sqlite3_destructor_type, in an effort to work around possible legacy compiler bugs. (check-in: 83553edf78 user: drh tags: trunk)
2025-06-17
19:32
Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Also fix a corner case in the previous check-in on this branch. (check-in: c232fa2bfc user: drh tags: branch-3.50)
19:10
Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. (check-in: 5973f9b9aa user: drh tags: trunk)
18:57
Fix a corner-case for [9441fff52cc4e19c]. (check-in: 336a59eb3a user: drh tags: trunk)
11:36
Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Possible fix for forum post b490f726db. (check-in: 3a3269fe8e user: dan tags: forum-b490f726db-fix)
2025-06-16
18:04
Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. (check-in: 6c5f4c8af9 user: drh tags: branch-3.50)
17:36
Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. Problem reported by forum post 68f29a2005. (check-in: 9441fff52c user: drh tags: trunk)
16:07
Improved debugging output for the transitive constraint optimization. (check-in: 94b53c20e9 user: drh tags: trunk)
15:34
Make the show-%p-az-zero hack of the previous check-in configurable at run-time using the 0x100000 bit of either .treetrace or .wheretrace. As before, this is all a no-op except for debugging builds. (check-in: a29627d7e7 user: drh tags: trunk)