SQLite

Today In History
Login

This Day In History For 2025-06-11

1 Year Ago (more context)

2024-06-11
22:47
A second approach to working on the round() function so that it gives a small boost to numbers that are ...49999999 such that they round up. (check-in: 44dd632896 user: drh tags: round-up-2)
20:28
Handle the case where unix-dotfile is used with URI parameter nolock=1. (check-in: 3925a5b904 user: dan tags: unix-dotfile-fix)
20:03
Fix a problem with rolling back hot journals using the unix-dotfile VFS. (check-in: 4ae3300b79 user: dan tags: unix-dotfile-fix)
18:22
Provide the ability to disable the exists-to-join optimization using SQLITE_TESTCTRL_OPTIMIZATIONS. Provide tree-trace output for the optimization. (check-in: 33a3f32785 user: drh tags: exists-to-join)
17:37
Merge trunk enhancements into the exists-to-join branch. (check-in: 5f25a9518a user: drh tags: exists-to-join)
17:04
Remove some dead JS code and update some JS docs. (check-in: 6935ac71ba user: stephan tags: trunk)
17:04
When compiling shell.c in SQLITE_SHELL_FIDDLE mode, ensure that the shell_main_exit goto label is reachable. (check-in: 06e6f64533 user: stephan tags: trunk)
14:36
Change constant expressions to pre-computed constants, because apparently MSVC on ARM requires that. Forum thread 4feb1685cced0a8e. (check-in: 6c103aee6f user: drh tags: trunk)

2 Years Ago (more context)

2023-06-11
22:05
Merge the latest trunk enhancements into the newbie-safe-aggregates branch. (check-in: 75a877a923 user: drh tags: newbie-safe-aggregates)
21:58
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: 88be7075cd user: drh tags: trunk)

4 Years Ago (more context)

2021-06-11
13:24 Edit [8b1f9a51e962cd9a|8b1f9a51e9]: Edit check-in comment. (artifact: 129c35210b user: drh)
13:19 Edit [5079b5d58fdceba3|5079b5d58f]: Mark "Closed". (artifact: ff774ea401 user: drh)
13:18
Reapply two recent ALTER TABLE error checks that turned out to be necessary after all. dbsqlfuzz fc5a9deefda00dda914748985155a6d4c44174e5. (check-in: 230fedd923 user: drh tags: trunk)
12:41
Avoid bugs in some implementations of dlopen() by avoiding calls to dlopen() with a filename argument that exceeds FILENAME_MAX bytes. Forum post 08a0d6d9bf. (check-in: 01f3877c71 user: drh tags: trunk)
12:14
Fix a crash in new ALTER TABLE code that could follow an OOM. (check-in: 6f1f2a0a9c user: dan tags: trunk)
12:02
Remove an unreachable branch added by the previous commit. (check-in: 852ee0e91c user: dan tags: trunk)
11:14
Fix problems with ALTER TABLE and schemas that contain views with some recursive CTEs, or CTEs that reference other CTEs. Forum post 9d965f2956. (check-in: 8b1f9a51e9 user: dan tags: trunk)
11:12 Edit [32e3ecfc8b122055|32e3ecfc8b]: Move to branch alter-table-cte-fix-1. (artifact: e5beb621d3 user: dan)
11:11 Edit [32e3ecfc8b122055|32e3ecfc8b]: Cancel tag "alter-table-cte-fix-1". (artifact: fd42816c56 user: dan)
11:10 Edit [32e3ecfc8b122055|32e3ecfc8b]: Add tag "alter-table-cte-fix-1". (artifact: 68baf08949 user: dan)

5 Years Ago (more context)

2020-06-11
16:04 Fixed ticket [b706351ce2]: Segfault in sqlite3Select plus 3 other changes (artifact: 0131405205 user: drh)
16:04
Add a new assert() to the SELECT processing. (check-in: 98cea4a32b user: drh tags: trunk)
15:53
Avoid rewriting compound SELECT statements that use a different collation sequence for ORDER BY and record processing a second time if they contain window functions. Fix for [b706351c]. (check-in: 32a88bdd4b user: dan tags: trunk)
15:51 Edit [50b4a1c7f4d29dc1|50b4a1c7f4]: Move to branch mistake. Add propagating "hidden". Mark "Closed". (artifact: 3322843e69 user: dan)
15:47
Avoid rewriting compound SELECT statements that use a different collation sequence for ORDER BY and record processing a second time if they contain window functions. Fix for [b706351c]. (Closed-Leaf check-in: 50b4a1c7f4 user: dan tags: mistake)
01:12 Ticket [b706351ce2] Segfault in sqlite3Select status still Open with 6 other changes (artifact: b07b31dde3 user: drh)
00:57
Provide the ability to use the SELECTTRACE() debugging macro outside of the select.c source file. Use this to add a new SELECTTRACE() entry in window.c for improved tracing of window-function parse-tree rewriting. (check-in: 30c6d895b5 user: drh tags: trunk)

10 Years Ago (more context)

2015-06-11
18:01
Merge recent trunk enhancements and fixes. (check-in: c39cb0e257 user: drh tags: sessions)
17:58
Merge trunk fixes. (Leaf check-in: 1df8cbbea6 user: drh tags: view-optimization)
17:26
Add the sqlite3changegroup_xxx() APIs to the sessions module. For combining multiple changesets or patchsets. (check-in: 0c1a901cd6 user: dan tags: sessions)
14:19
Remove stray outputs from the test suite. (check-in: afc6db9b10 user: drh tags: trunk)
13:58
When generating code for partial indexes, be sure not to modify the index condition expression in the schema. (check-in: e63d01c69c user: drh tags: trunk)

15 Years Ago (more context)

2010-06-11
19:04
Experimental change to the xShmXXX parts of the VFS interface. (check-in: ca68472db0 user: dan tags: experimental)
17:01
Refactor and simplify the logic used to change journalmode. (check-in: 95cc3f6fde user: drh tags: trunk)

25 Years Ago (more context)

2000-06-11
23:50
added the fcnt() function for testing (CVS 92) (check-in: 0f93c27cdd user: drh tags: trunk)