| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Bug in planner |
| Date: | 2015-04-24 09:43:41 |
| Message-ID: | 553A104D.6040403@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi!
I faced with planner error:
ERROR: could not find RelOptInfo for given relids
A test case is in attachment, all supported versions of pgsql and HEAD are
affected.
Suppose, there is something wrong in pull_up_sublinks_qual_recurse() near
converting NOT EXISTS into join, because preventing such convertion makes query
worked. But I'm not sure.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| Attachment | Content-Type | Size |
|---|---|---|
| bug.sql | text/plain | 988 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Jacobson | 2015-04-24 10:11:28 | Re: PL/pgSQL, RAISE and error context |
| Previous Message | Shigeru HANADA | 2015-04-24 09:38:39 | Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API) |