EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Wrong result on outer join  XML

Forum Index » GridSQL - General
Author Message
[Post New]16/12/2008 20:52:01
    Subject: Wrong result on outer join
[Up]
Don_N

New member

Joined: 03/12/2008 17:15:20
Messages: 9
Offline
create table t1 (id int);
create table t2 (id int);
insert into t1 values (1);
select * from t1 left join t2 on t2.id = 0;

Result:

no rows to display

Expected:

1, null
[Post New]17/12/2008 17:37:25
    Subject: Re:Wrong result on outer join
[Up]
Mason_S

Senior member

Joined: 01/04/2008 09:03:08
Messages: 366
Offline
It looks like we have a bug when the ON clause does not actually contain a join condition. We will investigate.

Regards,

Mason Sharp
[WWW]
 
Forum Index » GridSQL - General
Go to:   
Powered by JForum 2.1.8 © JForum Team