Обсуждение: pgsql: Add an SSI regression test that tests all interesting permutatio

Поиск
Список
Период
Сортировка

pgsql: Add an SSI regression test that tests all interesting permutatio

От
Heikki Linnakangas
Дата:
Add an SSI regression test that tests all interesting permutations in the
order of begin, prepare, and commit of three concurrent transactions that
have conflicts between them.

The test runs for a quite long time, and the expected output file is huge,
but this test caught some serious bugs during development, so seems
worthwhile to keep. The test uses prepared transactions, so it fails if the
server has max_prepared_transactions=0. Because of that, it's marked as
"ignore" in the schedule file.

Dan Ports

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/af35737313f92fcbe227baf51bb69b8650acc41a

Modified Files
--------------
.../isolation/expected/prepared-transactions.out   |34843 ++++++++++++++++++++
src/test/isolation/isolation_schedule              |    5 +
src/test/isolation/isolationtester.c               |   12 +-
.../isolation/specs/prepared-transactions.spec     | 1507 +
4 files changed, 36365 insertions(+), 2 deletions(-)