SQLite

Today In History
Login

This Day In History For 2025-06-12

1 Year Ago (more context)

2024-06-12
22:15
Remove some dead JS code. Improve the exception-to-C-result-code conversion to account for the case of a file disappearing while the OPFS VFS is waiting to acquire a lock on it. (check-in: 5bd9fd5f61 user: stephan tags: trunk)
21:09 Edit [c298b8ba2dcd01fa|c298b8ba2d]: Edit check-in comment. (artifact: f2ee9bb736 user: stephan)
21:08
Fix a potential db corruption case triggered by the OPFS VFS's xCheckReservedLock() implementation. (check-in: a7cd07d96e user: stephan tags: branch-3.46)
21:01
Remove some JS docs which no longer apply. No code changes. (check-in: f253cab335 user: stephan tags: trunk)
17:01
Do not attempt the exists-to-join optimization for expressions from the ON clause of joins. (check-in: 4666433cbd user: dan tags: exists-to-join)
15:50
Fix a problem with rolling back hot journals using the unix-dotfile VFS. (check-in: a44703135e user: dan tags: trunk)
15:29
Omit tests that depend on sqlite3_release_memory() in lock5.test when running the memsubsys1 or memsubsys2 permutations. (Closed-Leaf check-in: 9d63033bf4 user: dan tags: unix-dotfile-fix)
14:29 Edit [3dec4b35ecd68a4d|3dec4b35ec]: Mark "Closed". Edit check-in comment. (artifact: b13ceba749 user: drh)
12:36
Fix a potential db corruption case triggered by the OPFS VFS's xCheckReservedLock() implementation, as discussed in forum thread a2f573b00cda1372. (check-in: c298b8ba2d user: stephan tags: trunk)
12:17
Doc updates in JS code. No functional changes. (check-in: 587ed3a5d2 user: stephan tags: trunk)
11:41
Do not attempt to run hot journal rollback tests in lock5.test with the "inmemory_journal" permutation, which cannot generate hot journals. (check-in: 1e6fa95b88 user: dan tags: unix-dotfile-fix)
11:39
Slight API doc tweak for xCheckReservedLock(), based on forum feedback. No code changes. (check-in: 2af7a96f68 user: stephan tags: trunk)
10:17
Improvements to the layout and comments for the new round() implementation. (Leaf check-in: d6b1df1a22 user: drh tags: round-up-2)
00:30
Test cases for the round() function for values within one epsilon of the 5 round-up threshold. (check-in: 552b1b1066 user: drh tags: round-up-2)

2 Years Ago (more context)

2023-06-12
18:22
Initialize a local variable in FTS3 to avoid a GCC compiler warning. (check-in: 7ec4ab327d user: drh tags: trunk)
18:11
Finish .parameter improvements. (no set <cast_op> anymore, not useful enough for its apparent complexity) (check-in: bbbdb864f0 user: larrybr tags: cli_extension)
14:26
The decision was made to halt work on this enhancement. See the discussion beginning with forum post 4c8a673560d7999a. The changes on this branch work, but they add unnecessary user complexity with no corresponding benefit. (Closed-Leaf check-in: c8ef3b7874 user: drh tags: newbie-safe-aggregates)
14:16
Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae (check-in: 44fdc798de user: drh tags: branch-3.42)
14:12
Make sure temporary sqlite3_value objects used by STAT4 are reset to NULL prior to being reused, to prevent a memory leak associated with the custom xDel string value destructor. dbsqlfuzz 65209ab5d5730e4fd14fff9d024325a77239036e. (check-in: 2cf197a28b user: drh tags: branch-3.42)
14:09
Defer setting the BTS_PAGESIZE_FIXED flag until after we are certain there are no errors and the page size has been set. Forum post b901808856. (check-in: cefaf128d2 user: drh tags: branch-3.42)
14:03
Extra space to prevent a buffer overread on corrupt STAT4 records. dbsqlfuzz 7128d1b41ce9df2c007f9c24c1e89e2f1b2590ca. (check-in: 566c4c14dd user: drh tags: branch-3.42)
13:57
Simplify a memcpy() in defragmentPage(). It now might copy more content than is strictly necessary, but runs faster and uses less code space. Possible reasons for the improved performance: (1) the copy is now always 8-byte aligned, (2) fewer intermediate results are required which means less register pressure which helps the compiler to optimize the subroutine. (check-in: 1292d676ea user: drh tags: branch-3.42)
13:53
Fix CLI fault on missing -nonce reported by forum post f8c14a1134. (check-in: 67cf7c4096 user: drh tags: branch-3.42)
13:49
Fix a problem causing bloom filters to be used less efficiently than they might be. Problem reported by forum post 06c3f01da6. (check-in: 56d9bb7aa6 user: dan tags: trunk)
13:46
Fix a problem causing an infinite loop in the recovery extension when processing a corrupt free-block list. (check-in: d21c06b73d user: drh tags: branch-3.42)
13:43
Fix an issue with sqldiff reported by forum post 9bd2155bdfae25a7. (check-in: 50721074f7 user: drh tags: branch-3.42)
13:35 Edit [a35c50eca907d0cf|a35c50eca9]: Edit check-in comment. (artifact: 3ec8813467 user: drh)
13:31
Check-in [70e12efd1b189560] left a path through lockBtree() that failed to set the BTS_PAGESIZE_FIXED flag. That omission is fixed by this check-in. dbsqlfuzz 02c9ab74eb0619c9ae3b894ce157fae1d7f94645 (check-in: 30dcc872eb user: drh tags: trunk)
11:06
Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae (check-in: a35c50eca9 user: dan tags: trunk)

4 Years Ago (more context)

2021-06-12
18:12
The sqlite3WithPush() routine might destroy its second argument if there was a prior OOM. Do not use the second argument of sqlite3WithPush() if this happens. (check-in: baa3f96250 user: drh tags: trunk)
18:02 Edit [193b14a58e378ab3|193b14a58e]: Move to branch original-uaf-fix. Mark "Closed". Edit check-in comment. (artifact: 8e1a7deb2e user: drh)
17:58 Edit [6796b7a2485eca27|6796b7a248]: Edit check-in comment. Remove the "Closed" mark. (artifact: 6728bd25e9 user: drh)
17:45
An alternative approach to the use-after-free problem. (Closed-Leaf check-in: 6796b7a248 user: drh tags: alternative-oom-fix)
16:17
Fix a use-after-free that could follow an OOM in ALTER TABLE. (Edit:) Still contains problems. (Closed-Leaf check-in: 193b14a58e user: dan tags: original-uaf-fix)

5 Years Ago (more context)

2020-06-12
15:45
New test case added to test/fuzzdata8.db. (check-in: 14a5cbddc8 user: drh tags: trunk)
15:17
Fix a buffer overread in fts3 that could occur when decoding a corrupted record. (check-in: 9a4a40c45f user: dan tags: trunk)
00:31
Remove a NEVER() that turns out to be reachable. (check-in: 44e573ecd5 user: drh tags: trunk)

10 Years Ago (more context)

2015-06-12
13:49
Add a fast-path implementation of pcache1Fetch() for the common case of separate caches that do not use a mutex. (check-in: 760700edb3 user: drh tags: faster-pcache1-fetch)
13:04
Minor performance optimization in pcache1.c. (check-in: 2e8ad2ead9 user: drh tags: trunk)
12:54
Add the OP_ColumnsUsed opcode (when compiled with SQLITE_ENABLE_COLUMN_USED_MASK) as a hint to the b-tree layer as to which columns of a btree cursor will be used. (check-in: 711a176cbf user: drh tags: trunk)

15 Years Ago (more context)

2010-06-12
17:22 Edit [eade8bc238df5804|eade8bc238]: Change branch background color to "#c0ffc0". Timestamp 2010-06-12 12:02:36. (artifact: 44cbba82fd user: drh)
17:22 Edit [ca68472db01c14a8|ca68472db0]: Timestamp 2010-06-11 19:04:21. (artifact: 4f8df3ca1f user: drh)
17:21 Edit [ca68472db01c14a8|ca68472db0]: Change background color to "#c0ffc0". Timestamp 2010-06-11 19:04:21. (artifact: 674a88b50d user: drh)
12:02
Fix some problems with handling IO errors on the experimental branch. (check-in: eade8bc238 user: dan tags: experimental)

20 Years Ago (more context)

2005-06-12
23:17
Version 3.2.2 (CVS 2511) (check-in: 0e190e9d91 user: drh tags: trunk)
23:16
Update the EXPORT definitions list to include the latest additions to the API. (CVS 2510) (check-in: 44e54b132e user: drh tags: trunk)
22:23
Updates in preparation for the release of version 3.2.2. (CVS 2509) (check-in: e9602c4a9d user: drh tags: trunk)
22:12
Fix documentation typos. (CVS 2508) (check-in: 41049062cd user: drh tags: trunk)
22:01
Documentation updates (ticket #1279). Add the sqlite3_db_handle API. (ticket #1275). (CVS 2507) (check-in: 21d44fa5e7 user: drh tags: trunk)
21:35
Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) (check-in: 36f2da1f8d user: drh tags: trunk)
12:01
Elminiate a VM opcode that was no longer needed. (CVS 2505) (check-in: 97b348a5ad user: drh tags: trunk)

25 Years Ago (more context)

2000-06-12
17:49
:-) (CVS 96) (check-in: 36c2b059ac user: drh tags: trunk)
17:49
:-) (CVS 1698) (check-in: 662fa612dc user: drh tags: trunk)
12:36
:-) (CVS 95) (check-in: 547e8b927b user: drh tags: trunk)
12:29
:-) (CVS 94) (check-in: 84b506b06c user: drh tags: trunk)
12:20
:-) (CVS 93) (check-in: 3c0540e6fb user: drh tags: trunk)