Subject | Re: atomicity of UPDATEs |
---|---|
Author | hvlad |
Post date | 2010-04-15T10:07:05Z |
> Under 2.1.3, the following statement...It is fixed at v2.5. Search in its ReleaseNotes for "Logic Change in SET Clause".
>
> UPDATE tbl SET q = q + 1, p = q;
>
> appears non-atomic to me, seeing two different values for "Q" while
> updating a single row.
Regards,
Vlad