postgres
diff --git a/‎src/test/regress/expected/foreign_key.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/foreign_key.out
+8-6Lines changed: 8 additions & 6 deletions b/‎src/test/regress/expected/foreign_key.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/foreign_key.out
+8-6Lines changed: 8 additions & 6 deletions
diff --git a/‎src/test/regress/sql/foreign_key.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/foreign_key.sql
+2-4Lines changed: 2 additions & 4 deletions b/‎src/test/regress/sql/foreign_key.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/foreign_key.sql
+2-4Lines changed: 2 additions & 4 deletions
@@ -2456,12 +2456,14 @@ CREATE SCHEMA fkpart9
 INSERT INTO fkpart9.pk VALUES (35);
 INSERT INTO fkpart9.fk VALUES (35);
 DELETE FROM fkpart9.pk WHERE a=35;
-SELECT fk.fk_a, pk.a
-FROM fkpart9.fk
-LEFT JOIN fkpart9.pk ON fk.fk_a = pk.a
-WHERE fk.fk_a=35;
- fk_a | a 
-------+---
+SELECT * FROM fkpart9.pk;
+ a 
+---
+(0 rows)
+
+SELECT * FROM fkpart9.fk;
+ fk_a 
+------
 (0 rows)
 
 DROP SCHEMA fkpart9 CASCADE;
 
@@ -1735,8 +1735,6 @@ CREATE SCHEMA fkpart9
 INSERT INTO fkpart9.pk VALUES (35);
 INSERT INTO fkpart9.fk VALUES (35);
 DELETE FROM fkpart9.pk WHERE a=35;
-SELECT fk.fk_a, pk.a
-FROM fkpart9.fk
-LEFT JOIN fkpart9.pk ON fk.fk_a = pk.a
-WHERE fk.fk_a=35;
+SELECT * FROM fkpart9.pk;
+SELECT * FROM fkpart9.fk;
 DROP SCHEMA fkpart9 CASCADE;