pgsql/src/backend/optimizer/path joinpath.c

From: Tom Lane <tgl(at)hub(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src/backend/optimizer/path joinpath.c
Date: 2001-04-15 00:48:18
Message-ID: 200104150048.f3F0mI349028@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)org 01/04/14 20:48:17

Modified files:
src/backend/optimizer/path: joinpath.c

Log message:
Prevent generation of invalid plans for RIGHT or FULL joins with multiple
join clauses. The mergejoin executor wants all the join clauses to appear
as merge quals, not as extra joinquals, for these kinds of joins. But the
planner would consider plans in which partially-sorted input paths were
used, leading to only some of the join clauses becoming merge quals.
This is fine for inner/left joins, not fine for right/full joins.

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian - CVS 2001-04-15 01:56:08 pgsql/doc TODO
Previous Message Peter Eisentraut - PostgreSQL 2001-04-15 00:43:37 pgsql/src/bin/psql common.c