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 1tGn6h-000kxH-Tp for pgsql-committers@arkaria.postgresql.org; Thu, 28 Nov 2024 22:35:31 +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 1tGn6f-001qEM-BR for pgsql-committers@arkaria.postgresql.org; Thu, 28 Nov 2024 22:35:30 +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 1tGn4q-001owx-71 for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:37 +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-0002kk-Tx for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:36 +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-000AwD-P2 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-0003ze-Kr for pgsql-committers@lists.postgresql.org; Thu, 28 Nov 2024 22:33:30 +0000 Content-Type: multipart/mixed; boundary="===============5936312245277450692==" 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 --===============5936312245277450692== 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 b20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81YzlkODYzNmQzMGQwODM4Yzc0MzJjMmM3NTA5NmI0 Y2Q3ODAxOTcxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUuYyB8IDE5ICsrKysrKysrKysrLS0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9zdWJzZWxlY3Qub3V0ICAgfCA0NyArKysrKysrKysrKysrKysrKysrKysr KysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N1YnNlbGVjdC5zcWwgICAgICAgIHwgMTYg KysrKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA4MCBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9u cygtKQoK --===============5936312245277450692==--