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