Horton

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

Anthony SKORSKI <skorski.anthony@gmail.com>

View thread View on postgr.es
From: SKORSKI Anthony <skorski.anthony@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2019-04-09T08:00:58Z
Lists: pgsql-bugs 
Thanks for the impressive reactivity.
I will test it as soon as possible.

Regards

Le lun. 8 avr. 2019 à 22:13, Tom Lane <tgl@sss.pgh.pa.us> a écrit :

> 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.