pgsql-server/src/backend/optimizer/plan Tag: R ... - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql-server/src/backend/optimizer/plan Tag: R ...
Date
Msg-id 20040229173648.6386BD1E2E2@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    04/02/29 13:36:48

Modified files:
    src/backend/optimizer/plan: Tag: REL7_4_STABLE createplan.c

Log message:
    make_sort_from_pathkeys()'s method for choosing which of several
    equivalent sort expressions to use was broken: you can't just look
    at the relation membership, you have to actually grovel over the
    individual Vars in each expression.  I think this did work when it
    was written, but it was broken by subsequent optimizations that made
    join relations not propagate every single input variable upward.
    Must find the Var that got propagated, not choose one at random.
    Per bug report from Daniel O'Neill.


pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server/src/backend/optimizer/plan create ...
Next
From: neilc@svr1.postgresql.org (Neil Conway)
Date:
Subject: pgsql-server/doc/src/sgml Makefile