summaryrefslogtreecommitdiff
path: root/src/test/suite/join.sql
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2000-11-24 17:14:07 +0000
committerPeter Eisentraut <peter_e@gmx.net>2000-11-24 17:14:07 +0000
commit4cbeefb1e8a862d5fd4f3587125338765951d74d (patch)
tree32ee691ddc066690135790825cdb93c11f201753 /src/test/suite/join.sql
parent80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff)
downloadpostgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/join.sql')
-rw-r--r--src/test/suite/join.sql40
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;