From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Naylor <john.naylor@enterprisedb.com>
cc: cyg0810@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17097: FailedAssertion at initsplan.c
In-reply-to: 
 <CAFBsxsGKi_+kRMLy5QZk=+D0FJW91tO_UsXkcDfzwoaGYq8XKA@mail.gmail.com>
References: <17097-3372ef9f798fc94f@postgresql.org>
 <CAFBsxsHW60-r=JdH4Mh-MtchSkZ38tYcRnivutOhnXH0b1MdCQ@mail.gmail.com>
 <CAFBsxsGHwHMDuCDZj+ZDA6+Bzs02cdGPFSif7Mh-KH18wOT9LQ@mail.gmail.com>
 <2230092.1625848961@sss.pgh.pa.us>
 <CAFBsxsGKi_+kRMLy5QZk=+D0FJW91tO_UsXkcDfzwoaGYq8XKA@mail.gmail.com>
Comments: In-reply-to John Naylor <john.naylor@enterprisedb.com>
	message dated "Fri, 09 Jul 2021 12:53:37 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2257077.1625852398.1@sss.pgh.pa.us>
Date: Fri, 09 Jul 2021 13:39:58 -0400
Message-ID: <2257078.1625852398@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2257078.1625852398%40sss.pgh.pa.us>
Precedence: bulk

John Naylor <john.naylor@enterprisedb.com> writes:
> If it saves you some time, the assert happens here in
> replace_vars_in_jointree():

> case RTE_JOIN:
> case RTE_CTE:
> case RTE_NAMEDTUPLESTORE:
> case RTE_RESULT:
> /* these shouldn't be marked LATERAL */
> Assert(false);
> break;

> where the plan has RTE_RESULT

Ah.  When converting the FUNCTION RTE to a dummy RESULT,
we must clear its lateral flag to avoid making this
logic unhappy.  Fixed.

			regards, tom lane