errmsg("range partition key of row contains null")));

}

if (partdesc->boundinfo->has_null&&isnull[0])

cur_index=-1;

if (isnull[0]&&partdesc->boundinfo->has_null)

cur_index=partdesc->boundinfo->null_index;

{

boolequal= false;

insert into mlparted1 (a, b) values (2, 3);

ERROR: new row for relation "mlparted11" violates partition constraint

DETAIL: Failing row contains (3, 2).

-- check routing error through a list partitioned table when the key is null

create table lparted_nonullpart (a int, b char) partition by list (b);

create table lparted_nonullpart_a partition of lparted_nonullpart for values in ('a');

insert into lparted_nonullpart values (1);

ERROR: no partition of relation "lparted_nonullpart" found for row

DETAIL: Partition key of the failing row contains (b) = (null).

drop table lparted_nonullpart;

-- check that RETURNING works correctly with tuple-routing

alter table mlparted drop constraint check_b;

create table mlparted12 partition of mlparted1 for values from (5) to (10);

insert into mlparted1 (a, b)values (2,3);

createtablelparted_nonullpart (aint, bchar) partition by list (b);

createtablelparted_nonullpart_a partition of lparted_nonullpart forvaluesin ('a');

insert into lparted_nonullpartvalues (1);

droptable lparted_nonullpart;

altertable mlparted dropconstraint check_b;

createtablemlparted12 partition of mlparted1 forvaluesfrom (5) to (10);