Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group