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 v0 as select from t;
select from v0;

create view v1a (sumc, sumd) as select sum (c), sum (d) from t;
select from v1a;
create view v1b (sumc, sumd) as select sum (c), sum (d) from t;
select from v1b;

create view v2a as select from t order by a;
select from v2a;
create view v2b as select from t order by a, b;
select from v2b;
create view v2c as select from t order by a, b, c;
select from v2c;
create view v2d as select from t order by a, b, c, d;
select from v2d;

create view v3 (a, b) as select a, b from t group by a;
select from v3;

create view v4 (a, b) as select a, b from t group by a, b;
select from v4;

create view v5a (suma, sumb, sumc) as select sum (a), sum (b), sum (c)
	from t group by a;
select from v5a;
create view v5b (suma, sumb, sumc) as select sum (a), sum (b), sum (c)
	from t group by a, b;
select from v5b;
create view v5c (suma, sumb, sumc) as select sum (a), sum (b), sum (c)
	from t group by a, b, c;
select from v5c;

create view v6a (a, sumb) as select a, sum (b) from t group by a;
select from v6a;
create view v6b (a, sumb) as select a, sum (b) from t group by a, b;
select from v6b;

create view v7a (a, b, sumc) as select a, b, sum (c) from t group by a;
select from v7a;
create view v7b (a, b, sumc) as select a, b, sum (c) from t group by a, b;
select from v7b;
create view v7c (a, b, sumc) as select a, b, sum (c) from t group by a, b, c;
select from v7c;

create view v8a (a, b, sumc) as select a, b, sum (c) from t order by a;
select from v8a;
create view v8b (a, b, sumc) as select a, b, sum (c) from t order by a, b;
select from v8b;
create view v8c (a, b, sumc) as select a, b, sum (c) from t order by a, b;
select from v8c;
+-+-+-+-+-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 v0 as select from t;
* select from v0;
     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 v1a (sumc, sumd) as select sum (c), sum (d) from t;
* select from v1a;
       sumc         sumd

         54          945
* create view v1b (sumc, sumd) as select sum (c), sum (d) from t;
* select from v1b;
       sumc         sumd

         54          945
* 
* create view v2a as select from t order by a;
* select from v2a;
     a       b       c       d

     1       1      10     101
     1       2       9     102
     1       1       8     103
     1       2       6     105
     1       1       4     107
     1       2       2     109
     2       1       7     104
     2       2       5     106
     3       2       3     108
* create view v2b as select from t order by a, b;
* select from v2b;
     a       b       c       d

     1       1      10     101
     1       1       8     103
     1       1       4     107
     1       2       9     102
     1       2       6     105
     1       2       2     109
     2       1       7     104
     2       2       5     106
     3       2       3     108
* create view v2c as select from t order by a, b, c;
* select from v2c;
     a       b       c       d

     1       1       4     107
     1       1       8     103
     1       1      10     101
     1       2       2     109
     1       2       6     105
     1       2       9     102
     2       1       7     104
     2       2       5     106
     3       2       3     108
* create view v2d as select from t order by a, b, c, d;
* select from v2d;
     a       b       c       d

     1       1       4     107
     1       1       8     103
     1       1      10     101
     1       2       2     109
     1       2       6     105
     1       2       9     102
     2       1       7     104
     2       2       5     106
     3       2       3     108
* 
* create view v3 (a, b) as select a, b from t group by a;
* select from v3;
     a       b

     1       1
     1       2
     1       1
     2       1
     1       2
     2       2
     1       1
     3       2
     1       2
     3
     1
     2
* 
* create view v4 (a, b) as select a, b from t group by a, b;
* select from v4;
     a       b

     1       1
     1       2
     2       2
     3       2
     2       1
* 
* create view v5a (suma, sumb, sumc) as select sum (a), sum (b), sum (c)
. 	from t group by a;
* select from v5a;
       suma         sumb         sumc

          3            2            3
          6            9           39
          4            3           12
* create view v5b (suma, sumb, sumc) as select sum (a), sum (b), sum (c)
. 	from t group by a, b;
* select from v5b;
       suma         sumb         sumc

          3            3           22
          3            6           17
          2            2            5
          3            2            3
          2            1            7
* create view v5c (suma, sumb, sumc) as select sum (a), sum (b), sum (c)
. 	from t group by a, b, c;
* select from v5c;
       suma         sumb         sumc

          1            1            4
          1            2            9
          1            1            8
          1            2            2
          2            2            5
          3            2            3
          1            2            6
          2            1            7
          1            1           10
* 
* create view v6a (a, sumb) as select a, sum (b) from t group by a;
* select from v6a;
     a         sumb

     3            2
     1            9
     2            3
* create view v6b (a, sumb) as select a, sum (b) from t group by a, b;
* select from v6b;
     a         sumb

     1            3
     1            6
     2            2
     3            2
     2            1
* 
* create view v7a (a, b, sumc) as select a, b, sum (c) from t group by a;
* select from v7a;
     a       b         sumc

     1       1
     1       2
     1       1
     2       1
     1       2
     2       2
     1       1
     3       2
     1       2
     3                    3
     1                   39
     2                   12
* create view v7b (a, b, sumc) as select a, b, sum (c) from t group by a, b;
* select from v7b;
     a       b         sumc

     1       1           22
     1       2           17
     2       2            5
     3       2            3
     2       1            7
* create view v7c (a, b, sumc) as select a, b, sum (c) from t group by a, b, c;
* select from v7c;
     a       b         sumc

     1       1            4
     1       2            9
     1       1            8
     1       2            2
     2       2            5
     3       2            3
     1       2            6
     2       1            7
     1       1           10
* 
* create view v8a (a, b, sumc) as select a, b, sum (c) from t order by a;
* select from v8a;
     a       b         sumc

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

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

     1       1
     1       1
     1       1
     1       2
     1       2
     1       2
     2       1
     2       2
     3       2
                         54
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test for initialize/terminate group function in s retrieval.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
