| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | nickf(at)ontko(dot)com |
| Cc: | "PGSQL-SQL" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: RIGHT JOIN is only supported with mergejoinable join conditions |
| Date: | 2001-11-07 19:06:08 |
| Message-ID: | 5788.1005159968@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
"Nick Fankhauser" <nickf(at)ontko(dot)com> writes:
> and
> (
> local_case_type.local_case_subtype_code =
> case_data.local_case_type_code
> )
Did you actually mean to match local_case_subtype_code against
local_case_type_code, or is that a typo?
I believe you have uncovered a planner bug, but the bug may be triggered
by the partial overlap of this join condition with the next one.
Assuming that it's a typo, you may find that you avoid the problem by
fixing the typo.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-11-07 19:14:54 | Re: MD5-based passwords |
| Previous Message | Nick Fankhauser | 2001-11-07 18:29:44 | Re: RIGHT JOIN is only supported with mergejoinable join conditions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fstelpstra@yahoo.com | 2001-11-07 20:49:39 | Re: Design Tool for postgresql |
| Previous Message | Nick Fankhauser | 2001-11-07 18:29:44 | Re: RIGHT JOIN is only supported with mergejoinable join conditions |