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

pgsql: Add support for doing FULL JOIN ON FALSE.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add support for doing FULL JOIN ON FALSE.
Date: 2010-01-05 23:25:36
Message-ID: 20100105232536.7F2BC753FB7@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Add support for doing FULL JOIN ON FALSE.  While this is really a rather
peculiar variant of UNION ALL, and so wouldn't likely get written directly
as-is, it's possible for it to arise as a result of simplification of
less-obviously-silly queries.  In particular, now that we can do flattening
of subqueries that have constant outputs and are underneath an outer join,
it's possible for the case to result from simplification of queries of the
type exhibited in bug #5263.  Back-patch to 8.4 to avoid a functionality
regression for this type of query.

Modified Files:
--------------
    pgsql/src/backend/executor:
        nodeMergejoin.c (r1.99 -> r1.100)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeMergejoin.c?r1=1.99&r2=1.100)
    pgsql/src/backend/optimizer/path:
        joinpath.c (r1.128 -> r1.129)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c?r1=1.128&r2=1.129)
    pgsql/src/include/nodes:
        execnodes.h (r1.216 -> r1.217)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h?r1=1.216&r2=1.217)
    pgsql/src/test/regress/expected:
        join.out (r1.42 -> r1.43)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join.out?r1=1.42&r2=1.43)
    pgsql/src/test/regress/sql:
        join.sql (r1.31 -> r1.32)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/join.sql?r1=1.31&r2=1.32)

pgsql-committers by date

Next:From: Tom LaneDate: 2010-01-05 23:25:44
Subject: pgsql: Add support for doing FULL JOIN ON FALSE.
Previous:From: Robert HaasDate: 2010-01-05 21:54:00
Subject: pgsql: Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).

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