]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Fix multiple problems with RETURNING on a DML statement against a view,
authordrh <>
Tue, 28 Mar 2023 11:18:04 +0000 (11:18 +0000)
committerdrh <>
Tue, 28 Mar 2023 11:18:04 +0000 (11:18 +0000)
commit3cbf38c7832e234aab1848e32c104fe345e19e4f
tree6821e5e42b3e349d1c92cd308aed7df4a655cf32
parentfc6c3936aac93d7c47c2780b0254422737a23090
Fix multiple problems with RETURNING on a DML statement against a view,
all inspired by [forum:/forumpost/dc3b92cfa0|forum post dc3b92cfa0].
(1) Do not allow a RETURNING clause to trick the code generator into thinking
that the view being updated has an INSTEAD OF trigger.
(2) Generate all result columns for a view in a DML statement.
(3) The automatic covering index for a view should cover all result columns
of the view.

FossilOrigin-Name: c8bedef0d61731c29ae34de1594222d15b578f9e2cddbbd5b74fb3059644fe0f
manifest
manifest.uuid
src/delete.c
src/insert.c
src/sqliteInt.h
src/trigger.c
src/update.c
src/where.c
test/returning1.test
test/window1.test