src/test/singlenode_isolation2/sql/gdd/dist-deadlock-01.sql

DROP TABLE IF EXISTS t01;
CREATE TABLE t01 (id int, val int);
INSERT INTO t01 (id, val) SELECT i, i FROM generate_series(1, 100) i;

-- gang creation order is important, reset any guc to force the creation
10: RESET optimizer;
20: RESET optimizer;

10: BEGIN;
20: BEGIN;

10: UPDATE t01 SET val=val WHERE id=segid(0,1);

20: UPDATE t01 SET val=val WHERE id=segid(1,1);
-- seg 0: con20 ==> con10, xid lock
20&: UPDATE t01 SET val=val WHERE id=segid(0,1);

-- seg 1: con10 ==> con20, xid lock
10>: UPDATE t01 SET val=val WHERE id=segid(1,1);

-- con20 will be cancelled by gdd
20<:
20q:

-- no more deadlock
10<:
10q: