Horton

Add isolation test for INSERT ON CONFLICT speculative insertion failure.

Andres Freund <andres@anarazel.de>

View on postgr.es
Commit: 05cf41973157577aac9706dcc7998054949b0ed4
Author: Andres Freund <andres@anarazel.de>
Date: 2019-05-14T18:53:54Z
Releases: 11.4 
Add isolation test for INSERT ON CONFLICT speculative insertion failure.

This path previously was not reliably covered. There was some
heuristic coverage via insert-conflict-toast.spec, but that test is
not deterministic, and only tested for a somewhat specific bug.

Backpatch, as this is a complicated and otherwise untested code
path. Unfortunately 9.5 cannot handle two waiting sessions, and thus
cannot execute this test.

Triggered by a conversion with Melanie Plageman.

Author: Andres Freund
Discussion: https://postgr.es/m/CAAKRu_a7hbyrk=wveHYhr4LbcRnRCG=yPUVoQYB9YO1CdUBE9Q@mail.gmail.com
Backpatch: 9.5-

Files

PathChange+/−
src/test/isolation/expected/insert-conflict-specconflict.out added +179 −0
src/test/isolation/isolation_schedule modified +1 −0
src/test/isolation/specs/insert-conflict-specconflict.spec added +149 −0

Discussion