This Day In History For 2025-05-31
1 Year Ago (more context)
|
2024-05-31
| ||
| 20:32 | Further tests for OR constraints on virtual tables. (check-in: ff4a30056f user: dan tags: xbestindex-or-terms) | |
| 19:26 | Better handle WHERE terms that are common to two or more OR branches when planning virtual table queries. (check-in: 4edd9b29f5 user: dan tags: xbestindex-or-terms) | |
| 15:39 | Do not even try star-schema detection if the join has fewer than 5 tables, since 5 is the minimum for a positive detection. (check-in: a07ec16bbc user: drh tags: trunk) | |
| 14:39 | Document the OP_Explain opcode. Add the WhereLoop.rRun value as P3 in OP_Explain opcodes associated with WhereLoops, for testing purposes. (check-in: 996c46e61d user: drh tags: trunk) | |
2 Years Ago (more context)
|
2023-05-31
| ||
| 18:52 | Add a comment to explain why both sides of an AND must be non-null-row in order for the overall expression to be non-null-row. No code changes. (check-in: 8396032ce1 user: drh tags: trunk) | |
| 18:35 | Improved detection of when the LEFT JOIN strength reduction optimization can be applied. (check-in: f544a8e47c user: drh tags: trunk) | |
| 12:42 | Minor enhancement to the sqlite3_trace_v2() documentation. No code changes. (check-in: fba97230e3 user: drh tags: trunk) | |
| 11:03 | Fix a problem causing an infinite loop in the recovery extension when processing a corrupt free-block list. (check-in: 5a516c6c7a user: dan tags: trunk) | |
3 Years Ago (more context)
|
2022-05-31
| ||
| 18:18 | New FULL JOIN test cases. No changes to code. (check-in: 13e89ef664 user: drh tags: trunk) | |
| 17:24 | More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb]. (check-in: f2d224c5fa user: drh tags: trunk) | |
| 15:18 | Fix an assert that is incorrect for a corrupt database. (check-in: fe0a840805 user: drh tags: trunk) | |
| 14:19 | Many new PG-confirmed test cases in joinD.test. (check-in: 481e89c764 user: drh tags: trunk) | |
| 11:22 | Restore an ON-clause test case (removed by [3869fd9a2b9483cb]) that turns out to be necessary for correct operation. Fix for forum post c2554d560bac97c5. (check-in: f407ec678f user: drh tags: trunk) | |
| 11:13 | Add back in a test case for ON-clauses that was removed yesterday by [3869fd9a2b9483cbf] but which turned out to be necessary after all. (Closed-Leaf check-in: aba52a90ee user: drh tags: right-join-bug-20220531) | |
| 10:48 | Add test cases for forum post c2554d560bac97c5. (check-in: e66d5ae86c user: drh tags: right-join-bug-20220531) | |
| 02:03 | Updated the wasm builds to generate gzip'ed copies of relevant files to take advantage of althttpd's new capability of substituting gzip files in place of requested files. This cuts over-the-wire size of the fiddle app by more than half. (check-in: 40925585f1 user: stephan tags: trunk) | |
15 Years Ago (more context)
|
2010-05-31
| ||
| 20:28 | Fix issues with locking_mode=EXCLUSIVE in WAL. (check-in: 8deba0cebd user: drh tags: wal-incr-ckpt) | |
| 18:24 | Add an "isInit" field in the wal-index header that must be non-zero for a valid header. Use this to detect an uninitialized wal-index. (check-in: a16fde1901 user: drh tags: wal-incr-ckpt) | |
| 16:56 | Fix an inconsistent #ifdef in wal.c. Fix os_unix.c so that it does not allow moving an SHM lock directly exclusive to shared without going through unlocked. (check-in: 552658da28 user: drh tags: wal-incr-ckpt) | |
| 16:41 | Avoid dropping the checkpoint lock after a recovery run as a precursor to a checkpoint operation. (check-in: cc25cfa046 user: dan tags: wal-incr-ckpt) | |
| 16:17 | Zero the checkpoint header as the last step of successful WAL recovery. Avoid an unnecessary lock/unlock in WalBeginReadTransaction. (check-in: db3509c55d user: dan tags: wal-incr-ckpt) | |
| 16:10 | Get the new xShmLock interface design working on os_win.c. (check-in: 149a7082e2 user: drh tags: wal-incr-ckpt) | |
| 14:39 | Make sure WAL alway requests enough shared-memory space. (check-in: 138f128317 user: drh tags: wal-incr-ckpt) | |
| 14:28 | Remove the tests that enable tracing based on the existance of the "vdbe_*" files when in SQLITE_DEBUG mode. (check-in: cdbb4e7ca7 user: drh tags: wal-incr-ckpt) | |
| 14:18 | Update another test case in wal.test. (check-in: 99fde69e61 user: dan tags: wal-incr-ckpt) | |
| 13:11 | Change WAL test cases to account for the improved concurrency in the new checkpoint logic. (check-in: 2d6f248505 user: drh tags: wal-incr-ckpt) | |
| 12:30 | Do not fail a checkpoint just because active readers prevent backfill. (check-in: 9aa4243e0c user: drh tags: wal-incr-ckpt) | |
| 12:15 | Add WALTRACE() macros to help with debugging and analysis. (check-in: 765c33181a user: drh tags: wal-incr-ckpt) | |
| 12:02 | Another minor fix to checkpoint on the WAL branch. (check-in: 853f1e3f77 user: dan tags: wal-incr-ckpt) | |
| 11:39 | Fix a bug in checkpoint introduced by [181ceb32ea]. (check-in: b499dbc88a user: dan tags: wal-incr-ckpt) | |
| 11:16 | Fix some asserts and other things in the new WAL branch. (check-in: 181ceb32ea user: dan tags: wal-incr-ckpt) | |
| 06:38 | Changes to the way one of the WAL/OOM tests works. (check-in: 15abbc3416 user: dan tags: trunk) | |
| 01:41 | WAL runs but quickly deadlocks. (check-in: ace58acbf1 user: drh tags: wal-incr-ckpt) | |
25 Years Ago (more context)
|
2000-05-31
| ||
| 23:33 | :-) (CVS 30) (check-in: 9b8458bbce user: drh tags: trunk) | |
| 22:58 | :-) (CVS 29) (check-in: 09054df318 user: drh tags: trunk) | |
| 21:06 | :-) (CVS 28) (check-in: 57c5add197 user: drh tags: trunk) | |
| 20:00 | added DISTINCT on select (CVS 27) (check-in: 1f0c4ffd98 user: drh tags: trunk) | |
| 18:33 | :-) (CVS 26) (check-in: 0b7d9eb8ad user: drh tags: trunk) | |
| 18:20 | :-) (CVS 25) (check-in: 35a8f523e8 user: drh tags: trunk) | |
| 17:59 | :-) (CVS 24) (check-in: 4cd98ebaea user: drh tags: trunk) | |
| 15:43 | :-) (CVS 23) (check-in: 0b040cea57 user: drh tags: trunk) | |
| 15:35 | :-) (CVS 22) (check-in: d33ad08e0d user: drh tags: trunk) | |
| 15:34 | added aggregate functions like count(*) (CVS 21) (check-in: dee7a8be88 user: drh tags: trunk) | |
| 02:27 | :-) (CVS 20) (check-in: 01d85b35e9 user: drh tags: trunk) | |