Commitf6bb11c

committed

pathman: CTE tests

1 parente543fef commitf6bb11cCopy full SHA for f6bb11c

File tree

+39

-0

lines changed

+39

-0

lines changed

Lines changed: 28 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -380,6 +380,34 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE (dt >= '2015-01-15' AND d`
`380`	`380`	`-> Seq Scan on range_rel_4`
`381`	`381`	`(8 rows)`
`382`	`382`
	`383`	`+/*`
	`384`	`+ * Test CTE query`
	`385`	`+ */`
	`386`	`+EXPLAIN (COSTS OFF)`
	`387`	`+ WITH ttt AS (SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt < '2015-03-15')`
	`388`	`+SELECT * FROM ttt;`
	`389`	`+ QUERY PLAN`
	`390`	`+--------------------------------------------------------------------------------------------`
	`391`	`+ CTE Scan on ttt`
	`392`	`+ CTE ttt`
	`393`	`+ -> Append`
	`394`	`+ -> Seq Scan on range_rel_2`
	`395`	`+ -> Index Scan using range_rel_3_dt_idx on range_rel_3`
	`396`	`+ Index Cond: (dt < 'Sun Mar 15 00:00:00 2015'::timestamp without time zone)`
	`397`	`+(6 rows)`
	`398`	`+`
	`399`	`+EXPLAIN (COSTS OFF)`
	`400`	`+ WITH ttt AS (SELECT * FROM test.hash_rel WHERE value = 2)`
	`401`	`+SELECT * FROM ttt;`
	`402`	`+ QUERY PLAN`
	`403`	`+--------------------------------------`
	`404`	`+ CTE Scan on ttt`
	`405`	`+ CTE ttt`
	`406`	`+ -> Append`
	`407`	`+ -> Seq Scan on hash_rel_2`
	`408`	`+ Filter: (value = 2)`
	`409`	`+(5 rows)`
	`410`	`+`
`383`	`411`	`/*`
`384`	`412`	`* Test split and merge`
`385`	`413`	`*/`

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -92,6 +92,17 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt`
`92`	`92`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.range_relWHERE dt>='2015-02-15'AND dt<'2015-03-15';`
`93`	`93`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.range_relWHERE (dt>='2015-01-15'AND dt<'2015-02-15')OR (dt>'2015-03-15');`
`94`	`94`
	`95`	`+/*`
	`96`	`+ * Test CTE query`
	`97`	`+*/`
	`98`	`+EXPLAIN (COSTS OFF)`
	`99`	`+ WITH tttAS (SELECT*FROMtest.range_relWHERE dt>='2015-02-01'AND dt<'2015-03-15')`
	`100`	`+SELECT*FROM ttt;`
	`101`	`+`
	`102`	`+EXPLAIN (COSTS OFF)`
	`103`	`+ WITH tttAS (SELECT*FROMtest.hash_relWHERE value=2)`
	`104`	`+SELECT*FROM ttt;`
	`105`	`+`
`95`	`106`	`/*`
`96`	`107`	`* Test split and merge`
`97`	`108`	`*/`

Comments

(0)