Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows
Дата
Msg-id 1068521.1623967448@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows
Список pgsql-bugs
Alexander Korotkov <aekorotkov@gmail.com> writes:
> On Thu, Jun 17, 2021 at 10:49 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> we need to add some code that checks for default searchMode, and in
>> that case doesn't call the consistentFn unless at least one
>> (non-MAYBE) input is TRUE.

> I think in default search mode we can just start with curResult equal
> to GIN_FALSE instead of calling directBoolConsistentFn().

No, it's not that simple, because there might be other keys that are
TRUE not MAYBE.  So the result could legitimately be TRUE in this case.

BTW, I think it'd be a really good idea for this function to restore
all the MAYBE entries to GIN_MAYBE before returning, so that you can
remove the caveat that it destroys the contents of entryRes[].  I have
basically zero faith that that's safe, and it seems pretty cheap to
not have to make the assumption.

            regards, tom lane



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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows