SQLite

Timeline
Login

50 most recent check-ins

2026-09-04
14:20
For "make test" on Windows, the --stop-on-error option is used for testrunner.tcl, which causes processing to do an orderly shutdown if any individual test module fails. (leaf check-in: 4021369bc9 ... user: drh tags: trunk)
14:02
Improved orderly-shutdown in testrunner. Windows lets running jobs complete. Unix just invokes exit and lets the OS deal with cleaning up the mess. (closed check-in: ce822e8dc1 ... user: drh tags: windows-testing)
13:43
Remove an intentional error used for testing that was accidently left in the previous check-in. (check-in: 87f9d70d9e ... user: drh tags: windows-testing)
13:37
The testrunner.tcl script is enhanced so that --stop-on-error does not exit immediately, but instead marks all pending tasks as "halt" so that no new tasks are scheduled, but allows "running" tasks to continue on to completion, as an immediate halt can cause hung processes on Windows. Also, in Makefile.msc, the "test" target now includes --stop-on-error. (check-in: 0fba9b52b4 ... user: drh tags: windows-testing)
12:39
Fix the GetDiskTypeW() call in the previous check-in so that it works on x32. (check-in: ae1650228d ... user: drh tags: trunk)
2026-09-03
19:56
On Windows, use the GetDriveTypeW() interface to detect network filesystems and always use a single shared file handle for the -shm files on such filesystems. (check-in: 52ed3b490a ... user: drh tags: trunk)
18:37
Enhance the WAL checkpoint algorithm to run faster and use less memory if the WAL file is larger than the database file. (check-in: 630ab4b6bd ... user: drh tags: trunk)
18:26
Improve the documentation of the WalIterator object and the new pagemap algorithm. Remove one unnecessary conditional. (closed check-in: f690f5b148 ... user: drh tags: pagemap-checkpoint)
16:37
Fix a bug in fts5 test code function fts5TestUtf8(). Report 2026-09-03T14:51:50Z. (check-in: ac094ec69b ... user: dan tags: trunk)
16:32
Omit a minro optimization that fails in two ways: (1) it does not actually make the code run any faster, and (2) it allows an incorrect type coercion on a GROUP BY query where there is a subquery as one of the result set columns. Bug 2026-09-03T02:29:56Z. (check-in: 5d9e5cddec ... user: drh tags: trunk)
14:45
When checkpointing, use a mapping from pgno to frame instead of the sorted list of frame/pgno pairs in cases where this will use less memory. (check-in: ec3d33931b ... user: dan tags: pagemap-checkpoint)
13:14
Remove a residual "win_unc_locking" detail from the testrunner logic. (closed check-in: b52b77d404 ... user: drh tags: win-shared-shm)
13:11
On windows, multiple open connections to a WAL-mode database from a single process now share the same file handle for the *-shm file. (check-in: e9da3cfb8d ... user: drh tags: win-shared-shm)
2026-09-02
12:39
When -DSQLITE_DEBUG or -DSQLITE_ENABLE_WALSTAT is used, provide the sqlite_walstat() SQL function that provides state information about the WAL subsystem. Used for debugging only. Function subject to change or removal. (check-in: 789d84e691 ... user: drh tags: trunk)
2026-09-01
17:50
Cygwin portability patches from Jan Nijtmans. (check-in: c76e64373c ... user: stephan tags: trunk)
17:44
Within a checkpoint, avoid allocating memory for *-shm pages that will not be processed as they have already been completely checkpointed. (check-in: 53a9312cc9 ... user: dan tags: trunk)
16:26
Cygwin portability patches sent off-list from from Jan Nijtmans. (closed check-in: f8306cd54d ... user: stephan tags: cygwin-portability)
12:36
Make sure the extra sorting cursor used by SQLITE_ENABLE_SORTER_REFERENCES is initialized even if the corresponding table is empty. Bug 2026-09-01T01:34:02Z (check-in: a418005ba5 ... user: drh tags: trunk)
2026-08-31
20:43
Update the authorizer action code documentation to make it clear that string arguments to the authorizer callback can be in an arbitrary case. (check-in: 6f73383647 ... user: drh tags: trunk)
18:15
Fix a false-positive SQLITE_CORRUPT error that could occur with an incremental vacuum database if many tables were created and dropped within a single wal-mode transaction. (check-in: f847298c8d ... user: dan tags: trunk)
15:18
Fix a harmless compiler warning. (check-in: 40530cf21d ... user: drh tags: trunk)
15:02
Return an error if the arguments of a table-valued function that is on the left of a RIGHT JOIN depend on tables to the right of it in the FROM clause. Report 2026-08-31T08:07:08Z. (check-in: 43c8d7c41c ... user: dan tags: trunk)
11:04
Fix a bad interaction between the skip-ahead DISTINCT optimization and "ORDER BY ... NULLS FIRST/LAST" clauses. Report 2026-08-30T23:22:05Z. (check-in: 7bfd3d6f80 ... user: dan tags: trunk)
09:48
In Lemon, remove the option to omit compression of the action table. (check-in: 9b75f0c346 ... user: drh tags: trunk)
2026-08-29
20:27
Follow-up to check-in [2cb349e5b02aa549] to help indexes on negative DEFAULT integer values get stored more efficiently. (check-in: c77ff6089d ... user: drh tags: trunk)
19:51
Remove a redundant OP_RealAffinity inserted by recent changes to sqlite3ColumnDefault(). (check-in: c7a987a4f7 ... user: drh tags: trunk)
18:39
Fix the CLI so that it does not capture ".echo" output as part of the result of a ".testcase"...".check". (check-in: 33322913a8 ... user: drh tags: trunk)
16:26
Ensure that ALTER TABLE ADD COLUMN has zero return columns, even when altering a STRICT table. Test case in TH3. (check-in: 778e2bb9a6 ... user: drh tags: trunk)
13:42
Fix harmless comment typo. (check-in: 66f608ceca ... user: drh tags: trunk)
2026-08-27
18:07
Fix a case in the fts5 matchinfo() demo function causing it to return the wrong error code. (check-in: 5251f4d707 ... user: dan tags: trunk)
14:26
Built-in SQL function oom() invokes sqlite3OomFault() and then returns NULL, but only if compiled with SQLITE_DEBUG or SQLITE_BUILTIN_OOM_FUNCTION. (check-in: 90dfac7f27 ... user: drh tags: trunk)
10:58
Fix a C90-compliance issue in the CLI. (check-in: 555f31c64d ... user: drh tags: trunk)
10:31
Enhance the authorizer so that it invokes the callback for the use of SQL functions in the DEFAULT clause of a CREATE TABLE. It does this both with the CREATE TABLE statement is first used, and whenever the DEFAULT expression is used, but not when the schema is being reparsed. (check-in: 4b30d1d7e2 ... user: drh tags: trunk)
10:16
Update a stale comment. Fix minor #ifdef issues. (closed check-in: 2959ec249b ... user: drh tags: authorize-default)
10:01
Fix the ext/misc/compress.c extension such that it compiles independently of the CLI. (check-in: 4cd5ecc5b3 ... user: drh tags: trunk)
09:44
Minor enhancements to the built-in ".mode" documentation in the CLI. (check-in: b3a034a82d ... user: drh tags: trunk)
01:42
Performance optimizations and code simplifications. (check-in: cbf2e796e0 ... user: drh tags: authorize-default)
2026-08-26
21:04
Split the sqlite3ColumnExpr() routine out into two routines, one that works as before and the second sqlite3ColumnExprAuth() to deal with the authenticator in places where that is needed. (check-in: 51a1149bdc ... user: drh tags: authorize-default)
19:37
An attempt to make the authorizer effective at preventing the use of some functions within the DEFAULT clause of a table. (check-in: 321e41b091 ... user: drh tags: authorize-default)
18:21
Add the --deny and --ignore options to the ".auth" command in the CLI. (check-in: da1e7d73c6 ... user: drh tags: trunk)
15:23
The sqlite3ExprListIsConstant() routine probably should not return true if the list contains a function like random(). Fixed here. Simplify the logic used to test if expressions are constant. (check-in: 753f42a092 ... user: drh tags: trunk)
12:31
Enhance the tmstmpvfs.c extension so that it tags zero pages in the log file. (check-in: e9d649b77b ... user: drh tags: trunk)
2026-08-25
18:40
Improved handling of OOM conditions in the sessions extension. Bug 2026-08-25T17:04:14Z. (check-in: ce2aa9f849 ... user: drh tags: trunk)
18:28
Add assert() statements and comments to explain why the return value of sqlite3_column_name() does not need to be checked in fts3.c. Repor 2026-08-25T17:08:22Z. (check-in: 08b34b1656 ... user: dan tags: trunk)
18:26
Avoid a possible NULL pointer dereference in the QRF sublibrary when compiled with SQLITE_ENABLE_STMT_SCANSTATUS. (check-in: 58014b2a2e ... user: drh tags: trunk)
18:16
Improved handling of OOM errors in the Windows implementation of the sqlite3_stdio.c extension. Bug 2026-08-25T16:55:53Z. (check-in: 555489e4c2 ... user: drh tags: trunk)
17:59
Prevent some potential NULL pointer deferences following misuse of the non-standard amatch extension. Bug 2026-08-25T16:47:32Z. (check-in: 99b69371a1 ... user: drh tags: trunk)
17:12
New optimizations for improved performance of UNION with LIMIT 1, with or without ORDER BY. (check-in: b5b8ede613 ... user: drh tags: trunk)
17:08
Fix two test cases that do not work when optimizations are disabled. (closed check-in: e78b72fadf ... user: drh tags: union-to-union-all)
16:29
Make the optimization of UNION with ORDER BY and LIMIT sound by restricing it to LIMIT 1. (check-in: 7e6e665d05 ... user: drh tags: union-to-union-all)
More ↓