Re: BUG #19405: Assertion in eval_windowaggregates() fails due to integer overflow

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tender Wang <tndrwang(at)gmail(dot)com>
Cc: exclusion(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19405: Assertion in eval_windowaggregates() fails due to integer overflow
Date: 2026-02-17 01:55:30
Message-ID: CAMbWs4-stRKsWK6JXYn1eaR1JJzxAeF7QULQ-=0mJFX9k4RFzA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Feb 15, 2026 at 5:48 PM Tender Wang <tndrwang(at)gmail(dot)com> wrote:
> v2 seems to cover all cases. WFM.
>
> In window.sql, we don't have a test case for this issue. I think we
> should add it to the window.sql

I've included test cases covering the overflow scenarios for ROWS mode
in v3. (I failed to come up with queries for GROUPS mode that
demonstrate the bug, but I suspect I just haven't found the right test
case yet.) I have also included a commit message.

- Richard

Attachment Content-Type Size
v3-0001-Fix-integer-overflow-in-nodeWindowAgg.c.patch application/octet-stream 8.3 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Noah Misch 2026-02-17 04:20:43 Re: BUG #19406: substring(text) fails on valid UTF-8 toasted value in PostgreSQL 15.16
Previous Message PG Bug reporting form 2026-02-16 20:44:35 BUG #19411: libpq 16.x exhibits a memory leak when connections are repeatedly created and destroyed