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

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/src/backend/optimizer/plan Tag: R ...
Date: 2004-02-29 17:36:48
Message-ID: 20040229173648.6386BD1E2E2@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)svr1(dot)postgresql(dot)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.

Browse pgsql-committers by date

  From Date Subject
Next Message Neil Conway 2004-03-01 16:08:58 pgsql-server/doc/src/sgml Makefile
Previous Message Tom Lane 2004-02-29 17:36:06 pgsql-server/src/backend/optimizer/plan create ...