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/parse.sql | |
| parent | 80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff) | |
| download | postgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz | |
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/parse.sql')
| -rw-r--r-- | src/test/suite/parse.sql | 45 |
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; |
