MIME-Version: 1.0
References: <19435-3cc1a87f291129f1@postgresql.org> <CAHGQGwEEHFnH8DsZbwxdZeiHozm2LCRTLSgL8Qn=5MoN4450ZA@mail.gmail.com>
 <CAPpHfdsDQhDqvqi+-UxvyYRP72ASkdWzCn43e2Hj6WsY15opvA@mail.gmail.com>
 <CAHewXNmU3E0oXLgvoOtXw7kfTiAZsKu8La_hQ=pyScgxvP45iw@mail.gmail.com>
 <CAHewXN=LjuWz3PcyhjdbJAyo+Zs9MisPDRYnSZBUy4PMeKi+zA@mail.gmail.com>
 <CALdSSPj1kTTQvmV3H3HMf5P3um8ybxoH3DaTPm+XgdYAur1Q4A@mail.gmail.com> <CAHewXNndByMu3S+_h4LLDkXA5qrO1s=s-CE8HqUtc9vTA9yrjg@mail.gmail.com>
In-Reply-To: <CAHewXNndByMu3S+_h4LLDkXA5qrO1s=s-CE8HqUtc9vTA9yrjg@mail.gmail.com>
From: Alexander Korotkov <aekorotkov@gmail.com>
Date: Tue, 17 Mar 2026 19:46:18 +0200
Message-ID: <CAPpHfdv6gzSTXHJxYSgB8sULadXM4wvhgoQODaOxYCJfagKNPw@mail.gmail.com>
Subject: Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by
 Complex Join with Self-Referencing Tables
To: Tender Wang <tndrwang@gmail.com>
Cc: Kirill Reshke <reshkekirill@gmail.com>, Fujii Masao <masao.fujii@gmail.com>, ammmkilo@163.com, 
	pgsql-bugs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="0000000000006f89c4064d3bea60"
Archived-At: <https://www.postgresql.org/message-id/CAPpHfdv6gzSTXHJxYSgB8sULadXM4wvhgoQODaOxYCJfagKNPw%40mail.gmail.com>
Precedence: bulk

--0000000000006f89c4064d3bea60
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Mar 17, 2026 at 3:30=E2=80=AFPM Tender Wang <tndrwang@gmail.com> wr=
ote:
> Kirill Reshke <reshkekirill@gmail.com> =E4=BA=8E2026=E5=B9=B43=E6=9C=8817=
=E6=97=A5=E5=91=A8=E4=BA=8C 21:24=E5=86=99=E9=81=93=EF=BC=9A
> >
> > On Tue, 17 Mar 2026 at 18:20, Tender Wang <tndrwang@gmail.com> wrote:
> > Yes, it looks like your analysis is valid. Will you share a patch for
> > updating `clause` ?
> >
> Sorry, it's already the middle of the night here, so I'm afraid I
> don't have much time to work on this right now.

Thank you for your research.  I've written a simple draft patch.  It
fixes the reported case, but I doubt it is correct in general.  I'll
continue the investigation.

------
Regards,
Alexander Korotkov
Supabase

--0000000000006f89c4064d3bea60
Content-Type: application/octet-stream; name="sje_joininfo_fix.patch"
Content-Disposition: attachment; filename="sje_joininfo_fix.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mmuwkee90>
X-Attachment-Id: f_mmuwkee90

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2FuYWx5emVqb2lucy5jIGIv
c3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vYW5hbHl6ZWpvaW5zLmMKaW5kZXggMTJlOWVkMGQw
YzcuLjY4YmZiNzZhNWIwIDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9h
bmFseXplam9pbnMuYworKysgYi9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9hbmFseXplam9p
bnMuYwpAQCAtMTk1Nyw2ICsxOTU3LDEyIEBAIHJlbW92ZV9zZWxmX2pvaW5fcmVsKFBsYW5uZXJJ
bmZvICpyb290LCBQbGFuUm93TWFyayAqa21hcmssIFBsYW5Sb3dNYXJrICpybWFyaywKIAlDaGFu
Z2VWYXJOb2Rlc0V4dGVuZGVkKChOb2RlICopIHJvb3QtPnBhcnNlLCB0b1JlbW92ZS0+cmVsaWQs
IHRvS2VlcC0+cmVsaWQsCiAJCQkJCQkgICAwLCByZXBsYWNlX3JlbGlkX2NhbGxiYWNrKTsKIAor
CWZvcmVhY2hfbm9kZShSZXN0cmljdEluZm8sIHJpbmZvLCB0b0tlZXAtPmpvaW5pbmZvKQorCXsK
KwkJQ2hhbmdlVmFyTm9kZXNFeHRlbmRlZCgoTm9kZSAqKSByaW5mby0+Y2xhdXNlLCB0b1JlbW92
ZS0+cmVsaWQsCisJCQkJCQkJICAgdG9LZWVwLT5yZWxpZCwgMCwgcmVwbGFjZV9yZWxpZF9jYWxs
YmFjayk7CisJfQorCiAJLyogUmVwbGFjZSBsaW5rcyBpbiB0aGUgcGxhbm5lciBpbmZvICovCiAJ
cmVtb3ZlX3JlbF9mcm9tX3F1ZXJ5KHJvb3QsIHRvUmVtb3ZlLCB0b0tlZXAtPnJlbGlkLCBOVUxM
LCBOVUxMKTsKIAo=
--0000000000006f89c4064d3bea60--