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-08T20:13:42Z
Lists: pgsql-bugs 
I wrote:
> 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 ...

Fixed at
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=051c71c6746309782d9bf1ebb257d3b5f88e6fb7

			regards, tom lane

Commits

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