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 1wpTQZ-001fPp-2n for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Jul 2026 16:16:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wpTQY-00CUvE-2C for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Jul 2026 16:16:10 +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 1wpTQX-00CUv5-1w for pgsql-bugs@lists.postgresql.org; Thu, 30 Jul 2026 16:16:10 +0000 Received: from m16.mail.126.com ([220.197.31.9]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wpTQG-000000016Lq-4B2k for pgsql-bugs@lists.postgresql.org; Thu, 30 Jul 2026 16:16:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:To:Subject:Content-Type:MIME-Version: Message-ID; bh=80PLX6P4j+15GAB9nHvzutD6qd7iWxs523EIxlft0gw=; b=g CJSy7x0whJ2sS56AbUuHm1ihv+Ox3I8N4BQHhj9w0+a8ZZO8BPQ6TzdykeBRF760 ng4NUSXzUeuxeGY7BbJcznfjcUxQZcYEDOHjEUP5xPJEpxpp/exTchfFlHJthau1 FGhiq+2GVsVyMbxWRyq7UKVvSzvuv9lB5bH3C6ZW4s= Received: from ld_zju$126.com ( [2408:820c:8ff8:3c1c:c9f9:1a8c:5731:5958] ) by ajax-webmail-wmsvr-41-109 (Coremail) ; Fri, 31 Jul 2026 00:15:43 +0800 (CST) X-Originating-IP: [2408:820c:8ff8:3c1c:c9f9:1a8c:5731:5958] Date: Fri, 31 Jul 2026 00:15:43 +0800 (CST) From: ld_zju To: pgsql-bugs@lists.postgresql.org Subject: DO NOT pull up a sublink when it has no join condition with the upper relation X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2023.4-cmXT build 20260511(2e539873) Copyright (c) 2002-2026 www.mailtech.cn 126com X-NTES-SC: AL_Qu2TB/iZt0kv5SieZ+kfmkwWhes/XsGwvv0j2oRVPJx6jD3j0B89dFVmJFDxy+GUJhCTmhqzcjhp6vt/WrNcXLIByYJcpuIO1GYwvhKzI+/04A== Content-Type: multipart/alternative; boundary="----=_Part_119591_1620568741.1785428143867" MIME-Version: 1.0 Message-ID: <13beb150.7b23.19fb3cf6efc.Coremail.ld_zju@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: bSkvCgD3Nx2veGtqTKgmAA--.57329W X-CM-SenderInfo: hogb6ybx6rjloofrz/xtbBoQ++hGpreK8JngAA3V X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_119591_1620568741.1785428143867 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGksCgoKSSd2ZSBlbmNvdW50ZXJlZCBhIHNjZW5hcmlvIHdoZXJlIHB1bGxpbmcgdXAgYSBzdWJs aW5rIG5vdCBvbmx5IGJyaW5ncyBubyBiZW5lZml0IGJ1dCBhY3R1YWxseSBkZWdyYWRlcyB0aGUg ZmluYWwgcGxhbiBzaWduaWZpY2FudGx5LgoKCkhlcmUgaXMgdGhlIHRlc3QgY2FzZToKCgpjcmVh dGUgdGFibGUgdDEoYSBpbnQsYiBpbnQsYyBpbnQsZCBpbnQpOwpjcmVhdGUgdGFibGUgdDIoYSBp bnQsYiBpbnQsYyBpbnQsZCBpbnQpOwpjcmVhdGUgdGFibGUgdDMoYSBpbnQsYiBpbnQsYyBpbnQs ZCBpbnQpOwppbnNlcnQgaW50byB0MSBzZWxlY3QgaSxpLGksaSBmcm9tIGdlbmVyYXRlX3Nlcmll cygxLDEwMDApIGk7Cmluc2VydCBpbnRvIHQyIHNlbGVjdCBpLGksaSxpIGZyb20gZ2VuZXJhdGVf c2VyaWVzKDEsMTAwMCkgaTsKaW5zZXJ0IGludG8gdDMgc2VsZWN0IGksaSxpLGkgZnJvbSBnZW5l cmF0ZV9zZXJpZXMoMSwxMCkgaTsKCgpleHBsYWluIHNlbGVjdCAqIGZyb20gdDEgd2hlcmUgZXhp c3RzKHNlbGVjdCAxIGZyb20gdDIgd2hlcmUgdDIuYSBpbihzZWxlY3QgdDMuYSBmcm9tIHQzIHdo ZXJlIHQzLmI9dDEuYikpOwogICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTgot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tCiBOZXN0ZWQgTG9vcCBTZW1pIEpvaW4gKGNvc3Q9MC4wMC4uMjg0MTgyMzIuNjcg cm93cz05MjUgd2lkdGg9MTYpCiAgIEpvaW4gRmlsdGVyOiAoQU5ZICh0Mi5hID0gKFN1YlBsYW4g YW55XzEpLmNvbDEpKQogICAtPiBTZXEgU2NhbiBvbiB0MSAoY29zdD0wLjAwLi4yOC41MCByb3dz PTE4NTAgd2lkdGg9MTYpCiAgIC0+IE1hdGVyaWFsaXplIChjb3N0PTAuMDAuLjM3Ljc1IHJvd3M9 MTg1MCB3aWR0aD00KQogICAgICAgICAtPiBTZXEgU2NhbiBvbiB0MiAoY29zdD0wLjAwLi4yOC41 MCByb3dzPTE4NTAgd2lkdGg9NCkKICAgU3ViUGxhbiBhbnlfMQogICAgIC0+IFNlcSBTY2FuIG9u IHQzIChjb3N0PTAuMDAuLjMzLjEyIHJvd3M9OSB3aWR0aD00KQogICAgICAgICAgIEZpbHRlcjog KGIgPSB0MS5iKQooOCByb3dzKQoKClRoZSBFWElTVFMgc3VibGluayBpcyBwdWxsZWQgdXAgYW5k IGpvaW5lZCB3aXRoIHQxIHZpYSBhIE5lc3RlZCBMb29wIFNlbWkgSm9pbi4gSG93ZXZlciwgc2lu Y2UgdGhlcmUgaXMgbm8gam9pbiBjb25kaXRpb24gYmV0d2VlbiB0MSBhbmQgdGhlIHN1Ymxpbmsg KHRoZSBjb25kaXRpb24gdDMuYiA9IHQxLmIgaXMgaW5zaWRlIHRoZSBzdWJwbGFuKSwgdGhpcyBy ZXN1bHRzIGluIGEgQ2FydGVzaWFuIHByb2R1Y3QgYmV0d2VlbiB0MSBhbmQgdDIsIGZvbGxvd2Vk IGJ5IGZpbHRlcmluZyB0aHJvdWdoIHRoZSBzdWJwbGFuLiBXaXRoIHQxIGFuZCB0MiBib3RoIGhh dmluZyAxMDAwIHJvd3MsIHRoaXMgcHJvZHVjZXMgYSBsYXJnZSBpbnRlcm1lZGlhdGUgcmVzdWx0 IHNldCAoMSwwMDAsMDAwIHJvd3MpIHdoZW4gdGhlIGFjdHVhbCByZXN1bHQgc2V0IGlzIG11Y2gg c21hbGxlci4KCgpXb3VsZCBpdCBiZSBwb3NzaWJsZSB0aGF0IHRoZSBzdWJsaW5rIGlzIHB1bGxl ZCB1cCBvbmx5IHdoZW4gaXQgaGFzIGFueSBqb2luIGNvbmRpdGlvbnMgd2l0aCB0aGUgdXBwZXIg cmVsYXRpb24/IElmIG5vIHN1Y2ggY29uZGl0aW9ucyBleGlzdCwgYSBDYXJ0ZXNpYW4gcHJvZHVj dCBpcyBsaWtlbHkgYW5kIHB1bGxpbmcgdXAgc2hvdWxkIGJlIGF2b2lkZWQuCgoKQW55IHRob3Vn aHRzIG9yIHN1Z2dlc3Rpb25zIHdvdWxkIGJlIGFwcHJlY2lhdGVkIQoKCkJlc3QgcmVnYXJkcywK RGVuZywgTFU= ------=_Part_119591_1620568741.1785428143867 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdiBz dHlsZT0ibWFyZ2luOjA7Ij5IaSw8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L2Rp dj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPkkndmUgZW5jb3VudGVyZWQgYSBzY2VuYXJpbyB3aGVy ZSBwdWxsaW5nIHVwIGEgc3VibGluayBub3Qgb25seSBicmluZ3Mgbm8gYmVuZWZpdCBidXQgYWN0 dWFsbHkgZGVncmFkZXMgdGhlIGZpbmFsIHBsYW4gc2lnbmlmaWNhbnRseS48L2Rpdj48ZGl2IHN0 eWxlPSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPkhlcmUgaXMg dGhlIHRlc3QgY2FzZTo8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46MDsiPmNyZWF0ZSB0YWJsZSB0MShhIGludCxiIGludCxjIGludCxkIGlu dCk7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij5jcmVhdGUgdGFibGUgdDIoYSBpbnQsYiBp bnQsYyBpbnQsZCBpbnQpOzwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+Y3JlYXRlIHRhYmxl IHQzKGEgaW50LGIgaW50LGMgaW50LGQgaW50KTs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsi Pmluc2VydCBpbnRvIHQxIHNlbGVjdCBpLGksaSxpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMTAw MCkgaTs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPmluc2VydCBpbnRvIHQyIHNlbGVjdCBp LGksaSxpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMTAwMCkgaTs8L2Rpdj48ZGl2IHN0eWxlPSJt YXJnaW46MDsiPmluc2VydCBpbnRvIHQzIHNlbGVjdCBpLGksaSxpIGZyb20gZ2VuZXJhdGVfc2Vy aWVzKDEsMTApIGk7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9kaXY+PGRpdiBz dHlsZT0ibWFyZ2luOjA7Ij5leHBsYWluIHNlbGVjdCAqIGZyb20gdDEgd2hlcmUgZXhpc3RzKHNl bGVjdCAxIGZyb20gdDIgd2hlcmUgdDIuYSBpbihzZWxlY3QgdDMuYSBmcm9tIHQzIHdoZXJlIHQz LmI9dDEuYikpOzwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+Jm5ic3A7ICZuYnNwOyAmbmJz cDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNw OyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBRVUVSWSBQTEFOPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2lu OjA7Ij4tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJzcDtOZXN0ZWQg TG9vcCBTZW1pIEpvaW4gIChjb3N0PTAuMDAuLjI4NDE4MjMyLjY3IHJvd3M9OTI1IHdpZHRoPTE2 KTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+Jm5ic3A7ICZuYnNwO0pvaW4gRmlsdGVyOiAo QU5ZICh0Mi5hID0gKFN1YlBsYW4gYW55XzEpLmNvbDEpKTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjowOyI+Jm5ic3A7ICZuYnNwOy0mZ3Q7ICBTZXEgU2NhbiBvbiB0MSAgKGNvc3Q9MC4wMC4uMjgu NTAgcm93cz0xODUwIHdpZHRoPTE2KTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+Jm5ic3A7 ICZuYnNwOy0mZ3Q7ICBNYXRlcmlhbGl6ZSAgKGNvc3Q9MC4wMC4uMzcuNzUgcm93cz0xODUwIHdp ZHRoPTQpPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAm bmJzcDsgJm5ic3A7LSZndDsgIFNlcSBTY2FuIG9uIHQyICAoY29zdD0wLjAwLi4yOC41MCByb3dz PTE4NTAgd2lkdGg9NCk8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPiZuYnNwOyAmbmJzcDtT dWJQbGFuIGFueV8xPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJzcDsgJm5ic3A7ICZu YnNwOy0mZ3Q7ICBTZXEgU2NhbiBvbiB0MyAgKGNvc3Q9MC4wMC4uMzMuMTIgcm93cz05IHdpZHRo PTQpPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJz cDsgJm5ic3A7ICZuYnNwO0ZpbHRlcjogKGIgPSB0MS5iKTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjowOyI+KDggcm93cyk8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46MDsiPlRoZSBFWElTVFMgc3VibGluayBpcyBwdWxsZWQgdXAgYW5kIGpv aW5lZCB3aXRoIHQxIHZpYSBhIE5lc3RlZCBMb29wIFNlbWkgSm9pbi4gSG93ZXZlciwgc2luY2Ug dGhlcmUgaXMgbm8gam9pbiBjb25kaXRpb24gYmV0d2VlbiB0MSBhbmQgdGhlIHN1YmxpbmsgKHRo ZSBjb25kaXRpb24gdDMuYiA9IHQxLmIgaXMgaW5zaWRlIHRoZSBzdWJwbGFuKSwgdGhpcyByZXN1 bHRzIGluIGEgQ2FydGVzaWFuIHByb2R1Y3QgYmV0d2VlbiB0MSBhbmQgdDIsIGZvbGxvd2VkIGJ5 IGZpbHRlcmluZyB0aHJvdWdoIHRoZSBzdWJwbGFuLiBXaXRoIHQxIGFuZCB0MiBib3RoIGhhdmlu ZyAxMDAwIHJvd3MsIHRoaXMgcHJvZHVjZXMgYSBsYXJnZSBpbnRlcm1lZGlhdGUgcmVzdWx0IHNl dCAoMSwwMDAsMDAwIHJvd3MpIHdoZW4gdGhlIGFjdHVhbCByZXN1bHQgc2V0IGlzIG11Y2ggc21h bGxlci48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJt YXJnaW46MDsiPldvdWxkIGl0IGJlIHBvc3NpYmxlIHRoYXQgdGhlIHN1YmxpbmsgaXMgcHVsbGVk IHVwIG9ubHkgd2hlbiBpdCBoYXMgYW55IGpvaW4gY29uZGl0aW9ucyB3aXRoIHRoZSB1cHBlciBy ZWxhdGlvbj8gSWYgbm8gc3VjaCBjb25kaXRpb25zIGV4aXN0LCBhIENhcnRlc2lhbiBwcm9kdWN0 IGlzIGxpa2VseSBhbmQgcHVsbGluZyB1cCBzaG91bGQgYmUgYXZvaWRlZC48L2Rpdj48ZGl2IHN0 eWxlPSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPkFueSB0aG91 Z2h0cyBvciBzdWdnZXN0aW9ucyB3b3VsZCBiZSBhcHByZWNpYXRlZCE8L2Rpdj48ZGl2IHN0eWxl PSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPkJlc3QgcmVnYXJk cyw8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPkRlbmcsIExVPC9kaXY+PC9kaXY+ ------=_Part_119591_1620568741.1785428143867--