Postgres Pro
Downloads
Home   >   mailing lists

Re: Errors "failed to construct the join relation" and "failed to build any 2-way joins" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Errors "failed to construct the join relation" and "failed to build any 2-way joins"
Date
Msg-id 726.1576218371@sss.pgh.pa.us
Whole thread Raw
In response to Errors "failed to construct the join relation" and "failed to buildany 2-way joins"  (Will Leinweber <will@bitfission.com>)
Responses Re: Errors "failed to construct the join relation" and "failed to build any 2-way joins"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Will Leinweber <will@bitfission.com> writes:
> On 12.1, fresh initdb the following query gives me the error
> "ERROR:  failed to construct the join relation"

I'm getting an assertion failure in an assert-enabled build, here:

(gdb) f 3
#3  0x00000000006f382a in create_lateral_join_info (root=0x2d380c8)
    at initsplan.c:637
637                     Assert(!bms_is_member(rti, lateral_relids));

Eyeing the plan produced by v11, I'm suspecting some oversight in
the RTE_RESULT changes (4be058fe9); but I haven't actually bisected.
Too tired to look closer right now.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: xact_start for walsender & logical decoding not updated
Next
From: vignesh C
Date:
Subject: Re: segmentation fault when cassert enabled