SQLite

Timeline
Login

50 most recent check-ins

2026-07-12
07:42
Improve documentation for sqlite3_result_zeroblob64(). No changes to code. (leaf check-in: c3d307d136 ... user: drh tags: trunk)
2026-07-11
19:49
Improvements to the implementation of sqlite3_result_str() so that it has 100% mutation coverage. (check-in: 121f54c532 ... user: drh tags: trunk)
16:14
Minor change to the "weekday N" modifier in the date/time functions to facilitate 100% mutation test coverage. (check-in: 76002a6f5d ... user: drh tags: trunk)
2026-07-10
15:06
New compile-time option SQLITE_MAX_SCHEMA and runtime limit option SQLITE_LIMIT_SCHEMA that put an upper bound on the number of objects in a database schema. Current default is 10 million. (check-in: 4ff362a4c2 ... user: drh tags: trunk)
2026-07-09
21:10
Ensure that the "leaf-size" field of an fts5 record is only read from records that are actually leaves and are large enough to contain it. (leaf check-in: 7bad71288c ... user: drh tags: branch-3.53)
20:56
Ensure that the "leaf-size" field of an fts5 record is only read from records that are actually leaves and are large enough to contain it. Bug 2026-07-09T20:15:55Z. (check-in: fe52900694 ... user: dan tags: trunk)
17:13
In the sqlite3_rsync utility program, fix three defects identified by Anthropic. (check-in: b6ab126399 ... user: drh tags: branch-3.53)
16:34
In the sqlite3_rsync utility program, fix three defects identified by Bug e2dfadf51209f12b. (check-in: 805f3acd2b ... user: drh tags: trunk)
2026-07-08
20:33
Fix an incorrect free() call in the CLI on Windows when using the -A command-line option. (check-in: 74a4c3b666 ... user: drh tags: branch-3.53)
20:30
Fix an incorrect free() call in the CLI on Windows when using the -A command-line option. (check-in: 1ce57ba94b ... user: drh tags: trunk)
17:54
Allow "ALTER TABLE ... DROP CONSTRAINT" to drop foreign key constraints. (check-in: 4b0882cdb5 ... user: dan tags: trunk)
17:40
Allow "ALTER TABLE ... DROP CONSTRAINT" to drop foreign key constraints. (closed check-in: 17c0896381 ... user: dan tags: drop-constraint-fk)
15:43
For display modes in the CLI for which column headers are enabled, make the mode "always" instead of "on. Improved comments and test cases. (check-in: c8aa208bf5 ... user: drh tags: trunk)
15:34
Make the (legacy, deprecated) ".header" command in the CLI responsive to the "always" title mode. Clean up title mode and define its operation with improved comments in the TCL interface and in the CLI. Add the "-title auto" option to the CLI. (closed check-in: f94259fc07 ... user: drh tags: title-always-default-on)
2026-07-07
14:53
Change the CLI so that the default "--title" is "always" instead of "on" for some display modes. This check-in also include a fix to "--title always" for the "markdown" display mode. (check-in: c3b0fff1b7 ... user: drh tags: title-always-default-on)
13:53
Add the "--rowcount on" and "--title always" features to QRF, the CLI, and the TCL interface. Make them on by default for "--style psql". (check-in: 4edba31af4 ... user: drh tags: trunk)
13:24
Corrections to the mode matrix in the CLI (closed check-in: 0bca306165 ... user: drh tags: psql-mode)
13:16
Fix a problem with --rowcount found by Claude in code review. (check-in: bc5fb05aa6 ... user: drh tags: psql-mode)
12:24
Improved title separator in QRF when using "-title always" on an empty row. Improved comments on the mode matrix in the CLI code. Additional test cases. (check-in: a102d28fca ... user: drh tags: psql-mode)
11:00
Show --rowcount for "--style insert". New test cases. (check-in: 386c40e3a9 ... user: drh tags: psql-mode)
00:23
Continuing work on --rowcount and --title always. (check-in: adeb4fbb86 ... user: drh tags: psql-mode)
2026-07-06
19:24
Add new option "bRowCount" to QRF. Add QRF_Always as a possibility for bTitles. Use these feature to enhance ".mode psql" to be a better approximation of what psql actually does. (check-in: 600c6b4640 ... user: drh tags: psql-mode)
16:55
Fix an OOB read caused by passing an out-of-range phrase number to fts5 auxiliary API xPhraseFirstColumn() in detail=columns mode. (check-in: 9aac477d65 ... user: drh tags: branch-3.53)
16:52
Fix another buffer overread in RBU that could occur when processing an RBU database with corrupt rbu_control fields. (check-in: dd482ecec3 ... user: drh tags: branch-3.53)
16:46
Fix mulutiple problems in RBU and reduce divergence between the Fossil native implementation of delta and the variant of that code used by RBU. (check-in: 6870e39ecc ... user: drh tags: branch-3.53)
16:26
Reduce divergence between ext/misc/fossildelta.c, the delta code in ext/rbu/sqlite3rbu.c, and Fossil itself. (check-in: 7f49a7a90e ... user: drh tags: trunk)
16:04
Fix an OOB read caused by passing an out-of-range phrase number to fts5 auxiliary API xPhraseFirstColumn() in detail=columns mode. (check-in: aeb85fdfca ... user: dan tags: trunk)
15:13
Fix a problem in the fossil-delta implementation within RBU causing it to reject some well-formed delta records. Bug 2026-07-06T13:01:22Z. This fixes a problem introduced by check-in [67271c31292bc1bd] and published in version 3.53.3. (check-in: 0bfba3824f ... user: dan tags: trunk)
14:37
Fix another buffer overread in RBU that could occur when processing an RBU database with corrupt rbu_control fields. Bug 2026-07-06T13:01:41Z. (check-in: 46c2476b10 ... user: dan tags: trunk)
14:10
Fix an OOB read that could occur in RBU when using a state db with corrupt contents. Bug 2026-07-06T13:02:00Z. (check-in: 9e54159f9a ... user: dan tags: trunk)
13:57
Avoid a (harmless) 1-byte OOB read due to malformed inputs in the normalize.c extension. (check-in: a6cdeee6e6 ... user: drh tags: branch-3.53)
13:43
Avoid a (harmless) 1-byte OOB read due to malformed inputs in the normalize.c extension. Bug 2026-07-06T13:02:37Z (check-in: b1d7123bc6 ... user: drh tags: trunk)
13:41
Return an error if a patchset is passed to sqlite3rebaser_configure(). And avoid a buffer overread in the session module when an UPDATE change is rebased against a baseline that records fewer columns than the UPDATE. (check-in: 37c90c8fc2 ... user: drh tags: branch-3.53)
11:58
Return an error if a patchset is passed to sqlite3rebaser_configure(). This was causing a buffer overread. Bug reported by Owais Lone (thesecguy). (check-in: 887a29a837 ... user: dan tags: trunk)
11:34
In the strdup.c expension, do not invoke memcpy() with a NULL pointer even if the count is zero. (check-in: c56da4bba1 ... user: drh tags: trunk)
08:36
Avoid a buffer overread in the session module when an UPDATE change is rebased against a baseline that records fewer columns than the UPDATE. Bug 2026-07-05T13:57:01Z. (check-in: ea26bf3cd7 ... user: dan tags: trunk)
2026-07-05
19:24
Properly handle errors from the readlink() system call in the fileio.c extension. (check-in: b6500b6bf1 ... user: drh tags: branch-3.53)
19:18
Fix the parse_create_index() SQL function created by the incremental integrity_check extension so that it works for widely correct CREATE INDEX statements. Also fix the extension so that it removes the parse_create_index() function. Add the sqlite3_intck_register() API function so that the parse_create_index() function can be more easily tested. (check-in: 88bfcc7361 ... user: drh tags: branch-3.53)
19:18
Properly handle errors from the readlink() system call in the fileio.c extension. Bug 2026-07-05T12:06:32Z (check-in: 85effd2ad3 ... user: drh tags: trunk)
18:28
Fix the parse_create_index() SQL function created by the incremental integrity_check extension so that it works for widely correct CREATE INDEX statements. Bug 2026-07-05T12:00:57Z. Also fix the extension so that it removes the parse_create_index() function. Add the sqlite3_intck_register() API function so that the parse_create_index() function can be more easily tested. (check-in: bd28985523 ... user: drh tags: trunk)
16:06
Be sure to invoke the authorizer callback on all terms of the USING clause in a RIGHT JOIN. Bug 2026-07-05T08:15:45Z (check-in: bbd69ce274 ... user: drh tags: trunk)
2026-07-04
15:09
Add the strdup() SQL function extension for use in testing. (check-in: 521a7cf844 ... user: drh tags: trunk)
12:16
The jsonSkipLabel() routine, part of json_each() and json_next(), should never return an index outside of the range of bytes of the input JSONB. (check-in: 4ccbd6042a ... user: drh tags: branch-3.53)
12:12
The jsonSkipLabel() routine, part of json_each() and json_next(), should never return an index outside of the range of bytes of the input JSONB. Bug 2026-07-04T04:58:54Z (check-in: 96072f5f87 ... user: drh tags: trunk)
09:28
Fix possible one-byte OOB read in the fossildelta.c extension. (check-in: 3d6c32fc07 ... user: drh tags: branch-3.53)
09:22
Fix possible one-byte OOB read in the fossildelta.c extension. Bug 2026-07-04T04:53:59Z (check-in: 8001a373d1 ... user: drh tags: trunk)
08:52
Fix possible 1-byte OOB read when decoding a malformed FLOAT5 element in JSONB. (check-in: a43c78f9f6 ... user: drh tags: branch-3.53)
08:48
Fix possible 1-byte OOB read when decoding a malformed FLOAT5 element in JSONB. Bug 2026-07-04T04:59:19Z (check-in: 6ed20ab693 ... user: drh tags: trunk)
2026-07-03
22:59
Improved data validation in fts5SecureDeleteOverflow(). (check-in: c87fc653b0 ... user: drh tags: branch-3.53)
20:26
Improved data validation in fts5SecureDeleteOverflow(). Bug 2026-07-03T19:16:18Z (check-in: bb1588f04a ... user: drh tags: trunk)
More ↓