regression.diffs
text/x-diff
Filename: regression.diffs
Type: text/x-diff
Part: 0
Patch
Format: unified
| File | + | − |
|---|---|---|
| /home/postgres/pgsql/src/test/regress/results/partition_prune.out | 4 | 16 |
diff -U3 /home/postgres/pgsql/src/test/regress/expected/partition_prune.out /home/postgres/pgsql/src/test/regress/results/partition_prune.out
--- /home/postgres/pgsql/src/test/regress/expected/partition_prune.out 2019-04-01 12:39:52.613109088 -0400
+++ /home/postgres/pgsql/src/test/regress/results/partition_prune.out 2019-04-01 13:18:02.852615395 -0400
@@ -3409,24 +3409,18 @@
--------------------------
Update on pp_lp
Update on pp_lp1
- Update on pp_lp2
-> Seq Scan on pp_lp1
Filter: (a = 1)
- -> Seq Scan on pp_lp2
- Filter: (a = 1)
-(7 rows)
+(4 rows)
explain (costs off) delete from pp_lp where a = 1;
QUERY PLAN
--------------------------
Delete on pp_lp
Delete on pp_lp1
- Delete on pp_lp2
-> Seq Scan on pp_lp1
Filter: (a = 1)
- -> Seq Scan on pp_lp2
- Filter: (a = 1)
-(7 rows)
+(4 rows)
set constraint_exclusion = 'off'; -- this should not affect the result.
explain (costs off) select * from pp_lp where a = 1;
@@ -3444,24 +3438,18 @@
--------------------------
Update on pp_lp
Update on pp_lp1
- Update on pp_lp2
-> Seq Scan on pp_lp1
Filter: (a = 1)
- -> Seq Scan on pp_lp2
- Filter: (a = 1)
-(7 rows)
+(4 rows)
explain (costs off) delete from pp_lp where a = 1;
QUERY PLAN
--------------------------
Delete on pp_lp
Delete on pp_lp1
- Delete on pp_lp2
-> Seq Scan on pp_lp1
Filter: (a = 1)
- -> Seq Scan on pp_lp2
- Filter: (a = 1)
-(7 rows)
+(4 rows)
drop table pp_lp;
-- Ensure enable_partition_prune does not affect non-partitioned tables.