Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-31 Thread Tom Lane
"Sergey Burladyan" <[EMAIL PROTECTED]> writes: > Description:may be Query Error: subplan does not executed I've applied a patch for this; it'll be in the next set of releases. regards, tom lane ---(end of broadcast)-

Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-31 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > I don't understand that code very well. Why does it think that the right > pathkeys of "test1.id = test2.id" and "test1.id = test1.id+test2.id" are > equal? They *will* be equal ... after the join (if correctly implemented :-(). The problem is the c

Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-31 Thread Heikki Linnakangas
Tom Lane wrote: > It appears that join_clause_is_redundant() is rejecting the clause as > redundant. I suppose some part of that machinery gets confused by the > fact that the RHS of the clause references both relations. The > EquivalenceClass rewrite cleaned this whole area up greatly, so no > s

Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-28 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Sergey Burladyan wrote: >> i have query with join of two table and 'where' filter it result by subplan >> which have references to join result, but this subplan not executed and >> result is incorrect. This subplan also not exist in explain analyze o

Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-27 Thread Heikki Linnakangas
Sergey Burladyan wrote: > i have query with join of two table and 'where' filter it result by subplan > which have references to join result, but this subplan not executed and > result is incorrect. This subplan also not exist in explain analyze output. I can reproduce this on 8.1 and 8.2 branch h