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 ) id 1we102-004Uqa-0z for pgsql-bugs@arkaria.postgresql.org; Mon, 29 Jun 2026 01:41:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1we0zz-000CTX-2p for pgsql-bugs@arkaria.postgresql.org; Mon, 29 Jun 2026 01:41:23 +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 ) id 1we0zz-000CTO-1l for pgsql-bugs@lists.postgresql.org; Mon, 29 Jun 2026 01:41:23 +0000 Received: from mail-oa1-x33.google.com ([2001:4860:4864:20::33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1we0zx-00000000iJS-0OjZ for pgsql-bugs@lists.postgresql.org; Mon, 29 Jun 2026 01:41:23 +0000 Received: by mail-oa1-x33.google.com with SMTP id 586e51a60fabf-43fc82b52afso1694326fac.1 for ; Sun, 28 Jun 2026 18:41:20 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782697279; cv=none; d=google.com; s=arc-20260327; b=BngAVzIZMGeqwnXZC7xS/C6oKSOxn/W0C9FxDI6n7apFo4OqYRvYJut2zGWcI4WX3k /mcGNWyQ3GVpPYb1RH9BelLtvr2raNaB7Cxwe0pROq0+PqN1xTAJKHteALjuetglmqgf fpWxGy00/nZ4vNtFeR5rz2kztb+2zi5e9HXYHNSgDwyYF1PVQJg5cs2Hx1WNSlzMbEeS LHf5190dIjU7fJKcp3B+uka7UwACrS2vCoYT+8U9INL/3gMnRkR5SAlg65uR6NF6Kvme kV4hpvx9fLPRtCOisROopwD+CvYhwLFgOM7h36XU8QImSTEDMv7PinYA76VLstI6YxmT /UEg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=mMlT69qHtl44R1RZ+5ob+N4xKo7ENqi14dLfj8+THV4=; fh=CEhuTkWvc9CCw5yOpoXcojKf2KkT4yRtsZfwI0jl/ao=; b=IEX5g+gA7cleiCcfbZpun0Nszj6ZDNSPnJeXcjuvxWnBLD7K1oi+3JfLwun/p4IYdw 3SBMWfzvz2HPpVQzP+CHa1ipcWou0zLqXB2rmQLL5ov4k7m716lLrYPfhWo8mnDVxy/Y 6riFf8HTxD/gawyOWmhmDu1l6jHn5Q57zaiwtX8H0g3G+zVoXNLPtMKoSxK5nLBWBMom gTPl4xqB6rMB88cUgnnqAIJv8U9e488HNiWee8X4V3/MNIykRI11NQgwrchLb5NVXGWj KHtDQttCCKvHefsFzmQ5d4GHahlBtj60V4YayuYDcLPir3ntyEQofg5vXRB97Dzao89g mvPQ==; 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=1782697279; x=1783302079; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=mMlT69qHtl44R1RZ+5ob+N4xKo7ENqi14dLfj8+THV4=; b=OkyBFXlvGdQFyHXr0YCJC5f+CHfcaM5JebgTN1iQpJUw2oU19wpTkxBwm7tGjtuHeT 9pm8m29CthmrF3aHun+L/ywMsE8b0Ic5m/C6WOKbMWrEa2x5trc4A0S2i3Ic9AaezUp8 AUEQrkyU2+3ATigzUiPCa8l5srYEwSS6fijZDJQoXS/u/aQVxk7a4cp0+vDGh+ykCpZo BVqrTRdCWUA8sy1clf4c/dWctXwJGv3gJ5ju4NlM4f65seple6sF/4z/KVMVwDdoBNNn jg8vO9b+WTTNChAe/Z3EljT4Vsdvxu0X4+T2Xic3AtuKiNUi3YyuQc29McWkwK9GOsvZ 3Tkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782697279; x=1783302079; h=content-transfer-encoding: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; bh=mMlT69qHtl44R1RZ+5ob+N4xKo7ENqi14dLfj8+THV4=; b=GI/JW4vxq58eBGACF5ygOOBXM2dKQZLL2FjMNCI31JR9Kwat65rrHudqqyNBLKrApS a1hS7oj1KRHlCcIELwQGLDKkXuHe81ewOCXvOwLbUTGyZphaMis/RIQMMTK8+vK3sGMs Cc/x9rm0SwhQd8Hzxm7zLu/EJCfNV9aLEvh3xAsuUkBnskl2PGzEB3GhBnayqj3+EKhn sCvQKI/Cp6MRvqFmEurDL4SQm5vLCALPP5IInOipNpyLhYwXATs5WbeBTDjkJBf7oL5g oDn8u1wgol6KGWLGBXoM2lXs88TDOauZingHPs6Rzto5YPH6YkWLzvGNBG71nGomLQrN hEew== X-Forwarded-Encrypted: i=1; AFNElJ/nfvblOwLgd98jAp2ridifwvS1Sw0nTxHPGuLjdm7tIZXvjT6EB4yEbRCuL0Rqv8wN8rVQ8BPVulc8@lists.postgresql.org X-Gm-Message-State: AOJu0Ywv+RZV/NXqdLG6rgUekBRGLEWff7Jmb4RPH/Y4j18focnI++u4 AmjAmxxbo5H27YHun/Np/eReUB7REW2g/ClHj8J1+NXd/41uKDSKlN30hGq5N/OmZ6NHKxZ7F3u LxGPjwcnQK7neSE2BSPnWCcuXwawOEjc= X-Gm-Gg: AfdE7cm6cPABPrI4IkNp6mFGWk/pWla5qisD2b/QNdOvwgmEJ2tPO9NoBosu90yQ87g T1XOkq5XUYL1ZoVduuCU8t5L4c0o3zIPXlcX4MA2oeGHzubNU4mxi7C2T7PyfLknD9CdyrVudLG rj2nQQjpNBcAY6CFFad/koi+yZT9imIWn5xQHkBo3o0q5MosDt28BZFDwVLUNlKzVX7ogiZ6Bwz /5snVevnwUeZilayR5bDI/HBgiSkmL7X3FA8Vaep0w9fG3wZc1I4sOlkEeTPIJnDTmwCjHoccg= X-Received: by 2002:a05:6871:7810:b0:448:558c:d834 with SMTP id 586e51a60fabf-448558cee78mr5731845fac.35.1782697278744; Sun, 28 Jun 2026 18:41:18 -0700 (PDT) MIME-Version: 1.0 References: <19534-9cdf4693c42033da@postgresql.org> <544F3673-0EC9-4440-9FC5-4BB4F0AA3037@outlook.com> In-Reply-To: From: Richard Guo Date: Mon, 29 Jun 2026 10:41:07 +0900 X-Gm-Features: AVVi8CdeRXWyWQfIkEf7vrvK5X7szaY0NnyJ9RusqAdjCiwR4u2rlHCnzonFV5c Message-ID: Subject: Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations To: Tender Wang Cc: Chengpeng Yan , "imchifan@163.com" , "pgsql-bugs@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jun 29, 2026 at 10:23=E2=80=AFAM Tender Wang w= rote: > The correct result is the most important thing. So I agree with you. > The fix seems obvious: we should refuse quals pushed down to the > subquery if the quals contain a nondeterministic partition clause var. This class of bug is currently being discussed and addressed on thread [1]. I suggest we consolidate the discussion there to avoid duplicating effort. [1] https://postgr.es/m/CAMbWs49dHFVVwx9MjYmvUrZu0L4vZTbGVyhj3T2SsWgS1Bzhzg= @mail.gmail.com - Richard