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