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

pgsql: Fix a bug in the original implementation of redundant-join-clause

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix a bug in the original implementation of redundant-join-clause
Date: 2007-07-31 19:54:01
Message-ID: 20070731195401.1FFA89FBC2B@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix a bug in the original implementation of redundant-join-clause removal:
clauses in which one side or the other references both sides of the join
cannot be removed as redundant, because that expression won't have been
constrained below the join.  Per report from Sergey Burladyan.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.191.2.11 -> r1.191.2.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.191.2.11&r2=1.191.2.12)
    pgsql/src/backend/optimizer/plan:
        createplan.c (r1.202.2.4 -> r1.202.2.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c.diff?r1=1.202.2.4&r2=1.202.2.5)
    pgsql/src/backend/optimizer/util:
        relnode.c (r1.72.2.1 -> r1.72.2.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/relnode.c.diff?r1=1.72.2.1&r2=1.72.2.2)
        restrictinfo.c (r1.41.2.4 -> r1.41.2.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/restrictinfo.c.diff?r1=1.41.2.4&r2=1.41.2.5)
    pgsql/src/include/optimizer:
        restrictinfo.h (r1.34.2.1 -> r1.34.2.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/restrictinfo.h.diff?r1=1.34.2.1&r2=1.34.2.2)
    pgsql/src/test/regress/expected:
        join.out (r1.25.2.2 -> r1.25.2.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join.out.diff?r1=1.25.2.2&r2=1.25.2.3)
        join_1.out (r1.6.2.3 -> r1.6.2.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join_1.out.diff?r1=1.6.2.3&r2=1.6.2.4)
    pgsql/src/test/regress/sql:
        join.sql (r1.17.2.2 -> r1.17.2.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/join.sql.diff?r1=1.17.2.2&r2=1.17.2.3)

pgsql-committers by date

Next:From: Tom LaneDate: 2007-07-31 19:54:11
Subject: pgsql: Fix a bug in the original implementation of redundant-join-clause
Previous:From: Tom LaneDate: 2007-07-31 19:53:50
Subject: pgsql: Fix a bug in the original implementation of redundant-join-clause

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