| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: 8.2 bug with outer join reordering |
| Date: | 2006-12-06 20:59:32 |
| Message-ID: | 1346.1165438772@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> On 8.1 this returns 1 record. On 8.2 this returns 100000. It appears to
> be applying the filter too soon, and then it does an outer join which
> violates the WHERE.
AFAICS the outer join reordering is perfectly legal --- the problem is
that the WHERE condition is being allowed to bubble down too far.
I can't reproduce it with less than four tables, so it's a pretty
weird corner case. Apparently there's something wrong with
distribute_qual_to_rels' logic for determining qual placement, but
I'm not sure what yet ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-12-06 22:20:41 | Re: 8.2 bug with outer join reordering |
| Previous Message | Alex Piyevsky | 2006-12-06 20:38:49 | BUG #2812: Transaction is aborted after error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2006-12-06 21:25:18 | Re: SQL/PSM implemenation for PostgreSQL (roadmap) |
| Previous Message | Tom Lane | 2006-12-06 20:37:19 | Re: psql return codes |