src/test/singlenode_isolation2/sql/gdd/delete-deadlock-root-leaf-concurrent-op.sql

DROP TABLE IF EXISTS part_tbl;
CREATE TABLE part_tbl (a int, b int, c int) PARTITION BY RANGE(b) (START(1) END(2) EVERY(1));
INSERT INTO part_tbl SELECT i, 1, i FROM generate_series(1,100)i;

-- check gdd is enabled
show gp_enable_global_deadlock_detector;
1:BEGIN;
1:DELETE FROM part_tbl_1_prt_1 WHERE c = segid(2,1);

2:BEGIN;
2:DELETE FROM part_tbl WHERE c = segid(1,1);

-- the below delete will wait to acquire the transaction lock to delete the tuple
-- held by Session 2
1&:DELETE FROM part_tbl_1_prt_1 WHERE c = segid(1,1);

-- the below delete will wait to acquire the transaction lock to delete the tuple
-- held by Session 1
--
-- It is possible that GDD gets triggered immediately, so use '2>:' instead of
-- '2&:' for stable output.
2>:DELETE FROM part_tbl WHERE c = segid(2,1);

1<:
2<:

-- since gdd is on, Session 2 will be cancelled.

1:ROLLBACK;
2:ROLLBACK;
DROP TABLE IF EXISTS part_tbl;