1 files changed, 25 insertions, 0 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out
index 6774390046..cfe7ded08d 100644
--- a/src/test/regress/expected/join.out
+++ b/src/test/regress/expected/join.out
@@ -1847,7 +1847,32 @@ SELECT '' AS "xxx", *
   FROM J1_TBL UNION JOIN J2_TBL;
 ERROR:  UNION JOIN is not implemented yet
 --
+-- Multiway full join
+--
+CREATE TABLE t1 (name TEXT, n INTEGER);
+CREATE TABLE t2 (name TEXT, n INTEGER);
+CREATE TABLE t3 (name TEXT, n INTEGER);
+INSERT INTO t1 VALUES ( 'aa', 11 );
+INSERT INTO t2 VALUES ( 'aa', 12 );
+INSERT INTO t2 VALUES ( 'bb', 22 );
+INSERT INTO t2 VALUES ( 'dd', 42 );
+INSERT INTO t3 VALUES ( 'aa', 13 );
+INSERT INTO t3 VALUES ( 'bb', 23 );
+INSERT INTO t3 VALUES ( 'cc', 33 );
+SELECT * FROM t1 FULL JOIN t2 USING (name) FULL JOIN t3 USING (name);
+ name | n  | n  | n  
+------+----+----+----
+ aa   | 11 | 12 | 13
+ bb   |    | 22 | 23
+ cc   |    |    | 33
+ dd   |    | 42 |   
+(4 rows)
+
+--
 -- Clean up
 --
+DROP TABLE t1;
+DROP TABLE t2;
+DROP TABLE t3;
 DROP TABLE J1_TBL;
 DROP TABLE J2_TBL;