| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Pete Beck <pete(at)electrostrata(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1886: Bug in SQL parsing |
| Date: | 2005-09-16 13:59:35 |
| Message-ID: | 20050916065614.L69600@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, 16 Sep 2005, Pete Beck wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1886
> Logged by: Pete Beck
> Email address: pete(at)electrostrata(dot)com
> PostgreSQL version: 8.0.1 & 8.0.3
> Operating system: Linux and Windows
> Description: Bug in SQL parsing
> Details:
>
> Postgres incorrectly reports a relation is being missing in a SQL.
>
> The following query reports:
>
> ERROR: relation "product0_" does not exist
I believe this error is correct.
It looks to me like you have:
A Left join B on condition, C left join D on condition2
where condition2 refers to A.
IIRC, in standard SQL, the scope for condition contains A and B and the
scope for condition2 contains C and D but not A.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2005-09-16 14:17:14 | Re: BUG #1885: SHOW autovacuum settings tab completion broken |
| Previous Message | Michael Fuhr | 2005-09-16 13:00:49 | Re: BUG #1885: SHOW autovacuum settings tab completion broken |