pathman: CTE tests

zilder · zilder · commit f6bb11c17401 · 2016-03-15T18:01:21.000+03:00
diff --git a/contrib/pg_pathman/expected/pg_pathman.out b/contrib/pg_pathman/expected/pg_pathman.out
@@ -380,6 +380,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE (dt >= '2015-01-15' AND d
    ->  Seq Scan on range_rel_4
 (8 rows)
 
+/*
+ * Test CTE query
+ */
+EXPLAIN (COSTS OFF)
+    WITH ttt AS (SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt < '2015-03-15')
+SELECT * FROM ttt;
+                                         QUERY PLAN                                         
+--------------------------------------------------------------------------------------------
+ CTE Scan on ttt
+   CTE ttt
+     ->  Append
+           ->  Seq Scan on range_rel_2
+           ->  Index Scan using range_rel_3_dt_idx on range_rel_3
+                 Index Cond: (dt < 'Sun Mar 15 00:00:00 2015'::timestamp without time zone)
+(6 rows)
+
+EXPLAIN (COSTS OFF)
+    WITH ttt AS (SELECT * FROM test.hash_rel WHERE value = 2)
+SELECT * FROM ttt;
+              QUERY PLAN              
+--------------------------------------
+ CTE Scan on ttt
+   CTE ttt
+     ->  Append
+           ->  Seq Scan on hash_rel_2
+                 Filter: (value = 2)
+(5 rows)
+
 /*
  * Test split and merge
  */
diff --git a/contrib/pg_pathman/sql/pg_pathman.sql b/contrib/pg_pathman/sql/pg_pathman.sql
@@ -92,6 +92,17 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt
 EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE dt >= '2015-02-15' AND dt < '2015-03-15';
 EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE (dt >= '2015-01-15' AND dt < '2015-02-15') OR (dt > '2015-03-15');
 
+/*
+ * Test CTE query
+ */
+EXPLAIN (COSTS OFF)
+    WITH ttt AS (SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt < '2015-03-15')
+SELECT * FROM ttt;
+
+EXPLAIN (COSTS OFF)
+    WITH ttt AS (SELECT * FROM test.hash_rel WHERE value = 2)
+SELECT * FROM ttt;
+
 /*
  * Test split and merge
  */
