Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data - Mailing list pgsql-bugs

From Ceschia, Marcello
Subject Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data
Date
Msg-id 160E3DD4FB702C4CB860C65186686E690259F5E6@MRZS152229.medizin.uni-leipzig.de
Whole thread Raw
In response to Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl@sss.pgh.pa.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
weuse a function to join the tables one by one and for the moment it is working. 

Thank you for your helps

 Marcello

pgsql-bugs by date:

Previous
From: "John Smith"
Date:
Subject: BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts.
Next
From: "John Smith"
Date:
Subject: Re: BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts.