diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-02-20 14:14:20 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-02-20 14:14:20 -0300 |
| commit | 3f50d5ced3f854119862b1ce60a6f3c5d38a4386 (patch) | |
| tree | c674b2204656c2842cee75c73924220e22546dab | |
| parent | aab50a7ae4945d63be33c322929822fed9bab57a (diff) | |
| download | postgresql-3f50d5ced3f854119862b1ce60a6f3c5d38a4386.tar.gz postgresql-3f50d5ced3f854119862b1ce60a6f3c5d38a4386.zip | |
Simplify FK-to-partitioned regression test query
Avoid a join between relations having the FK to detect FK violation.
The planner might optimize this considering the PK must exist on the
referenced side at some point, effectively masking a bug this test
tries to detect.
Tom Lane and Jehan-Guillaume de Rorthais
Discussion: https://postgr.es/m/467.1581270529@sss.pgh.pa.us
| -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; |