Re: [sqlsmith] Planner error on lateral joins

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [sqlsmith] Planner error on lateral joins
Date: 2020-11-29 20:39:42
Message-ID: 1106991.1606682382@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Seltenreich <seltenreich(at)gmx(dot)de> writes:
> testing with sqlsmith on master at 3df51ca8b3 produced one instance of
> the following error:
> ERROR: failed to build any 6-way joins

Thanks for the test case! The attached modification to use only
longstanding test tables fails back to 9.5, but succeeds in 9.4.
I've not tried to bisect yet.

regards, tom lane

Attachment Content-Type Size
lateraljoinbug.sql text/plain 668 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul A Jungwirth 2020-11-29 20:53:40 Re: range_agg
Previous Message Tom Lane 2020-11-29 20:29:00 Re: [sqlsmith] parallel worker errors "subplan ... was not initialized"