1Parsed test spec with 3 sessions
2
3starting permutation: s0init s0start s1begin s1sharepgclass s2begin s2sharepgclass s0w s0start s2commit s1commit
4step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
5?column?
6--------
7init
8(1 row)
9
10step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
11data
12----
13(0 rows)
14
15step s1begin: BEGIN;
16step s1sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
17?column?
18--------
19t
20(1 row)
21
22step s2begin: BEGIN;
23step s2sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
24?column?
25--------
26t
27(1 row)
28
29step s0w: INSERT INTO do_write DEFAULT VALUES;
30step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
31data
32--------------------------------------------
33BEGIN
34table public.do_write: INSERT: id[integer]:1
35COMMIT
36(3 rows)
37
38step s2commit: COMMIT;
39step s1commit: COMMIT;
40?column?
41--------
42stop
43(1 row)
44
45
46starting permutation: s0init s0start s1begin s1keysharepgclass s2begin s2keysharepgclass s0alter s0w s0start s2commit s1commit
47step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
48?column?
49--------
50init
51(1 row)
52
53step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
54data
55----
56(0 rows)
57
58step s1begin: BEGIN;
59step s1keysharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR KEY SHARE) s;
60?column?
61--------
62t
63(1 row)
64
65step s2begin: BEGIN;
66step s2keysharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR KEY SHARE) s;
67?column?
68--------
69t
70(1 row)
71
72step s0alter: ALTER TABLE do_write ADD column ts timestamptz;
73step s0w: INSERT INTO do_write DEFAULT VALUES;
74step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
75data
76------------------------------------------------------------------------------
77BEGIN
78COMMIT
79BEGIN
80table public.do_write: INSERT: id[integer]:1 ts[timestamp with time zone]:null
81COMMIT
82(5 rows)
83
84step s2commit: COMMIT;
85step s1commit: COMMIT;
86?column?
87--------
88stop
89(1 row)
90
91