50 most recent check-ins
|
2026-09-12
| ||
| 11:12 | When looking up a text key in a temporary index, use the fast memcmp-based comparison if the index uses the built-in BINARY collation. Indexes in the schema already got this fast path because they record BINARY as a NULL collation pointer. (leaf check-in: f065790f59 ... user: drh tags: trunk) | |
| 10:43 | Configure-script patches from forum post fe9e99eb27c8 to address cygwin/msys cross-compilation issues related to --with-tcl and --with-tclsh. Stashing in a branch pending testing on those platorms. It does not adversely affect any native-build systems tested so far. (leaf check-in: 4470bed69b ... user: stephan tags: cygwin-msys-tclsh-forum-fe9e99eb) | |
|
2026-09-11
| ||
| 22:11 | When looking up a text key in a temporary index, use the fast memcmp-based comparison if the index uses the built-in BINARY collation. Indexes in the schema already got this fast path because they record BINARY as a NULL collation pointer. (closed check-in: ebb4534bc8 ... user: jeffchen tags: binary-collseq-fastpath) | |
|
2026-09-10
| ||
| 23:54 | Do not discard INDEXED BY or NOT INDEXED from a parenthesized term of the FROM clause. Bug 2026-09-10T20:38:13Z. (check-in: e308b0fce4 ... user: drh tags: trunk) | |
| 20:10 | In PRAGMA integrity_check, double the space available for checking that every byte of a page is used only once as a safety margin to deal with unforeseen kinds of database corruption. (leaf check-in: f28d770d87 ... user: drh tags: branch-3.53) | |
| 20:04 | In PRAGMA integrity_check, double the space available for checking that every byte of a page is used only once as a safety margin to deal with unforeseen kinds of database corruption. (check-in: 0c173d54b1 ... user: drh tags: trunk) | |
| 10:25 | The value returned by json_each.root should be SQLITE_TRANSIENT, not SQLITE_STATIC. (check-in: 65a1a91388 ... user: drh tags: branch-3.53) | |
| 10:20 | The value returned by json_each.root should be SQLITE_TRANSIENT, not SQLITE_STATIC. (check-in: 1d9bd6c8a2 ... user: drh tags: trunk) | |
|
2026-09-09
| ||
| 13:49 | Fix minor issues with the delta_parse() table-valued function in the fossildelta.c extension. Add test cases for the fossildelta.c extension. Bug 2026-09-09T10:29:35Z and Bug 2026-09-09T10:55:54Z. (check-in: 737ab94632 ... user: drh tags: trunk) | |
|
2026-09-05
| ||
| 14:50 | Merge the latest trunk changes into the begin-concurrent branch. (leaf check-in: 7701fc5cba ... user: drh tags: begin-concurrent) | |
|
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. (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) | |
