cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create t set a, b;
insert into t values (1, 3, 2, 1, 3, 4, 4, 5, 5, 2);
select from t order by a;
select from t order by b;
create view v1 (i, j, k, l) as select a, b, b + 1, b * b from t;
select from v1;
select from v1 order by i;
select from v1 order by j;
select from v1 where k > 3 order by j;
select from v1 where l > 10 order by j;
create view v2 (i, j, k) as select a, b, b + 1 from t order by a;
select from v2;
create view v3 (i, j, k) as select a, b, b + 1 from t order by b;
select from v3;
create view vv1 (m, n, o, p) as select i, j, k, j * k from v1;
select from vv1;
select from vv1 order by m;
select from vv1 order by n;
select from vv1 where o > 3 order by n;
select from vv1 where p > 15 order by n;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* create t set a, b;
* insert into t values (1, 3, 2, 1, 3, 4, 4, 5, 5, 2);
* select from t order by a;
     a       b

     1       3
     2       1
     3       4
     4       5
     5       2
* select from t order by b;
     a       b

     2       1
     5       2
     1       3
     3       4
     4       5
* create view v1 (i, j, k, l) as select a, b, b + 1, b * b from t;
* select from v1;
     i       j            k            l

     1       3            4            9
     2       1            2            1
     3       4            5           16
     4       5            6           25
     5       2            3            4
* select from v1 order by i;
     i       j            k            l

     1       3            4            9
     2       1            2            1
     3       4            5           16
     4       5            6           25
     5       2            3            4
* select from v1 order by j;
     i       j            k            l

     2       1            2            1
     5       2            3            4
     1       3            4            9
     3       4            5           16
     4       5            6           25
* select from v1 where k > 3 order by j;
     i       j            k            l

     1       3            4            9
     3       4            5           16
     4       5            6           25
* select from v1 where l > 10 order by j;
     i       j            k            l

     3       4            5           16
     4       5            6           25
* create view v2 (i, j, k) as select a, b, b + 1 from t order by a;
* select from v2;
     i       j            k

     1       3            4
     2       1            2
     3       4            5
     4       5            6
     5       2            3
* create view v3 (i, j, k) as select a, b, b + 1 from t order by b;
* select from v3;
     i       j            k

     2       1            2
     5       2            3
     1       3            4
     3       4            5
     4       5            6
* create view vv1 (m, n, o, p) as select i, j, k, j * k from v1;
* select from vv1;
     m       n            o            p

     1       3            4           12
     2       1            2            2
     3       4            5           20
     4       5            6           30
     5       2            3            6
* select from vv1 order by m;
     m       n            o            p

     1       3            4           12
     2       1            2            2
     3       4            5           20
     4       5            6           30
     5       2            3            6
* select from vv1 order by n;
     m       n            o            p

     2       1            2            2
     5       2            3            6
     1       3            4           12
     3       4            5           20
     4       5            6           30
* select from vv1 where o > 3 order by n;
     m       n            o            p

     1       3            4           12
     3       4            5           20
     4       5            6           30
* select from vv1 where p > 15 order by n;
     m       n            o            p

     3       4            5           20
     4       5            6           30
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test for expression in select list for views with order by.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
