Commit5012551

committed

Add a simple test case covering a join against an inheritance tree,

since we're evidently not testing that at all right now :-(

1 parentf959390 commit5012551Copy full SHA for 5012551

File tree

+21

-0

lines changed

+21

-0

lines changed

Lines changed: 13 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2209,6 +2209,19 @@ SELECT * FROM t3;`
`2209`	`2209`	`---+---`
`2210`	`2210`	`(0 rows)`
`2211`	`2211`
	`2212`	`+-- Test join against inheritance tree`
	`2213`	`+create temp table t2a () inherits (t2);`
	`2214`	`+insert into t2a values (200, 2001);`
	`2215`	`+select * from t1 left join t2 on (t1.a = t2.a);`
	`2216`	`+ a \| b \| a \| b`
	`2217`	`+-----+------+-----+------`
	`2218`	`+ 5 \| 10 \| \|`
	`2219`	`+ 15 \| 20 \| \|`
	`2220`	`+ 100 \| 100 \| \|`
	`2221`	`+ 200 \| 1000 \| 200 \| 2000`
	`2222`	`+ 200 \| 1000 \| 200 \| 2001`
	`2223`	`+(5 rows)`
	`2224`	`+`
`2212`	`2225`	`--`
`2213`	`2226`	`-- regression test for 8.1 merge right join bug`
`2214`	`2227`	`--`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -389,6 +389,14 @@ SELECT * FROM t3;`
`389`	`389`	`DELETEFROM t3 USING t3 t3_otherWHEREt3.x=t3_other.xANDt3.y=t3_other.y;`
`390`	`390`	`SELECT*FROM t3;`
`391`	`391`
	`392`	`+-- Test join against inheritance tree`
	`393`	`+`
	`394`	`+create temp table t2a () inherits (t2);`
	`395`	`+`
	`396`	`+insert into t2avalues (200,2001);`
	`397`	`+`
	`398`	`+select*from t1left join t2on (t1.a=t2.a);`
	`399`	`+`
`392`	`400`	`--`
`393`	`401`	`-- regression test for 8.1 merge right join bug`
`394`	`402`	`--`

Comments

(0)