diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-08-13 17:14:38 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-08-13 17:14:38 +0000 |
| commit | 501255114d0266a599c2b52fdf15fe8cac0a4650 (patch) | |
| tree | 19dd4158c51d8452efbe9f98253d71d628b1deca /src/test/regress/sql/join.sql | |
| parent | f959390cd0e016fa535c0ffc228a5aec9c8a4859 (diff) | |
| download | postgresql-501255114d0266a599c2b52fdf15fe8cac0a4650.tar.gz | |
Add a simple test case covering a join against an inheritance tree,
since we're evidently not testing that at all right now :-(
Diffstat (limited to 'src/test/regress/sql/join.sql')
| -rw-r--r-- | src/test/regress/sql/join.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/sql/join.sql b/src/test/regress/sql/join.sql index 123d1f3015..1516e09b56 100644 --- a/src/test/regress/sql/join.sql +++ b/src/test/regress/sql/join.sql @@ -389,6 +389,14 @@ SELECT * FROM t3; DELETE FROM t3 USING t3 t3_other WHERE t3.x = t3_other.x AND t3.y = t3_other.y; SELECT * FROM t3; +-- Test join against inheritance tree + +create temp table t2a () inherits (t2); + +insert into t2a values (200, 2001); + +select * from t1 left join t2 on (t1.a = t2.a); + -- -- regression test for 8.1 merge right join bug -- |