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 | b2304a71748a3e664a1b8354d746f28c38aaa816 (patch) | |
| tree | 76f4ccea1f1a98210daf1bcedf2d46d092e85959 /src/test/regress/expected/foreign_key.out | |
| parent | 53b01acd463d64c385db0ab728b8cc336549a315 (diff) | |
| download | postgresql-b2304a71748a3e664a1b8354d746f28c38aaa816.tar.gz | |
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
Diffstat (limited to 'src/test/regress/expected/foreign_key.out')
| -rw-r--r-- | src/test/regress/expected/foreign_key.out | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/src/test/regress/expected/foreign_key.out b/src/test/regress/expected/foreign_key.out index 9e1d749601..07bd5b6434 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; |