pgsql: Forward-port regression test for bug #10587 into 9.3 and HEAD.

Forward-port regression test for bug #10587 into 9.3 and HEAD.

Although this bug is already fixed in post-9.2 branches, the case
triggering it is quite different from what was under consideration
at the time.  It seems worth memorializing this example in HEAD
just to make sure it doesn't get broken again in future.

Extracted from commit 187ae17300776f48b2bd9d0737923b1bf70f606e.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/ab76208e3df6841b3770edeece57d0f048392237

Modified Files
--------------
src/test/regress/expected/join.out |   71 ++++++++++++++++++++++++++++++++++++
src/test/regress/sql/join.sql      |   58 +++++++++++++++++++++++++++++
2 files changed, 129 insertions(+)