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 1wl9qy-0018jx-1E for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Jul 2026 18:33:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wl9qx-003fYc-1B for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Jul 2026 18:33:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wl9qx-003fYU-0K for pgsql-bugs@lists.postgresql.org; Sat, 18 Jul 2026 18:33:35 +0000 Received: from mail-vk1-xa2b.google.com ([2607:f8b0:4864:20::a2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wl9qu-00000000rX9-1OOb for pgsql-bugs@lists.postgresql.org; Sat, 18 Jul 2026 18:33:34 +0000 Received: by mail-vk1-xa2b.google.com with SMTP id 71dfb90a1353d-5bf8a2932a3so4085127e0c.1 for ; Sat, 18 Jul 2026 11:33:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1784399610; x=1785004410; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:in-reply-to:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:from:to:cc:subject:date:message-id:reply-to :content-type; bh=M/Wp8IDtbdnSbRIBRhHfRMeyhr6UqOhSXBKYppBPtjM=; b=avajkAKo8W6M3DHwGe4zj22g9YeqJ/w/OFTsW1TySNbhy7G/NNHlF0wgwNTkurfiyx 0/A2oIqEnbzBcZn9sNQq2UjePJus1Ond0yJ+qryhBmmzuvDXM1wcgVWzzXigHt9J8Elu h90zg1rM5kYcl/mHqSr9/wTTevds0tVukhKfCwz7bFM8+YyRFz0/7fBG9pXEIyCCP++y oksBM3HtLlhcazYlsZR0IrdNjlwTeWz9dq6OPDNNZTdX/R3TY7xZfGYQaR/2bqjI5l6g aBxf+OgrDg9e6HywgWn2ZPcIU2XqTYJs/4pEZXyJsTLUxg7wA5s/mTMzeExPqpswv5fA CLug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1784399610; x=1785004410; h=content-transfer-encoding:content-type:in-reply-to:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to:content-type; bh=M/Wp8IDtbdnSbRIBRhHfRMeyhr6UqOhSXBKYppBPtjM=; b=mMxPru6ZfknsUXifOIpP1GoFFNwSOEsVguvmJFVM0/064PB+X+6vs8jreJTt72GPfk FKQxyJiETspWwYqdZvyw3JXQNQpT/os5KKWFNt+rRN5ECRHWW9fCyhMwdKlCL+jlLG3r F5JyYvQXha7rwtxW8s/e8bxzwwleUbZISArcUy0j1ov2oNFcTUI480ae2JAKmToSRAvA HwEIpwW3ymzbcc5UOlq7VTGzseRyb1900U5Zafi8n/CDg75uZ09x/f2uL8loW8wfqaHX jsYz+yHSXHXp6k5evnnh3gaaQ1H45xfDKyxXy9rkz6jUqV7hStNK0n0WI/eBmN0NFKNd M2TQ== X-Forwarded-Encrypted: i=1; AHgh+RrjgvgJG2Fp2MWrtjzSlc49uGROYphTtt459KdmHgMwSyqlEwEDkt8XJGsPCLPZpwPToamqRiH9a6iw@lists.postgresql.org X-Gm-Message-State: AOJu0YwSDD4jioN2O4sjK9zBHIeVj8XvFOusZ2s0ka6FSu/144vazQ9p jZCaUgS6156bHrQaQAd3JV2ywR2O2WUdIIoykv0DA/duJr5AUyu/aaNa X-Gm-Gg: AfdE7ckFI24lUrNN1tUgMwDp1xnQA2NUeEZyhQ6vwsCEQmVS2K++4/yQpeomJZ9uNTG Y3/K6oVatitPHVipJA31Ci/0vJRtXQ2T4BbW1lV4OOM3LxbP16ue8J+Le43e2EmdgDQidJ0Pfv4 OMaeQ8Lw0DpbUR4wbkG/JyN1yqqTq+Pxs0WzRKKHRcAciZZm9RpZ7lfyNy3lUA9i0QcvGU1NVCp iEK5CTJnXfk3/nYel7kbVafKxRSIEehm9TrF6kAatzsTL2hHV47fkS1OcZEK+8VXLYE+M6jwT6v VrdNPiMb3sXQHbUYPd0NVQa41lJwwialWdmf0hLHzIuoEYLnqzY4a2dOAeUmO8d4jOtEiYPIbNA pp11qqUcF6zWZ9Vn8mRX/hraWJH4+W9m2pOzfxG2FfR3LBgI8bTM1QY+oCUM1xz95XqEwVFCc6p /KG4xahezZKXKrGjlG+6IKS3aas8zOWCahhKdeWayM8MDO5fOlJ3yo4zyYuElYrrYhjTiPi7Rp X-Received: by 2002:a05:6102:50a3:b0:738:9d06:2a1e with SMTP id ada2fe7eead31-747534ad92emr2360450137.8.1784399610533; Sat, 18 Jul 2026 11:33:30 -0700 (PDT) Received: from ?IPV6:2804:14d:32a7:4273:85a8:3ba6:bcc7:b6c0? ([2804:14d:32a7:4273:85a8:3ba6:bcc7:b6c0]) by smtp.gmail.com with ESMTPSA id a1e0cc1a2514c-976fc36c393sm2738225241.2.2026.07.18.11.33.28 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 18 Jul 2026 11:33:30 -0700 (PDT) Message-ID: <6a4fabe2-4b4f-4877-97cb-a550581f5d5b@gmail.com> Date: Sat, 18 Jul 2026 15:33:26 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16) To: Tom Lane , Richard Guo Cc: leis@in.tum.de, pgsql-bugs@lists.postgresql.org References: <19553-4561747f93f368a7@postgresql.org> <3824828.1784244210@sss.pgh.pa.us> <3957687.1784308823@sss.pgh.pa.us> <298498.1784398271@sss.pgh.pa.us> Content-Language: en-US From: Matheus Alcantara In-Reply-To: <298498.1784398271@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 18/07/26 15:11, Tom Lane wrote: > Richard Guo writes: >> On Sat, Jul 18, 2026 at 2:20 AM Tom Lane wrote: >>> If no objections, I'll push and backpatch soon. > >> v3 LGTM. > > Pushed. > Thank you! -- Matheus Alcantara EDB: https://www.enterprisedb.com