This Day In History For 2020-08-10
1 Year Ago (more context)
|
2019-08-10
| ||
| 15:07 | • Edit [da01ba4fa47c6508|da01ba4f]: Edit check-in comment. (artifact: d9c628b3 user: drh) | |
| 15:06 | • Fixed ticket [9080b622]: Constant expression in partial index results in row not being fetched plus 6 other changes (artifact: 53eb33a8 user: drh) | |
| 15:06 | Fix the sqliteExprImpliesExpr() routine so that it recognizes that "(NULL IS FALSE) IS FALSE" doe not imply "NULL NOT NULL". Ticket [9080b6227fabb466] (check-in: da01ba4f user: drh tags: trunk) | |
| 14:35 | Add extra test cases related to the previous commit. (check-in: 3c690b2b user: dan tags: trunk) | |
| 14:16 | Remove two incorrect assert() statements from the logic used to derive column names and types from subqueries. (check-in: 712e4771 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2018-08-10
| ||
| 20:19 | Ensure the schema cookie is changed when a column is renamed. (check-in: 2dec9ea4 user: dan tags: alter-table-rename-column) | |
| 19:33 | Fix harmless compiler warnings. (check-in: 9564d700 user: drh tags: alter-table-rename-column) | |
| 19:19 | When a column is renamed, update any references to it in REFERENCES clauses that belong to other tables. (check-in: 191079bd user: dan tags: alter-table-rename-column) | |
| 15:27 | Merge latest trunk changes with this branch. (check-in: c355a837 user: dan tags: alter-table-rename-column) | |
| 14:23 | Fix a problem with renaming columns on tables with REFERENCES clauses that specify a large number of columns. (check-in: d48f7bbd user: dan tags: alter-table-rename-column) | |
3 Years Ago (more context)
|
2017-08-10
| ||
| 20:43 | Allow WITHOUT ROWID virtual tables to be writable as long as they have exactly one column as their PRIMARY KEY. (check-in: c601d128 user: drh tags: trunk) | |
| 20:36 | Add the "instance" type to the fts5vocab virtual table module. For direct access to the contents of the fts5 term index. (check-in: 34a7bd71 user: dan tags: trunk) | |
| 19:12 | Fix a typo in csv01.test introduced by the previous commit. (Closed-Leaf check-in: f38ff718 user: dan tags: writable-vtab-without-rowid) | |
| 19:10 | Add extra tests to this branch. (check-in: b0e3b88a user: dan tags: writable-vtab-without-rowid) | |
| 17:53 | Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key. (check-in: 6997e00c user: drh tags: writable-vtab-without-rowid) | |
| 15:19 | Experimental changes that allow a WITHOUT ROWID virtual table to be writable as long as it has only a single-column PRIMARY KEY. (check-in: ab9ee4c1 user: drh tags: writable-vtab-without-rowid) | |
| 03:27 | Add a first draft of the "vtablog" extensions that implements a generic virtual table useful for experimentation using the command-line shell. (check-in: e49279e6 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2016-08-10
| ||
| 20:02 | Optimization to sqlite3WhereExprUsage(). (check-in: 95493058 user: drh tags: trunk) | |
| 19:43 | List of MATCH operator names in isMatchOfColumn() should be constant. (check-in: 7319d676 user: drh tags: trunk) | |
| 18:56 | Performance enhancement in the expression walker. (check-in: ebccbd96 user: drh tags: trunk) | |
| 15:02 | Tweaks to pcache1TruncateUnsafe() to make it slightly smaller and faster and easier to test. (check-in: 059f4e2e user: drh tags: trunk) | |
| 14:40 | Rearrange the code inside sqlite3RunParser() routine so that sqlite3Parser() is only called from a single place. This allows sqlite3Parser() to be in-lined, which results in a 0.25% overall performance gain. (check-in: 25d1d02b user: drh tags: trunk) | |
| 13:34 | Increment the version number to 3.15. (check-in: 8c2701e7 user: drh tags: trunk) | |
| 13:30 | Improved comments on the lempar.c parser template. Adjust the YY_SHIFT_USE_DFLT constant in the Lemon-generated parser tables so as to guarantee that it is always out of range of the yy_lookahead[] table. (check-in: 83622f3f user: drh tags: trunk) | |
| 11:50 | Fix pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. (check-in: b07a26df user: drh tags: trunk) | |
| 03:35 | Try to make pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. (Leaf check-in: 9ab53605 user: drh tags: debug) | |
| 02:54 | Remove all timers and other debugging logs except for the one timer on pcache1TruncateUnsafe(). (check-in: 5980e625 user: drh tags: debug) | |
| 01:43 | Performance optimization in the yy_find_shift_action() routine of the Lemon-generated parser. (check-in: ba6663be user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-08-10
| ||
| 20:53 | Record when an allocated page is taken from the freelist trunk. (check-in: bb5d7782 user: drh tags: experimentalIoLog) | |
| 20:22 | Add the sqlite3_experimental_log_open() interface. This is for diagnostic use only and is not intended to ever go on trunk. (check-in: ac5d2e9d user: drh tags: experimentalIoLog) | |
10 Years Ago (more context)
|
2010-08-10
| ||
| 15:46 | Fix a bug in pager.c causing it to omit the xSync() call required following a hot-journal rollback. (Closed-Leaf check-in: 42ba43ac user: dan tags: experimental) | |
| 09:58 | Add variable pager.dbHintSize, used to limit the number of calls made to the xFileControl(FCNTL_SIZE_HINT) method. (check-in: eb3ac895 user: dan tags: experimental) | |
| 07:12 | Changes to debugging code in mutex_unix.c and mutex_w32.c to make an assert() statement threadsafe. (check-in: e82e32bd user: dan tags: trunk) | |