diff options
| -rw-r--r-- | src/test/regress/expected/foreign_key.out | 14 | ||||
| -rw-r--r-- | src/test/regress/sql/foreign_key.sql | 6 |
2 files changed, 10 insertions, 10 deletions
diff --git a/src/test/regress/expected/foreign_key.out b/src/test/regress/expected/foreign_key.out index 9e1d7496014..07bd5b6434f 100644 --- a/src/test/regress/expected/foreign_key.out +++ b/src/test/regress/expected/foreign_key.out @@ -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; diff --git a/src/test/regress/sql/foreign_key.sql b/src/test/regress/sql/foreign_key.sql index b03a6670a21..c5c9011afcb 100644 --- a/src/test/regress/sql/foreign_key.sql +++ b/src/test/regress/sql/foreign_key.sql @@ -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; |