Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault

Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>> I can easily reproduce the segfault on 8.4 and 8.5a2:
>
> Doesn't crash here ... could we see the specific test data being used,
> please?

uploaded a dump of the dataset here:

http://www.kaltenbrunner.cc/files/rand_gen_data.sql

and the query that causes the segfault:

http://www.kaltenbrunner.cc/files/rand_gen_query.sql


Stefan