cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create t set a, b, c, d;
insert into t values (
1, 1, 10, 101,
1, 2, 9, 102,
1, 1, 8, 103,
2, 1, 7, 104,
1, 2, 6, 105,
2, 2, 5, 106,
1, 1, 4, 107,
3, 2, 3, 108,
1, 2, 2, 109);

create view v1 as select from t;
select from v1;
create view v2 (suma, sumb, sumc) as select sum (a), sum (b), sum (c) from t;
select from v2;
create view v3 (a, b, sumc) as select a, b, sum (c) from t;
select from v3;
create view v4 (a, b, sumb, c, sumc) as select a, b, sum (b), c, sum (c) from t;
select from v4;
create view v5 (a, suma, b, sumb, c, sumc, ab, ac, bc, sumasumb, sumbsumc)
	as select a width 4, sum (a) width 5, b width 4,
	sum (b) width 5, c width 4, sum (c) width 5,
	a * b width 4, a * c width 4, b * c width 4,
	sum (a) * sum (b) width 8, sum (b) * sum (c) width 8 from t;
select from v5;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* create t set a, b, c, d;
* insert into t values (
. 1, 1, 10, 101,
. 1, 2, 9, 102,
. 1, 1, 8, 103,
. 2, 1, 7, 104,
. 1, 2, 6, 105,
. 2, 2, 5, 106,
. 1, 1, 4, 107,
. 3, 2, 3, 108,
. 1, 2, 2, 109);
* 
* create view v1 as select from t;
* select from v1;
     a       b       c       d

     1       1      10     101
     1       2       9     102
     1       1       8     103
     2       1       7     104
     1       2       6     105
     2       2       5     106
     1       1       4     107
     3       2       3     108
     1       2       2     109
* create view v2 (suma, sumb, sumc) as select sum (a), sum (b), sum (c) from t;
* select from v2;
       suma         sumb         sumc

         13           14           54
* create view v3 (a, b, sumc) as select a, b, sum (c) from t;
* select from v3;
     a       b         sumc

     1       1
     1       2
     1       1
     2       1
     1       2
     2       2
     1       1
     3       2
     1       2
                         54
* create view v4 (a, b, sumb, c, sumc) as select a, b, sum (b), c, sum (c) from t;
* select from v4;
     a       b         sumb       c         sumc

     1       1                   10
     1       2                    9
     1       1                    8
     2       1                    7
     1       2                    6
     2       2                    5
     1       1                    4
     3       2                    3
     1       2                    2
                         14                   54
* create view v5 (a, suma, b, sumb, c, sumc, ab, ac, bc, sumasumb, sumbsumc)
. 	as select a width 4, sum (a) width 5, b width 4,
. 	sum (b) width 5, c width 4, sum (c) width 5,
. 	a * b width 4, a * c width 4, b * c width 4,
. 	sum (a) * sum (b) width 8, sum (b) * sum (c) width 8 from t;
* select from v5;
   a   suma     b   sumb     c   sumc    ab    ac    bc  sumasumb  sumbsumc

   1            1           10            1    10    10
   1            2            9            2     9    18
   1            1            8            1     8     8
   2            1            7            2    14     7
   1            2            6            2     6    12
   2            2            5            4    10    10
   1            1            4            1     4     4
   3            2            3            6     9     6
   1            2            2            2     2     4
         13           14           54                         182       756
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test for initialize/terminate group function in g retrieval.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
