Horton

Re: Small query using LATERAL that segfaults Postgres

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2020-07-14T00:40:38Z
Lists: pgsql-bugs 
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!

			regards, tom lane

Commits

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