This Day In History For 2020-08-22

1 Year Ago (more context)

2019-08-22
21:16		• Edit [d3531f5be7d37696|d3531f5b]: Edit check-in comment. (artifact: e809bbe8 user: drh)
21:13		Add additional VDBE coverage macros. (check-in: d3531f5b user: drh tags: nulls-last)
19:35		Merge fixes from trunk. Also fix a reference to the KeyInfo.aSortOrder field, which should now be KeyInfo.aSortFlags (check-in: 63e625c8 user: drh tags: nulls-last)
16:39		• Fixed ticket [7e07a3db]: LIKELY() seems to cause unexpected affinity conversion for rowid plus 6 other changes (artifact: 8584b3e4 user: drh)
16:38		Fix the likely(), unlikely(), and likelihood() functions so that they have no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] (check-in: 44578865 user: drh tags: trunk)
14:34		• New ticket [7e07a3db] LIKELY() seems to cause unexpected affinity conversion for rowid. (artifact: ea40e09c user: mrigger)
11:14		• Fixed ticket [ac184eb5]: Row with comparison on TEXT UNIQUE column is not fetched plus 7 other changes (artifact: 924b1a42 user: drh)
11:11		Fix a false-positive in sqlite3ExprNeedsNoAffinityChange(). Ticket [ac184eb571d5e6e0] (check-in: e62eddbb user: drh tags: trunk)
09:44		• New ticket [ac184eb5] Row with comparison on TEXT UNIQUE column is not fetched. (artifact: d99f1ffe user: mrigger)
00:55		• Fixed ticket [d9f584e9]: Row is not fetched in table with INTEGER PRIMARY KEY plus 7 other changes (artifact: 815dccdd user: drh)
00:53		Fix the OP_SeekGE, OP_SeekGT, OP_SeekLE, and OP_SeekLT opcodes so that they preserve the datatype of the value in the register used as the key. Ticket [d9f584e936c7a8d0] (check-in: 81b9f0f5 user: drh tags: trunk)

3 Years Ago (more context)

2017-08-22
21:23		Update documentation to make it clear that SQLITE_SOURCE_ID and sqlite3_sourceid() might changes if the source code is edited. (check-in: e69c0c87 user: drh tags: trunk)
21:07		Less dramatic changes to the source-id following an edit. Modify the way that the amalgamation is constructed to give it the opportunity to detect changes and modify the source-id. (check-in: 564c7340 user: drh tags: trunk)
19:54		Modify the SQLITE_SOURCE_ID if the source code has changed in any way since the previous check-in. (check-in: 515d6a83 user: drh tags: trunk)
19:49		Trying again to get out-of-tree builds to work correctly. (Closed-Leaf check-in: a1b3337e user: drh tags: mksourceid)
19:47		• Edit [ca5dcb4a36931161|ca5dcb4a]: Move to branch mistake. Edit check-in comment. (artifact: a7e64d23 user: drh)
19:44		mksourceid still does not work right. (Leaf check-in: ca5dcb4a user: drh tags: mistake)
19:43		Attempting to fix the source-id generator so that it works for out-of-tree builds. (check-in: 5a037ac2 user: drh tags: mksourceid)
19:35		• Edit [d4c05e04f7e1325a|d4c05e04]: Move to branch mksourceid. (artifact: 0e49c235 user: drh)
19:19		Add the "mksourceid" program to the build process. That program changes the SQLITE_SOURCE_ID if the source tree has been modified in any way. (check-in: d4c05e04 user: drh tags: mksourceid)
15:21		Fix error tests in seldom-used compile-time branches of the unix backend. (check-in: 885c2b44 user: drh tags: trunk)

4 Years Ago (more context)

2016-08-22
21:01		Add a couple of extra tests to changebatch1.test. (check-in: 207d970b user: dan tags: changebatch)
20:49		Add an experimental module to detect conflicts between sessions changesets. (check-in: 0c9fd6b7 user: dan tags: changebatch)
20:10		Add support for the SQLITE_DBCONFIG_MAINDBNAME configuration option. (check-in: 78395193 user: drh tags: trunk)
14:30		Fix the vector BETWEEN operator so that it only evaluates the left-most vector expression once. Add support for vector comparisons in the CASE operator. (check-in: 07e69f43 user: drh tags: rowvalue)
00:48		Reinstate the mechanism in BETWEEN that avoids evaluating the first expression more than once, but fix the affinity extractor so that it works with this mechanism. The de-duplication of the first expression still does not work for vector expressions, though. (check-in: 2f39987f user: drh tags: rowvalue)

5 Years Ago (more context)

2015-08-22
20:32		Fix a problem to do with detecting unlocked transaction conflicts if another client restarts the wal while the transaction is running. (check-in: e3968b25 user: dan tags: begin-concurrent)
19:39		Add the json_valid() function to the json1.c extension. Fix various minor problems in the json1.c extension. (check-in: 380a9734 user: drh tags: trunk)
17:28		Add further tests for deferred page allocation. And fixes for the same. (check-in: ed0a31be user: dan tags: begin-concurrent)
07:56		Merge further trunk changes. (check-in: c2327a3b user: dan tags: begin-concurrent)
07:55		Merge trunk changes into this branch. (check-in: 9021f736 user: dan tags: begin-concurrent)
03:05		Fix a couple instances of OOM handling in the json extension. (check-in: 213a6c5c user: drh tags: trunk)
01:32		• Fixed ticket [c2a19d81]: Incorrect LEFT JOIN when FROM clause contains nested subqueries plus 5 other changes (artifact: 05ca3244 user: drh)
01:32		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: 351bc22f user: drh tags: trunk)

15 Years Ago (more context)

2005-08-22
02:10		Update the download page of the website to handle TEA builds and starkits. (CVS 2612) (check-in: 1fab599b user: drh tags: trunk)

20 Years Ago (more context)

2000-08-22
18:30		Version 1.0.3 (CVS 497) (check-in: d35a1f8b user: drh tags: trunk)
18:29		bug fix (CVS 142) (check-in: f255ea6d user: drh tags: trunk)
13:47		:-) (CVS 141) (check-in: 7ecc9c44 user: drh tags: trunk)
13:43		:-) (CVS 140) (check-in: 9d72ceb4 user: drh tags: trunk)
13:40		:-) (CVS 139) (check-in: 67e2da38 user: drh tags: trunk)
13:40		:-) (CVS 138) (check-in: c6b71d9b user: drh tags: trunk)
13:27		:-) (CVS 137) (check-in: 5f6559ee user: drh tags: trunk)