Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wh4Vl-0001uS-1V
	for pgsql-bugs@arkaria.postgresql.org;
	Tue, 07 Jul 2026 12:02:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wh4Vj-000ZB0-1s
	for pgsql-bugs@arkaria.postgresql.org;
	Tue, 07 Jul 2026 12:02:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1wh4Vj-000ZAr-0u
	for pgsql-bugs@lists.postgresql.org;
	Tue, 07 Jul 2026 12:02:48 +0000
Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1wh4Vh-000000001xc-0ZZ4
	for pgsql-bugs@lists.postgresql.org;
	Tue, 07 Jul 2026 12:02:47 +0000
Received: by mail-wm1-x335.google.com with SMTP id
 5b1f17b1804b1-493b77b150aso37390495e9.2
        for <pgsql-bugs@lists.postgresql.org>;
 Tue, 07 Jul 2026 05:02:45 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1783425763; cv=none;
        d=google.com; s=arc-20260327;
        b=V1d/1Vu/GLHsvsm6Ew0VbtLzuyCPZhchR3/dqUoxhD3GvggzOu02pW4Q9kEIiqJMu9
         dMdmh6rh7GXGlL+rcdKcItg4v0Pr+foMeDgzQrpJQqzSoIS4ma3k3/kP1u2ONvHEEClN
         OwU1nI/yC4Sx62pNzSIAGq71xSbLcZal3n0D03LdEZRdnIOZKtUsdpTXmL8HSvoTxBRe
         1cCVwcpEt3dBaz7xmoCPJmowK1AHC3ozeQowZb/WU9q6WZde0coTy2QOiofuYa2vumHX
         Gv/Fc2Hm7ePyIhQ4t4KkMQl7v8I6TvOTZM0O5LuX/8/vr/SlbwhL0xdexn2fl7ApUpOO
         OAJg==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20260327;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:dkim-signature;
        bh=EK7BJTtKs5D5H9vG3Trzs2dmELsX5vsPHgtjSU+FpU4=;
        fh=aX7ac7PFe1UhKbanNy0fC7PciE7Sycy21gjTzQgLrnY=;
        b=P3nFp79BBhrnjfVTw/ex8E0E+to1cUsOfN2AiZyeuiAWACsS6oCc3XumXYA4D13HJ3
         5Ud6kfrUj/TbONhwZEHxDZAbGsQmPKWoTvfcrXuiPdvrYfDyfDfCjDZIu2VklCpjIUnl
         JM2BY18K5I3UC3KMvb+QPZmYPduLPY5tY96Qv311SjqnH8EacFWAYZta6tpM/AG9gRtu
         bnfGWj6proGVPSRmV4Il4mcou1fK/vM1+d14GnN5fwyzuqJwuSH4CrlKK5LUEcczZW8P
         mm1qKD/jfpNViTwYv4g8GXA5oYbYzdBwoBPguSGOTTBkpkxQ9JAqNT9C0KjM2xW0/2ih
         pPGg==;
        darn=lists.postgresql.org
ARC-Authentication-Results: i=1; mx.google.com; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20251104; t=1783425763; x=1784030563;
 darn=lists.postgresql.org;
        h=content-type:cc:to:subject:message-id:date:from:in-reply-to
         :references:mime-version:from:to:cc:subject:date:message-id:reply-to
         :content-type;
        bh=EK7BJTtKs5D5H9vG3Trzs2dmELsX5vsPHgtjSU+FpU4=;
        b=Lwbfj9AXBRaMlFR+0uO99qUPhnvXSkDovpR4SX80DL4CYeHbEqZDZwwJkP922wkkFi
         Wetbaec3tdxw2XoBlFFJ2HjFbY19L8TYoF2m9bAKxr03I06elg1vif8DapPsYTZZs4Sb
         D+ns6/H/E3XlRE2Sl99AZjFhwpzODDhziye61GzGvCqILAkPr8XR+M/riaYbIAPomH32
         vp22DilAf0GYecXU4rGFPrbx+bDVH3KAx65FZ7409yuU5gPMkUooAKRspyZaoW4lt3Zk
         mGRWGyYSBEIDt2fSu0IlLF7ipG7pmqj0sWJDRf0f8yqi+vwiK8uvexmNuvU6fPLXkGWg
         r31g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1783425763; x=1784030563;
        h=content-type:cc:to:subject:message-id:date:from:in-reply-to
         :references:mime-version:x-gm-gg:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to:content-type;
        bh=EK7BJTtKs5D5H9vG3Trzs2dmELsX5vsPHgtjSU+FpU4=;
        b=sioiSYYbumvgTjudcRLmYVeWozLYnBVcrq0B+rsyy824KFZkZ3RhVojYIkw5aapnu4
         KO4pdyCX58TaSpYLjM298htcbUIloGaQjFab0gTvJ4qtKWj8IGVOTTrhhe9KEnwtGHLx
         PqrRFlI6zLvgD8GecCte3VXxQv8EOPJdDwiVj2e4YKLI0bchNfMVD6eeqVtNnf1Wvh9/
         06xulKCWhiWGvo76pM8fBqRXxO+zs+G9boEnY2m4MnCZDsxgrjnekst9Zx1aSQR+pJay
         KWQrsE1Q4nFe3j9Y6sGaSH0jvXvmoqjf4nu5PiXmyqBmmytaeNWMDSBQlm7vhueLsjcl
         uDpw==
X-Forwarded-Encrypted: i=1;
 AHgh+RojGL+1tuMOWCGSbfaNTaaHGfUS3k36XMRhx/bhkVA8YdGgUWoBP/rxZENhc3F0JDpN8CXxQvJ8ndA1@lists.postgresql.org
X-Gm-Message-State: AOJu0Yyvbwm9622y/JpSmroG3Ratk4nEJRmLGuIgZPYm8mfEeuKDYu/N
	EDgcbTQWSZqC79LUyk2a2hwPkvdQymetWs/ZfJCNLLm6fy7p9iDMmG+iCWOTpA0dB84xKy3Q/j5
	C0QljycmtxGpE+42qDi0SWf+VcuXKhO4=
X-Gm-Gg: AfdE7cmLJ+BW8EVrpatilWWJ7QJ44iP1o+sMW80qXz4mwIRQxvF9uN3j6/LOOzL/r9H
	SLH5LvRvDkCy81Mv0kTonYQl5Io67yYf3QlBWIfmTo67JA4WdMfVg9HNlkKX6otY4v0Ntmhiy4i
	K7rhqnIVfZGsjhTajZLpewE8AzdN/PhssOj0inICRazncBL8k7VNhteZpIrsof0zs/6rhIC4K5V
	Vte6ThFlrXl+5jQxR8NZBoCaex0WOLXhQH/Dnmfg2jmdgntU7NOYtGqv/fqoUGIdBTcMlLNZ3ab
	NvKJppmgPdM2ltrDAW0x83pWLeylr3JrILGwzYGNrUuyofK8p3+Om50mesA8RGA=
X-Received: by 2002:a05:600c:474a:b0:493:c062:a533 with SMTP id
 5b1f17b1804b1-493df0673f8mr58558155e9.17.1783425762349; Tue, 07 Jul 2026
 05:02:42 -0700 (PDT)
MIME-Version: 1.0
References: <19533-413a1014e5d0e766@postgresql.org>
 <EC273387-5C73-4C9C-BF30-8BA260A90FFB@outlook.com>
 <CAMbWs4-6umOecRifmC88RW0SHWDAvb4c3-VD8XQ3NJufsUyUOQ@mail.gmail.com>
 <CAApHDvqHXZpF9pPStLqPp5O=G2gVpPD959bMTRRkLjdy4Tvx7g@mail.gmail.com>
 <CAApHDvoJ07GM6V2QWyJAgsJcM-dcFS+nwPq4Um=-NsXv5PmoCw@mail.gmail.com>
 <CANWCAZbiYQ+=CHAaftwp2x83Gy6tJCB8GUe15yO5DW-cpp0Mxg@mail.gmail.com>
 <CAApHDvrN-HL=dSBez=pme5RQKCiH7SrsMEFV-eQRJN3Vs94ZEQ@mail.gmail.com>
 <CANWCAZap+k7-E2f-XoC36Hk4izZjbN8w2c9OuomummGfZ5d20w@mail.gmail.com>
 <D1C82EBB-54F6-420E-9006-3A737B0E70A6@outlook.com>
 <CAApHDvpKHEZXVDsaAyJ9pAkX3KH34jC83spXPjJPyrtrsKk_HA@mail.gmail.com>
 <CANWCAZYT8pusrf554FpM6NgjS3uWjEkaip9oXSRVc2iu2CEqgw@mail.gmail.com>
In-Reply-To: 
 <CANWCAZYT8pusrf554FpM6NgjS3uWjEkaip9oXSRVc2iu2CEqgw@mail.gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Wed, 8 Jul 2026 00:02:30 +1200
X-Gm-Features: AVVi8Cc7DcbDBswQL27Dx1b31eJ7xcN5VW2fH4ZpR9QLa4I0DPwQ_5d_AoY0f08
Message-ID: 
 <CAApHDvqgtAj72Cyd9srCJ+FAApJh7XSzPJvp0fdSeotC-QA4cA@mail.gmail.com>
Subject: Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown
 on count() with EXCLUDE CURRENT ROW
To: John Naylor <johncnaylorls@gmail.com>
Cc: Chengpeng Yan <chengpeng_yan@outlook.com>,
 Richard Guo <guofenglinux@gmail.com>,
	"imchifan@163.com" <imchifan@163.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/CAApHDvqgtAj72Cyd9srCJ%2BFAApJh7XSzPJvp0fdSeotC-QA4cA%40mail.gmail.com>
Precedence: bulk

On Tue, 7 Jul 2026 at 17:11, John Naylor <johncnaylorls@gmail.com> wrote:
> Works for me.

Pushed.

David