Horton

Re: Small query using LATERAL that segfaults Postgres

Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>

View thread View on postgr.es
From: Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
To: pgsql-bugs@lists.postgresql.org
Date: 2020-07-14T09:00:18Z
Lists: pgsql-bugs 
On Mon, Jul 13, 2020 at 08:40:38PM -0400, Tom Lane wrote:
> Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk> writes:
> > This small query seems to segfault Postgres.  I've tried on the
> > version of Postgres 11 that comes with Debian Stable and all versions
> > on https://www.db-fiddle.com/ including 13 (Beta).  DB Fiddle actually
> > says "An unexpected error occurred." but I suspect that's the
> > segfault.
> 
> Hm, looks like this has been wrong since we introduced LATERAL :-(.
> I pushed a band-aid fix.  Thanks for the report!

Thanks Tom.  Could you send a link to the fix?  I'd be interested to
see what the problem was.

Tom

Commits

  1. Cope with lateral references in the quals of a subquery RTE.