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

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Bernt M(dot) Johnsen" <Bernt(dot)Johnsen(at)Sun(dot)COM>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Date: 2009-10-30 06:21:17
Message-ID: 4AEA85DD.6010808@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message hx.li 2009-10-30 06:32:07 Re: BUG #5147: DBA can not access view
Previous Message Gray 2009-10-30 05:39:10 BUG #5150: math bug