This Day In History For 2018-05-01
1 Year Ago (more context)
|
2017-05-01
| ||
| 20:07 | Update this branch with latest trunk changes. (check-in: 83b1e163ef user: dan tags: server-edition) | |
| 19:53 | Remove an unnecessary branch. (check-in: a33179596f user: drh tags: having-where-optimization) | |
| 18:35 | • Fixed ticket [f68dc596c4]: Database corruption on REPLACE with a mix of NULL and non-NULL rowids. plus 5 other changes (artifact: f8f6c4c104 user: drh) | |
| 18:24 | Enhance "PRAGMA integrity_check" to detect duplicate rowids within a leaf page. (check-in: adcad37b00 user: dan tags: trunk) | |
| 18:12 | Clear the BTCF_ValidNKey flag set if a cursor is moved by sqlite3BtreeInsert(). Fix for [f68dc596c4]. (check-in: a6727eef6d user: dan tags: trunk) | |
| 18:09 | • New ticket [f68dc596c4] Database corruption on REPLACE with a mix of NULL and non-NULL rowids.. (artifact: 784838a8d5 user: drh) | |
| 17:04 | Futher bug fixes to the function that determines when a materialized view can be reused. (Closed-Leaf check-in: c64fe3a169 user: drh tags: materialized-view-reuse) | |
| 16:37 | Minor bug fixes and performance enhancement. (check-in: b2aae55958 user: drh tags: materialized-view-reuse) | |
| 15:15 | Initial implementation of an optimization that attempts to reuse the same materialization of a view on a self-join of the view. (check-in: 478c34b9a8 user: drh tags: materialized-view-reuse) | |
| 14:25 | Update this branch with latest trunk changes. (check-in: 11f4761c3a user: dan tags: schemalint) | |
| 14:09 | Add extra tests for the optimization on this branch. (check-in: 4921cd9520 user: dan tags: having-where-optimization) | |
3 Years Ago (more context)
|
2015-05-01
| ||
| 20:38 | Further improvements to test coverage of fts5 code. (check-in: d4331943df user: dan tags: fts5) | |
| 20:34 | Enhance the fuzzershell --uniquecases option to output results in order of increasing runtime and to include the runtime in the comment separator of the output. (check-in: 04630b989d user: drh tags: trunk) | |
| 19:21 | Enhance fuzzershell to accept multiple input files. Add the test/fuzzdata2.txt fuzz test content. (check-in: ab5523aafe user: drh tags: trunk) | |
| 18:00 | Fix an assert in RTREE that would fire if the rtree table is misdeclared. (check-in: 9a45409cc4 user: drh tags: trunk) | |
| 16:57 | Fix an assert() failure caused by setting "PRAGMA journal_mode=off" on an database in exclusive-mode that has already opened the journal file. (check-in: 40db3e4012 user: dan tags: trunk) | |
| 15:25 | Remove obselete comment text from the description of the Table object. No changes to code. (check-in: 6566b72a9c user: drh tags: trunk) | |
| 14:07 | Use the sqlite3Fts3ErrMsg() function to set error message text in FTS3, and to ensure that error messages are not overwritten and thus leaked. (check-in: 605347e087 user: drh tags: trunk) | |
| 12:14 | Improve test coverage of fts5.c. (check-in: add4f4681c user: dan tags: fts5) | |
4 Years Ago (more context)
|
2014-05-01
| ||
| 20:26 | Fix an obscure problem to do with temp register allocation that could occur if more than one simple SELECT within a compound SELECT uses a partial sort. (check-in: 427409ae10 user: dan tags: trunk) | |
| 20:24 | Add #ifdefs for test coverage. Add a testcase(). (check-in: be2702ce35 user: drh tags: trunk) | |
| 10:19 | Update a test case in wal2.test that explicitly corrupts a checksum in the wal file to account for the fact that the first byte of said checksum may initially be 0xFF. (check-in: 2b935bdea1 user: dan tags: trunk) | |
| 01:49 | Take out the special handling of nolock=true in os_win.c and add it to pager.c, so that it works for all VFSes. Add the pPager->noLock boolean for clarity. (check-in: 725c1c14be user: drh tags: win32-none) | |
| 01:20 | Avoid unnecessary xUnlock operations on temp file. (check-in: 1829c38c32 user: drh tags: win32-none) | |
| 01:13 | Add the immutable=TRUE query parameter and SQLITE_IOCAP_IMMUTABLE, either of which prevents locking of the database and omits tests for existance of journal files. (check-in: 71f152c85d user: drh tags: win32-none) | |
5 Years Ago (more context)
|
2013-05-01
| ||
| 20:40 | Fix comments in the magic number file. (Closed-Leaf check-in: 5a500848d2 user: drh tags: application-id) | |
| 20:36 | Preserve the application-ID across VACUUM. Updates to the magic number file. (check-in: 4a190bea18 user: drh tags: application-id) | |
| 19:49 | Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. (check-in: 28c9e7fdee user: drh tags: application-id) | |
| 17:58 | Do not use a transitive constraint to an IN operator where the RHS is a constant if there exists a direct == operator to another table in an outer loop. (check-in: faedaeace9 user: drh tags: trunk) | |
| 17:22 | Avoid redundant constraint checking due to transitive constraints. (check-in: 329478cbed user: drh tags: trunk) | |
10 Years Ago (more context)
|
2008-05-01
| ||
| 18:01 | Fix a problem with journal files being created unnecessarily when doing an atomic write in exclusive access locking mode. Fix a test script problem. (CVS 5075) (check-in: 70e708660f user: drh tags: trunk) | |
| 17:16 | Fix more compiler warnings. (CVS 5074) (check-in: 59568844e7 user: drh tags: trunk) | |
| 17:03 | Fix harmless compiler warnings. (CVS 5073) (check-in: 227a6f67c2 user: drh tags: trunk) | |
| 02:47 | Test versions of getVarint functions. The updates essentially utilize loop unrolling and some shifting/anding tricks to minimize the number of logical operations required. (CVS 5072) (check-in: 682dc24dbe user: shane tags: trunk) | |
15 Years Ago (more context)
|
2003-05-01
| ||
| 16:56 | Correctly create an index that uses an INTEGER PRIMARY KEY as one of columns to be indexed. (CVS 946) (check-in: 6d019e0baa user: drh tags: trunk) | |