Re: pgsql: Fix crash in BRIN inclusion op functions, due to missingdatum c - Mailing list pgsql-hackers

On 2020-Jan-20, Heikki Linnakangas wrote:

> That case arises at least with the range_union() function, when one of
> the arguments is an 'empty' range:
> 
> CREATE TABLE brintest (n numrange);
> CREATE INDEX brinidx ON brintest USING brin (n);
> INSERT INTO brintest VALUES ('empty');
> INSERT INTO brintest VALUES (numrange(0, 2^1000::numeric));
> INSERT INTO brintest VALUES ('(-1, 0)');
> 
> SELECT brin_desummarize_range('brinidx', 0);
> SELECT brin_summarize_range('brinidx', 0);

I noticed that this test increases line-wise coverage of
brin_inclusion.c by a few percentage points, so I added it.

Again, thanks

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services