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

pgsql: The result of a FULL or RIGHT join can't be assumed to be sorted

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: The result of a FULL or RIGHT join can't be assumed to be sorted
Date: 2005-01-23 02:26:24
Message-ID: 20050123022624.342EE3A5019@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
The result of a FULL or RIGHT join can't be assumed to be sorted by the
left input's sorting, because null rows may be inserted at various points.
Per report from Ferenc Lutischn.

Tags:
----
REL7_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        joinpath.c (r1.67 -> r1.67.2.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c.diff?r1=1.67&r2=1.67.2.1)
        pathkeys.c (r1.36 -> r1.36.2.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/pathkeys.c.diff?r1=1.36&r2=1.36.2.1)
    pgsql/src/include/optimizer:
        paths.h (r1.59 -> r1.59.2.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/paths.h.diff?r1=1.59&r2=1.59.2.1)

pgsql-committers by date

Next:From: User MhaDate: 2005-01-23 13:03:12
Subject: pginstaller - pginst: "Natural Language Support" -> "National Language
Previous:From: Tom LaneDate: 2005-01-23 02:24:43
Subject: pgsql: The result of a FULL or RIGHT join can't be assumed to be sorted

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