Обсуждение: Bug #512: outer join bug

Hee-Sun, Choi (hurricane_blue@hanmail.net) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
outer join bug

Long Description
Hello!

i met a bug when i was using outer join..

see example code..

Sample Code
select * from
(select .. from .. where .. ) aa
left outer join
(select .. from .. where code='abc') bb on aa.id=bb.id
                        -----------

we will meet error if we will try to compare character in where-clause

No file was uploaded with this report

On Fri, 9 Nov 2001 pgsql-bugs@postgresql.org wrote:

> Hee-Sun, Choi (hurricane_blue@hanmail.net) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> outer join bug
>
> Long Description
> Hello!
>
> i met a bug when i was using outer join..
>
> see example code..
>
> Sample Code
> select * from
> (select .. from .. where .. ) aa
> left outer join
> (select .. from .. where code='abc') bb on aa.id=bb.id
>                         -----------
>
> we will meet error if we will try to compare character in where-clause

You're going to need to give a complete bug report with schema and
actual query and what version you're running.  I couldn't replicate
what I think you were trying on 7.2b1, but I'm not sure if I'm trying
the same case.

pgsql-bugs@postgresql.org writes:
> i met a bug when i was using outer join..

> see example code..

> Sample Code
> select * from
> (select .. from .. where .. ) aa
> left outer join
> (select .. from .. where code='abc') bb on aa.id=bb.id
>                         -----------

This bug report is completely useless, because we can't tell exactly
what you actually did, nor what you think is wrong.  Please review
the bug submission suggestions at
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/bug-reporting.html

            regards, tom lane