Horton

Re: BUG #15741: ERROR: failed to build any 3-way joins

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: skorski.anthony@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2019-04-08T14:13:58Z
Lists: pgsql-bugs 
PG Bug reporting form <noreply@postgresql.org> writes:
> Trying to build a tool which automatically builds queries to "flatten" JSONB
> fields, I came to a `ERROR: failed to build any 3-way joins` message while
> trying to execute some of those queries.

Yeah, that's certainly a bug.  I'll take a look later ...

			regards, tom lane

Commits

  1. Fix improper interaction of FULL JOINs with lateral references.