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 1wkVnU-000ieI-1r for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Jul 2026 23:47:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wkVnT-00Fa95-1S for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Jul 2026 23:47:19 +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 1wkVnT-00Fa8w-0g for pgsql-bugs@lists.postgresql.org; Thu, 16 Jul 2026 23:47:19 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wkVnQ-00000000aaf-2QwL for pgsql-bugs@lists.postgresql.org; Thu, 16 Jul 2026 23:47:18 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-81ed2a00f12so43047177b3.2 for ; Thu, 16 Jul 2026 16:47:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1784245636; x=1784850436; darn=lists.postgresql.org; h=in-reply-to:references:to:from:subject:cc:message-id:date :content-type:content-transfer-encoding:mime-version:from:to:cc :subject:date:message-id:reply-to:content-type; bh=wveo4ItdPw3SUcGkhhWWuEKaR4B0x5/pmNsJoBx1GVU=; b=UAS0wUlMXDNNH7h1P3PbGWOpVEbeNstBxHn/NquHBMRqJ2uk0DLn7bWsb7wF4Ucj6k q+AILYZjyGYFxXy+YyoyA2zjDrKxzO7sNZZ1HSv9+nmLx2Y7TclHw4ULk6O25+4sVMRQ YnNuSKzZaL6YojXJKFmNVFTUzF4mVJ/zrDtnHGOQg4SMOmgpaipTEeuyUCzWAWpzvhtd ayBeVji/SSJwcIF/XzuIxPKG7EPFt5ac+EgUUFkeGnWOUnh8FRLIh9IBZrtxQHnrhc96 q+/CZLN01rj5jGITWIDRhsJsCR9lw15DIQyj5ChroJ+r6N7iKZyvXwTK+puXySGqm4sr MDFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1784245636; x=1784850436; h=in-reply-to:references:to:from:subject:cc:message-id:date :content-type:content-transfer-encoding:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=wveo4ItdPw3SUcGkhhWWuEKaR4B0x5/pmNsJoBx1GVU=; b=BMvofiXnc21/rAO0hWJ+Cc/OGnIc2JA4IKirXk1+RZllVVLbYG71AhUjZMD2Eo6ykJ Cca8sXh/+Gc3mhWy5yZJxArpuBpBP1eZagDYj0+aAemcIdwvdGPx2dAMbe+rn1CnyGLF qX9DGkCZ0/A8PwD6/WxwjcWuplCSvvNyMqZVncMmfiw7po24FkiKd6nDGjp/0+6shU6C Lsxr06uy6iMOU0VJxmyct9GpP12stiimVOq7snpSlYCEUQ6nHPrXYnP29mKJ7lh3o5AI 6w4sVYW3auWXEZ+0p2uLxsN/ocXzbmDl/0bFvsxm7A3lbT80ng9MedOOQB20cRnq8d/b jBgw== X-Forwarded-Encrypted: i=1; AHgh+RrtlEX3XtChN1CQz8TyJdcT+1NILjQUA7+xNaD/cQX7O8ZawuiJi9URmBSlqIt6JgOMvCzNvKGpVAch@lists.postgresql.org X-Gm-Message-State: AOJu0YzDlQA68B11yGqwJgX8ANH0M+lWYkFPJixWhUxcDCsiaV+R4OR6 5lY73YHg/LBj5jwa398oYca+cp7K8LUj0QSyJVD/GKcQBRxDdoIb3GLy X-Gm-Gg: AfdE7cn4TObXQrs16D4aWMWOvFlSTJEm+MfT3Vjm8Q9LZnSOWrqf02u6U+ghe7Sq0JY A50nh4MT4WU91Of0kkPx6Iaax6NgwBIuWW7UP1fqze3AwN57xwC5JykWr8N0omp2wzhdgLIOVIf EGfLQSz/jebjzrwOvcnxHcXM7UU74hrY7ivwykCRQXEAtvdLuzNSzs9rvYZzqM9umTC02/OFBgs +2DfVX9htuTT1wFvUuwvuN56oJ1M/n+cP4DeSoY/+ud1YJvji1XlUVWZaH9FJyRe35ZnuEloV4Y fMiDRyhzHgqD1N00mVMrOpG7FWsuMrn20sGC0Dmhb1VAO/hem54v0OvVO1/6hmPhaj5K2h0be+j OMZaKXt1KR7//0OtF/5hDjzNGJL3qOaDVuoucSw6CotJ8H6DYSWAVY+peYFBRGStBaswkWnG99Z jrZXu9+riKebuTTMQBDCgI+qc= X-Received: by 2002:a05:690c:6993:b0:81e:87ca:4799 with SMTP id 00721157ae682-81ebfe3bf04mr90957717b3.23.1784245635833; Thu, 16 Jul 2026 16:47:15 -0700 (PDT) Received: from localhost ([2804:14d:32a7:4273:cf0:5f01:2a01:a729]) by smtp.gmail.com with ESMTPSA id 00721157ae682-81e6c1eea67sm209939657b3.37.2026.07.16.16.47.14 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 16 Jul 2026 16:47:15 -0700 (PDT) Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=UTF-8 Date: Thu, 16 Jul 2026 20:47:12 -0300 Message-Id: Cc: , Subject: Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16) From: "Matheus Alcantara" To: "Tom Lane" X-Mailer: aerc 0.21.0 References: <19553-4561747f93f368a7@postgresql.org> <3824828.1784244210@sss.pgh.pa.us> In-Reply-To: <3824828.1784244210@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu Jul 16, 2026 at 8:23 PM -03, Tom Lane wrote: > > [ ... ] > > But I've not tried to write any code yet; do you feel like attacking > that? > Sure, I'll try to write and I'll share soon. -- Matheus Alcantara EDB: https://www.enterprisedb.com