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/group_err.sql | |
| parent | 80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff) | |
| download | postgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz | |
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/group_err.sql')
| -rw-r--r-- | src/test/suite/group_err.sql | 29 |
1 files changed, 0 insertions, 29 deletions
diff --git a/src/test/suite/group_err.sql b/src/test/suite/group_err.sql deleted file mode 100644 index 36600ce1f8..0000000000 --- a/src/test/suite/group_err.sql +++ /dev/null @@ -1,29 +0,0 @@ ---------------------------------------------------------------------------- --- --- group_err.sql- --- test illegal use of GROUP BY (with aggregates) --- --- --- Copyright (c) 1994-5, Regents of the University of California --- --- $Id: group_err.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $ --- ---------------------------------------------------------------------------- - -create table G_ERR (x int4, y int4, z int4); - -select x from G_ERR group by y; -select x, sum(z) from G_ERR group by y; -select x, count(x) from G_ERR; - -select max(count(x)) from G_ERR; - -select x from G_ERR where count(x) = 1; - -create table H_ERR (a int4, b int4); - -select y, a, count(y), sum(b) -from G_ERR, H_ERR -where G_ERR.y = H_ERR.a group by y; - -drop table G_ERR, H_ERR; |