Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
|
2026-02-11
| ||
| 19:42 | Minor performance enhancement to floating-point rendering. (leaf check-in: 38d8c0d8a0 ... user: drh tags: fp-perf) | |
|
2026-02-10
| ||
| 19:33 | Correction to date/time computations associated with the timestamp-vfs. (leaf check-in: b67889e4f1 ... user: drh tags: trunk) | |
| 18:28 | Minor tweaks to the star-query optimization in the query planner. (check-in: 5021e114b2 ... user: drh tags: trunk) | |
|
2026-02-09
| ||
| 19:58 | Immediately reset all pending prepared statements on any call to sqlite3_set_authorizer(), even if the authorizer is being disabled. (check-in: 5c0468acd1 ... user: drh tags: trunk) | |
| 14:45 | Do not allow table-function argument expressions on the RHS of an OUTER join to refer to FROM clause elements to their right. (check-in: 021e48e289 ... user: dan tags: trunk) | |
|
2026-02-08
| ||
| 12:13 | Fix a method name typo in test-only code which could hide the triggering error condition. (check-in: b2c1a4184c ... user: stephan tags: trunk) | |
| 05:08 | JS doc touchups. (check-in: dcd22fd6d1 ... user: stephan tags: trunk) | |
|
2026-02-07
| ||
| 13:41 | Improved output from calls to sqlite3ShowSrcList() made from a symbolic debugger. (check-in: 241d23f8d3 ... user: drh tags: trunk) | |
|
2026-02-05
| ||
| 21:14 | Do a better job of not generating unnecessary Bloom filters associated with IN operators. (check-in: 3861df5c12 ... user: drh tags: trunk) | |
| 13:03 | Fix harmless compiler warning when the CLI is compiled with SQLITE_OMIT_PROGRESS_CALLBACK. (check-in: d6150c813c ... user: drh tags: trunk) | |
|
2026-02-04
| ||
| 20:51 | Display scanstatus results in neat columns. (check-in: c476d956d0 ... user: drh tags: trunk) | |
| 18:10 | Improved output for ".scanstatus est" in the CLI. (check-in: e6902937ec ... user: drh tags: trunk) | |
| 17:52 | Improved display of scan-status estimates. (closed check-in: 70ef095740 ... user: drh tags: scanstatus-improvements) | |
| 13:35 | Render scan-status values with 3 or 4 significant digits only, for improved readability. (check-in: d9102ff0c4 ... user: drh tags: scanstatus-improvements) | |
| 11:51 | Fix scanstatus output in QRF so that it shows the total number of cycles on the "QUERY PLAN" line. (check-in: 611cef0ec2 ... user: drh tags: scanstatus-improvements) | |
|
2026-02-03
| ||
| 17:21 | Improve the query planner by reducing the estimated number of output rows for each stage of a join if there are LIKE, GLOB, REGEXP, or MATCH constraints on the table where the pattern string is a constant. The reduction in the output row estimate is proportional to the length of the pattern string. (check-in: 6852843e6a ... user: drh tags: trunk) | |
| 17:07 | Minor change to test/dotcmd01.test so that it works with STAT4. (check-in: 8aaf5b6b6c ... user: drh tags: trunk) | |
| 16:29 | Improved comments on this enhancement. No code changes. (closed check-in: 510a6738e5 ... user: drh tags: prune-by-like-glob) | |
| 14:00 | Refactor the implementation of this enhancement to keep all the code inside the query planner, not leaking out into SQL function implementations. Expand the enhancement to cover MATCH and REGEXP operators and overloads of LIKE and GLOB. (check-in: 96f8ce225e ... user: drh tags: prune-by-like-glob) | |
|
2026-02-02
| ||
| 20:54 | When reducing the truth probability of a LIKE/GLOB constraint, only consider non-wildcard characters in the pattern. (check-in: 2ba8fc290d ... user: drh tags: prune-by-like-glob) | |
| 16:03 | Do not reduce the estimated truth probability of LIKE and GLOB operators by quite so much. Fix a single test case whose output changed. (check-in: fdebbedbd9 ... user: drh tags: prune-by-like-glob) | |
| 14:24 | Merge the latest trunk enhancements into the prune-by-like-glob branch. (check-in: d9d3d3a807 ... user: drh tags: prune-by-like-glob) | |
| 11:42 | Update session module test code to correctly use Tcl_Size instead of int. (check-in: 619060c226 ... user: dan tags: trunk) | |
|
2026-02-01
| ||
| 21:10 | Add the "--timeout SECONDS" option to the ".progress" command in the CLI. (check-in: 8eb5c88aeb ... user: drh tags: trunk) | |
| 15:58 | Enhance the ".timer" command in the CLI to accept the "once" argument, and so that it leaves its last real-time result in the $TIMER variable. Also fix a harmless warning from an earlier check-in. (check-in: 8ad7dffc26 ... user: drh tags: trunk) | |
| 00:37 | An experimental query-planner change that reduces the estimated number of output rows for FROM clause terms that are restricted by a LIKE or GLOB operator, based on the number of bytes in the pattern. The idea is that longer patterns will match fewer records and hence should reduce the estimated output count. The implementation is not workable as it stands now. This is just a crazy idea, saved for future reference. (check-in: 97bcb56a20 ... user: drh tags: prune-by-like-glob) | |
|
2026-01-31
| ||
| 02:17 | Fix a missed optimization opportunity due to a typo in check-in [898bfa1afd8260ea]. Reported by forum post 2026-01-31T00:49:53z. (check-in: 3a4f9a323d ... user: drh tags: trunk) | |
|
2026-01-30
| ||
| 17:10 | Make CROSS JOIN a join reorder barrier again, as the SQLite documentation says it is. It mistakenly stopped being a join barrier with check-in [c1ea064948ba08c4]. (check-in: d294106ecb ... user: drh tags: trunk) | |
| 16:03 | Fix the new CLI so that the ".eqp" setting does not affect the output of other dot commands such as .schema or .tables. (check-in: a5a1b69b3f ... user: drh tags: trunk) | |
| 13:11 | Change the new escape-character mechanism for CSV import so that there are separate options for an escape character for quoted and unquoted fields of the CSV. (check-in: 293ec20e29 ... user: drh tags: trunk) | |
| 12:27 | Undo the previous check-in. In its place, add the --escape option to the ".import" command. (check-in: f11a05d52a ... user: drh tags: trunk) | |
| 12:15 | Enhance the CSV import capability in the CLI so that it understands backslash-escaped double-quotes. (check-in: 7ba0594d3c ... user: drh tags: trunk) | |
| 06:37 | kvvfs fix for npm ticket #146: use of a test-mode-only symbol in non-test runs leads to a null deref in xFileControl(). (check-in: 407724c4e8 ... user: stephan tags: trunk) | |
|
2026-01-28
| ||
| 17:25 | Capture sqlite3_rsync's remote-end result code so the local side can exit with non-0 if, e.g., the remote sqlite3_rsync binary is found but fails to start. Confirmation received that it resolves the motivating problem report. (check-in: 971d51374e ... user: stephan tags: trunk) | |
| 16:59 | Improved (faster) bytecode for the merge algorithm. (check-in: 0b7f4b97e6 ... user: drh tags: trunk) | |
| 10:52 | Add a comment to sqlite3Stat4Value() explaining that it read a few bytes past the end of the specified buffer. (check-in: b95644eafd ... user: dan tags: trunk) | |
|
2026-01-27
| ||
| 23:33 | Avoid unsigned integer overflow when evaluating an array index in a JSON path expression. Forum post 2026-01-27T14:18:49z. (check-in: 631c8d44cd ... user: drh tags: trunk) | |
| 22:27 | Improved byte-code coverage testing verification in the merge algorithm. (check-in: e49ec0e24b ... user: drh tags: trunk) | |
| 16:18 | The tmstmpvfs.c extension should not modify the content of pages going into the WAL file, as that would corrupt the page checksum used for recovery. Instead, only insert timestamp information as content is written into the database file. (check-in: dabaeeb1da ... user: drh tags: trunk) | |
| 16:15 | Teach sqlite3_rsync to increment its error count when a child process fails, based on forum post 8fe404e547faa42e. This passes basic sanity tests but requires more testing and needs a review of the final 'else' block in the new code. (closed check-in: 8be55d405f ... user: stephan tags: rsync-child-rc) | |
| 14:59 | For CSV import in the CLI, when the table is created automatically because it does not previously exist, make the column types "ANY" instead of "TEXT" so that they will automatically adjust to different datatypes in the input text. (check-in: aff74e71ea ... user: drh tags: trunk) | |
| 14:27 | Add the --csv option to the showtmlog utility program. (check-in: 2e96e8efa9 ... user: drh tags: trunk) | |
| 14:00 | Fix trivial buffer overreads in the sessions module that could occur when parsing changeset blobs. (check-in: 661878a628 ... user: dan tags: trunk) | |
| 12:50 | Additional usage notes added to the header comment of the tmstmpvfs.c source file. No code changes. (check-in: d1b8e7740b ... user: drh tags: trunk) | |
| 12:02 | Enhanced documentation in the header comment of tmstmpvfs.c. (check-in: 3d37da3cb5 ... user: drh tags: trunk) | |
| 11:19 | Fix frame number computation in the log generated by tmstmpvfs.c. (check-in: 57fda9dd85 ... user: drh tags: trunk) | |
|
2026-01-26
| ||
| 21:20 | Enhancements to tmstmpvfs.c: (1) Use the exact same timestamp on logfile entries as on the pages that control, where appropriate. (2) Include the WAL frame number in ELOG_CKPT_PAGE logfile entries. (check-in: fcf1629785 ... user: drh tags: trunk) | |
| 20:17 | Add test for fts3 compress= and uncompress= options. (check-in: bace9de67d ... user: dan tags: trunk) | |
| 19:37 | Improve the comments on the generated byte-code for the merge algorithm. (check-in: 4468c9e1a2 ... user: drh tags: trunk) | |
| 13:54 | Fix the initialization of the sqlite3Api[] constant to conform with the previous check-in. (check-in: 0a31a74084 ... user: drh tags: trunk) | |