regression.diffs

text/plain

Filename: regression.diffs
Type: text/plain
Part: 1
Message: Re: Problem with default partition pruning
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