src/test/suite/sqlcompat.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

---------------------------------------------------------------------------
--
-- 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;