summaryrefslogtreecommitdiff
path: root/src/test/suite/parse.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/parse.sql
parent80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff)
downloadpostgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/parse.sql')
-rw-r--r--src/test/suite/parse.sql45
1 files changed, 0 insertions, 45 deletions
diff --git a/src/test/suite/parse.sql b/src/test/suite/parse.sql
deleted file mode 100644
index d9832c8bc0..0000000000
--- a/src/test/suite/parse.sql
+++ /dev/null
@@ -1,45 +0,0 @@
----------------------------------------------------------------------------
---
--- parse.sql-
--- checks the parser
---
---
--- Copyright (c) 1994, Regents of the University of California
---
--- $Id: parse.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $
---
----------------------------------------------------------------------------
-
-create table foo (x int4, y int4, z int4);
-create table bar (x int4, y int4, z int4);
-create table baz (a int4, b int4);
-
-insert into foo values (1, 2, 3);
-insert into foo values (4, 5, 6);
-insert into foo values (7, 8, 9);
-insert into bar values (11, 12, 13);
-insert into bar values (14, 15, 16);
-insert into bar values (17, 18, 19);
-insert into baz values (99, 88);
-insert into baz values (77, 66);
-
--- once upon a time, this becomes a join of foo and f:
-select * from foo f where f.x = 4;
-select * from foo f, foo where f.x > foo.x;
-select * from foo f, foo where f.x = 1 and foo.z > f.z;
-
--- not standard SQL, POSTQUEL semantics
--- update foo set x = f.x from foo f where foo.x = 1 and f.x = 7
--- select * from foo
-
--- fix error message:
---select foo.x from foo,bar,baz where foo.x=bar.x and bar.y=baz.x and baz.x=foo.x
-
--- see if renaming the column works
-select y as a, z as b from foo order by a;
-select foo.y as a, foo.z as b from foo order by b;
-
--- column expansion
-select foo.*, bar.z, baz.* from foo, bar, baz;
-
-drop table foo, bar, baz;