]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Fix UPSERT so that it checks the target-constraint first and fires the
authordrh <drh@noemail.net>
Tue, 14 Aug 2018 15:12:52 +0000 (15:12 +0000)
committerdrh <drh@noemail.net>
Tue, 14 Aug 2018 15:12:52 +0000 (15:12 +0000)
commit8430450674663fc453e10d78d942df9cc851da7f
tree751ddcef772d29acc44ae1a17a23574ef47d7e28
parentef52b36a6b7401c44e5031fd14ded929b93076e8
Fix UPSERT so that it checks the target-constraint first and fires the
DO UPDATE if that constraint is violated regardless of whether or not
other constraints are in violation.  This aligns SQLite behavior with
what PostgreSQL does. Fix for ticket [908f001483982c43cdb476dfb590a1a].

FossilOrigin-Name: 529fb55e3d00472f13446117527b0896827b11e870b581af7fe7cbb7392ef3cd
manifest
manifest.uuid
src/insert.c
src/vdbe.h
src/vdbeaux.c
test/upsert1.test