Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements
Date
Msg-id ZIqZUKZ/PpMfbqXT@paquier.xyz
Whole thread Raw
In response to Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements  (Alexander Lakhin <exclusion@gmail.com>)
List 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

Attachment

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #17975: Nested Loop Index Scan returning wrong result
Next
From: Richard Guo
Date:
Subject: Re: BUG #17976: Inconsistent results of SELECT using CASE WHEN clause