/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/test_decoding/expected/invalidation_distribution.out
40 строк
1 KB
Masahiko Sawada
Fix re-distributing previously distributed invalidation messages during logical decoding.
17 июн 2025, 03:36
17 июн 2025, 03:36
d87d07b
Код
Авторство
О чём код?
Parsed test spec with 3 sessions starting permutation: s1_insert_tbl1 s1_begin s1_insert_tbl1 s2_alter_pub_add_tbl s1_commit s1_insert_tbl1 s2_get_binary_changes step s1_insert_tbl1: INSERT INTO tbl1 (val1, val2) VALUES (1, 1); step s1_begin: BEGIN; step s1_insert_tbl1: INSERT INTO tbl1 (val1, val2) VALUES (1, 1); step s2_alter_pub_add_tbl: ALTER PUBLICATION pub ADD TABLE tbl1; step s1_commit: COMMIT; step s1_insert_tbl1: INSERT INTO tbl1 (val1, val2) VALUES (1, 1); step s2_get_binary_changes: SELECT count(data) FROM pg_logical_slot_get_binary_changes('isolation_slot', NULL, NULL, 'proto_version', '4', 'publication_names', 'pub') WHERE get_byte(data, 0) = 73; count ----- 1 (1 row) ?column? -------- stop (1 row) starting permutation: s1_begin s1_insert_tbl1 s3_begin s3_insert_tbl1 s2_alter_pub_add_tbl s1_insert_tbl1 s1_commit s3_commit s2_get_binary_changes step s1_begin: BEGIN; step s1_insert_tbl1: INSERT INTO tbl1 (val1, val2) VALUES (1, 1); step s3_begin: BEGIN; step s3_insert_tbl1: INSERT INTO tbl1 (val1, val2) VALUES (2, 2); step s2_alter_pub_add_tbl: ALTER PUBLICATION pub ADD TABLE tbl1; step s1_insert_tbl1: INSERT INTO tbl1 (val1, val2) VALUES (1, 1); step s1_commit: COMMIT; step s3_commit: COMMIT; step s2_get_binary_changes: SELECT count(data) FROM pg_logical_slot_get_binary_changes('isolation_slot', NULL, NULL, 'proto_version', '4', 'publication_names', 'pub') WHERE get_byte(data, 0) = 73; count ----- 1 (1 row) ?column? -------- stop (1 row)