partition-eval-plan-qual.spec

text/plain

Filename: partition-eval-plan-qual.spec
Type: text/plain
Part: 0
Message: Re: BUG #15677: Crash while deleting from partitioned table
setup {
create table p (a int) partition by list (a);
create table p1 partition of p for values in (1);
insert into p values (1);
}

session "s1"
setup 				{ begin; }
step "s1_update"	{ update p set a = a; }
step "s1_commit"	{ commit; }

session "s2"
step "s2_update"	{ with u as (update p set a = a returning p.*) update p set a = u.a from u; }

permutation "s1_update" "s2_update" "s1_commit"