SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v5, Patch count: 1, First patch: +224−11, All patches: +224−11

Tags

Bugfix

Created

2026-08-28 21:02:42

Last modified

2026-08-31 11:36:25 (1 week ago)

Latest email

2026-09-12 18:01:21 (17 hours ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Ready for Committer

Target version

Authors

Zsolt Parragi (zsolt.parragi)

Reviewers

Become reviewer

Committer

Links

Emails

SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row: First at 2026-08-19 11:33:01 by Zsolt Parragi <zsolt.parragi at percona.com>
Latest at 2026-09-12 18:01:21 by Andrey Borodin <x4mmm at yandex-team.ru>
Latest attachment (v5-0001-Fix-missing-SIREAD-lock-on-the-row-found-by-ON-CO.patch) at 2026-09-12 10:34:21 from Dean Rasheed <dean.a.rasheed at gmail.com>
    Attachment (v5-0001-Fix-missing-SIREAD-lock-on-the-row-found-by-ON-CO.patch) at 2026-09-12 10:34:21 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: No)
    Attachment (v4-0001-Fix-missing-SIREAD-lock-on-the-row-found-by-ON-CO.patch) at 2026-09-10 07:18:49 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (v3-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-25 22:38:35 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (v2-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-19 19:32:48 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-SELE.patch) at 2026-08-19 11:33:01 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)

History

When	Who	What
2026-08-31 11:36:25	Andrey Borodin (x4m)	New status: Ready for Committer
2026-08-28 21:02:42	Zsolt Parragi (zsolt.parragi)	Attached mail thread CAN4CZFM1GkHJkpMeo4G5rxtacVsfeKCJYiik9E9AKX1E9VYQ1w@mail.gmail.com
2026-08-28 21:02:42	Zsolt Parragi (zsolt.parragi)	Created patch record