This Day In History For 2020-09-29
2 Years Ago (more context)
|
2018-09-29
| ||
| 19:38 | Add the PRAGMA table_vinfo command (with an extra "v" before "info") that works like PRAGMA table_info (without the "v") except that it also shows hidden columns on virtual tables. (check-in: 8bcd1a59 user: drh tags: pragma-table-vinfo) | |
3 Years Ago (more context)
|
2017-09-29
| ||
| 22:13 | Always render a subquery that is not part of a join as a co-routine. (check-in: 6b1651d7 user: drh tags: prefer-coroutine-sort-subquery) | |
| 16:08 | Merge the query flattener comment improvements from trunk. (check-in: f62cd4d9 user: drh tags: prefer-coroutine-sort-subquery) | |
| 16:07 | Clean up the comments on the query flattener to more clearly and accurately express the conditions under which the flattener is able to run. (check-in: 0840f9f8 user: drh tags: trunk) | |
| 14:31 | Merge changes from trunk. (check-in: 06f432fb user: drh tags: prefer-coroutine-sort-subquery) | |
| 12:44 | Make sure the 6th parameter to the authorizer callback for view subqueries has the correct view name. (check-in: 2a45bbc9 user: drh tags: trunk) | |
| 12:12 | Better names for subqueries in EXPLAIN comments. (check-in: 04ef40a8 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2016-09-29
| ||
| 20:28 | Small size and performance optimization to sqlite3VdbeChangeP5(). (check-in: 3c93c8f5 user: drh tags: trunk) | |
| 19:50 | Remove the peep-hole optimization of removing OP_Close opcodes that come before OP_Halt, as the extra work of removing those opcodes uses more cycles than just running them. (check-in: 984a96d7 user: drh tags: trunk) | |
| 19:27 | Size and performance optimization to sqlite3ValueFromExpr() (check-in: 945f82bc user: drh tags: trunk) | |
| 15:53 | Clarification and typo-fixes in comments. No changes to code. (check-in: e2cd79aa user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-09-29
| ||
| 19:45 | • Edit [3e15dea55c31c92b|3e15dea5]: Mark "Closed". (artifact: 1db42ebb user: drh) | |
| 19:45 | • Edit [3e15dea55c31c92b|3e15dea5]: Move to branch mistake. Edit check-in comment. (artifact: 2f6844fa user: drh) | |
| 17:51 |
This condition was not always true after all.....
Change an always-true condition in the virtual table transaction interface into an assert(). (Closed-Leaf check-in: 3e15dea5 user: drh tags: mistake) | |
| 17:20 | Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. (check-in: 7d272aa6 user: drh tags: trunk) | |
| 17:04 | • Edit [0e317dda5dfd35b7|0e317dda]: Mark "Closed". (artifact: a50b98e1 user: drh) | |
| 16:47 | Add the sqlite3_index_info.idxFlags field, allowing xBestIndex() implementations to specify to SQLite that a strategy may visit at most one row. Add support for this to fts3/4. Omit the statement journal from virtual table UPDATE and DELETE operations that are guaranteed not to affect more than one row. (check-in: a1d08fd3 user: dan tags: trunk) | |
| 16:41 | Ensure that the xSavepoint() virtual table method is correctly invoked if there are already open savepoints (or statement transactions) the first time a virtual table is written within a transaction. (check-in: 77948b5e user: dan tags: trunk) | |
| 15:50 | Remove dead code, replacing with assert() statements that make sure the code really was dead. (Closed-Leaf check-in: 0e317dda user: drh tags: vtab-onepass) | |
| 13:25 | Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-level VDBE is being coded (versus a trigger) and use that interface. (check-in: 59662cd2 user: drh tags: vtab-onepass) | |
| 12:32 | Fix compiler warnings. (check-in: d1a07838 user: drh tags: vtab-onepass) | |
| 12:19 | Fix an off-by-one error in test function fts5_decode(). (check-in: 3a9f0762 user: dan tags: trunk) | |
| 11:59 | Merge latest trunk change into this branch. (check-in: b519c0d6 user: dan tags: vtab-onepass) | |
| 11:57 | Change the name of the new sqlite3_index_info.flags field to "idxFlags". Add documentation for the same to sqlite.h.in. (check-in: f61203bc user: dan tags: vtab-onepass) | |
| 10:11 | Add tests for fts3 and onepass update/delete operations. Also fix a problem with onepass updates that do not affect any rows. (check-in: 820c8044 user: dan tags: vtab-onepass) | |
10 Years Ago (more context)
|
2010-09-29
| ||
| 18:26 | Add test cases to e_createtable.test. (check-in: f34dc54d user: dan tags: trunk) | |
| 14:27 | • Edit [1ef0dc9328f47506|1ef0dc93]: Timestamp 2010-09-29 13:31:00. (artifact: 6506bc2b user: drh) | |
| 13:31 | Add tests for "CREATE TABLE ... AS SELECT ..." statements to e_createtable.test. (check-in: 1ef0dc93 user: dan tags: trunk) | |
| 01:54 | Updates to sqlite3_finalize() documentation. (check-in: 8c5994cf user: drh tags: trunk) | |
20 Years Ago (more context)
|
2000-09-29
| ||
| 15:15 | Fix a problem with the configure script (CVS 1703) (check-in: ed5f5404 user: drh tags: trunk) | |
| 15:15 | Fix a problem with the configure script (CVS 148) (check-in: 2aeb82db user: drh tags: trunk) | |
| 13:30 | :-) (CVS 147) (check-in: e11f7527 user: drh tags: trunk) | |