Re: [HACKERS] Bug in planner

2015-04-25 Thread Tom Lane
David Rowley writes: > On 24 April 2015 at 21:43, Teodor Sigaev wrote: >> I faced with planner error: >> ERROR: could not find RelOptInfo for given relids > I've done a little debugging on this too and I get the idea that in > eqjoinsel() that min_righthand incorrectly does not have a bit set f

Re: [HACKERS] Bug in planner

2015-04-25 Thread David Rowley
On 24 April 2015 at 21:43, Teodor Sigaev wrote: > Hi! > > I faced with planner error: > ERROR: could not find RelOptInfo for given relids > > Good find! I've simplified your query a bit, the following still shows the issue (using your schema): SELECT * FROM t1 WHERE NOT EXISTS (SELECT t2.c2 AS

[HACKERS] Bug in planner

2015-04-24 Thread Teodor Sigaev
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 preventin