]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Do not use the one-pass optimization on an UPDATE if there is a subquery
authordrh <>
Thu, 16 Mar 2023 10:17:30 +0000 (10:17 +0000)
committerdrh <>
Thu, 16 Mar 2023 10:17:30 +0000 (10:17 +0000)
commit7d5a5491215eb48acba22a81067aae2661bb2fd6
tree8680f1df9f8c4decf1f2dc4112d2db3520b48b39
parent5531316dd030b320c5653454bc2dcec23bf261b2
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
manifest
manifest.uuid
src/update.c
test/corruptL.test
test/delete.test
test/update.test