]> git.ipfire.org Git - thirdparty/sqlite.git/commit
For UPDATE and DELETE, use OP_DeferredSeek always. If the seek must later
authordrh <drh@noemail.net>
Fri, 14 Aug 2020 20:04:26 +0000 (20:04 +0000)
committerdrh <drh@noemail.net>
Fri, 14 Aug 2020 20:04:26 +0000 (20:04 +0000)
commit68c0c71065354a2c06e3283f0a2f1758afec5aba
tree7c453f11bab6677bf021140d75d5603d46d5484f
parent5e6d90fe15e0c8be357008f9e5ff6afba0662c0b
For UPDATE and DELETE, use OP_DeferredSeek always.  If the seek must later
be resolved, add the OP_FinishSeek opcode after all WHERE clause terms have
been processed.  This obviates the need for the WHERE_SEEK_TABLE and
WHERE_SEEK_UNIQ_TABLE flags to sqlite3WhereBegin() and the ensuing
complication, and it allows the covering index optimization to be used
further into WHERE clause processing.

FossilOrigin-Name: a495f60d315e34b1a1bc5fb1336e05047add52c8fb2710b577c97b10a5e734f6
manifest
manifest.uuid
src/delete.c
src/sqliteInt.h
src/update.c
src/wherecode.c