/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/expected/partition-split.out
229 строк
8 KB
Alexander Korotkov
Implement ALTER TABLE ... SPLIT PARTITION ... command
14 дек 2025, 14:29
14 дек 2025, 14:29
4b3d173
Код
Авторство
О чём код?
Parsed test spec with 2 sessions starting permutation: s1b s1splt s2b s2i s1c s2c s2s step s1b: BEGIN; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2b: BEGIN; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1b s1splt s2brr s2i s1c s2c s2s step s1b: BEGIN; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1b s1splt s2bs s2i s1c s2c s2s step s1b: BEGIN; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2bs: BEGIN ISOLATION LEVEL SERIALIZABLE; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1brr s1splt s2b s2i s1c s2c s2s step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2b: BEGIN; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1brr s1splt s2brr s2i s1c s2c s2s step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1brr s1splt s2bs s2i s1c s2c s2s step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2bs: BEGIN ISOLATION LEVEL SERIALIZABLE; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1bs s1splt s2b s2i s1c s2c s2s step s1bs: BEGIN ISOLATION LEVEL SERIALIZABLE; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2b: BEGIN; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1bs s1splt s2brr s2i s1c s2c s2s step s1bs: BEGIN ISOLATION LEVEL SERIALIZABLE; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1bs s1splt s2bs s2i s1c s2c s2s step s1bs: BEGIN ISOLATION LEVEL SERIALIZABLE; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2bs: BEGIN ISOLATION LEVEL SERIALIZABLE; step s2i: INSERT INTO tpart VALUES (1, 'text01'); <waiting ...> step s1c: COMMIT; step s2i: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 1|text01 tpart_00_10 | 5|text05 tpart_15_20 |15|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (5 rows) starting permutation: s1b s1splt s2b s2u s1c s2c s2s step s1b: BEGIN; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2b: BEGIN; step s2u: UPDATE tpart SET i = 16 where i = 5; <waiting ...> step s1c: COMMIT; step s2u: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_15_20 |15|text15 tpart_15_20 |16|text05 tpart_20_30 |25|text25 tpart_default|35|text35 (4 rows) starting permutation: s1b s1splt s2b s2u2 s1c s2c s2s step s1b: BEGIN; step s1splt: ALTER TABLE tpart SPLIT PARTITION tpart_10_20 INTO (PARTITION tpart_10_15 FOR VALUES FROM (10) TO (15), PARTITION tpart_15_20 FOR VALUES FROM (15) TO (20)); step s2b: BEGIN; step s2u2: UPDATE tpart SET i = 11 where i = 15; <waiting ...> step s1c: COMMIT; step s2u2: <... completed> step s2c: COMMIT; step s2s: SELECT tableoid::regclass, * FROM tpart ORDER BY tableoid::regclass::text COLLATE "C", i; tableoid | i|t -------------+--+------ tpart_00_10 | 5|text05 tpart_10_15 |11|text15 tpart_20_30 |25|text25 tpart_default|35|text35 (4 rows)