Re: BUG #19898: int4_avg_accum_inv wraps below INT64_MIN instead of raising an error

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: imchifan8(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19898: int4_avg_accum_inv wraps below INT64_MIN instead of raising an error
Date: 2026-11-15 06:54:49
Message-ID: CAApHDvqzQyv8tpwOpZpjymYONzzrxrps13DRL_j2vgJ765mqRw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, 13 Nov 2026 at 21:58, PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
> The issue was reproduced on PostgreSQL 18.6 on Linux/amd64. This occurs when
> an int4 moving aggregate removes a value from a reachable state whose exact
> next sum is below INT64_MIN.

Please share a reproducer showing this happening. (I mean specifically
by using the aggregate function, as you mention in the text above, and
not calling the component function manually.)

David

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zsolt Parragi 2026-11-15 16:15:02 Re: BUG #19897: Recovery fails after "LOG: consistent recovery state reached"
Previous Message Ishjaap Singh 2026-11-15 06:39:45 Re: BUG #19600: pgcrypto crypt() can return text with invalid encoding