SQLite

Timeline
Login

50 most recent check-ins

2026-06-13
20:16
Speed up SQL aggregate functions percentile() and median() by avoiding a full sort of the array of arguments. (leaf check-in: 9232b5f21d ... user: dan tags: pecentile-partial-sort)
18:17
Make the --header option to the CLI sticky, so that it does not get turned off by subsequence --csv or similar mode change options. (leaf check-in: 5019306601 ... user: drh tags: branch-3.53)
18:04
Make the --header option to the CLI sticky, so that it does not get turned off by subsequence --csv or similar mode change options. Bug 2026-06-13T11:49:18Z (leaf check-in: b19cef1862 ... user: drh tags: trunk)
2026-06-12
18:38
When reading a super-journal name from a journal file, allocate a new buffer rather than using Pager.pTmpSpace. This prevents a buffer overrun that could occur when using a VFS with a large sqlite3_vfs.mxPathname value with a database with a small page size. (check-in: aa756c8038 ... user: drh tags: branch-3.53)
18:35
When reading a super-journal name from a journal file, allocate a new buffer rather than using Pager.pTmpSpace. This prevents a buffer overrun that could occur when using a VFS with a large sqlite3_vfs.mxPathname value with a database with a small page size. (check-in: 7f71859841 ... user: dan tags: trunk)
17:32
Fix errors in comments on this branch. Also prefer SQLITE_NOMEM_BKPT to SQLITE_NOMEM. (closed check-in: ac17669e84 ... user: dan tags: super-journal-malloc)
17:16
Fix a memory leak that could follow an OOM error in the new code on this branch. (check-in: d4774a8987 ... user: dan tags: super-journal-malloc)
16:47
Improved documentation for sqlite3_deserialize(). (check-in: f15d076820 ... user: drh tags: trunk)
16:26
Do not use shared locks on SHM files when the filename is a long DOS-device path. Only used shared locks for UNC paths. Do not confuse the long-DOS-device syntax with UNC paths. (check-in: a4691489f2 ... user: drh tags: trunk)
16:04
Fix a buffer overwrite in fts3 that could occur while processing NEAR queries against corrupt records. (check-in: 85afd8e291 ... user: drh tags: branch-3.53)
15:36
Fix a buffer overwrite in fts3 that could occur while processing NEAR queries against corrupt records. Bug 2026-06-11T23:11:26Z. (check-in: b0f773e99e ... user: dan tags: trunk)
12:20
When using a read-only WAL/SHM, handle a corrupt page size in the WAL file correctly. (check-in: 9a79ca31ff ... user: drh tags: branch-3.53)
12:15
When using a read-only WAL/SHM, handle a corrupt page size in the WAL file correctly. Bug 2026-06-11T22:20:03Z. (check-in: 09ab0a1bac ... user: drh tags: trunk)
11:55
Add the --raw option to the dbtotxt command-line tool, for debugging. (check-in: abfecc0820 ... user: drh tags: trunk)
11:45
Fix a signed integer overflow that could occur in fts3 when processing corrupt database records. (check-in: 42fe4d2e8b ... user: drh tags: branch-3.53)
11:24
Fix a signed integer overflow that could occur in fts3 when processing corrupt database records. Bug 2026-06-11T23:12:25Z. (check-in: 978d04f051 ... user: dan tags: trunk)
00:13
Defense against a read-only WAL file that has an invalid page size. (closed check-in: ce3a8f9122 ... user: drh tags: corrupt-readonly-wal)
2026-06-11
23:28
Fix a signed-integer overflow in fts5 that might occur when dealing with strategicly corrupted records. (check-in: a36fc58e55 ... user: drh tags: branch-3.53)
23:26
Fix a possible signed integer overflow in the RBU extension given a maliciously crafted delta. (check-in: c40f3e8e78 ... user: drh tags: branch-3.53)
23:22
Harden code that processes Fossil Deltas against OOM and maliciously malformed delta blobs. (check-in: 1657b9716f ... user: drh tags: branch-3.53)
23:18
Enhance the ".ar -x" command to add the undocumented --debug option and to give enhanced robustness to deliberately malformed archives. (check-in: cd7bb77fdf ... user: drh tags: branch-3.53)
23:11
Comment improvements on the ".ar -x" command of the CLI. No changes to code. (check-in: 5b939fb1a2 ... user: drh tags: trunk)
22:48
Fix harmless compiler warnings. (check-in: dd0c161fcd ... user: drh tags: trunk)
16:39
Further improvements to the ".ar" command of the CLI. (check-in: 6149b938c7 ... user: drh tags: trunk)
14:28
Three-pass algorithm for the ".ar x" command in the CLI, so that symlinks are created after all regular files are created. (check-in: 37a80d20fe ... user: drh tags: trunk)
14:14
Add the (undocumented) --debug option to the ".ar" command in the CLI (check-in: 3a040ffc47 ... user: drh tags: trunk)
01:37
Improved detection of corrupt node IDs in RTree shadow tables. (check-in: 4e875ae5c3 ... user: drh tags: branch-3.53)
01:31
Improved detection of corrupt node IDs in RTree shadow tables. Test case in TH3. (check-in: e01a185a69 ... user: drh tags: trunk)
2026-06-10
20:10
When reading a super-journal name from a journal file, allocate a new buffer rather than using Pager.pTmpSpace. This prevents a buffer overrun that could occur when using a VFS with a large sqlite3_vfs.mxPathname value with a database with a small page size. (check-in: 37aa82a50a ... user: dan tags: super-journal-malloc)
16:51
Fix a signed-integer overflow in fts5 that might occur when dealing with strategicly corrupted records. Bug 2026-06-10T03:56:42Z. (check-in: fc6442ee54 ... user: dan tags: trunk)
10:40
Detect an OOM condition in the realpath() function of the fileio.c extension and cause that function to return NULL. To Do: we should go back in and fix realpath() to raise an SQLITE_NOMEM error on OOM rather than returning NULL. But we will delay that, in as much as OOMs are all but impossible on modern OSes. Bug 2026-06-10T07:46:32Z. (check-in: 8b961dc3d2 ... user: drh tags: trunk)
10:13
Fix a possible signed integer overflow in the RBU extension given a maliciously crafted delta. Bug 2026-06-10T06:41:54Z. (check-in: 8531c0c3b6 ... user: drh tags: trunk)
09:51
Harden code that processes Fossil Deltas against OOM and maliciously malformed delta blobs. Bug 2026-06-10T07:01:00Z and Bug 2026-06-10T07:06:43Z. (check-in: 67271c3129 ... user: drh tags: trunk)
2026-06-09
10:43
Avoid a possible integer overflow when fts5 tokenizes a very large document. Only possible with non-standard builds that use large values of SQLITE_MAX_LENGTH. Bug 2026-06-09T05:27:16Z. (check-in: d562e91374 ... user: dan tags: trunk)
10:16
Change loop counter variables from int to i64 to avoid a potential integer overflow inside an assert() statement when SQLite is compiled with SQLITE_DEBUG and an extra-large SQLITE_MAX_LENGTH. Does not affect production builds. Bug 2026-06-09T08:53:14Z. (check-in: 77f615d983 ... user: drh tags: trunk)
2026-06-08
19:23
Fix four obscure yet separate problems in FTS5. (check-in: a6eb055c35 ... user: drh tags: branch-3.53)
18:15
Fix builds on i486 CPUs. Forum 2025-01-25T12:58:44Z. (check-in: 4cb349370d ... user: drh tags: trunk)
17:48
Fix another buffer overread in fts5 when processing corrupt records. Bug 2026-06-08T16:03:39Z . (check-in: 8ba5acabf9 ... user: dan tags: trunk)
15:20
Fix a buffer overread that could occur in fts5 when processing corrupt records. Bug 2026-06-08T11:15:52Z (check-in: b07441cfc0 ... user: dan tags: trunk)
12:03
Avoid a potential use-after-free in fts5. Report 2026-06-08T08:45:27Z. (check-in: 9c018b02db ... user: dan tags: trunk)
11:24
Clamp the nToken parameter to the fts5 snippet() function between 0 and 64. It has always been documented this way, but not previously implemented. Report 2026-06-08T08:29:00Z. (check-in: 4af1d9b3e5 ... user: dan tags: trunk)
10:47
Add extra tests to check that non-deterministic functions may not be used in indexes. (check-in: beeef9dc2b ... user: dan tags: trunk)
2026-06-06
18:32
Improvements to the GCC compiler bug work-around of check-in [7fae321095ebec77]. (check-in: 247894f70d ... user: drh tags: trunk)
17:20
Minor performance enhancement and improved comments on the quicksort algorithm used by the median() implementation in func.c. (check-in: 2800f6a75b ... user: drh tags: trunk)
2026-06-05
00:11
A new approach to working around the GCC bug. (closed check-in: 2f95186ea5 ... user: drh tags: gcc-bug-114659)
2026-06-04
16:58
Disable the vector-IN-SELECT optimization if the number of columns is so large that it would cause the WhereTerm.nChild column to wrap. (check-in: 10d9da4f48 ... user: drh tags: branch-3.53)
16:56
Disable the vector-IN-SELECT optimization if the number of columns is so large that it would cause the WhereTerm.nChild column to wrap. Bug 2026-06-04T10:00:49Z. (check-in: bb49dfc948 ... user: drh tags: trunk)
12:27
Fix a crash that could be caused by configuring the pager-cache with a bulk allocation too small to fit even one page. (check-in: 3be41e1752 ... user: drh tags: branch-3.53)
11:48
Fix a crash that could be caused by configuring the pager-cache with a bulk allocation too small to fit even one page. Bug 2026-06-04T07:03:12Z. (check-in: b4b9dc632b ... user: dan tags: trunk)
11:42
Fix a possible NULL pointer derefence in the (experimental and untested) uuid.c extension. Bug 2026-06-04T09:50:59Z. (check-in: fa6374fe3a ... user: drh tags: trunk)
More ↓