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 1tGn4r-000kit-5i for pgsql-committers@arkaria.postgresql.org; Thu, 28 Nov 2024 22:33:37 +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 1tGn4o-001ocY-DV for pgsql-committers@arkaria.postgresql.org; Thu, 28 Nov 2024 22:33:35 +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 1tGn4o-001ocL-63 for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:35 +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 1tGn4l-0002kl-Tb for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:34 +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 1tGn4k-000AwF-P5 for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:30 +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 1tGn4j-0003zi-MP for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:30 +0000 Content-Type: multipart/mixed; boundary="===============0784368118528558357==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid mislabeling of lateral references when pulling up a subque X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 28 Nov 2024 22:33:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0784368118528558357== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgbWlzbGFiZWxpbmcgb2YgbGF0ZXJhbCByZWZlcmVuY2VzIHdoZW4gcHVsbGluZyB1cCBh IHN1YnF1ZXJ5LgoKSWYgd2UgYXJlIHB1bGxpbmcgdXAgYSBzdWJxdWVyeSB0aGF0J3MgdW5kZXIg YW4gb3V0ZXIgam9pbiwgYW5kCnRoZSBzdWJxdWVyeSdzIHRhcmdldCBsaXN0IGNvbnRhaW5zIGEg c3RyaWN0IGV4cHJlc3Npb24gdGhhdCB1c2VzCmJvdGggYSBzdWJxdWVyeSB2YXJpYWJsZSBhbmQg YSBsYXRlcmFsLXJlZmVyZW5jZSB2YXJpYWJsZSwgaXQncyBva2F5CnRvIHB1bGwgdXAgdGhlIGV4 cHJlc3Npb24gd2l0aG91dCB3cmFwcGluZyBpdCBpbiBhIFBsYWNlSG9sZGVyVmFyLgpUaGF0J3Mg c2FmZSBiZWNhdXNlIGlmIHRoZSBzdWJxdWVyeSB2YXJpYWJsZSBpcyBmb3JjZWQgdG8gTlVMTApi eSB0aGUgb3V0ZXIgam9pbiwgdGhlIGV4cHJlc3Npb24gcmVzdWx0IHdpbGwgY29tZSBvdXQgYXMg TlVMTCB0b28sCnNvIHdlIGRvbid0IGhhdmUgdG8gZm9yY2UgdGhhdCBvdXRjb21lIGJ5IGV2YWx1 YXRpbmcgdGhlIGV4cHJlc3Npb24KYmVsb3cgdGhlIG91dGVyIGpvaW4uICBJdCdkIGJlIGNvcnJl Y3QgdG8gd3JhcCBpbiBhIFBIViwgYnV0IHRoYXQgY2FuCmxlYWQgdG8gdmVyeSBzaWduaWZpY2Fu dGx5IHdvcnNlIHBsYW5zLCBzaW5jZSB3ZSdkIHRoZW4gaGF2ZSB0byB1c2UKYSBuZXN0bG9vcCBw bGFuIHRvIHBhc3MgZG93biB0aGUgbGF0ZXJhbCByZWZlcmVuY2UgdG8gd2hlcmUgdGhlCmV4cHJl c3Npb24gd2lsbCBiZSBldmFsdWF0ZWQuCgpIb3dldmVyLCB3aGVuIHdlIGRvIHRoYXQsIHdlIHNo b3VsZCBub3QgbWFyayB0aGUgbGF0ZXJhbCByZWZlcmVuY2UKdmFyaWFibGUgYXMgYmVpbmcgbnVs bGVkIGJ5IHRoZSBvdXRlciBqb2luLCBiZWNhdXNlIGl0IGlzbid0IGFmdGVyCndlIHB1bGwgdXAg dGhlIGV4cHJlc3Npb24gaW4gdGhpcyB3YXkuICBTbyB0aGUgbWFya2luZyBsb2dpYyBhZGRlZApi eSBjYjhlNTBhNGEgd2FzIGluY29ycmVjdCBpbiB0aGlzIGRldGFpbCwgbGVhZGluZyB0byAid3Jv bmcKdmFybnVsbGluZ3JlbHMiIGVycm9ycyBmcm9tIHRoZSBjb25zaXN0ZW5jeS1jaGVja2luZyBs b2dpYyBpbgpzZXRyZWZzLmMuICBJdCBzZWVtcyB0byBiZSBzdWZmaWNpZW50IHRvIGp1c3Qgbm90 IG1hcmsgbGF0ZXJhbApyZWZlcmVuY2VzIGF0IGFsbCBpbiB0aGlzIGNhc2UuICAoSSBoYXZlIGEg bmFnZ2luZyBmZWVsaW5nIHRoYXQgbW9yZQpjb21wbGV4aXR5IG1heSBiZSBuZWVkZWQgaW4gY2Fz ZXMgd2hlcmUgdGhlcmUgYXJlIHNldmVyYWwgbGV2ZWxzIG9mCm91dGVyIGpvaW4sIGJ1dCBzb21l IGF0dGVtcHRzIHRvIGJyZWFrIGl0IHdpdGggdGhhdCBkaWRuJ3Qgc3VjY2VlZC4pCgpQZXIgcmVw b3J0IGZyb20gQmVydHJhbmQgTWFtYXNhbS4gIEJhY2stcGF0Y2ggdG8gdjE2LCBhcyB0aGUgcHJl dmlvdXMKcGF0Y2ggd2FzLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUNaNjdf VUFfRVZycWlGWEp1OVhLNTBiYUVwSD1vZkVQSnN3YTJrRnhnNnh1U3ctd3dAbWFpbC5nbWFpbC5j b20KCkJyYW5jaAotLS0tLS0KUkVMXzE2X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvODU5OTBlMmZkNTYxMDU3NjYzNWM2NWRi OTI5MjI5N2IxNzMwYzk0NwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3ByZXAvcHJlcGpvaW50cmVlLmMgfCAxOSArKysrKysrKysrKy0tCnNyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2VsZWN0Lm91dCAgIHwgNDcgKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zdWJzZWxlY3Quc3FsICAgICAg ICB8IDE2ICsrKysrKysrKysrCjMgZmlsZXMgY2hhbmdlZCwgODAgaW5zZXJ0aW9ucygrKSwgMiBk ZWxldGlvbnMoLSkKCg== --===============0784368118528558357==--