Re: Bug #795: null resulting from left join corrupts select

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: karsten(dot)merkle(at)artundweise(dot)de, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #795: null resulting from left join corrupts select
Date: 2002-10-10 14:30:33
Message-ID: 27813.1034260233@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> select
> *
> from
> test1 left join test2 on (test1.test1_id = test2.test1_id)
> where
> test1.test1_id = test2.test1_id;

Hm. I think what is happening is that the planner is (mistakenly)
deciding that the where-clause and on-clause are equivalent, and
so dropping the second one ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ruslan A Dautkhanov 2002-10-11 08:27:58 Re: Creating server-side functions: one simple error
Previous Message Tom Lane 2002-10-10 14:19:25 Re: Creating server-side functions: one simple error