/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/expected/partition-concurrent-attach.out
54 строки
2 KB
Tom Lane
Improve display of query results in isolation tests.
23 июн 2021, 18:13
23 июн 2021, 18:13
4a05406
Код
Авторство
О чём код?
Parsed test spec with 2 sessions starting permutation: s1b s1a s2b s2i s1c s2c s2s step s1b: begin; step s1a: alter table tpart attach partition tpart_2 for values from (100) to (200); step s2b: begin; step s2i: insert into tpart values (110,'xxx'), (120, 'yyy'), (150, 'zzz'); <waiting ...> step s1c: commit; step s2i: <... completed> ERROR: new row for relation "tpart_default" violates partition constraint step s2c: commit; step s2s: select tableoid::regclass, * from tpart; tableoid| i|j --------+---+--- tpart_2 |110|xxx tpart_2 |120|yyy tpart_2 |150|zzz (3 rows) starting permutation: s1b s1a s2b s2i2 s1c s2c s2s step s1b: begin; step s1a: alter table tpart attach partition tpart_2 for values from (100) to (200); step s2b: begin; step s2i2: insert into tpart_default (i, j) values (110, 'xxx'), (120, 'yyy'), (150, 'zzz'); <waiting ...> step s1c: commit; step s2i2: <... completed> ERROR: new row for relation "tpart_default" violates partition constraint step s2c: commit; step s2s: select tableoid::regclass, * from tpart; tableoid| i|j --------+---+--- tpart_2 |110|xxx tpart_2 |120|yyy tpart_2 |150|zzz (3 rows) starting permutation: s1b s2b s2i s1a s2c s1c s2s step s1b: begin; step s2b: begin; step s2i: insert into tpart values (110,'xxx'), (120, 'yyy'), (150, 'zzz'); step s1a: alter table tpart attach partition tpart_2 for values from (100) to (200); <waiting ...> step s2c: commit; step s1a: <... completed> ERROR: updated partition constraint for default partition "tpart_default_default" would be violated by some row step s1c: commit; step s2s: select tableoid::regclass, * from tpart; tableoid | i|j ---------------------+---+--- tpart_default_default|110|xxx tpart_default_default|120|yyy tpart_default_default|150|zzz (3 rows)