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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-patches by date

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