This Day In History For 2020-07-17
1 Year Ago (more context)
|
2019-07-17
| ||
| 19:57 | Always use the stdlib.h intptr_t type for pointer-integer conversions, when it is available. (check-in: c0d93244 user: drh tags: trunk) | |
| 18:19 | When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9]. (check-in: bc6b0d73 user: drh tags: branch-3.29) | |
| 18:11 | Fix problems with duplicate fields in the PRIMARY KEYs of WITHOUT ROWID tables. (check-in: bda25883 user: drh tags: branch-3.29) | |
| 16:18 | Fix an incorrect assert() in balance_nonroot(). (check-in: 59c9e73f user: drh tags: trunk) | |
| 15:47 | • Fixed ticket [1be72aab]: CHECK constraint using COLLATE with CASE or BETWEEN plus 3 other changes (artifact: fd3c95a4 user: drh) | |
| 15:05 | Improvement to the hexdb interpreter built into the CLI and into the TCL test harness: Round the "size" up to the next multiple of the "pagesize". (check-in: 9ec92939 user: drh tags: trunk) | |
| 14:34 | When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9]. (check-in: 7ef7b23c user: dan tags: trunk) | |
| 14:28 | • Ticket [1be72aab] CHECK constraint using COLLATE with CASE or BETWEEN status still Open with 3 other changes (artifact: 551d972b user: drh) | |
| 14:27 | • Ticket [1be72aab]: 6 changes (artifact: 5a7be497 user: drh) | |
| 13:36 | • New ticket [1be72aab]. (artifact: 50f9f11e user: drh) | |
| 13:10 | • Fixed ticket [fd3aec0c]: Valgrind warning if PK has more columns than the table. plus 5 other changes (artifact: c294e6d9 user: drh) | |
| 12:49 | Fix the WITHOUT ROWID table logic so that it generates a correct KeyInfo object for tables that have a PRIMARY KEY containing the same column used more than once with different collating sequences. Enhance the index_xinfo pragma to assist in testing the above. Fix for ticket [fd3aec0c7e3e2998]. (check-in: 84a51a75 user: drh tags: trunk) | |
| 12:42 | New test cases for PRAGMA index_xinfo on a WITHOUT ROWID table. And new testcases using index_xinfo to verify that WITHOUT ROWID tables are constructed correctly. (Closed-Leaf check-in: 340378c1 user: drh tags: wor-pk-dups) | |
| 11:01 | Enhance the "PRAGMA index_info()" and "PRAGMA index_xinfo()" statements so that they allow a WITHOUT ROWID table as their argument, and in that case show the structure of the underlying index used to implement the WITHOUT ROWID table. (check-in: 62274ff6 user: drh tags: wor-pk-dups) | |
| 09:18 | Fix problems with duplicate fields in the PRIMARY KEYs of WITHOUT ROWID tables. (check-in: bd9a47a3 user: dan tags: wor-pk-dups) | |
| 07:23 | Add casts to shell.c.in to avoid warnings on systems where size_t is 32 bits. (check-in: fe014288 user: dan tags: trunk) | |
| 01:27 | • New ticket [fd3aec0c] Valgrind warning if PK has more columns than the table.. (artifact: 6e4769b4 user: drh) | |
2 Years Ago (more context)
|
2018-07-17
| ||
| 14:01 | If an SQLITE_IOERR error is encountered as part of an atomic commit on an F2FS file-system, retry the commit in legacy journal mode. (check-in: 2e0357c2 user: dan tags: trunk) | |
| 13:55 | Fix for builds without SQLITE_ENABLE_BATCH_ATOMIC_WRITE. (Closed-Leaf check-in: b10ec14e user: dan tags: exp-retry-atomic-commit) | |
3 Years Ago (more context)
|
2017-07-17
| ||
| 21:03 | Add test cases to test/unionvtab.test. (Closed-Leaf check-in: f2c4a584 user: dan tags: union-vtab) | |
| 20:25 | Enhance error detection and fix other issues in unionvtab code. (check-in: 9c3f1b9a user: dan tags: union-vtab) | |
| 20:21 | Merge all the latest fixes and enhancements from trunk. (check-in: e181225d user: drh tags: apple-osx) | |
| 19:37 | Try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. This is a cherry-pick of [6df18e949d36] with bug fixes. (check-in: cd6ac078 user: drh tags: branch-3.8.9) | |
| 19:25 | When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. (Closed-Leaf check-in: adc082c1 user: drh tags: push-down-backport) | |
| 19:14 | Do not apply the WHERE-clause pushdown optimization to terms that originate in the ON or USING clause of a LEFT JOIN. Fix for ticket [c2a19d81652f40568c]. (check-in: 52674f94 user: drh tags: push-down-backport) | |
| 19:07 | For FROM-clause subqueries that cannot be flattened, try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. Cherry-pick from [6df18e949d36]. Still need to backport bug fixes associated with that check-in. (check-in: 043d6ce8 user: drh tags: push-down-backport) | |
| 18:45 | Merge all changes from branch-3.20. Improvements to the fts5() extension interface. Work around a gcc/valgrind bug in the sqlite3_value_pointer() interface. (check-in: e0aca7d2 user: drh tags: trunk) | |
| 17:46 | Interchange to branches within an "if" statement in sqlite3_value_pointer() in order to work around a bug in gcc. (Closed-Leaf check-in: 8a606e4a user: drh tags: branch-3.20) | |
| 17:10 | • Edit [f4f7196b87700109|f4f7196b]: Mark "Closed". (artifact: e2c08e14 user: dan) | |
| 15:38 | Improved the interface to the fts5() extension mechanism for enhanced security. (check-in: bc78235f user: drh tags: branch-3.20) | |
| 13:37 | Merge the pointer-type enhancement from the 3.20 branch. (check-in: 9e8e1c4a user: drh tags: trunk) | |
| 13:27 | • Edit [62a86aa6c0519cf1|62a86aa6]: Move to branch union-vtab. (artifact: 4856024d user: drh) | |
| 12:41 | Comment changes clarifying details of the pointer-type parameter. No changes to code. (check-in: e4579e50 user: drh tags: branch-3.20) | |
| 12:27 | Add the pointer-type parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a static string that must match (according to strcmp()) or else the pointer is passed as a NULL. This is a security measure to prevent crossing pointers between different extensions. (check-in: e1196567 user: drh tags: branch-3.20) | |
| 11:39 | Improve the sqlite3_result_pointer() interface so that it cannot be faked using sqlite3_result_null() and sqlite3_result_subtype(). (Closed-Leaf check-in: c13264d5 user: drh tags: pointer-types) | |
| 09:30 | Use integer handles for fts3 cursors for a small performance improvement. (Closed-Leaf check-in: f4f7196b user: dan tags: union-vtab, fts3-int-cursor) | |
| 00:40 | Add an experimental "pointer type" parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a string that must compare equal using strcmp() or else the pointer comes through as a NULL. (check-in: 211cce04 user: drh tags: pointer-types) | |
5 Years Ago (more context)
|
2015-07-17
| ||
| 12:42 | More adjustments to the malloc5.test module so that it works correctly with the new pcache1 bulk allocation. (check-in: 2a7b3a44 user: drh tags: trunk) | |
| 01:16 | Avoid a harmless compiler warning. (check-in: 2288842b user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-07-17
| ||
| 18:44 | Add new test file e_expr.test. (check-in: cbcf8abb user: dan tags: trunk) | |
| 09:27 | Do not run journal3.test with the inmemory_journal permutation. (check-in: e1d228e9 user: dan tags: trunk) | |