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.96) (envelope-from ) id 1w3aCD-001Mkn-0W for pgsql-committers@arkaria.postgresql.org; Fri, 20 Mar 2026 13:47:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3aCB-006RAS-1g for pgsql-committers@arkaria.postgresql.org; Fri, 20 Mar 2026 13:47:23 +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.96) (envelope-from ) id 1w3aCB-006RAK-10 for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 13:47:23 +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.98.2) (envelope-from ) id 1w3aC8-00000000BXu-3K0m for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 13:47:23 +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=NipYvoiIekV7iyuLbJe7PIR+GEg06ow2CnLGFtiqrcs=; b=icxBU/FX4s056Y1/0THvYH+1KE irQW9ypo11LSenu/BqiNoRfqafHFgWGoXCNbtfEY7jq2bzlLHn2zNI+gx71XXcknMdGtPj6JKBs08 2wJ0viCvbX41QaB8rNaKff/4KphnQDoR/3D9gB59oyfBD8npNMmrA7yNVe+FnS1PGv3zsZWxgS+sV ud7V4fX9fCUkdBapVLIbgDEhts7Ukj9i8lWnONgbyt5HdS5HCxEbbCIR6oHtWlfw1XYgycTTk3qGC +OJi4V3FPrPApjTOK2LzngeHFL+RU02Tvjld/N96beKARi/lxY/EgmQSHLHGxtpxoWpFo2UhPwmrV H89TcuRQ==; 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.96) (envelope-from ) id 1w3aC8-001zTs-0E for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 13:47:20 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3aC7-000eK9-0o for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 13:47:20 +0000 Content-Type: multipart/mixed; boundary="===============4075424889861208117==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix self-join removal to update bare Var references in join clau X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 20 Mar 2026 13:47:20 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4075424889861208117== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHNlbGYtam9pbiByZW1vdmFsIHRvIHVwZGF0ZSBiYXJlIFZhciByZWZlcmVuY2VzIGluIGpv aW4gY2xhdXNlcwoKU2VsZi1qb2luIHJlbW92YWwgZmFpbGVkIHRvIHVwZGF0ZSBWYXIgbm9kZXMg d2hlbiB0aGUgam9pbiBjbGF1c2Ugd2FzIGEKYmFyZSBWYXIgKGUuZy4sIE9OIHQxLmJvb2xfY29s KSByYXRoZXIgdGhhbiBhbiBleHByZXNzaW9uIGNvbnRhaW5pbmcKVmFycy4gIENoYW5nZVZhck5v ZGVzV2Fsa0V4cHJlc3Npb24oKSB1c2VkIGV4cHJlc3Npb25fdHJlZV93YWxrZXIoKSwKd2hpY2gg ZGVzY2VuZHMgaW50byBjaGlsZCBub2RlcyBidXQgZG9lcyBub3QgcHJvY2VzcyB0aGUgdG9wLWxl dmVsIG5vZGUKaXRzZWxmLiAgV2hlbiBhIGJhcmUgVmFyIHJlZmVyZW5jaW5nIHRoZSByZW1vdmVk IHJlbGF0aW9uIGFwcGVhcmVkIGFzCnRoZSBjbGF1c2UsIGl0cyB2YXJubyB3YXMgbGVmdCB1bmNo YW5nZWQsIGxlYWRpbmcgdG8gIm5vIHJlbGF0aW9uIGVudHJ5CmZvciByZWxpZCBOIiBlcnJvcnMu CgpGaXggYnkgY2FsbGluZyBDaGFuZ2VWYXJOb2Rlc193YWxrZXIoKSBkaXJlY3RseSBpbnN0ZWFk IG9mCmV4cHJlc3Npb25fdHJlZV93YWxrZXIoKSwgc28gdGhlIHRvcC1sZXZlbCBub2RlIGlzIGFs c28gcHJvY2Vzc2VkLgoKQnVnOiAjMTk0MzUKUmVwb3J0ZWQtYnk6IEhhbmcgQW1tbWtpbG8gPGFt bW1raWxvQDE2My5jb20+CkF1dGhvcjogQW5kcmVpIExlcGlraG92IDxsZXBpaG92QGdtYWlsLmNv bT4KQ28tYXV0aG9yZWQtYnk6IFRlbmRlciBXYW5nIDx0bmRyd2FuZ0BnbWFpbC5jb20+CkNvLWF1 dGhvcmVkLWJ5OiBBbGV4YW5kZXIgS29yb3Rrb3YgPGFla29yb3Rrb3ZAZ21haWwuY29tPgpSZXZp ZXdlZC1ieTogS2lyaWxsIFJlc2hrZSA8cmVzaGtla2lyaWxsQGdtYWlsLmNvbT4KRGlzY3Vzc2lv bjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0LzE5NDM1LTNjYzFh ODdmMjkxMTI5ZjElNDBwb3N0Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTgKCkJyYW5j aAotLS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZThiOWQ2NDk3NDY5ZGFkYjNjMmYzNzY1ZGZlZWQ3NDMy YWY3NzcwNAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvcmV3cml0 ZS9yZXdyaXRlTWFuaXAuYyB8ICA0ICstLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9qb2lu Lm91dCB8IDE2ICsrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvam9pbi5zcWwg ICAgICB8ICA2ICsrKysrKwozIGZpbGVzIGNoYW5nZWQsIDIzIGluc2VydGlvbnMoKyksIDMgZGVs ZXRpb25zKC0pCgo= --===============4075424889861208117==--