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
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. |
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. |