Re: BUG #1886: Bug in SQL parsing - Mailing list pgsql-bugs

Well spotted! :-)
It looks like the bug must actually be with Hibernate, which generated
the offending code.

I'll take it up with those guys.

Thanks for your help!

Pete

Stephan Szabo wrote:
> 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@electrostrata.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.
>