diff options
Diffstat (limited to 'src/test/suite/sqlcompat.sql')
| -rw-r--r-- | src/test/suite/sqlcompat.sql | 57 |
1 files changed, 0 insertions, 57 deletions
diff --git a/src/test/suite/sqlcompat.sql b/src/test/suite/sqlcompat.sql deleted file mode 100644 index 456f220aa7..0000000000 --- a/src/test/suite/sqlcompat.sql +++ /dev/null @@ -1,57 +0,0 @@ ---------------------------------------------------------------------------- --- --- sqlcompat.sql- --- test aliases for SQL basic types and aggregates --- --- --- Copyright (c) 1994-5, Regents of the University of California --- --- $Id: sqlcompat.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $ --- ---------------------------------------------------------------------------- - --- check aliases for data types -create table st1 (x int, y integer, z int4); -insert into st1 values (1); -insert into st1 values (10); -select * from st1; -create table st2 (x smallint, y int2); -insert into st2 values (1); -insert into st2 values (10); -select * from st2; -create table st3 (x float, y real, z float4); -insert into st3 values (1); -insert into st3 values (10); -select * from st3; - -create table st4 (x float8); -insert into st4 values (1); -insert into st4 values (10); -select * from st4; - --- check aliases for aggregate names -select max(x) from st1; -select min(x) from st1; -select sum(x) from st1; -select avg(x) from st1; - -select max(x) from st2; -select min(x) from st2; -select sum(x) from st2; -select avg(x) from st2; - -select max(x) from st3; -select min(x) from st3; -select sum(x) from st3; -select avg(x) from st3; - -select max(x) from st4; -select min(x) from st4; -select sum(x) from st4; -select avg(x) from st4; - -drop table st1; -drop table st2; -drop table st3; -drop table st4; - |
