0004-tweak-test_decoding-tests-20211222.patch

text/x-patch
Download
Filename: 0004-tweak-test_decoding-tests-20211222.patch
Type: text/x-patch
Part: 3
Message: Re: logical decoding and replication of sequences
Patch

Format: format-patch
Series: patch 0004
Subject: tweak test_decoding tests
File	+	−
contrib/test_decoding/expected/sequence.out	29	19
From ee0f4ffe25d6ced57cd2822616ceb131407aeb5d Mon Sep 17 00:00:00 2001
From: Tomas Vondra <tomas.vondra@postgresql.org>
Date: Wed, 22 Dec 2021 03:53:10 +0100
Subject: [PATCH 4/6] tweak test_decoding tests

---
 contrib/test_decoding/expected/sequence.out | 48 +++++++++++++--------
 1 file changed, 29 insertions(+), 19 deletions(-)

diff --git a/contrib/test_decoding/expected/sequence.out b/contrib/test_decoding/expected/sequence.out
index c3c2a18a35..971373e083 100644
--- a/contrib/test_decoding/expected/sequence.out
+++ b/contrib/test_decoding/expected/sequence.out
@@ -93,13 +93,16 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc
  BEGIN
  sequence public.test_sequence: transactional:1 last_value:1 log_cnt:0 is_called:0
  COMMIT
- sequence public.test_sequence: transactional:0 last_value:33 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:1 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:2 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:3 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:4 log_cnt:0 is_called:1
  BEGIN
  sequence public.test_sequence: transactional:1 last_value:4 log_cnt:0 is_called:1
  COMMIT
- sequence public.test_sequence: transactional:0 last_value:334 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:14 log_cnt:0 is_called:1
  BEGIN
- sequence public.test_sequence: transactional:1 last_value:14 log_cnt:32 is_called:1
+ sequence public.test_sequence: transactional:1 last_value:14 log_cnt:0 is_called:1
  COMMIT
  BEGIN
  sequence public.test_sequence: transactional:1 last_value:14 log_cnt:0 is_called:1
@@ -107,14 +110,14 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc
  BEGIN
  sequence public.test_sequence: transactional:1 last_value:4000 log_cnt:0 is_called:0
  COMMIT
- sequence public.test_sequence: transactional:0 last_value:4320 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:4000 log_cnt:0 is_called:1
  sequence public.test_sequence: transactional:0 last_value:3500 log_cnt:0 is_called:1
- sequence public.test_sequence: transactional:0 last_value:3830 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:3510 log_cnt:0 is_called:1
  sequence public.test_sequence: transactional:0 last_value:3500 log_cnt:0 is_called:1
- sequence public.test_sequence: transactional:0 last_value:3830 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:0 last_value:3510 log_cnt:0 is_called:1
  sequence public.test_sequence: transactional:0 last_value:3500 log_cnt:0 is_called:0
- sequence public.test_sequence: transactional:0 last_value:3820 log_cnt:0 is_called:1
-(24 rows)
+ sequence public.test_sequence: transactional:0 last_value:3500 log_cnt:0 is_called:1
+(27 rows)
 
 DROP SEQUENCE test_sequence;
 -- rollback on sequence creation and update
@@ -226,7 +229,7 @@ ROLLBACK;
 SELECT * from test_table_a_seq;
  last_value | log_cnt | is_called 
 ------------+---------+-----------
-       3003 |      30 | t
+       3003 |       0 | t
 (1 row)
 
 SELECT nextval('test_table_a_seq');
@@ -242,12 +245,17 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc
  BEGIN
  sequence public.test_table_a_seq: transactional:1 last_value:1 log_cnt:0 is_called:0
  COMMIT
- sequence public.test_table_a_seq: transactional:0 last_value:33 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:1 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:2 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:3 log_cnt:0 is_called:1
  sequence public.test_table_a_seq: transactional:0 last_value:3000 log_cnt:0 is_called:1
- sequence public.test_table_a_seq: transactional:0 last_value:3033 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:3001 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:3002 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:3003 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:0 last_value:3004 log_cnt:0 is_called:1
  BEGIN
  COMMIT
-(8 rows)
+(13 rows)
 
 -- savepoint test on table with serial column
 BEGIN;
@@ -260,15 +268,17 @@ ROLLBACK TO SAVEPOINT a;
 DROP TABLE test_table;
 COMMIT;
 SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '0', 'skip-sequences', '0');
-                                         data                                          
----------------------------------------------------------------------------------------
+                                         data                                         
+--------------------------------------------------------------------------------------
  BEGIN
  sequence public.test_table_a_seq: transactional:1 last_value:1 log_cnt:0 is_called:0
- sequence public.test_table_a_seq: transactional:1 last_value:33 log_cnt:0 is_called:1
+ sequence public.test_table_a_seq: transactional:1 last_value:1 log_cnt:0 is_called:1
  table public.test_table: INSERT: a[integer]:1 b[integer]:100
+ sequence public.test_table_a_seq: transactional:1 last_value:2 log_cnt:0 is_called:1
  table public.test_table: INSERT: a[integer]:2 b[integer]:200
+ sequence public.test_table_a_seq: transactional:1 last_value:3 log_cnt:0 is_called:1
  COMMIT
-(6 rows)
+(8 rows)
 
 -- savepoint test on table with serial column
 BEGIN;
@@ -303,7 +313,7 @@ ROLLBACK TO SAVEPOINT a;
 SELECT * FROM test_sequence;
  last_value | log_cnt | is_called 
 ------------+---------+-----------
-       3001 |      32 | t
+       3001 |       0 | t
 (1 row)
 
 DROP SEQUENCE test_sequence;
@@ -313,9 +323,9 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc
 --------------------------------------------------------------------------------------
  BEGIN
  sequence public.test_sequence: transactional:1 last_value:1 log_cnt:0 is_called:0
- sequence public.test_sequence: transactional:1 last_value:33 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:1 last_value:1 log_cnt:0 is_called:1
  sequence public.test_sequence: transactional:1 last_value:3000 log_cnt:0 is_called:1
- sequence public.test_sequence: transactional:1 last_value:3033 log_cnt:0 is_called:1
+ sequence public.test_sequence: transactional:1 last_value:3001 log_cnt:0 is_called:1
  COMMIT
 (6 rows)
 
-- 
2.31.1