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 a, b from t group by a, b;
select from v1;
create view v2 as select a, b from t group by a;
select from v2;
create view v3 as select sum (c) from t group by a;
select from v3;
create view v4 as select a, sum (c) from t group by a;
select from v4;
create view v5 as select a, b, sum (c) from t group by a;
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 a, b from t group by a, b;
* select from v1;
     a       b

     1       1
     1       2
     2       2
     3       2
     2       1
* create view v2 as select a, b from t group by a;
* select from v2;
     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 v3 as select sum (c) from t group by a;
* select from v3;
EXPRESSION_1

           3
          39
          12
* create view v4 as select a, sum (c) from t group by a;
* select from v4;
     a  EXPRESSION_1

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

     1       1
     1       2
     1       1
     2       1
     1       2
     2       2
     1       1
     3       2
     1       2
     3                     3
     1                    39
     2                    12
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test the new group by.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
