Postgres Pro
Downloads
Home   >   mailing lists

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

From Elliott Groszek
Subject BUG #5755: Query Optimzer Bug
Date
Msg-id 201011162239.oAGMd7ZR045353@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5755: Query Optimzer Bug
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5755
Logged by:          Elliott Groszek
Email address:      elliott.groszek@navy.mil
PostgreSQL version: 8.4.4
Operating system:   RedHat
Description:        Query Optimzer Bug
Details:

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);

Please advise,  Elliott

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #5753: Existing Functions No Longer Work
Next
From: Tom Lane
Date:
Subject: Re: BUG #5755: Query Optimzer Bug