/ Check-in [529fb55e3d]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment: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].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 529fb55e3d00472f13446117527b0896827b11e870b581af7fe7cbb7392ef3cd
User & Date: drh 2018-08-14 15:12:52
Context
2018-08-15
14:03
Allow sqlite3_snapshot_open() to be called to change the snapshot after a read transaction is already open on database. check-in: 4139916995 user: dan tags: trunk
2018-08-14
18:12
Merge fixes and enhancements from trunk. check-in: dff0314b7e user: drh tags: alter-table-rename-column
15:12
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]. check-in: 529fb55e3d user: drh tags: trunk
2018-08-13
22:50
Stop requiring the global VFS mutex to access the unixInodeInfo.pUnused field. The unixInodeInfo mutex is sufficient. check-in: e3ea43dabf user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/insert.c.

Changes to src/vdbe.h.

Changes to src/vdbeaux.c.

Changes to test/upsert1.test.