Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5755: Query Optimzer Bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5755: Query Optimzer Bug
Date
Msg-id 27568.1290009930@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5755: Query Optimzer Bug  ("Elliott Groszek" <elliott.groszek@navy.mil>)
Responses Re: BUG #5755: Query Optimzer Bug  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
Tree view 
"Elliott Groszek" <elliott.groszek@navy.mil> writes:
> The following SQL statements produce different query plans even though
> "phone" is not reference in the SQL!

> explain update customer set login_name =
> (select "NESSOuserName" from person,phone
> where person.cac_cert=customer.cac_cert);

> explain update customer set login_name =
> (select "NESSOuserName" from person
> where person.cac_cert=customer.cac_cert);

That's not a bug.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Elliott Groszek"
Date:
Subject: BUG #5755: Query Optimzer Bug
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #5755: Query Optimzer Bug