Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
39 events for week 2024-08 beginning on 2024-02-26
Following week ↑|
2024-02-25
| ||
| 21:30 | Make sure key comprisons are done correctly if the index key contains NaN values that have not been shifted into NULLs. That can only happen due to database corruption, but we need to deal with it nevertheless. (check-in: 7e4c743f user: drh tags: trunk) | |
|
2024-02-24
| ||
| 19:58 | Add two GIFs that contain the feather logo. (check-in: 5f21e6a8 user: drh tags: trunk) | |
| 16:26 | Add further tests for the intck module. (check-in: c253e276 user: dan tags: incr-integrity-check) | |
|
2024-02-23
| ||
| 20:51 | Add tests for the new code on this branch. (check-in: 351d46b2 user: dan tags: incr-integrity-check) | |
| 18:21 | Add the ".intck ?STEPS_PER_UNLOCK?" command to the shell tool. (check-in: cfd05183 user: dan tags: incr-integrity-check) | |
| 18:02 | Typo fixes reported in the forum. No code changes. (check-in: 67d8bae0 user: stephan tags: trunk) | |
| 17:10 | Fix detection of surplus index entries when all indexed fields are NULL. (check-in: 5f310fb7 user: dan tags: incr-integrity-check) | |
| 15:13 | Fix problems with resuming integrity-check operations on indexes with mixed ASC and DESC columns, and on indexes that contain NULL values. (check-in: 0f68b35a user: dan tags: incr-integrity-check) | |
|
2024-02-22
| ||
| 18:15 | Fix harmless compiler warning seen with MSVC. (check-in: e5db0899 user: mistachkin tags: trunk) | |
| 00:50 | Fix debugging code so that it compiles on MSVC. (check-in: ce5df19d user: drh tags: trunk) | |
|
2024-02-21
| ||
| 20:58 | Fix various issues in sqlite3intck.c. (check-in: 8a7bfa74 user: dan tags: incr-integrity-check) | |
| 20:21 | Fix typo in comment. Fossil forum post cc20266bf2. (check-in: 7e3c46ee user: drh tags: trunk) | |
| 19:31 | Simplify the way the restart key is saved internally by the intck extension. (check-in: 0e39962b user: dan tags: incr-integrity-check) | |
| 19:17 | Add documentation to ext/intck/sqlite3intck.h. (check-in: 4cc19bd7 user: dan tags: incr-integrity-check) | |
| 16:15 | Ensure intck tests are run by testrunner.tcl. (check-in: 11d6816c user: dan tags: incr-integrity-check) | |
| 16:12 | Merge trunk changes into this branch. (check-in: 63e8846a user: dan tags: incr-integrity-check) | |
|
2024-02-20
| ||
| 20:18 | Have the intck extension better handle corruption at the b-tree layer. (check-in: ecd775d1 user: dan tags: incr-integrity-check) | |
| 18:17 | Use fewer cycles to generate the "next key" value used by sqlite3_intck_suspend() function in the intck extension. (check-in: 95f01426 user: dan tags: incr-integrity-check) | |
| 16:04 | Consider using "=" and IS operators with even low-quality indexes in cases where they are selected explicitly using an INDEXED BY clause. (check-in: 43cbbea8 user: dan tags: incr-integrity-check) | |
| 15:38 | Fixes to comments associated with the recent PRAGMA optimize enhancements. No changes to code. (check-in: 27a2113d user: drh tags: trunk) | |
| 13:11 | Remove an unreachable branch from printf(). Change it into an assert(). (check-in: 4c9886b6 user: drh tags: trunk) | |
| 13:10 | Remove an unused variable from the merge in the previous check-in. (check-in: 5c26bf37 user: drh tags: trunk) | |
| 12:48 | Enhancements to PRAGMA optimize and ANALYZE. Add the 0x10000 flag to PRAGMA optimize. ANALYZE now records zero-size partial indexes in the sqlite_stat1 table. PRAGMA optimize looks for both growth and shrinkage in table sizes, and uses tighter bounds (10x rather than 25x) to trigger a re-analyze. PRAGMA optimize automatically uses are reasonable analysis_limit to prevent excessive runtimes. (check-in: 63ef234e user: drh tags: trunk) | |
| 12:14 | Another simplification of the PRAGMA optimize logic for improved coverage. (Closed-Leaf check-in: 6c5a0c85 user: drh tags: better-pragma-optimize) | |
|
2024-02-19
| ||
| 23:58 | Minor fixes. (check-in: ed5afebc user: drh tags: better-pragma-optimize) | |
| 20:47 | Fix a minor hiccup in the computation of the number of btrees to be scanned. (check-in: 91302d9b user: drh tags: better-pragma-optimize) | |
| 20:15 | Use more efficient SQL to verify that indexes contain entries that match their tables. (check-in: c01e008c user: dan tags: incr-integrity-check) | |
| 20:12 | If there is no mention of a table in sqlite_stat1, use OP_Rewind to see if the table is empty prior to invoking ANALYZE. (check-in: 0cc93b19 user: drh tags: better-pragma-optimize) | |
| 19:56 | In PRAGMA optimize, scale back the analysis_limit when many different tables and indexes must be scanned. (check-in: 63661535 user: drh tags: better-pragma-optimize) | |
| 18:57 | • Edit [2cf78a5b5fce7f2d|2cf78a5b]: Edit check-in comment. (artifact: ea748af2 user: drh) | |
| 18:57 | • Edit [40532ffba91cf332|40532ffb]: Move to branch better-pragma-optimize. (artifact: 09c8e3a0 user: drh) | |
| 18:55 | Merge trunk fixes into the better-pragma-optimize branch. (check-in: 2cf78a5b user: drh tags: better-pragma-optimize) | |
| 18:55 | • Edit [40532ffba91cf332|40532ffb]: Move to branch better-optimize. (artifact: 4d0599e1 user: drh) | |
| 18:03 | Add implementation of sqlite3_intck_suspend(). (check-in: c36ada86 user: dan tags: incr-integrity-check) | |
| 16:22 | If a table has one or more rows and it has a partial index has zero rows, still make an entry in the sqlite_stat1 table for the partial index, so that we know that "PRAGMA optimize" does not need to redo the whole table. (check-in: e147b189 user: drh tags: better-pragma-optimize) | |
| 13:50 | Simplifications to PRAGMA optimize to make it easier to use. It always tries to ANALYZE unanalyzed indexes. The 0x10000 flag just makes it check for size changes in all tables. (check-in: 44ed7f4c user: drh tags: better-pragma-optimize) | |
| 13:06 | Change the 0x20000 bit (use analysis limit) to 0x10, meaning that this feature is on by default. The default analysis limit is changed to 2000 which is almost always sufficient for accurate analysis results. (check-in: 4abd47b5 user: drh tags: better-pragma-optimize) | |
| 12:28 | • Edit [f18b2524da6bbbcf|f18b2524]: Edit check-in comment. (artifact: f9d91f4b user: stephan) | |
| 12:20 | Extend the strerror_r() result type discrepancy check in os_unix.c to include the Android NDK, as reported in forum post 3f13857fa4062301. The NDK's strerror_r() signature is version-dependent, whereas this change assumes int return (POSIX semantic) across all versions. (check-in: f18b2524 user: stephan tags: trunk) | |