pgsql: Fix an oversight in join-removal optimization: we have to check

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix an oversight in join-removal optimization: we have to check
Date: 2010-03-22 13:57:16
Message-ID: 20100322135716.4A93E7541D0@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix an oversight in join-removal optimization: we have to check not only for
plain Vars that are generated in the inner rel and used above the join, but
also for PlaceHolderVars. Per report from Oleg K.

Modified Files:
--------------
pgsql/src/backend/optimizer/path:
joinpath.c (r1.130 -> r1.131)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c?r1=1.130&r2=1.131)
pgsql/src/test/regress/expected:
join.out (r1.43 -> r1.44)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join.out?r1=1.43&r2=1.44)
pgsql/src/test/regress/sql:
join.sql (r1.32 -> r1.33)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/join.sql?r1=1.32&r2=1.33)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2010-03-22 14:56:09 pgsql: Re-order createuser and vacuumedb documentation options, for
Previous Message Michael Meskes 2010-03-22 07:41:21 pgsql: Fixed ECPG regression test to make sure it uses absolute paths