[PATCH] fix GIN index search sometimes losing results

Поиск
Список
Период
Сортировка
От Pavel Borisov
Тема [PATCH] fix GIN index search sometimes losing results
Дата
Msg-id CALT9ZEE-aLotzBg-pOp2GFTesGWVYzXA3=mZKzRDa_OKnLF7Mg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PATCH] fix GIN index search sometimes losing results  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi, all

It appeared than GIN index sometimes lose results if simultaneously:


1 if query operand contains weight marks 

2 if weight-marked operand is negated by ! operator

3 if there are only logical (not phrase) operators from this negation towards the root of query tree. 


e.g. '!crew:A'::tsquery refuse to find 'crew:BCD'::tsvector


Seems it is in all versions of PG.


The patch is intended to deal with the issue. Also it contains tests for these rare condition.


Pavel Borisov.

 

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PG compilation error with Visual Studio 2015/2017/2019
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PG 13 release notes, first draft