ushiftbits,

wordnum;

if (upper<lower)

returna;

if (lower<0||upper<0)

elog(ERROR,"negative bitmapset member not allowed");

if (lower>upper)

a= (Bitmapset*)palloc0(BITMAPSET_SIZE(uwordnum+1));

a->nwords=uwordnum+1;

}

elseif (uwordnum >=a->nwords)

{

intoldnwords=a->nwords;

inti;

a= (Bitmapset*)repalloc(a,BITMAPSET_SIZE(uwordnum+1));

a->nwords=uwordnum+1;

(7 rows)

drop table coercepart;

CREATE TABLE part (a INT, b INT) PARTITION BY LIST (a);

CREATE TABLE part_p1 PARTITION OF part FOR VALUES IN (-2,-1,0,1,2);

CREATE TABLE part_p2 PARTITION OF part DEFAULT PARTITION BY RANGE(a);

CREATE TABLE part_p2_p1 PARTITION OF part_p2 DEFAULT;

INSERT INTO part VALUES (-1,-1), (1,1), (2,NULL), (NULL,-2),(NULL,NULL);

EXPLAIN (COSTS OFF) SELECT tableoid::regclass as part, a, b FROM part WHERE a IS NULL ORDER BY 1, 2, 3;

QUERY PLAN

---------------------------------------------------------------------------

Sort

Sort Key: ((part_p2_p1.tableoid)::regclass), part_p2_p1.a, part_p2_p1.b

-> Append

-> Seq Scan on part_p2_p1

Filter: (a IS NULL)

(5 rows)

--

-- some more cases

--

droptable coercepart;

CREATETABLEpart (aINT, bINT) PARTITION BY LIST (a);

CREATETABLEpart_p1 PARTITION OF part FORVALUESIN (-2,-1,0,1,2);

CREATETABLEpart_p2 PARTITION OF part DEFAULT PARTITION BY RANGE(a);

CREATETABLEpart_p2_p1 PARTITION OF part_p2 DEFAULT;

INSERT INTO partVALUES (-1,-1), (1,1), (2,NULL), (NULL,-2),(NULL,NULL);

EXPLAIN (COSTS OFF)SELECT tableoid::regclassas part, a, bFROM partWHERE a ISNULLORDER BY1,2,3;