GiST multirange index scans can fail to return rows

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
GiST multirange index scans can fail to return rows
Дата
в 18:01:52
Msg-id
CAH2-Wzm1GpQ9qixP=Xs2TYdfnLM88OZ=yUFHNuajS_W7U90-tQ@mail.gmail.com
Список
Дерево обсуждения
GiST multirange index scans can fail to return rows Peter Geoghegan <pg@bowt.ie>
The attached regression test patch (written by Claude Code) shows that
a GiST index on a multirange column can fail to return rows during
scans that use the contained-by operator.

The multirangetypes test already runs every GiST query twice, once
with a sequential scan and once with the index, and the two must
agree. The added query asks for rows contained in
'{[1,11),[21,31),[41,51)}', which is a value the test table already
contains. The sequential scan returns 501 and the index scan returns
500. The row it loses has a multirange that exactly matches the one
from the query.

The multirange GiST support was added by db6335b5b. This is an issue
on 14 and up.

-- 
Peter Geoghegan
В списке pgsql-hackers по дате отправления
От: Chengpeng Yan
Дата:
От: Pierre Forstmann
Дата:
FAQ