Thread: pgsql: Add isolation tests for the combination of EPQ and triggers.
Add isolation tests for the combination of EPQ and triggers. As evidenced by bug #16036 this area is woefully under-tested. Add fairly extensive tests for the combination. Backpatch back to 9.6 - before that isolationtester was not capable enough. While we don't backpatch tests all the time, future fixes to trigger.c would potentially look different enough in 12+ from the earlier branches that introducing bugs during backpatching is more likely than normal. Also, it's just a crucial and undertested area of the code. Author: Andres Freund Discussion: https://postgr.es/m/16036-28184c90d952fb7f@postgresql.org Backpatch: 9.6-, the earliest these tests work Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/54b0feaf90d8c00adb5aa9c094b4f70b509ede0f Modified Files -------------- .../isolation/expected/eval-plan-qual-trigger.out | 2587 ++++++++++++++++++++ src/test/isolation/isolation_schedule | 1 + .../isolation/specs/eval-plan-qual-trigger.spec | 409 ++++ 3 files changed, 2997 insertions(+)