This Day In History For 2020-02-24
2 Years Ago (more context)
|
2018-02-24
| ||
| 08:26 | Test edge cases in the zonefile module. Fix a broken error message in the same. (check-in: 1764ade22b user: dan tags: zonefile) | |
3 Years Ago (more context)
|
2017-02-24
| ||
| 19:58 | Optimize defragmentPage() in the case where the page contains either one or two free-blocks and a small number of fragmented bytes. (check-in: 202b1c0276 user: dan tags: defragmentpage-opt) | |
4 Years Ago (more context)
|
2016-02-24
| ||
| 23:31 | Fix typo. Improve interim debugging. (check-in: e0029bdf20 user: mistachkin tags: vsixTest) | |
| 23:25 | Test build all supported configurations and platforms during VSIX testing. (check-in: cce40a0b8e user: mistachkin tags: vsixTest) | |
| 21:42 | Initial work on an automated VSIX testing tool. Not working or tested yet. (check-in: 496e4ac984 user: mistachkin tags: vsixTest) | |
| 21:10 | • Edit [3e9ed1aea43e8ce2|3e9ed1aea4]: Edit check-in comment. (artifact: 2aea6a8cb9 user: drh) | |
| 20:16 | Extend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified. (check-in: e721975faa user: dan tags: trunk) | |
| 19:57 | Change a char* to const char* in order to suppress some harmless compiler warnings. (check-in: 56f62e34ae user: drh tags: trunk) | |
| 17:18 | When an index completely covers a table, it can be used as a covering index even if columns past the 63rd column are indexed and accessed. (check-in: 3e9ed1aea4 user: drh tags: trunk) | |
| 16:14 | Fix a problem with handling identifiers that start with "x" if SQLITE_OMIT_BLOB_LITERAL is defined. (check-in: b65217c69c user: dan tags: trunk) | |
| 15:49 | • Edit [71d488b599cbde81|71d488b599]: Edit check-in comment. (artifact: b41e3f2cfa user: drh) | |
| 15:43 | Identify indexes that completely cover their table. (Closed-Leaf check-in: 71d488b599 user: drh tags: covering-index) | |
| 13:35 | LSM1: Fix the integer key encoding so that negative keys are in numeric order. (check-in: f92dc4187f user: drh tags: lsm-vtab) | |
5 Years Ago (more context)
|
2015-02-24
| ||
| 20:21 | • Fixed ticket [2326c258d0]: Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index plus 3 other changes (artifact: 28d4d42e5b user: drh) | |
| 20:12 | Make sure partial indexes are not qualified incorrectly by a constraint that is inside the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead33]. Cherry-pick from [491cfe9b3f87f]. (check-in: 9d94ac6a8b user: drh tags: branch-3.8.8) | |
| 20:10 | Prevent partial indexes on the table on the left hand side of a LEFT JOIN from being incorrectly qualified by a constraint in the ON clause of the join. This relaxes the rule introduced by the previous commit (as the partial indexes on the table on the rhs of the LEFT JOIN may now be qualified by terms within the ON clause). (check-in: 1d6fb43a57 user: dan tags: trunk) | |
| 20:04 | Make sure partial indexes are not qualified incorrectly by a constraint that is inside the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead33]. (check-in: 491cfe9b3f user: drh tags: trunk) | |
| 18:39 | More test cases to help ensure that partial indexes do not get used if their qualifing constraint is inside the ON clause of a LEFT JOIN. (Closed-Leaf check-in: c6399958a1 user: drh tags: tkt-2326c258) | |
| 18:13 | • Ticket [2326c258d0] Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index status still Open with 7 other changes (artifact: 6c8344ce68 user: drh) | |
| 16:48 | This additional fix prevents a partial index from being qualified for use if the constraint that qualifies the partial index is part of the ON clause of a LEFT JOIN. (check-in: 1a1516e4da user: drh tags: tkt-2326c258) | |
| 16:34 | • Edit [c0f4e308a508183b|c0f4e308a5]: Move to branch tkt-2326c258. (artifact: 1e3cf43eaa user: drh) | |
| 16:33 | • Edit [c0f4e308a508183b|c0f4e308a5]: Edit check-in comment. Add tag "tkt-2326c258". (artifact: 60161b5f95 user: drh) | |
| 16:22 | Increase the version number to 3.8.8.3 (check-in: a92afe7d8c user: drh tags: branch-3.8.8) | |
| 16:05 | Make sure partial automatic indexes are not based on terms in the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead3]. UPDATE: This fix does not work where the partial index is a named index. (check-in: c0f4e308a5 user: drh tags: tkt-2326c258) | |
| 16:04 | • Edit [d95d0313c447f5ba|d95d0313c4]: Edit check-in comment. (artifact: 19d78b5d3b user: drh) | |
| 15:30 | • New ticket [2326c258d0] Incorrect result on a LEFT JOIN with an ORDER BY. (artifact: f6a379b6db user: drh) | |
10 Years Ago (more context)
|
2010-02-24
| ||
| 22:36 | • Ticket [ebdbadade5] LEFT JOIN incorrect when ON clause does not reference right table. status still Open with 3 other changes (artifact: 2267692434 user: drh) | |
| 22:35 | • New ticket [ebdbadade5]. (artifact: e3450baa28 user: drh) | |
| 21:44 | Add testcase() macros beside each sqlite3_log() call to make sure it is tested with both logging enable and disabled. (check-in: 1168763d2c user: drh tags: trunk) | |
| 19:55 | • Ticket [2e047cbefa] select DISTINCT performance could be better status still Open with 4 other changes (artifact: 8a75f8251b user: anonymous) | |
| 19:36 | Changes to compile time option diags to report values for some defines. Added test cases to TCL test suite (ctime.test). (check-in: dd480f62af user: shaneh tags: trunk) | |
| 19:23 | Add a sqlite3_log() call on anonymous constraint failures. Fix the output of test cases having to do with improved reprepare reporting. Fix the VACUUM command to report more helpful error messages when things go wrong. (check-in: 69a493182f user: drh tags: trunk) | |
| 18:40 | Fix an incorrect ALWAYS() macro in vdbeapi.c. Fix the output of a few test cases that changed due to better error propagation out of reprepare. (check-in: a8c984c1d6 user: drh tags: trunk) | |
| 18:25 | Remove an unused variable from rtree. (check-in: 8e60d3995a user: drh tags: trunk) | |
| 17:15 | Enhancements to the way errors are reported up when an automatic statement reprepare fails. (check-in: 1a6d4bb130 user: drh tags: trunk) | |
| 15:11 | • Fixed ticket [d2f02d37f5]: Assertion fault on UPDATE involving two virtual tables. plus 1 other change (artifact: fe19816b76 user: drh) | |
| 15:10 | Fix an assertion fault that occurs when two different virtual tables are used in a single UPDATE statement. Ticket [d2f02d37f52b]. (check-in: ff61e0fd80 user: drh tags: trunk) | |
| 14:03 | • Ticket [d2f02d37f5] Assertion fault on UPDATE involving two virtual tables. status still Open with 3 other changes (artifact: 150a3df0c3 user: drh) | |
| 13:52 | • New ticket [d2f02d37f5]. (artifact: 29a566c9c2 user: drh) | |
15 Years Ago (more context)
|
2005-02-24
| ||
| 04:51 | Revised man page from Bill Bumgarner. (CVS 2360) (check-in: 5c99bea5a4 user: drh tags: trunk) | |