| 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-30 02:18:15 |
| Message-ID: | 1148060.1606702695@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wrote:
> 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.
Seems to be a missed consideration in add_placeholders_to_joinrel.
The attached fixes it for me.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| fix-lateral-relids-for-unused-PHV.patch | text/x-diff | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuro Yamada | 2020-11-30 02:19:10 | Re: list of extended statistics on psql |
| Previous Message | Craig Ringer | 2020-11-30 02:12:35 | Re: Printing LSN made easy |