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/sort.sql | |
| parent | 80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff) | |
| download | postgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz | |
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/sort.sql')
| -rw-r--r-- | src/test/suite/sort.sql | 57 |
1 files changed, 0 insertions, 57 deletions
diff --git a/src/test/suite/sort.sql b/src/test/suite/sort.sql deleted file mode 100644 index c5a334eeac..0000000000 --- a/src/test/suite/sort.sql +++ /dev/null @@ -1,57 +0,0 @@ ---------------------------------------------------------------------------- --- --- sort.sql- --- test sorting --- --- --- Copyright (c) 1994-5, Regents of the University of California --- --- $Id: sort.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $ --- ---------------------------------------------------------------------------- - -create table s1 (x int4, y int4); -create table s2 (a int4, b int4, c int4); -insert into s1 values (1, 3); -insert into s1 values (2, 3); -insert into s1 values (2, 1); -insert into s2 values (1, 3, 9); -insert into s2 values (1, 4, 9); -insert into s2 values (3, 4, 7); -insert into s2 values (3, 5, 8); -select distinct y from s1; -select a, c from s2; -select distinct a, c from s2; -select distinct a, c from s2 order by c; -select b, c from s2 order by c, b; -select x, b, c from s1, s2 order by b; -select distinct a, x, c from s1, s2 order by c, x; -select x AS p, b AS q, c AS r from s1, s2 order by p; -select x AS p, b AS q, c AS r from s1, s2 order by q; -select x AS p, b AS q, c AS r from s1, s2 order by r; -select x AS p, b AS q, c AS r from s1, s2 order by p, r; -select x AS p, b AS q, c AS r from s1, s2 order by q, r; -select x AS p, b AS q, c AS r from s1, s2 order by q, p; -create table s3 (x int4); -insert into s3 values (3); -insert into s3 values (4); -select * from s1, s3 order by x; -select * from s3, s1 order by x; -create table s4 (a int4, b int4, c int4, d int4, e int4, f int4, g int4, h int4, i int4); -insert into s4 values (1, 1, 1, 1, 1, 1, 1, 1, 2); -insert into s4 values (1, 1, 1, 1, 1, 1, 1, 1, 1); -insert into s4 values (1, 1, 1, 1, 1, 1, 1, 1, 3); -select * from s4 order by a, b, c, d, e, f, g, h; -create table s5 (a int4, b int4); -insert into s5 values (1, 2); -insert into s5 values (1, 3); -insert into s5 values (1, 1); -insert into s5 values (2, 1); -insert into s5 values (2, 4); -insert into s5 values (2, 2); -select * from s5 order by a using <; -select * from s5 order by a using >; -select * from s5 order by a using >, b using <; -select * from s5 order by a using >, b using >; - -drop table s1, s2, s3, s4, s5; |
