Re: Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level"

2021-08-18 Thread radiodiversion
versions of rows to see if they still match the search condition. Note that this is different from re-executing the command." I tried to explain as best I could. Of course, I dare not insist on anything. thanks! On Wed, 18 Aug 2021 at 03:47, David G. Johnston wrote: > On Tue, Aug 17, 20

Re: Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level"

2021-08-18 Thread radiodiversion
- i.e., it will happily skip a row it thought, before it started > waiting, that it was going to have to update but it will not go looking for > new rows that now may match the criteria. It also won't handle any inserts > by the same reasoning. This is reinforced by the leading sentence: > > "...they will only find target rows that were committed as of the command > start time." > > David J. > -- with best regards, radiodiversion