This Day In History For 2020-08-05
1 Year Ago (more context)
|
2019-08-05
| ||
| 23:31 | • Edit [e15a0977ddfad3d0|e15a0977]: Move to branch pending. Edit check-in comment. (artifact: 37715ac2 user: drh) | |
| 21:56 | • New ticket [9f66f887] EXPLAIN PRAGMA executes PRAGMA. (artifact: 6c982a95 user: mrigger) | |
| 21:04 | • Edit [470ac8d50ce2f7cc|470ac8d5]: Mark "Closed". (artifact: 8029b648 user: drh) | |
| 20:53 | Ensure that columns of views and sub-queries that are expressions with no affinity are not assigned BLOB affinity. This matches the documentation. Fix for [61c853857f40da49]. (On a branch because there are still subtle issues.) (check-in: e15a0977 user: dan tags: pending) | |
| 20:45 | Add test cases to this branch. (Closed-Leaf check-in: f37317d8 user: dan tags: tkt-61c853-A) | |
| 20:41 | • Ticket [d52a29a9] Unexpected affinity conversion in view status still Fixed with 4 other changes (artifact: 7c070101 user: drh) | |
| 19:44 | Fix the patch on this branch so that it works with sub-queries, as well as views. (check-in: 7480db30 user: dan tags: tkt-61c853-A) | |
| 19:34 | The second option for [61c853857f40da49]: In this mode, columns of VIEWs and subqueries that are formed by expressions have affinity BLOB rather than affinity none, as has usually been the case for a while. But this mode fixes a couple of corner cases involving query flattening and the push-down optimization where that rule was violated. (Closed-Leaf check-in: 470ac8d5 user: drh tags: tkt-61c853-B) | |
| 19:32 | One of two options on how to address ticket [61c853857f40da49]. In this mode, we back out the documentation change of [07b7749da88d54e5] and change the core to work as it has been documented to work since 2017, rather than how it has actually worked since 2009. (check-in: 09cd0c0c user: drh tags: tkt-61c853-A) | |
| 18:01 | Refactor field Expr.affinity into Expr.affExpr to avoid confusion with other fields and variables named "affinity" and display affExpr it in sqlite3TreeViewExpr() output. (check-in: a29f2a7d user: drh tags: trunk) | |
| 16:22 | Improved detection of corruption on the freeblock list of a btree page. (check-in: 4b00799b user: drh tags: trunk) | |
| 15:09 | • New ticket [61c85385] Row is not fetched in SELECT from VIEW. (artifact: 82f66d84 user: mrigger) | |
| 13:19 | Fix a problem with renaming a table when a view or trigger within the schema uses a FILTER with an aggregate function that is not currently registered with the database. (check-in: 2ac0e42f user: dan tags: trunk) | |
| 13:06 | • Fixed ticket [d52a29a9]: Unexpected affinity conversion in view plus 8 other changes (artifact: ac513e2e user: drh) | |
| 12:55 | Prevent an fts5 table from being its own content table, or part of a view that is the content table. (check-in: b6d52c93 user: dan tags: trunk) | |
| 11:27 | • New ticket [d52a29a9] Unexpected affinity conversion in view. (artifact: c86e9f56 user: mrigger) | |
3 Years Ago (more context)
|
2017-08-05
| ||
| 16:15 | Fix a segfault in swarmvtab that could occur if there was an error in the SQL statement passed to the constructor. Add other test cases. (check-in: 6ce8b7ca user: dan tags: trunk) | |
| 15:49 | Microoptimization in pcache1.c makes the code slightly smaller and faster. (check-in: 422cd9f3 user: drh tags: trunk) | |
| 15:30 | Fix memory leak in swarmvtab. (check-in: 002a9c7b user: dan tags: trunk) | |
4 Years Ago (more context)
|
2016-08-05
| ||
| 20:54 | Have the TEA package build without SQLITE_OMIT_DEPRECATED. As it uses recently deprecated interfaces sqlite3_profile() and sqlite3_trace(). (check-in: 95578898 user: dan tags: trunk) | |
| 16:16 | Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. (check-in: ae72513a user: dan tags: trunk) | |
| 15:34 | Remove an incorrect ALWAYS() statement and add a test case to show when the condition is sometimes false. (check-in: 0f57effa user: drh tags: trunk) | |
| 14:35 | Fix a very obscure problem following OOM in sqlite3_declare_vtab(). (check-in: 68eac748 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-08-05
| ||
| 19:35 | Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. (check-in: 9e3aafe4 user: dan tags: trunk) | |
| 15:29 | Update the spellfix virtual table extension so that an explicit "top = ?" constraint works even if there is also a "distance < ?" or "distance <= ?" constraint. (check-in: 08888383 user: dan tags: trunk) | |
| 08:01 | Fix some problems in test code detected by cppcheck. (check-in: c9ff4ca4 user: dan tags: trunk) | |
| 07:43 | Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". (check-in: dffd358f user: dan tags: trunk) | |
10 Years Ago (more context)
|
2010-08-05
| ||
| 18:53 | • Edit [54eff6de9d8d87f3|54eff6de]: Edit check-in comment. Timestamp 2010-08-05 18:53:27. (artifact: cc00e8a1 user: drh) | |
| 18:53 | Add comments describing UNKNOWN_LOCK to pager.c. Improve some other comments in the same file. (check-in: 54eff6de user: dan tags: experimental) | |
| 16:22 | Merge trunk changes with experimental branch. (check-in: acd26b8b user: dan tags: experimental) | |
| 16:08 | Catch an error code that was not being propagated back to the caller. (check-in: 800f4969 user: dan tags: experimental) | |
| 15:30 | Fixes for error handling with temp databases. And for errors that occur within OS locking primitives. (check-in: f99a902f user: dan tags: experimental) | |
| 11:56 | Make the size of a Bitvec object 512 bytes on all platforms, instead of having the size depend on the size of a pointer. This makes testing easier. (check-in: ca479f3d user: drh tags: trunk) | |
| 03:30 | • Edit [309bbedf9648c750|309bbedf]: Edit check-in comment. Timestamp 2010-08-05 02:52:32. (artifact: 89916f46 user: drh) | |
| 03:24 | • Fixed ticket [13f033c8]: Performance regression plus 2 other changes (artifact: c1ac8278 user: drh) | |
| 03:21 | Do not read the database file size on a SAVEPOINT rollback any more since after checkin [65b8636ac6e5] the in-header-size field is always valid. (check-in: fbe70e11 user: drh tags: trunk) | |
| 02:52 | Fix the query planner so that when it has a choice of full-scan tables to move to the outer loop, it chooses the one that is likely to give the fewest output rows. Ticket [13f033c865f878]. (check-in: 309bbedf user: drh tags: trunk) | |
15 Years Ago (more context)
|
2005-08-05
| ||
| 18:50 | Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) (check-in: 73fafd21 user: drh tags: trunk) | |