The result of a FULL or RIGHT join can't be assumed to be sorted by the
Tom Lane <tgl@sss.pgh.pa.us>
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 Lutischá¸n.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/path/joinpath.c | modified | +4 −3 |
| src/backend/optimizer/path/pathkeys.c | modified | +10 −1 |
| src/include/optimizer/paths.h | modified | +2 −1 |