| Lists: | Postg무지개 토토SQL : Postg무지개 토토SQL 메일 링리스트 : 2001-11-09 이후 PGSQL-BUGS 07:42 |
|---|
| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug #512: outer join bug |
| Date: | 2001-11-09 07:42:00 |
| Message-ID: | 200111090742.fA97g0d41489@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg무지개 토토SQL : Postg무지개 토토SQL 메일 링리스트 : 2001-11-09 이후 PGSQL-BUGS 07:42 |
Hee-Sun, Choi (hurricane_blue(at)hanmail(dot)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
| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <hurricane_blue(at)hanmail(dot)net>, <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Bug #512: outer join bug |
| Date: | 2001-11-09 16:03:22 |
| Message-ID: | 20011109080145.V57927-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Fri, 9 Nov 2001 pgsql-bugs(at)postgresql(dot)org wrote:
> Hee-Sun, Choi (hurricane_blue(at)hanmail(dot)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.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | hurricane_blue(at)hanmail(dot)net, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug #512: outer join bug |
| Date: | 2001-11-09 17:16:39 |
| Message-ID: | 20730.1005326199@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
pgsql-bugs(at)postgresql(dot)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