Do not use the one-pass optimization on an UPDATE if there is a subquery
in the WHERE clause, since if the subquery is hidden behind a short-circuit
operator, the subquery might not be evaluated until after one or more rows
have been updated. Fix for the problem reported by
[forum:/forumpost/
0007d1fdb1|forum post
0007d1fdb1]. This is the same
problem that was fixed by [
73f0036f045bf371] only for UPDATE instead of
DELETE.
FossilOrigin-Name:
2c56b984a0bd3be5ec326a2109ea7b8f1d4ef63c8fc325caac9663cf2479eaff