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 1rwkhV-003yVc-Uj for pgsql-committers@arkaria.postgresql.org; Tue, 16 Apr 2024 15:26:25 +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-004LPg-Ii for pgsql-committers@arkaria.postgresql.org; Tue, 16 Apr 2024 15:26:24 +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 1rwkeU-004J7v-Q8 for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:18 +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 1rwkeP-001I2q-Np for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:18 +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-007fmE-CW 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-002M79-JC for pgsql-committers@lists.postgresql.org; Tue, 16 Apr 2024 15:23:11 +0000 Content-Type: multipart/mixed; boundary="===============1454749264079379292==" 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 --===============1454749264079379292== 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 cWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0 LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMDMxMDdiNGVkYTdmMjk0NmJiNzgzMDhjYjA4 OGE1MTNiNzE4Yzc5MwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQv b3B0aW1pemVyL3BhdGgvZXF1aXZjbGFzcy5jIHwgMTUgKysrKysrKysrKysrKysrCnNyYy9iYWNr ZW5kL29wdGltaXplci91dGlsL3JlbG5vZGUuYyAgICB8IDI2ICsrKysrKysrKysrKysrKysrKyst LS0tLS0tCjIgZmlsZXMgY2hhbmdlZCwgMzQgaW5zZXJ0aW9ucygrKSwgNyBkZWxldGlvbnMoLSkK Cg== --===============1454749264079379292==--