regression.diffs
text/plain
Filename: regression.diffs
Type: text/plain
Part: 1
diff -U3 /pgsql/source/master/src/test/regress/expected/partition_prune.out /home/alvherre/Code/pgsql/build/master/src/test/regress/results/partition_prune.out
--- /pgsql/source/master/src/test/regress/expected/partition_prune.out 2019-08-06 12:27:10.041137540 -0400
+++ /home/alvherre/Code/pgsql/build/master/src/test/regress/results/partition_prune.out 2019-08-06 13:12:20.367678444 -0400
@@ -529,6 +529,12 @@
Filter: ((a = 1) OR ((b)::text = 'ab'::text))
-> Seq Scan on rlp3abcd
Filter: ((a = 1) OR ((b)::text = 'ab'::text))
+ -> Seq Scan on rlp3efgh
+ Filter: ((a = 1) OR ((b)::text = 'ab'::text))
+ -> Seq Scan on rlp3nullxy
+ Filter: ((a = 1) OR ((b)::text = 'ab'::text))
+ -> Seq Scan on rlp3_default
+ Filter: ((a = 1) OR ((b)::text = 'ab'::text))
-> Seq Scan on rlp4_1
Filter: ((a = 1) OR ((b)::text = 'ab'::text))
-> Seq Scan on rlp4_2
@@ -547,7 +553,7 @@
Filter: ((a = 1) OR ((b)::text = 'ab'::text))
-> Seq Scan on rlp_default_default
Filter: ((a = 1) OR ((b)::text = 'ab'::text))
-(25 rows)
+(31 rows)
explain (costs off) select * from rlp where a > 20 and a < 27;
QUERY PLAN
@@ -599,9 +605,11 @@
Append
-> Seq Scan on rlp4_1
Filter: ((a = 20) OR (a = 40))
+ -> Seq Scan on rlp4_default
+ Filter: ((a = 20) OR (a = 40))
-> Seq Scan on rlp5_default
Filter: ((a = 20) OR (a = 40))
-(5 rows)
+(7 rows)
explain (costs off) select * from rlp3 where a = 20; /* empty */
QUERY PLAN