Regression tests for BETWEEN support in hash partitioning.

Alexander Korotkov · Alexander Korotkov · commit d874c6b5d764 · 2016-05-08T02:01:25.000+03:00
diff --git a/expected/pg_pathman.out b/expected/pg_pathman.out
@@ -190,6 +190,16 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2 OR value = 1;
          Filter: (value = 2)
 (5 rows)
 
+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value BETWEEN 1 AND 2;
+                   QUERY PLAN                    
+-------------------------------------------------
+ Append
+   ->  Seq Scan on hash_rel_1
+         Filter: ((value >= 1) AND (value <= 2))
+   ->  Seq Scan on hash_rel_2
+         Filter: ((value >= 1) AND (value <= 2))
+(5 rows)
+
 EXPLAIN (COSTS OFF) SELECT * FROM test.num_range_rel WHERE id > 2500;
             QUERY PLAN             
 -----------------------------------
diff --git a/sql/pg_pathman.sql b/sql/pg_pathman.sql
@@ -66,6 +66,7 @@ SET enable_seqscan = ON;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2 OR value = 1;
+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value BETWEEN 1 AND 2;
 EXPLAIN (COSTS OFF) SELECT * FROM test.num_range_rel WHERE id > 2500;
 EXPLAIN (COSTS OFF) SELECT * FROM test.num_range_rel WHERE id >= 1000 AND id < 3000;
 EXPLAIN (COSTS OFF) SELECT * FROM test.num_range_rel WHERE id >= 1500 AND id < 2500;
