Commit56ea5a8

committed

pathman: join tests

1 parent26ab97d commit56ea5a8Copy full SHA for 56ea5a8

File tree

+45

-0

lines changed

+45

-0

lines changed

Lines changed: 34 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -425,6 +425,40 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel_1 UNION ALL SELECT * FROM test.`
`425`	`425`	`-> Index Scan using range_rel_2_dt_idx on range_rel_2`
`426`	`426`	`(4 rows)`
`427`	`427`
	`428`	`+/*`
	`429`	`+ * Join`
	`430`	`+ */`
	`431`	`+SET enable_indexscan = OFF;`
	`432`	`+EXPLAIN (COSTS OFF)`
	`433`	`+SELECT * FROM test.range_rel j1`
	`434`	`+JOIN test.range_rel j2 on j2.id = j1.id`
	`435`	`+JOIN test.num_range_rel j3 on j3.id = j1.id`
	`436`	`+WHERE j1.dt < '2015-03-01' AND j2.dt >= '2015-02-01' ORDER BY j2.dt;`
	`437`	`+ QUERY PLAN`
	`438`	`+---------------------------------------------------------------------------------`
	`439`	`+ Sort`
	`440`	`+ Sort Key: j2.dt`
	`441`	`+ -> Nested Loop`
	`442`	`+ Join Filter: (j1.id = j2.id)`
	`443`	`+ -> Nested Loop`
	`444`	`+ Join Filter: (j1.id = j3.id)`
	`445`	`+ -> Append`
	`446`	`+ -> Seq Scan on num_range_rel_1 j3`
	`447`	`+ -> Seq Scan on num_range_rel_2 j3_1`
	`448`	`+ -> Seq Scan on num_range_rel_3 j3_2`
	`449`	`+ -> Seq Scan on num_range_rel_4 j3_3`
	`450`	`+ -> Materialize`
	`451`	`+ -> Append`
	`452`	`+ -> Seq Scan on range_rel_1 j1`
	`453`	`+ -> Seq Scan on range_rel_2 j1_1`
	`454`	`+ -> Materialize`
	`455`	`+ -> Append`
	`456`	`+ -> Index Scan using range_rel_2_dt_idx on range_rel_2 j2`
	`457`	`+ -> Index Scan using range_rel_3_dt_idx on range_rel_3 j2_1`
	`458`	`+ -> Index Scan using range_rel_4_dt_idx on range_rel_4 j2_2`
	`459`	`+(20 rows)`
	`460`	`+`
	`461`	`+SET enable_indexscan = ON;`
`428`	`462`	`/*`
`429`	`463`	`* Test CTE query`
`430`	`464`	`*/`

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -104,6 +104,17 @@ SET enable_seqscan = OFF;`
`104`	`104`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.range_relWHERE dt<'2015-03-01'ORDER BY dt;`
`105`	`105`	`EXPLAIN (COSTS OFF)SELECTFROMtest.range_rel_1UNION ALLSELECTFROMtest.range_rel_2ORDER BY dt;`
`106`	`106`
	`107`	`+/*`
	`108`	`+ * Join`
	`109`	`+*/`
	`110`	`+SET enable_indexscan= OFF;`
	`111`	`+EXPLAIN (COSTS OFF)`
	`112`	`+SELECT*FROMtest.range_rel j1`
	`113`	`+JOINtest.range_rel j2onj2.id=j1.id`
	`114`	`+JOINtest.num_range_rel j3onj3.id=j1.id`
	`115`	`+WHEREj1.dt<'2015-03-01'ANDj2.dt>='2015-02-01'ORDER BYj2.dt;`
	`116`	`+SET enable_indexscan=ON;`
	`117`	`+`
`107`	`118`	`/*`
`108`	`119`	`* Test CTE query`
`109`	`120`	`*/`

Comments

(0)