diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2000-11-24 17:14:07 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2000-11-24 17:14:07 +0000 |
| commit | 4cbeefb1e8a862d5fd4f3587125338765951d74d (patch) | |
| tree | 32ee691ddc066690135790825cdb93c11f201753 /src/test/suite/join.sql | |
| parent | 80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff) | |
| download | postgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz | |
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/join.sql')
| -rw-r--r-- | src/test/suite/join.sql | 40 |
1 files changed, 0 insertions, 40 deletions
diff --git a/src/test/suite/join.sql b/src/test/suite/join.sql deleted file mode 100644 index 288b21ebc1..0000000000 --- a/src/test/suite/join.sql +++ /dev/null @@ -1,40 +0,0 @@ ---------------------------------------------------------------------------- --- --- joins.sql- --- test joins --- --- --- Copyright (c) 1994, Regents of the University of California --- --- $Id: join.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $ --- ---------------------------------------------------------------------------- - -create table foo (x int4, y int4); -create table bar (p int4, q int4); -create table baz (a int4, b int4); - -insert into foo values (1, 1); -insert into foo values (2, 2); -insert into bar values (1, 1); -insert into baz values (1, 1); -insert into baz values (2, 2); - -select * from foo,bar,baz -where foo.x=bar.p and bar.p=baz.a and baz.b=foo.y; - -select * from foo,bar,baz -where foo.y=bar.p and bar.p=baz.a and baz.b=foo.x and foo.y=bar.q; - -select * from foo,bar,baz -where foo.x=bar.q and bar.p=baz.b and baz.b=foo.y and foo.y=bar.q - and bar.p=baz.a; - -select * from foo,bar,baz -where foo.y=bar.p and bar.q=baz.b and baz.b=foo.x and foo.x=bar.q - and bar.p=baz.a and bar.p=baz.a; - -select bar.p from foo, bar; -select foo.x from foo, bar where foo.x = bar.p; - -drop table foo, bar, baz; |
