MIME-Version: 1.0
References: <CACZ67_UA_EVrqiFXJu9XK50baEpH=ofEPJswa2kFxg6xuSw-ww@mail.gmail.com>
 <2090950.1732810550@sss.pgh.pa.us> <CACZ67_ULS3HExOnRou1SXZZMzcAA2fE_WF3pzaFDEDW9v3ACMQ@mail.gmail.com>
 <23000.1732819862@sss.pgh.pa.us> <374985.1732833325@sss.pgh.pa.us>
In-Reply-To: <374985.1732833325@sss.pgh.pa.us>
From: Bertrand Mamasam <golgote@gmail.com>
Date: Fri, 29 Nov 2024 00:13:10 +0100
Message-ID: <CACZ67_XehfH392C_oZMTEynW23YDZcDscUzFvbpkJK7K10c-4g@mail.gmail.com>
Subject: Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN
 LATERAL and CTE
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007f80300628013a33"
Archived-At: <https://www.postgresql.org/message-id/CACZ67_XehfH392C_oZMTEynW23YDZcDscUzFvbpkJK7K10c-4g%40mail.gmail.com>
Precedence: bulk

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

On Thu, Nov 28, 2024 at 11:35=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote=
:

> I wrote:
> > Thanks for the test case!  A quick "git bisect" says I broke it at
> > cb8e50a4a09fe541e32cd54ea90a97f2924121a1 is the first bad commit
> > commit cb8e50a4a09fe541e32cd54ea90a97f2924121a1
> > Author: Tom Lane <tgl@sss.pgh.pa.us>
> > Date:   Fri Aug 30 12:42:12 2024 -0400
> >     Avoid inserting PlaceHolderVars in cases where pre-v16 PG did not.
> > Apparently that change was less safe than I thought.  Looking ...
>
> Fixed here:
>
>
> https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommitdiff;h=3D=
85990e2fd5610576635c65db9292297b1730c947
>
> Thanks for the report!
>

Excellent ! Thank you very much !!!

Bertrand

--0000000000007f80300628013a33
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Nov 28, 2024 at 11:35=E2=80=AFPM =
Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;=
 wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex">I wrote:<br>
&gt; Thanks for the test case!=C2=A0 A quick &quot;git bisect&quot; says I =
broke it at<br>
&gt; cb8e50a4a09fe541e32cd54ea90a97f2924121a1 is the first bad commit<br>
&gt; commit cb8e50a4a09fe541e32cd54ea90a97f2924121a1<br>
&gt; Author: Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us" target=3D"_b=
lank">tgl@sss.pgh.pa.us</a>&gt;<br>
&gt; Date:=C2=A0 =C2=A0Fri Aug 30 12:42:12 2024 -0400<br>
&gt;=C2=A0 =C2=A0 =C2=A0Avoid inserting PlaceHolderVars in cases where pre-=
v16 PG did not.<br>
&gt; Apparently that change was less safe than I thought.=C2=A0 Looking ...=
<br>
<br>
Fixed here:<br>
<br>
<a href=3D"https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommit=
diff;h=3D85990e2fd5610576635c65db9292297b1730c947" rel=3D"noreferrer" targe=
t=3D"_blank">https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcomm=
itdiff;h=3D85990e2fd5610576635c65db9292297b1730c947</a><br>
<br>
Thanks for the report!<br></blockquote><div><br></div><div>Excellent ! Than=
k you very much  !!!</div><div><br></div><div>Bertrand <br></div></div></di=
v>

--0000000000007f80300628013a33--