cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create t set a, b, c;
insert into t values
(1, 1, 2,
 1, 2, 3,
 2, 4, 5,
 3, 6, 7,
 3, 8, 9);
select from t;
select sum (a), sum (b), sum (c) from t;
select a, sum (b), sum (c) from t;
select a, sum (b), sum (c) from t group by a;
select a + sum (b) from t;
select a + sum (b) from t group by a;
select a + sum (c) from t group by a;
select a + sum (c), b + sum (c) from t group by a;
select a, b, sum (c) from t group by a, b;
select a + sum (c), b + sum (c) from t group by a, b;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* create t set a, b, c;
* insert into t values
. (1, 1, 2,
.  1, 2, 3,
.  2, 4, 5,
.  3, 6, 7,
.  3, 8, 9);
* select from t;
     a       b       c

     1       1       2
     1       2       3
     2       4       5
     3       6       7
     3       8       9
* select sum (a), sum (b), sum (c) from t;
     SUM(a)       SUM(b)       SUM(c)

         10           21           26
* select a, sum (b), sum (c) from t;
     a       SUM(b)       SUM(c)

     1
     1
     2
     3
     3
                 21           26
* select a, sum (b), sum (c) from t group by a;
     a       SUM(b)       SUM(c)

     3           14           16
     1            3            5
     2            4            5
* select a + sum (b) from t;

*** Error: SQL-invoked routine '+' invalid or parameter(s) incompatible
operator/function has mixed arguments
* select a + sum (b) from t group by a;
(a + SUM(b))

          17
           4
           6
* select a + sum (c) from t group by a;
(a + SUM(c))

          19
           6
           7
* select a + sum (c), b + sum (c) from t group by a;

*** Error: SQL-invoked routine '+' invalid or parameter(s) incompatible
operator/function has mixed arguments
* select a, b, sum (c) from t group by a, b;
     a       b       SUM(c)

     1       1            2
     1       2            3
     3       8            9
     3       6            7
     2       4            5
* select a + sum (c), b + sum (c) from t group by a, b;
(a + SUM(c))  (b + SUM(c))

           3             3
           4             5
          12            17
          10            13
           7             9
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* create t set a, b, c;
* insert into t values
. (1, 1, 2,
.  1, 2, 3,
.  2, 4, 5,
.  3, 6, 7,
.  3, 8, 9);
* select from t;
     a       b       c

     1       1       2
     1       2       3
     2       4       5
     3       6       7
     3       8       9
* select sum (a), sum (b), sum (c) from t;
     SUM(a)       SUM(b)       SUM(c)

         10           21           26
* select a, sum (b), sum (c) from t;
     a       SUM(b)       SUM(c)

     1
     1
     2
     3
     3
                 21           26
* select a, sum (b), sum (c) from t group by a;
     a       SUM(b)       SUM(c)

     3           14           16
     1            3            5
     2            4            5
* select a + sum (b) from t;

*** Error: SQLǵư줿롼 '+' ̵Ǥ뤫̵ʥѥ᡼ꤵƤޤ
ڥ졼ؿ˰ƱƤޤ
* select a + sum (b) from t group by a;
(a + SUM(b))

          17
           4
           6
* select a + sum (c) from t group by a;
(a + SUM(c))

          19
           6
           7
* select a + sum (c), b + sum (c) from t group by a;

*** Error: SQLǵư줿롼 '+' ̵Ǥ뤫̵ʥѥ᡼ꤵƤޤ
ڥ졼ؿ˰ƱƤޤ
* select a, b, sum (c) from t group by a, b;
     a       b       SUM(c)

     1       1            2
     1       2            3
     3       8            9
     3       6            7
     2       4            5
* select a + sum (c), b + sum (c) from t group by a, b;
(a + SUM(c))  (b + SUM(c))

           3             3
           4             5
          12            17
          10            13
           7             9
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
More test for expression in select list for views, in particular a + sum (b).
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
