cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
select from t1;
select from t2;
create view v12 (m, n, o, p) as select b, a, c, a concat c from t1, t2
	where b = d;
select from v12;
select from v12 where m > 3;
select from v12 where n > "c";
select from v12 where o > "C";
select from v12 where p > "c";
create view v12a as select from v12 where m > 3;
select from v12a;
create view v12b as select from v12 where n > "c";
select from v12b;
create view v12c as select from v12 where o > "C";
select from v12c;
create view v12d as select from v12 where p > "c";
select from v12d;

create view v21 (m, n, o, p, q) as select b, b * b, a, c, a concat c from t2, t1
	where b = d;
select from v21;
select from v21 where m > 3;
select from v21 where n > 5;
select from v21 where q > "c";
select from v21 where n < 5 or q > "c";
create view v21a as select from v21 where m > 3;
select from v21a;
create view v21b as select from v21 where n > 5;
select from v21b;
create view v21c as select from v21 where q > "c";
select from v21c;
create view v21d as select from v21 where n < 5 or q > "c";
select from v21d;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* select from t1;
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* select from t2;
c                d

ABC              1
BCD              2
CDE              3
DEF              4
EFG              5
* create view v12 (m, n, o, p) as select b, a, c, a concat c from t1, t2
. 	where b = d;
* select from v12;
     m  n           o           p

     1  abc         ABC         abcABC
     2  bcd         BCD         bcdBCD
     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* select from v12 where m > 3;
     m  n           o           p

     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* select from v12 where n > "c";
     m  n           o           p

     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* select from v12 where o > "C";
     m  n           o           p

     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* select from v12 where p > "c";
     m  n           o           p

     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* create view v12a as select from v12 where m > 3;
* select from v12a;
     m  n           o           p

     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* create view v12b as select from v12 where n > "c";
* select from v12b;
     m  n           o           p

     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* create view v12c as select from v12 where o > "C";
* select from v12c;
     m  n           o           p

     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* create view v12d as select from v12 where p > "c";
* select from v12d;
     m  n           o           p

     3  cde         CDE         cdeCDE
     4  def         DEF         defDEF
     5  efg         EFG         efgEFG
* 
* create view v21 (m, n, o, p, q) as select b, b * b, a, c, a concat c from t2, t1
. 	where b = d;
* select from v21;
     m            n  o           p           q

     1            1  abc         ABC         abcABC
     2            4  bcd         BCD         bcdBCD
     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* select from v21 where m > 3;
     m            n  o           p           q

     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* select from v21 where n > 5;
     m            n  o           p           q

     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* select from v21 where q > "c";
     m            n  o           p           q

     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* select from v21 where n < 5 or q > "c";
     m            n  o           p           q

     1            1  abc         ABC         abcABC
     2            4  bcd         BCD         bcdBCD
     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* create view v21a as select from v21 where m > 3;
* select from v21a;
     m            n  o           p           q

     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* create view v21b as select from v21 where n > 5;
* select from v21b;
     m            n  o           p           q

     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* create view v21c as select from v21 where q > "c";
* select from v21c;
     m            n  o           p           q

     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* create view v21d as select from v21 where n < 5 or q > "c";
* select from v21d;
     m            n  o           p           q

     1            1  abc         ABC         abcABC
     2            4  bcd         BCD         bcdBCD
     3            9  cde         CDE         cdeCDE
     4           16  def         DEF         defDEF
     5           25  efg         EFG         efgEFG
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
More test for expression in select list for views.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
