diff options
Diffstat (limited to 'src/test/modules/delay_execution/expected/partition-removal-1.out')
| -rw-r--r-- | src/test/modules/delay_execution/expected/partition-removal-1.out | 146 |
1 files changed, 102 insertions, 44 deletions
diff --git a/src/test/modules/delay_execution/expected/partition-removal-1.out b/src/test/modules/delay_execution/expected/partition-removal-1.out index 427f41c9aae..b81b9995e9a 100644 --- a/src/test/modules/delay_execution/expected/partition-removal-1.out +++ b/src/test/modules/delay_execution/expected/partition-removal-1.out @@ -3,121 +3,161 @@ Parsed test spec with 3 sessions starting permutation: s3lock s1b s1exec s2remp s3check s3unlock s3check s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s1b: BEGIN; step s1exec: SELECT * FROM partrem WHERE a <> 1 AND a <> (SELECT 3); <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3check: SELECT * FROM partrem; -a b +a|b +-+--- +1|ABC +3|DEF +(2 rows) -1 ABC -3 DEF step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1exec: <... completed> -a b +a|b +-+--- +2|JKL +(1 row) -2 JKL step s3check: SELECT * FROM partrem; -a b +a|b +-+--- +1|ABC +3|DEF +(2 rows) -1 ABC -3 DEF step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1brr s1exec s2remp s3check s3unlock s3check s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1exec: SELECT * FROM partrem WHERE a <> 1 AND a <> (SELECT 3); <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3check: SELECT * FROM partrem; -a b +a|b +-+--- +1|ABC +3|DEF +(2 rows) -1 ABC -3 DEF step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1exec: <... completed> -a b +a|b +-+--- +2|JKL +(1 row) -2 JKL step s3check: SELECT * FROM partrem; -a b +a|b +-+--- +1|ABC +3|DEF +(2 rows) -1 ABC -3 DEF step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1b s1exec2 s2remp s3unlock s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s1b: BEGIN; step s1exec2: SELECT * FROM partrem WHERE a <> (SELECT 2) AND a <> 1; <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1exec2: <... completed> -a b +a|b +-+--- +3|DEF +(1 row) -3 DEF step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1brr s1exec2 s2remp s3unlock s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1exec2: SELECT * FROM partrem WHERE a <> (SELECT 2) AND a <> 1; <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1exec2: <... completed> -a b +a|b +-+--- +3|DEF +(1 row) -3 DEF step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1brr s1prepare s2remp s1execprep s3unlock s1check s1c s1check s1dealloc step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1prepare: PREPARE ins AS INSERT INTO partrem VALUES ($1, 'GHI'); step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s1execprep: EXECUTE ins(2); <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1execprep: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+--- +2|GHI +(1 row) -2 GHI step s1c: COMMIT; step s2remp: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+- +(0 rows) step s1dealloc: DEALLOCATE ins; @@ -127,49 +167,67 @@ step s1prepare: PREPARE ins AS INSERT INTO partrem VALUES ($1, 'GHI'); step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s1execprep: EXECUTE ins(2); <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1execprep: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+--- +2|GHI +(1 row) -2 GHI step s1c: COMMIT; step s2remp: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+- +(0 rows) step s1dealloc: DEALLOCATE ins; starting permutation: s1brr s1check s3lock s2remp s1prepare s1execprep s3unlock s1check s1c s1check s1dealloc step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+- +(0 rows) step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock +---------------- + +(1 row) - step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s1prepare: PREPARE ins AS INSERT INTO partrem VALUES ($1, 'GHI'); step s1execprep: EXECUTE ins(2); <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock +------------------ +t +(1 row) -t step s1execprep: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+--- +2|GHI +(1 row) -2 GHI step s1c: COMMIT; step s2remp: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; -a b +a|b +-+- +(0 rows) step s1dealloc: DEALLOCATE ins; |