From 4cbeefb1e8a862d5fd4f3587125338765951d74d Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 24 Nov 2000 17:14:07 +0000 Subject: Remove obsolete test suite --- src/test/suite/join.sql | 40 ---------------------------------------- 1 file changed, 40 deletions(-) delete mode 100644 src/test/suite/join.sql (limited to 'src/test/suite/join.sql') 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; -- cgit v1.2.1