Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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. 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: Fri, 30 Oct 2009 07:21:17 +0100
- Message-id: <4AEA85DD.6010808@kaltenbrunner.cc> <text/plain>
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
- Follow-Ups:
- References:
- BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- From: Bernt Marius Johnsen
- Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- From: Euler Taveira de Oliveira
- Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- From: Bernt M. Johnsen
- Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- From: Stefan Kaltenbrunner
- Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- From: Tom Lane
- BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- Prev by Date: BUG #5150: math bug
- Next by Date: Re: BUG #5147: DBA can not access view
- Previous by thread: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- Next by thread: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- Indexes: