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 1w2qzO-000fSc-2U for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Mar 2026 13:31:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2qzN-00B3r0-2L for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Mar 2026 13:31:09 +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.96) (envelope-from ) id 1w2qzN-00B3qs-18 for pgsql-bugs@lists.postgresql.org; Wed, 18 Mar 2026 13:31:09 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2qzG-00000000MbV-2zrH for pgsql-bugs@lists.postgresql.org; Wed, 18 Mar 2026 13:31:08 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-4327790c4e9so5022435f8f.2 for ; Wed, 18 Mar 2026 06:31:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773840663; x=1774445463; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=jIP5R5acV223WupiaT7rEo95By2XU8RkMGc5pEHg0Do=; b=Ey3mzGPuG+BBUWuh5kg7OtPvFPiliONcsV23tMAVvhhAYx0lRg0tloo4z/xYz8ni0g h2/wtf19fk0eqWCHo2KBfXfjtoOGqYUugHLfw4mAePAW7AM61n1XfhydbhnQ+C9+nVxz skb4CrCCTXtXxtaZJekaxx9j+QQOX3wmVcq0z2hIgHmTVLZtz+0YP52Q7NSPnZdDcJ2K EvsjFeTyDJCD7XVHAjMHKCh3Ga0JD72NGgzATVOLdLCp495j+xCoLe6TlBfEV3c6/Z7l 0AEvUfiSes8cTbieneA3Gk8q8mq9Gbc8HQeMqvo2rU//BnKOe3whFSam00m/y7MZLbcT aeXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773840663; x=1774445463; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=jIP5R5acV223WupiaT7rEo95By2XU8RkMGc5pEHg0Do=; b=XvlA8RW8okpWLHqhzcK/lgBMWB5idST5yTx8PIgvLpB8cwqg4NMHJOPuzPXXGvXoYq mgT55Q88fWJzgw/sPXKbzdesKQORR1bRhCqC/3aWB3p86CSMD0QNW/eMrlRBrs+2enNP OODp2f0wPVXomt7qkwX+JXGmWBBI0nJOPAhz3e4P5U0TXxOn0amCuBxgwH7+CUIVkA1B 5cmJ1PH+8aMG0aQ1QEy0Kt0lIAkuJhWGFqCEB7kq7hRBNVaGCa8amff8BP7otfqQbSmb SndNfi0a7adCLrFLvB368FVtaKJgpNIIa2axCy5WTxbkY6FIZCTd9syh/EGyPI1aOIUP XYew== X-Forwarded-Encrypted: i=1; AJvYcCW38bBlxuW900FWLGwRk4+T6HrFs9yZMBj6jSGdFhYtg/wSnFIFkf54DnZGyX7zSRm8ejIVJq0+M2HT@lists.postgresql.org X-Gm-Message-State: AOJu0YzDdgGU+7ZGDn8BrF2n8O8BcEjxEBGto/SgkAW4B5t7ta4G5tbb pk4csvLIn0rmEQvQBnaFNeQyDFDPzOTBwXokYZ9dERcozuoHktdgqFe4 X-Gm-Gg: ATEYQzxK+/fQtHxU7UyTVSCxAx2MKA8MRpNtjnUK/8KySUSSTD6sBV9/ogdw59O58cy A8v9q92wP6eLXQNvnipBtAMzmCz6pE85gaJ8++IbZTf8VBvv7o33yz5peGb2KKWzu9fArdY1WOp Bz/1BJ4Zut555Pq36DNJU5IUEWkmDRw4kn50ZuTHPHt7C5CiuKL1vAsc/esBvzuXoT+sBxhJar2 LMEaZzVUVkh3qFrNbid91SAcDL+FuGrDVpncptGoxaj9tspe5wndf5OuWEFIjbHoOfGwMccmzia EtTC3BsBWRbrUQ86vot7QGSyqxOJlX/tUi2pMA9OhvOkc1gCN9ZKf5DPttkOiCgM0Rgtudyv/j+ 8BNj8VN0NVrC5ifAEvnUmZJCoCFPhG2Difa3PVFMurMBUoUIEiR+tpcMBkD1GHdfl4LQzob9ua1 THpMBvIEATvLRgjh4WqGWXjmJRDNY8Fa5Gv3prHQ== X-Received: by 2002:a05:600c:8486:b0:485:3692:e8f7 with SMTP id 5b1f17b1804b1-486f445e320mr49187825e9.25.1773840662509; Wed, 18 Mar 2026 06:31:02 -0700 (PDT) Received: from [192.168.15.192] ([80.251.191.198]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43b5184962bsm7964414f8f.7.2026.03.18.06.31.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 18 Mar 2026 06:31:01 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------MFA9wOEn0AVJHEbdqQ1zc2tU" Message-ID: Date: Wed, 18 Mar 2026 14:31:00 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables To: Alexander Korotkov Cc: Tender Wang , Kirill Reshke , Fujii Masao , ammmkilo@163.com, pgsql-bugs@lists.postgresql.org References: <19435-3cc1a87f291129f1@postgresql.org> Content-Language: en-US From: Andrei Lepikhov In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------MFA9wOEn0AVJHEbdqQ1zc2tU Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 18/3/26 13:21, Alexander Korotkov wrote: > On Wed, Mar 18, 2026 at 2:18 PM Andrei Lepikhov wrote: >> What is the reason for the second change? Tender, can you show us how to >> reproduce the issue so we can support your update to >> restrict_infos_logically_equal? If we include it, we should add a test. > > I think Tender already shown this in [1]. The same qual is present > twice in the plan. Got it. I suggest making this a separate commit to keep the history clear. Let me share a draft with a test case for the bug fix first. -- regards, Andrei Lepikhov, pgEdge --------------MFA9wOEn0AVJHEbdqQ1zc2tU Content-Type: text/plain; charset=UTF-8; name="0001-Fix-self-join-removal-to-update-bare-Var-references-.patch" Content-Disposition: attachment; filename*0="0001-Fix-self-join-removal-to-update-bare-Var-references-.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA4NmU2NWUxNmM3NmZlNDA0Y2I1YTE2ZGQwZDg5YTU4M2RhOWI2MmU2IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiQW5kcmVpIFYuIExlcGlraG92IiA8bGVwaWhvdkBn bWFpbC5jb20+CkRhdGU6IFdlZCwgMTggTWFyIDIwMjYgMTQ6MjM6NDYgKzAxMDAKU3ViamVj dDogW1BBVENIXSBGaXggc2VsZi1qb2luIHJlbW92YWwgdG8gdXBkYXRlIGJhcmUgVmFyIHJl ZmVyZW5jZXMgaW4gam9pbgogY2xhdXNlcwoKU2VsZi1qb2luIHJlbW92YWwgZmFpbGVkIHRv IHVwZGF0ZSBWYXIgbm9kZXMgd2hlbiB0aGUgam9pbiBjbGF1c2Ugd2FzIGEKYmFyZSBWYXIg KGUuZy4sIE9OIHQxLmJvb2xfY29sKSByYXRoZXIgdGhhbiBhbiBleHByZXNzaW9uIGNvbnRh aW5pbmcKVmFycy4gIENoYW5nZVZhck5vZGVzV2Fsa0V4cHJlc3Npb24oKSB1c2VkIGV4cHJl c3Npb25fdHJlZV93YWxrZXIoKSwKd2hpY2ggZGVzY2VuZHMgaW50byBjaGlsZCBub2RlcyBi dXQgZG9lcyBub3QgcHJvY2VzcyB0aGUgdG9wLWxldmVsIG5vZGUKaXRzZWxmLiAgV2hlbiBh IGJhcmUgVmFyIHJlZmVyZW5jaW5nIHRoZSByZW1vdmVkIHJlbGF0aW9uIGFwcGVhcmVkIGFz CnRoZSBjbGF1c2UsIGl0cyB2YXJubyB3YXMgbGVmdCB1bmNoYW5nZWQsIGxlYWRpbmcgdG8g Im5vIHJlbGF0aW9uIGVudHJ5CmZvciByZWxpZCBOIiBlcnJvcnMuCgpGaXggYnkgY2FsbGlu ZyBDaGFuZ2VWYXJOb2Rlc193YWxrZXIoKSBkaXJlY3RseSBpbnN0ZWFkIG9mCmV4cHJlc3Np b25fdHJlZV93YWxrZXIoKSwgc28gdGhlIHRvcC1sZXZlbCBub2RlIGlzIGFsc28gcHJvY2Vz c2VkLgoKQnVnOiAjMTk0MzUKQXV0aG9yOiBBbGV4YW5kZXIgS29yb3Rrb3YgPGFla29yb3Rr b3ZAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogVGVuZGVyIFdhbmcgPHRuZHJ3YW5nQGdtYWls LmNvbT4KUmV2aWV3ZWQtYnk6IEFuZHJlaSBMZXBpa2hvdiA8bGVwaWhvdkBnbWFpbC5jb20+ ClJldmlld2VkLWJ5OiBLaXJpbGwgUmVzaGtlIDxyZXNoa2VraXJpbGxAZ21haWwuY29tPgpE aXNjdXNzaW9uOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQv MTk0MzUtM2NjMWE4N2YyOTExMjlmMSU0MHBvc3RncmVzcWwub3JnCi0tLQogc3JjL2JhY2tl bmQvcmV3cml0ZS9yZXdyaXRlTWFuaXAuYyB8ICA0ICstLS0KIHNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvam9pbi5vdXQgfCAxNiArKysrKysrKysrKysrKysrCiBzcmMvdGVzdC9yZWdy ZXNzL3NxbC9qb2luLnNxbCAgICAgIHwgIDYgKysrKysrCiAzIGZpbGVzIGNoYW5nZWQsIDIz IGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tl bmQvcmV3cml0ZS9yZXdyaXRlTWFuaXAuYyBiL3NyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0 ZU1hbmlwLmMKaW5kZXggZmU4OTc1NGE3M2MuLjYxMGVkZjEwMjg0IDEwMDY0NAotLS0gYS9z cmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVNYW5pcC5jCisrKyBiL3NyYy9iYWNrZW5kL3Jl d3JpdGUvcmV3cml0ZU1hbmlwLmMKQEAgLTc0NCw5ICs3NDQsNyBAQCBDaGFuZ2VWYXJOb2Rl cyhOb2RlICpub2RlLCBpbnQgcnRfaW5kZXgsIGludCBuZXdfaW5kZXgsIGludCBzdWJsZXZl bHNfdXApCiBib29sCiBDaGFuZ2VWYXJOb2Rlc1dhbGtFeHByZXNzaW9uKE5vZGUgKm5vZGUs IENoYW5nZVZhck5vZGVzX2NvbnRleHQgKmNvbnRleHQpCiB7Ci0JcmV0dXJuIGV4cHJlc3Np b25fdHJlZV93YWxrZXIobm9kZSwKLQkJCQkJCQkJICBDaGFuZ2VWYXJOb2Rlc193YWxrZXIs Ci0JCQkJCQkJCSAgKHZvaWQgKikgY29udGV4dCk7CisJcmV0dXJuIENoYW5nZVZhck5vZGVz X3dhbGtlcihub2RlLCBjb250ZXh0KTsKIH0KIAogLyoKZGlmZiAtLWdpdCBhL3NyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbi5vdXQgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVk L2pvaW4ub3V0CmluZGV4IGVhM2RhYmZmNzdjLi5iZjc1OGY4ODFhYyAxMDA2NDQKLS0tIGEv c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9qb2luLm91dAorKysgYi9zcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2pvaW4ub3V0CkBAIC04MDkxLDYgKzgwOTEsMjIgQEAgV0hFUkUgcTAu YSA9IDE7CiAgICAtPiAgU2VxIFNjYW4gb24gc2ogbjEKICg3IHJvd3MpCiAKKy0tIEJVRyAj MTk0MzUgRG8gbm90IGZvcmdldCB0byByZXBsYWNlIHJlbGlkIGluIGJhcmUgVmFyIGpvaW4g Y2xhdXNlCitBTFRFUiBUQUJMRSBzbCBBREQgQ09MVU1OIGNvb2xfYm9vbCBib29sZWFuOwor RVhQTEFJTiAoQ09TVFMgT0ZGKQorU0VMRUNUIDEgQVMgYzEgRlJPTSBzbCBzbDEgTEVGVCBK T0lOIChzbCBBUyBzbDIgTkFUVVJBTCBKT0lOIHNsIEFTIHNsMykKKyAgT04gc2wyLmNvb2xf Ym9vbCBMRUZUIEpPSU4gc2wgQVMgc2w0IE9OIHNsMi5jb29sX2Jvb2w7CisgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBM QU4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAKKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQorIE5lc3RlZCBMb29wIExlZnQgSm9pbgorICAgLT4g IFNlcSBTY2FuIG9uIHNsIHNsMQorICAgLT4gIE5lc3RlZCBMb29wIExlZnQgSm9pbgorICAg ICAgICAgSm9pbiBGaWx0ZXI6IHNsMy5jb29sX2Jvb2wKKyAgICAgICAgIC0+ICBTZXEgU2Nh biBvbiBzbCBzbDMKKyAgICAgICAgICAgICAgIEZpbHRlcjogKGNvb2xfYm9vbCBBTkQgKGEg SVMgTk9UIE5VTEwpIEFORCAoYiBJUyBOT1QgTlVMTCkgQU5EIChjIElTIE5PVCBOVUxMKSBB TkQgKGNvb2xfYm9vbCBJUyBOT1QgTlVMTCkpCisgICAgICAgICAtPiAgU2VxIFNjYW4gb24g c2wgc2w0CisoNyByb3dzKQorCiAtLSBDaGVjayBvcHRpbWl6YXRpb24gZGlzYWJsaW5nIGlm IGl0IHdpbGwgdmlvbGF0ZSBzcGVjaWFsIGpvaW4gY29uZGl0aW9ucy4KIC0tIFR3byBpZGVu dGljYWwgam9pbmVkIHJlbGF0aW9ucyBzYXRpc2ZpZXMgc2VsZiBqb2luIHJlbW92YWwgY29u ZGl0aW9ucyBidXQKIC0tIHN0YXkgaW4gZGlmZmVyZW50IHNwZWNpYWwgam9pbiBpbmZvcy4K ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2pvaW4uc3FsIGIvc3JjL3Rlc3Qv cmVncmVzcy9zcWwvam9pbi5zcWwKaW5kZXggYWQ5MGMzMjZjMDAuLmZhZjA3ZjdjNGFiIDEw MDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbAorKysgYi9zcmMvdGVz dC9yZWdyZXNzL3NxbC9qb2luLnNxbApAQCAtMzE1Niw2ICszMTU2LDEyIEBAIFNFTEVDVCAq IEZST00KIChTRUxFQ1QgbjIuYSBGUk9NIHNqIG4xLCBzaiBuMiBXSEVSRSBuMS5hIDw+IG4y LmEpIHEwLCBzbAogV0hFUkUgcTAuYSA9IDE7CiAKKy0tIEJVRyAjMTk0MzUgRG8gbm90IGZv cmdldCB0byByZXBsYWNlIHJlbGlkIGluIGJhcmUgVmFyIGpvaW4gY2xhdXNlCitBTFRFUiBU QUJMRSBzbCBBREQgQ09MVU1OIGNvb2xfYm9vbCBib29sZWFuOworRVhQTEFJTiAoQ09TVFMg T0ZGKQorU0VMRUNUIDEgQVMgYzEgRlJPTSBzbCBzbDEgTEVGVCBKT0lOIChzbCBBUyBzbDIg TkFUVVJBTCBKT0lOIHNsIEFTIHNsMykKKyAgT04gc2wyLmNvb2xfYm9vbCBMRUZUIEpPSU4g c2wgQVMgc2w0IE9OIHNsMi5jb29sX2Jvb2w7CisKIC0tIENoZWNrIG9wdGltaXphdGlvbiBk aXNhYmxpbmcgaWYgaXQgd2lsbCB2aW9sYXRlIHNwZWNpYWwgam9pbiBjb25kaXRpb25zLgog LS0gVHdvIGlkZW50aWNhbCBqb2luZWQgcmVsYXRpb25zIHNhdGlzZmllcyBzZWxmIGpvaW4g cmVtb3ZhbCBjb25kaXRpb25zIGJ1dAogLS0gc3RheSBpbiBkaWZmZXJlbnQgc3BlY2lhbCBq b2luIGluZm9zLgotLSAKMi41MS4wCgo= --------------MFA9wOEn0AVJHEbdqQ1zc2tU--