Re: BUG #17097: FailedAssertion at initsplan.c

John Naylor <john.naylor@enterprisedb.com>

From: John Naylor <john.naylor@enterprisedb.com>
To: cyg0810@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2021-07-09T15:57:30Z
Lists: pgsql-bugs
I wrote:

> Thanks for the report! Unfortunately, the stack trace was not
informative, because there are no debug symbols. Here's a minimal
reproducer, which also traps an assertion on PG13. I'll bisect and see how
far back it goes.

The reproducer I shared stopped working at 7266d0997dd2a (Allow
functions-in-FROM to be pulled up if they reduce to constants). I'll dig
deeper a bit later unless someone beats me to it.

--
John Naylor
EDB: http://www.enterprisedb.com

Commits

  1. Avoid creating a RESULT RTE that's marked LATERAL.