| From: | "Elliott Groszek" <elliott(dot)groszek(at)navy(dot)mil> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5755: Query Optimzer Bug |
| Date: | 2010-11-16 22:39:07 |
| Message-ID: | 201011162239.oAGMd7ZR045353@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5755
Logged by: Elliott Groszek
Email address: elliott(dot)groszek(at)navy(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2010-11-17 05:03:30 | Re: BUG #5753: Existing Functions No Longer Work |
| Previous Message | Kris Jurka | 2010-11-16 22:13:52 | Re: BUG #5753: Existing Functions No Longer Work |