Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data

From: "Ceschia, Marcello" <Marcello(dot)Ceschia(at)medizin(dot)uni-leipzig(dot)de>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>,"pgsql-patches" <pgsql-patches(at)postgresql(dot)org>,"PostgreSQL Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data
Date: 2008-04-04 07:20:16
Message-ID: 160E3DD4FB702C4CB860C65186686E690259F5E6@MRZS152229.medizin.uni-leipzig.de (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
-----Urspr√ľngliche Nachricht-----
Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Gesendet: Donnerstag, 3. April 2008 21:33
An: Heikki Linnakangas
Cc: Alvaro Herrera; pgsql-patches; Ceschia, Marcello; PostgreSQL Bugs
Betreff: Re: [PATCHES] Re: [BUGS] BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data 


> What I propose we do is throw error for the moment, and make a TODO
> note to revisit the question after redesigning outer-join planning.
> Which is something I do intend to do for 8.4.


For me that's a good solution. 
My motivation for reporting this bug was to notice the developer about the problem.

Of course the query we did is a strange way to get a result, but it was possible without warning/error. At the moment we use a function to join the tables one by one and for the moment it is working.

Thank you for your helps

 Marcello

In response to

pgsql-bugs by date

Next:From: Mikael OmmaDate: 2008-04-04 12:32:44
Subject: BUG #4090: ECPG Selecting table with NULL values
Previous:From: John SmithDate: 2008-04-04 00:57:43
Subject: BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts.

pgsql-patches by date

Next:From: Simon RiggsDate: 2008-04-04 12:37:49
Subject: Re: Expose checkpoint start/finish times into SQL.
Previous:From: Tom LaneDate: 2008-04-04 07:14:28
Subject: Re: Expose checkpoint start/finish times into SQL.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group