| 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:21:47 |
| Message-ID: | 20050123022147.53C723A4FC4@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
Modified Files:
--------------
pgsql/src/backend/optimizer/path:
joinpath.c (r1.91 -> r1.92)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c.diff?r1=1.91&r2=1.92)
pathkeys.c (r1.63 -> r1.64)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/pathkeys.c.diff?r1=1.63&r2=1.64)
pgsql/src/include/optimizer:
paths.h (r1.77 -> r1.78)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/paths.h.diff?r1=1.77&r2=1.78)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-23 02:22:43 | pgsql: The result of a FULL or RIGHT join can't be assumed to be sorted |
| Previous Message | Bruce Momjian | 2005-01-23 01:01:31 | Re: pgsql: Add tools/find_gt_lt to find < and > in SGML |