This Day In History For 2025-06-08
1 Year Ago (more context)
|
2024-06-08
| ||
| 18:13 | Add extra tests for the changes on this branch. (check-in: a6365c778f user: dan tags: exists-to-join) | |
2 Years Ago (more context)
|
2023-06-08
| ||
| 20:49 | Remove SQLITE_EXTENSION_INIT macros from dbdata.c. (check-in: 106ec74576 user: dan tags: trunk) | |
| 16:19 | Improvements to the src-verify.c utility program so that it continues to muddle through a corrupt manifest file, making the most sense of it that it can and reporting "manifest" has having changed at the end. (check-in: 157b5d25e0 user: drh tags: trunk) | |
| 15:30 | Fix the amagamation generator so that it works one a clean source tree. (check-in: f502610d03 user: drh tags: trunk) | |
| 15:27 | Include source provenance in the header comment of the amalgamation. (check-in: e3eb5af905 user: drh tags: trunk) | |
| 12:52 | Enhance Lemon so that it remembers which -D command-line options are actually used in the grammar and includes a list of all such options in the header of the generated output file. (check-in: c47a4dbd24 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-06-08
| ||
| 18:29 | Move an #ifdef in shell.c to avoid a harmless "unused function" compiler warning. (check-in: 5abb5ef500 user: drh tags: trunk) | |
| 18:20 | Avoid zeroing the value returned by sqlite3_changes() when a DML statement is automatically reprepared in sqlite3_step(). (check-in: 09c8f9f197 user: dan tags: trunk) | |
| 17:48 | Improved comments on the new query flattener restriction of the previous check-in. Also a NEVER() macro on an unreachable branch. (check-in: 8c9e2d6315 user: drh tags: trunk) | |
| 15:38 | Fix the query flattener so that it refuses a flattening that might leave both an inner-join and outer-join ON-clause constraint (or equivalent) on the same term of the FROM clause. (check-in: f6c4fb48b6 user: drh tags: trunk) | |
| 15:30 | Add restriction (29) to the query flattener - do not allow flattening that would leave both EP_InnerON and EP_OuterON constraints on the same join term. (Leaf check-in: c585d6a467 user: drh tags: right-join-query-flattener) | |
| 13:13 | New test cases refute check-in [3f45007d544e5f78]. (check-in: 12d3c96c39 user: drh tags: right-join-query-flattener) | |
| 12:46 | Do not allow a partial index scan on the left table of a RIGHT JOIN, because since the index is partial, some rows will be omitted from the scan, and those rows will subsequently be picked up by the no-match logic in the right-join post-processing loop. forum post c4676c4956. (check-in: 615c002611 user: drh tags: trunk) | |
| 12:35 | Minor fix to test/index9.test so that it can be invoked with other index tests using a wildcard. (check-in: ccbd6e7749 user: drh tags: trunk) | |
| 12:20 | Update the routine that determines whether or not a partial index can be used so that it is not specific to LEFT JOIN. (check-in: 5a107fd7fa user: drh tags: trunk) | |
4 Years Ago (more context)
|
2021-06-08
| ||
| 23:46 | Remove two assert()s in FTS5 that checks for database corruption right before actual code does the same check. dbsqlfuzz 9680db8f5338cb9b6060eb3a02d984555d4472e3. (check-in: f3f82967b2 user: drh tags: trunk) | |
| 17:56 | Try to avoid a double-free in the showdb utility program when running pgidx on a corrupt database. See forum post a60ea5a4d4 for context (check-in: e3188a8663 user: drh tags: trunk) | |
| 12:22 | Add an assert() to prevent the value of the SQLITE_VTABRISK macros from being changed in a way that would break logic. (check-in: 33babdb582 user: drh tags: trunk) | |
| 12:15 | Avoid a buffer overread in fts3 that could occur when handling corrupt data structures. (check-in: 45f459d2fa user: dan tags: trunk) | |
5 Years Ago (more context)
|
2020-06-08
| ||
| 20:26 | • New ticket [7c6d876f84] Use after free in resetAccumulator.. (artifact: c4f17a319f user: yongheng) | |
| 14:43 | Fix a case where a corrupted fts3 record could cause an assert() failure, or spurious SQLITE_NOMEM error in builds with assert() disabled. (check-in: d48af4d2cf user: dan tags: trunk) | |
| 12:51 | Increase the version number to 3.32.3. (check-in: a376ec6942 user: drh tags: branch-3.32) | |
| 12:49 | When an Expr object is changed and that Expr is referenced by an AggInfo, then also update the AggInfo. Also, persist all AggInfo objects until the Parse object is destroyed. This is a new fix for ticket [c8d3b9f0a750a529]. (check-in: 44a58d6cb1 user: drh tags: branch-3.32) | |
| 11:38 | • Closed ticket [f7d890858f]: Segfault in moveToRoot plus 6 other changes (artifact: 41c2d826a6 user: drh) | |
| 11:34 | When an Expr object is changed and that Expr is referenced by an AggInfo, then also update the AggInfo. Also, persist all AggInfo objects until the Parse object is destroyed. This is a new fix for ticket [c8d3b9f0a750a529] that avoids the follow-on problems identified by tickets [0899cf62f597d7e7], [1f6f353b684fc708], [e5504e987e419fb0], and [f7d890858f361402]. (check-in: 6e6b3729e0 user: drh tags: trunk) | |
| 11:14 | • Edit [79eff1d0383179c4|79eff1d038]: Move to branch branch-3.32-early-winfunc-rewrite. (artifact: 6f26ffd90a user: drh) | |
| 11:13 | • Edit [0b42a2277e5bf527|0b42a2277e]: Move to branch early-winfunc-rewrite-dev. (artifact: 221d97d0e1 user: drh) | |
10 Years Ago (more context)
|
2015-06-08
| ||
| 22:59 | Code refactoring to try to shift FROM-clause subquery manifesting until after the query planner runs. Except this does not currently work because the query planner needs an estimated of the number of rows in the manifested table. Work in progress. (check-in: cabf218716 user: drh tags: view-optimization) | |
| 19:15 | Add the valgrindfuzz target to unix makefile. (check-in: e62aed01f1 user: drh tags: trunk) | |
| 18:48 | If a query contains "FROM t1 LEFT JOIN t2, t3, t4", ensure that tables t3 and t4 are not scanned before t2. The trunk already does this. (check-in: 0d9edfab9f user: dan tags: vtab-left-join) | |
| 18:05 | Avoid passing constraints that are unusable due to LEFT or CROSS joins to virtual table xBestIndex() methods. (check-in: 80ee56dda7 user: dan tags: vtab-left-join) | |
| 17:42 | Fix typo in comment. No changes to code. (check-in: e49c291735 user: mistachkin tags: trunk) | |
| 17:40 | Split out some source code into new files: wherecode.c, whereexpr.c, and treeview.c. Other minor refactoring changes. (check-in: 50f336818c user: drh tags: trunk) | |
| 15:08 | Factor out the TreeView parse tree printing module into a separate file. (check-in: c32ce54ca4 user: drh tags: view-optimization) | |
| 14:23 | Split more subfunctions of where.c out into a new whereexpr.c source file, for improved maintainability. (check-in: 46ef95c108 user: drh tags: view-optimization) | |
15 Years Ago (more context)
|
2010-06-08
| ||
| 15:50 | Close database opened by tester.tcl when it is sourced in all.test. Because test scripts are now run in slave interpreters, this connection was not being closed by the first script run as it was previously. (check-in: b072e9f69a user: dan tags: trunk) | |
| 15:16 | Changes to wal3.test to support small default cache size settings. And builds that create autovacuum databases by default. (check-in: ac4cc2574b user: dan tags: trunk) | |
25 Years Ago (more context)
|
2000-06-08
| ||
| 21:53 | :-) (CVS 86) (check-in: 049abcb37d user: drh tags: trunk) | |
| 19:43 | :-) (CVS 85) (check-in: 8b1c151b7b user: drh tags: trunk) | |
| 19:38 | :-) (CVS 84) (check-in: 57dce04add user: drh tags: trunk) | |
| 16:54 | :-) (CVS 83) (check-in: 2e5786d101 user: drh tags: trunk) | |
| 16:26 | :-) (CVS 82) (check-in: 33355b2d8d user: drh tags: trunk) | |
| 15:10 | :-) (CVS 81) (check-in: 61c381e7e6 user: drh tags: trunk) | |
| 13:36 | remove all memory leaks (CVS 80) (check-in: bf98cf82a7 user: drh tags: trunk) | |
| 11:25 | :-) (CVS 79) (check-in: 305b043f4f user: drh tags: trunk) | |
| 11:13 | :-) (CVS 78) (check-in: 923c14fe12 user: drh tags: trunk) | |
| 01:55 | :-) (CVS 77) (check-in: b3fb15ccde user: drh tags: trunk) | |
| 00:28 | :-) (CVS 76) (check-in: 1902923308 user: drh tags: trunk) | |
| 00:19 | :-) (CVS 75) (check-in: c47d552e7e user: drh tags: trunk) | |