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.94.2) (envelope-from ) id 1qm4el-005W9d-8p for pgsql-committers@arkaria.postgresql.org; Fri, 29 Sep 2023 03:59:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qm4ei-001Ul2-Ar for pgsql-committers@arkaria.postgresql.org; Fri, 29 Sep 2023 03:59:08 +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.94.2) (envelope-from ) id 1qm4eh-001Ukd-LE for pgsql-committers@lists.postgresql.org; Fri, 29 Sep 2023 03:59:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qm4ed-008CpG-Uz for pgsql-committers@lists.postgresql.org; Fri, 29 Sep 2023 03:59:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Lj+mIDAOd1xyHKEadUTFubdurIauC/hexaGFugCfRro=; b=HrVx7WpulQ7souPr7yVm0/Y7Rv FbLSzoA4Q7dTmmLi2mmgD6iGi//X3VJ9Ub5HrcWWgpqy1vlPNsHkFZP1Ed+8FpvpSiY8SDEaw5vFg k/VZzhL777WvnpDAns0MvXdrlJyLRgvFruQ8AsK6mJlN8zp1mep2QkV3KQu2XDTD3NlAyLmUYHa6j JJHmvz5fhx4On/+knfNVzcq4eiH1BNChpAK3usVBp1nBpDrhHOyJgOQKgN215+8a7ZsD1Exv4Jz0M W036XFz9irBLH9/CL/dObKkqkr0yksvJh28qFjaoN3+QMrmjKKa0oHSkjEDY0kPAOU8ihvlOT17jP KxMmdMUw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qm4ec-0001HC-NT for pgsql-committers@lists.postgresql.org; Fri, 29 Sep 2023 03:59:02 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qm4eb-006ZDY-QP for pgsql-committers@lists.postgresql.org; Fri, 29 Sep 2023 03:59:01 +0000 Content-Type: multipart/mixed; boundary="===============4160799090171492182==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Robustify find_base_rel and find_base_rel_ignore_join X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 29 Sep 2023 03:59:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4160799090171492182== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Um9idXN0aWZ5IGZpbmRfYmFzZV9yZWwgYW5kIGZpbmRfYmFzZV9yZWxfaWdub3JlX2pvaW4KCklt cHJvdmUgZmluZF9iYXNlX3JlbCgpIGFuZCBmaW5kX2Jhc2VfcmVsX2lnbm9yZV9qb2luKCkgc28g dGhhdCB0aGV5CnJhaXNlIGFuIEVSUk9SIGlmIHRoZXkgZXZlciByZWNlaXZlIGEgbmVnYXRpdmUg cmVsaWQgdmFsdWUgaW4Kbm9uLWNhc3NlcnQgYnVpbGRzLiAgSWYgZWl0aGVyIG9mIHRoZXNlIGZ1 bmN0aW9ucyBoYWQgZXZlciByZWNlaXZlZCBhCm5lZ2F0aXZlIHJlbGlkIHRoZW4gdGhleSdkIGhh dmUgYXR0ZW1wdGVkIHRvIGFjY2VzcyBtZW1vcnkgdGhhdCBkb2VzIG5vdApiZWxvbmcgdG8gc2lt cGxlX3JlbF9hcnJheS4KCkJlY2F1c2Ugbm8gZXZpZGVuY2UgaGFzIGJlZW4gcHJlc2VudGVkIG9m IGFjdHVhbCBjYXNlcyB3aGVyZSBidWdzIGhhdmUKY2F1c2VkIHRoaXMgdG8gaGFwcGVuLCBoZXJl IHdlIHRha2UgYSBsaWdodHdlaWdodCBhcHByb2FjaCB0byBjaGVja2luZwpmb3IgbmVnYXRpdmUg dmFsdWVzIGFuZCBzaW1wbHkgY2FzdCBib3RoIHZhbHVlcyB0byB1aW50MzIgYmVmb3JlCnBlcmZv cm1pbmcgdGhlIGNvbXBhcmlzb24uICBUaGlzIHdpbGwgY2F1c2UgYW55IG5lZ2F0aXZlIHJlbGlk cyB0byBiZQpzZWVuIGFzIGdyZWF0ZXIgdGhhbiBzaW1wbGVfcmVsX2FycmF5X3NpemUgd2hpY2gg d2lsbCBFUlJPUiByYXRoZXIgdGhhbgphdHRlbXB0IHRvIGFjY2VzcyBhIG5lZ2F0aXZlIHNpbXBs ZV9yZWxfYXJyYXkgZWxlbWVudC4gIE9idmlvdXNseSwgdGhlCnJ1bi10aW1lIGVycm9yIGlzIGJl dHRlciB0aGFuIGEgY3Jhc2gsIHNvIGl0IG1ha2VzIHNlbnNlIHRvIHByb3RlY3QKYWdhaW5zdCB0 aGlzLCBlc3BlY2lhbGx5IHdoZW4gaXQgY2FuIGJlIGRvbmUgd2l0aG91dCBhZGRpbmcgYW55CmFk ZGl0aW9uYWwgcnVuLXRpbWUgb3ZlcmhlYWQuCgpUaGVyZSBpcyBhIHNsaWdodCBjaGFuZ2UgaGVy ZSBpZiB0aGUgZnVuY3Rpb25zIGFyZSBldmVyIGNhbGxlZCB3aXRoIGEKcmVsaWQgb2YgMC4gIFRo aXMgd2lsbCBwYXNzIHRoZSBib3VuZHMgY2hlY2ssIGJ1dCB0aGF0IGFycmF5IGVudHJ5CnNob3Vs ZCBiZSBOVUxMIChhbG9uZyB3aXRoIHRoZSBjb3JyZXNwb25kaW5nIHNpbXBsZV9ydGVfYXJyYXkg ZW50cnkpLCBzbwp3b24ndCBwYXNzIHRoZSAiaWYgKHJlbCkiIGNvbmRpdGlvbiBhbmQgc3RpbGwg ZmFsbCB0aHJvdWdoIGFuZCByYWlzZSBhbgpFUlJPUi4KCkF1dGhvcjogUmFuaWVyIFZpbGVsYQpS ZXZpZXdlZC1ieTogQXNodXRvc2ggQmFwYXQsIERhdmlkIFJvd2xleQpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tL0NBRXVkUUFyUVNnaEJ1MmdMb2pnNG9fdG5Ial94MkhjUyUzRCUyQndl d0wzTkpTOHowVm5LJTJCZyU0MG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv ZDQwZDgyNzIxOTBjZTVmMTY0MWI5YWZiODNhMzc1MjEwMWFmNmEzOAoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcmVsbm9kZS5jIHwgMTAg KysrKy0tLS0tLQoxIGZpbGUgY2hhbmdlZCwgNCBpbnNlcnRpb25zKCspLCA2IGRlbGV0aW9ucygt KQoK --===============4160799090171492182==--