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