Re: BUG #18859: ERROR: unexpected plan node type: 356 - Mailing list pgsql-bugs

Andrei Lepikhov <lepihov@gmail.com> writes:
> On 21/3/2025 14:00, Tom Lane wrote:
>> Yeah, I'd just come to the same conclusion.  I guess we can make
>> this code look through a Material node as well as Gather.

> Yes, as I see there are no additional corner cases. See the code in
> attachment.

I think actually we want to use the same processing as for Gather,
in particular the check for a Const.  That's all about what
setrefs.c will do to the plan tree, and it'll do the same things
to Material as it would to Gather.  Since that stanza doesn't
actually do anything that's specific to Gather, the code change
can be as simple as

@@ -8323,7 +8325,7 @@ exec_save_simple_expr(PLpgSQL_expr *expr, CachedPlan *cplan)
                    ((Result *) plan)->resconstantqual == NULL);
             break;
         }
-        else if (IsA(plan, Gather))
+        else if (IsA(plan, Gather) || IsA(plan, Material))
         {
             Assert(plan->lefttree != NULL &&
                    plan->righttree == NULL &&

I fixed that, did some cosmetic fooling with the comment
and test case, and pushed it.  Thanks for the report,
and for the patch!

            regards, tom lane