Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements
Дата
Msg-id ZIqZUKZ/PpMfbqXT@paquier.xyz
обсуждение исходный текст
Ответ на Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements  (Alexander Lakhin <exclusion@gmail.com>)
Список pgsql-bugs
On Wed, Jun 14, 2023 at 01:21:40PM +0900, Michael Paquier wrote:
> Likely that's something we'd better backpatch, to avoid people playing
> with that too much in the back-branches.  Thoughts or objections?

Well, we could perhaps revisit the choice of 08ee64e to remove the
LEAF flag from the data stored.  However, seeing the lack of
complaints for the past 18 years with users storing large arrays under
gist__int_ops, spending more time on this is not really appealing,
either.  Or we would have heard about that because the decompression
immediately breaks for this case.

I have spent some time on that today, and applied what has been
suggested to restrict the usage of this operator when inserting data
for a leaf page, so as the decompression does not get crazy when
retrieving the contents of the leaf pages.
--
Michael

Вложения

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BUG #17975: Nested Loop Index Scan returning wrong result
Следующее
От: Richard Guo
Дата:
Сообщение: Re: BUG #17976: Inconsistent results of SELECT using CASE WHEN clause