Re: [sqlsmith] Planner error on lateral joins

2020-11-29 Thread Tom Lane
I wrote: > Andreas Seltenreich 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

Re: [sqlsmith] Planner error on lateral joins

2020-11-29 Thread Tom Lane
Andreas Seltenreich 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.

[sqlsmith] Planner error on lateral joins

2020-11-29 Thread Andreas Seltenreich
Hi, testing with sqlsmith on master at 3df51ca8b3 produced one instance of the following error: ERROR: failed to build any 6-way joins I can reproduce it on a fresh regression database with the query below. These were last logged in 2015. Back then, it resulted in this commit: http:/