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 1rwkhW-003yVb-48 for pgsql-committers@arkaria.postgresql.org; Tue, 16 Apr 2024 15:26:26 +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 1rwkhU-004LPd-FY for pgsql-committers@arkaria.postgresql.org; Tue, 16 Apr 2024 15:26:24 +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.94.2) (envelope-from ) id 1rwkeS-004IVU-Cb for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:16 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwkeO-0039RI-BU for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:15 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwkeN-007fmF-CV for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:11 +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 1rwkeM-002M7A-Jy for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:11 +0000 Content-Type: multipart/mixed; boundary="===============1776812515596834825==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ensure generated join clauses for child rels have correct relids X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 16 Apr 2024 15:23:11 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1776812515596834825== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5zdXJlIGdlbmVyYXRlZCBqb2luIGNsYXVzZXMgZm9yIGNoaWxkIHJlbHMgaGF2ZSBjb3JyZWN0 IHJlbGlkcy4KCldoZW4gYnVpbGRpbmcgYSBqb2luIGNsYXVzZSBkZXJpdmVkIGZyb20gYW4gRXF1 aXZhbGVuY2VDbGFzcywgaWYgdGhlCmNsYXVzZSBpcyB0byBiZSB1c2VkIHdpdGggYW4gYXBwZW5k cmVsIGNoaWxkIHJlbGF0aW9uIHRoZW4gbWFrZSBzdXJlCml0cyBjbGF1c2VfcmVsaWRzIGluY2x1 ZGUgdGhlIHJlbGlkcyBvZiB0aGF0IGNoaWxkIHJlbGF0aW9uLgpOb3JtYWxseSB0aGlzIHdvdWxk IGJlIHRydWUgYWxyZWFkeSBiZWNhdXNlIHRoZSBFcXVpdmFsZW5jZU1lbWJlcgp3b3VsZCBiZSBh IFZhciBvZiB0aGF0IHJlbGF0aW9uLiAgSG93ZXZlciwgaWYgdGhlIGFwcGVuZHJlbCByZXByZXNl bnRzCmEgZmxhdHRlbmVkIFVOSU9OIEFMTCBjb25zdHJ1Y3QgdGhlbiBzb21lIGNoaWxkIEVxdWl2 YWxlbmNlTWVtYmVycwpjb3VsZCBiZSBjb25zdGFudHMgd2l0aCBubyByZWxpZHMuICBUaGUgcmVz dWx0aW5nIHVuZGVyLW1hcmtlZCBjbGF1c2UKaXMgcHJvYmxlbWF0aWMgYmVjYXVzZSBpdCBjb3Vs ZCBtaXNsZWFkIGpvaW5fY2xhdXNlX2lzX21vdmFibGVfaW50bwphYm91dCB3aGVyZSB0aGUgY2xh dXNlIHNob3VsZCBiZSBldmFsdWF0ZWQuICBXZSBkbyBub3QgaGF2ZSBhbiBleGFtcGxlCnNob3dp bmcgaW5jb3JyZWN0IHBsYW4gZ2VuZXJhdGlvbiwgYnV0IHRoZXJlIGFyZSBleGlzdGluZyBjYXNl cyBpbgp0aGUgcmVncmVzc2lvbiB0ZXN0cyB0aGF0IHdpbGwgZmFpbCB0aGUgQXNzZXJ0cyB0aGlz IHBhdGNoIGFkZHMgdG8KZ2V0X2Jhc2VyZWxfcGFyYW1wYXRoaW5mby4gIEEgc2ltaWxhcmx5IHdy b25nIGNvbmNsdXNpb24gYWJvdXQgYQpjbGF1c2UgYmVpbmcgY29uc2lkZXJlZCBieSBnZXRfam9p bnJlbF9wYXJhbXBhdGhpbmZvIHdvdWxkIGxlYWQgdG8Kd3JvbmcgcGxhY2VtZW50IG9mIHRoZSBj bGF1c2UuICAoVGhpcyBhbHNvIHNxdWFyZXMgd2l0aCB0aGUgd2F5CnRoYXQgY2xhdXNlX3JlbGlk cyBpcyBjYWxjdWxhdGVkIGZvciBub24tZXF1aWpvaW4gY2xhdXNlcyBpbgphZGp1c3RfYXBwZW5k cmVsX2F0dHJzLikKClRoZSBvdGhlciByZWFzb24gZm9yIHdhbnRpbmcgdGhlc2UgbmV3IEFzc2Vy dHMgaXMgdGhhdCB0aGUgcHJldmlvdXMKYmxpdGhlIGFzc3VtcHRpb24gdGhhdCB0aGUgcmVzdWx0 cyBvZiBnZW5lcmF0ZV9qb2luX2ltcGxpZWRfZXF1YWxpdGllcwoibmVjZXNzYXJpbHkgc2F0aXNm eSBqb2luX2NsYXVzZV9pc19tb3ZhYmxlX2ludG8iIHR1cm5zIG91dCB0byBiZQp3cm9uZyBwcmUt djE2LiAgSWYgaXQncyBzdGlsbCB3cm9uZyBpdCdkIGJlIGdvb2QgdG8gZmluZCBvdXQuCgpQZXIg YnVnICMxODQyOSBmcm9tIEJlbm/DrnQgUnlkZXIuICBUaGUgYnVnIGFzIGZpbGVkIHdhcyBmaXhl ZCBieQpjb21taXQgMjQ4OWQ3NmM0LCBidXQgdGhlc2UgY2hhbmdlcyBjb3JyZWxhdGUgd2l0aCB0 aGUgZml4IHdlCndpbGwgbmVlZCB0byBhcHBseSBpbiBwcmUtdjE2IGJyYW5jaGVzLgoKRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xODQyOS04OTgyZDRhMzQ4Y2M4NmM2QHBvc3RncmVz cWwub3JnCgpCcmFuY2gKLS0tLS0tClJFTF8xNl9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRw czovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzkxODAwYWYxMzcxMDI5Zjc1ZThl MzRkNTVlOWI0MTI3MDZlZWMxODIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9i YWNrZW5kL29wdGltaXplci9wYXRoL2VxdWl2Y2xhc3MuYyB8IDE1ICsrKysrKysrKysrKysrKwpz cmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9yZWxub2RlLmMgICAgfCAyNiArKysrKysrKysrKysr KysrKysrLS0tLS0tLQoyIGZpbGVzIGNoYW5nZWQsIDM0IGluc2VydGlvbnMoKyksIDcgZGVsZXRp b25zKC0pCgo= --===============1776812515596834825==--