This Day In History For 2018-06-04
2 Years Ago (more context)
|
2016-06-04
| ||
| 21:05 | Improved comment on cursorOwnsBtShared(). No changes to code. (Closed-Leaf check-in: 5e269c2d26 user: drh tags: btree-refactor) | |
| 20:58 | Fix a C99-ism and a compiler warning for MSVC. (check-in: aa53a36ea2 user: drh tags: btree-refactor) | |
| 20:37 | Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. (check-in: bef35e18dd user: drh tags: btree-refactor) | |
| 17:12 | Allocate KeyInfo objects from lookaside if possible. (check-in: b411107a36 user: drh tags: trunk) | |
| 16:33 | Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). (check-in: 9583c0fb39 user: drh tags: trunk) | |
| 13:57 | Remove an unreachable branch in the UNIQUE constraint parsing. (check-in: 313e990c74 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2015-06-04
| ||
| 12:08 | Change the name of SrcList.a[].zIndex to the more descriptive SrcList.a[0].zIndexedBy. (check-in: 6a9cf06337 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2014-06-04
| ||
| 14:06 | Version 3.8.5 (check-in: b1ed4f2a34 user: drh tags: trunk, release, version-3.8.5) | |
5 Years Ago (more context)
|
2013-06-04
| ||
| 23:40 | Update some variable names and comments in the ORDER BY optimizer. Fix a bug in the ORDER BY optimizer dealing with IS NULL constraints. Updates to test cases. (check-in: cf96eb5945 user: drh tags: nextgen-query-plan-exp) | |
| 18:27 | Restore the PRAGMA reverse_unordered_selects behavior. (check-in: f49cd6c4e7 user: drh tags: nextgen-query-plan-exp) | |
| 18:03 | Get the index-only optimization working for OR queries. (check-in: 774d5ff857 user: drh tags: nextgen-query-plan-exp) | |
| 15:31 | Test case updates. (check-in: 0360fec7c0 user: drh tags: nextgen-query-plan-exp) | |
| 14:56 | • Ticket [5ed1772895] Incorrect ORDER BY on an indexed JOIN status still Open with 6 other changes (artifact: 114ba533cd user: drh) | |
| 14:48 | • New ticket [5ed1772895]. (artifact: 33be471b72 user: drh) | |
| 13:37 | Better determination of when an index is UNIQUE. (check-in: 63fd025ad9 user: drh tags: nextgen-query-plan-exp) | |
| 13:07 | Increase the estimated full-scan cost for an FTS3 table. (check-in: 8d9f29f847 user: drh tags: nextgen-query-plan-exp) | |
| 12:58 | Fix a display issue with EXPLAIN QUERY PLAN. (check-in: ff2fa40755 user: drh tags: nextgen-query-plan-exp) | |
| 12:42 | Refactor the ORDER BY optimizer in the NGQP so that it is easier to maintain and so that it can support optimizing out GROUP BY and DISTINCT clauses. (check-in: e605c468e3 user: drh tags: nextgen-query-plan-exp) | |
10 Years Ago (more context)
|
2008-06-04
| ||
| 15:09 | Fix another typo in the rtree README file. (CVS 5187) (check-in: 9ab87b7b0d user: drh tags: trunk) | |
| 14:20 | Fix a bug in the R-Tree documentation. (CVS 5186) (check-in: bb445a4b1f user: drh tags: trunk) | |
| 06:45 | Add "pragma journal_size_limit", used to limit the space consumed by persistent journal files left in the file-system after a transaction has concluded in exclusive (or journal_mode=persist) mode. (CVS 5185) (check-in: 5c59f469d0 user: danielk1977 tags: trunk) | |
15 Years Ago (more context)
|
2003-06-04
| ||
| 16:24 | Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999). Also clean up some compiler warnings for VC++. (CVS 1005) (check-in: af6f2bdf59 user: drh tags: trunk) | |
| 15:53 | Adjust test cases to cope with the extra column returned by the database_list pragma. (CVS 1004) (check-in: fa10c6df5a user: drh tags: trunk) | |
| 15:48 | Change the "database_list" pragma to return a third column containing the filename of the underlying database file. Always use an in-memory TEMP database with an in-memory main database. (CVS 1003) (check-in: f39100f575 user: drh tags: trunk) | |
| 12:44 | Version 2.8.3 (CVS 1002) (check-in: 433570e3e6 user: drh tags: trunk) | |
| 12:40 | Update the version number to 2.8.3. (CVS 1001) (check-in: c96f5bf0d7 user: drh tags: trunk) | |
| 12:31 | Disable the unreadable file test (attach-6.2) under windows because of problems in the OS. (CVS 1000) (check-in: 4bfb30d20b user: drh tags: trunk) | |
| 12:23 | Avoid corrupting indices when doing a REPLACE on a table with an INTEGER PRIMARY KEY that also has another index. Ticket #334. (CVS 999) (check-in: e813faae0e user: drh tags: trunk) | |