Re: BUG #18247: Integer overflow leads to negative width - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #18247: Integer overflow leads to negative width
Date
Msg-id CAMbWs4_8+mtt5C8EXmfHa_Hs-OW6EhEz_XjhzBk8miwg2h65CQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18247: Integer overflow leads to negative width  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #18247: Integer overflow leads to negative width
Re: BUG #18247: Integer overflow leads to negative width
Re: BUG #18247: Integer overflow leads to negative width
List pgsql-bugs

On Thu, Dec 14, 2023 at 10:43 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Guo <guofenglinux@gmail.com> writes:
> On Thu, Dec 14, 2023 at 5:29 PM PG Bug reporting form <
> noreply@postgresql.org> wrote:
>> EXPLAIN SELECT * FROM t;
>> QUERY PLAN
>> ------------------------------------------------------------
>> Seq Scan on t  (cost=0.00..10.00 rows=1 width=-2113929008)
>> (1 row)

> Can we just error out when an overflow occurs?

Probably better to clamp tuple width estimates to MaxAllocSize.
Anything larger would not correspond to reality anyhow.

Fair point.  How about the attached patch?

Thanks
Richard
Attachment

pgsql-bugs by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum
Next
From: RekGRpth
Date:
Subject: Re: BUG #18247: Integer overflow leads to negative width