SQLite

Timeline
Login

50 most recent check-ins

2026-06-22
11:02
Add the BTREE_HINT_TABLECURSOR cursor-hint. This is not currently used by stock SQLite. (leaf check-in: 35b3ff4007 ... user: dan tags: trunk)
10:38
Fixes for kvvfs journaling. Bug reports 2026-06-20T08:49:41Z and 2026-06-20T18:35:54Z. (leaf check-in: 4c773f5d64 ... user: stephan tags: branch-3.53)
2026-06-21
11:38
Correct test from [96a48a15760a] - that journal was indeed corrupt, but not in the intended manner. Add a verification that the bad journal gets replaced after a write. (check-in: c917122116 ... user: stephan tags: trunk)
11:10
Extend the test from the previous check-in a bit. (check-in: bd6bbd0e84 ... user: stephan tags: trunk)
10:55
Add a JS test demonstrating that [7c4db1cd2d06] recovers gracefully from journal corruption. (check-in: 96a48a1576 ... user: stephan tags: trunk)
08:38
Fix a result value semantics bug which broke application of a journal in kvvfs. Fix a memory-reset bug in hypothetical non-WASM builds of kvvfs. Bug report 2026-06-20T18:22:59Z, and this resolves the journaling issue mentioned in the parent post. (check-in: 7c4db1cd2d ... user: stephan tags: trunk)
08:13
Fix a potential integer overflow when decoding a corrupt kvvfs block. Bug report 2026-06-20T18:35:54Z. (check-in: c36fc5df62 ... user: stephan tags: trunk)
2026-06-20
21:54
Fix an incorrect assert() in check-in [984c9b181801c1de] (check-in: 1d41c93b36 ... user: drh tags: trunk)
11:07
Correct misuse of a loop control variable in writing of a kvvfs journal. Bug report 2026-06-20T08:49:41Z. Remove a snippet of dead code in the JS kvvfs side. (check-in: a396d7c54c ... user: stephan tags: trunk)
2026-06-19
23:53
Add the sqlite3_result_str() interface and use it to simplify the code. (check-in: 8f8361edf8 ... user: drh tags: trunk)
22:57
Use SQLITE_FINISH in a few places in the core, to help ensure that path is well tested. (closed check-in: 7356bf3a81 ... user: drh tags: sqlite3-result-str)
22:17
Put the sqlite3OomStr singleton in "const" space to ensure that it is never modified. Doing so identified a long-standing bug. (check-in: 2fe53e6d68 ... user: drh tags: sqlite3-result-str)
21:43
Additional changes based on Claude analysis. (check-in: d4691a0db1 ... user: drh tags: sqlite3-result-str)
20:01
Further refinements and uses for sqlite3_result_str(). (check-in: 974253a605 ... user: drh tags: sqlite3-result-str)
17:03
Prototype implementation for a new sqlite3_result_str() API. (check-in: cdbc62c36a ... user: drh tags: sqlite3-result-str)
16:55
Fix the format() SQL function so that it returns an empty string not a NULL if the first argument is an empty string. Bug 2026-06-19T16:40:04Z (check-in: ece7af98a8 ... user: drh tags: trunk)
12:14
Fix a cast in fts3_write so that it is applied as intended. (check-in: 6c22c34e9a ... user: drh tags: branch-3.53)
11:46
Fix a cast in fts3_write so that it is applied as intended. Bug 2026-06-19T07:56:23Z. (check-in: d6a3272e55 ... user: dan tags: trunk)
11:18
Fix an fts5 problem causing attempts to create locale=1 tables with more than 115 columns to fail. (check-in: 4d993e8f5f ... user: drh tags: branch-3.53)
11:14
Fix an fts5 problem causing attempts to create locale=1 tables with more than 115 columns to fail. Bug 2026-06-19T05:19:08Z. (check-in: 979229f720 ... user: dan tags: trunk)
2026-06-18
17:09
Fix a memory size computation error on 32-bit platforms caused by check-in [9a2a230464e43140]. (check-in: dc4763b14c ... user: drh tags: trunk)
2026-06-17
20:11
Small parsing performance improvement by reducing the amount of the Parse object that needs to be initialized. (check-in: 0901b7c2df ... user: drh tags: trunk)
19:28
Remove the unnecessary Parse.szOpAlloc field, for small size reduction and performance improvement. (check-in: 9a2a230464 ... user: drh tags: trunk)
18:39
Small performance boost in the sqlite3VdbeResolveLabel() routine of the code generator. (check-in: f786f3643e ... user: drh tags: trunk)
16:57
Safer conversion from double to 64-bit integer in two places. (check-in: 17c4443829 ... user: drh tags: trunk)
14:53
Additional refinements to the large floating-point handling in generate_series(). Follow-up to [5aab8c2cde63f9db]. (check-in: 4247c5d9af ... user: drh tags: trunk)
14:12
Fix CLI CSV test cases so that they suppress the CR on windows and thus work cross-platform. Test case changes only - no changes to code. (check-in: 89d9120af9 ... user: drh tags: branch-3.53)
13:52
Fix CLI CSV test cases so that they suppress the CR on windows and thus work cross-platform. (check-in: 7a2c96405e ... user: drh tags: trunk)
13:31
Fix the OR-to-IN optimization so that it works in cases where there are conflicting collation sequences on the equality constraints within the OR. Bug 2026-06-17T05:04:48Z. (check-in: 984c9b1818 ... user: drh tags: trunk)
09:46
Improved detection of when the alternative windows-compatible main() is needed in the sqldiff.exe utility. (check-in: 571846a9c2 ... user: drh tags: branch-3.53)
2026-06-16
23:59
Typo fix in a comment used to generate documentation. No changes to code. Forum 2026-06-16T23:18:50Z. (check-in: 7386faef61 ... user: drh tags: trunk)
18:06
After opening a non-covering index cursor, pass the corresponding table cursor to the implementation via sqlite3BtreeCursorHint(). (closed check-in: d48c6d2dcd ... user: dan tags: cursor-hint-tblcsr)
13:46
Limit VIEW recursion depth to SQLITE_LIMIT_EXPR_DEPTH to prevent static overflow in malicious schemas with tens of thousands of levels of recursive views. (check-in: 38430aa5ed ... user: drh tags: branch-3.53)
13:43
Limit VIEW recursion depth to SQLITE_LIMIT_EXPR_DEPTH to prevent static overflow in malicious schemas with tens of thousands of levels of recursive views. Bug 2026-06-16T04:21:51Z (check-in: 3f3fb9b638 ... user: drh tags: trunk)
12:02
Fix instances of potential buffer overflow caused by loading the contents of a stat4 table with an absurd number of samples in a 32-bit build. (check-in: c25ac7af86 ... user: drh tags: branch-3.53)
11:53
Fix instances of potential buffer overflow caused by loading the contents of a stat4 table with an absurd number of samples in a 32-bit build. Bug 2026-06-16T11:30:52Z. (check-in: 0b72246732 ... user: dan tags: trunk)
09:53
Fix a possible call to memcpy() with a NULL source pointer when the size parameter is zero (which is technically undefined behavior but in practice is completely harmless) in the sha1_query() extension function. Bug 2026-06-16T07:42:23Z. (check-in: 2063926473 ... user: drh tags: trunk)
2026-06-15
17:39
Consistent error messages for excess trigger nesting. (check-in: 4fb9f2ffb4 ... user: drh tags: trunk)
17:27
Speed up SQL aggregate functions percentile() and median() by using quickselect to find the required values instead of fully sorting the array of values with quicksort. (check-in: 0796d337f6 ... user: dan tags: trunk)
17:14
New Windows makefile targets for common EXEs that omit the ".exe" suffix, so that when muscle memory kicks in and we type "make sqlite3" on windows, it still works. (check-in: 1152463a66 ... user: drh tags: trunk)
17:13
Improve comments in percentSort(). (closed check-in: 9b43500f51 ... user: dan tags: pecentile-partial-sort)
16:49
Enhance SQLITE_LIMIT_TRIGGER_DEPTH so that it also limits a chain of distinct triggers during code generation. (check-in: b22709dcb3 ... user: drh tags: branch-3.53)
16:46
Fix a problem sometimes causing an UPSERT to incorrectly convert an excluded.* column from type REAL to INT in cases where doing so does not cause data loss. (check-in: 5d344e0288 ... user: drh tags: branch-3.53)
16:45
Enhance SQLITE_LIMIT_TRIGGER_DEPTH so that it also limits a chain of distinct triggers during code generation. Bug 2026-06-15T06:44:07Z. (check-in: 0b5378678e ... user: drh tags: trunk)
16:27
Improvements to handling of inequality constraints on generate_series().value against very large floating-point values. (check-in: e10ff7cd09 ... user: drh tags: branch-3.53)
15:48
Change the PACKAGE_BUGREPORT config option point to /bugs instead of /forum. (check-in: ca15fedede ... user: stephan tags: trunk)
15:38
Fix a problem sometimes causing an UPSERT to incorrectly convert an excluded.* column from type REAL to INT in cases where doing so does not cause data loss. Bug 2026-06-15T09:08:12Z. (check-in: 71334f7ec9 ... user: dan tags: trunk)
15:27
Improvements to handling of inequality constraints on generate_series().value against very large floating-point values. Bug 2026-06-15T04:37:48Z. (check-in: 5aab8c2cde ... user: drh tags: trunk)
15:24
Additional tweaks and test cases for generate_series() constraints using very large floating-point numbers. (closed check-in: 50d611404a ... user: drh tags: series-boundry-cases)
14:16
Better behavior for generate_series() in cases where constraints involve floating point number that are near the minimum and maximum 64-bit integer values. (check-in: 236ef21789 ... user: drh tags: series-boundry-cases)
More ↓