Re: pgsql: Fix crash in BRIN inclusion op functions, due to missingdatum c

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pgsql: Fix crash in BRIN inclusion op functions, due to missingdatum c
Дата
Msg-id 20200122214536.GA3912@alvherre.pgsql
обсуждение исходный текст
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dmitry Dolgov
Дата:
Сообщение: Re: Index Skip Scan
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: A rather hackish POC for alternative implementation of WITH TIES