Correct logical decoding restore behaviour for subtransactions.
Before initializing iteration over a subtransaction's changes, the last
few changes were not spilled to disk. That's correct if the transaction
didn't spill to disk, but otherwise... This bug can lead to missed or
misorderd subtransaction contents when they were spilled to disk.
Move spilling of the remaining in-memory changes to
ReorderBufferIterTXNInit(), where it can easily be applied to the top
transaction and, if present, subtransactions.
Since this code had too many bugs already, noticeably increase test
coverage.
Fixes: #14319
Reported-By: Huan Ruan
Discussion: <20160909012610.20024.58169@wrigleys.postgresql.org>
Backport: 9,4-, where logical decoding was added
Branch
------
REL9_6_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/76c0b73df6c481a29cf6e45bebeafd6d71957f08
Modified Files
--------------
contrib/test_decoding/Makefile | 3 +-
contrib/test_decoding/expected/spill.out | 256 ++++++++++++++++++++++++
contrib/test_decoding/sql/spill.sql | 179 +++++++++++++++++
src/backend/replication/logical/reorderbuffer.c | 13 +-
4 files changed, 445 insertions(+), 6 deletions(-)