cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
select from t1;
create view tv1 as select from t1;
select from tv1;
create view v1 as select from t1 where b in (1);
select from v1;
create view v2 as select from t1 where b in (2, 4, 5);
select from v2;
create view v3 as select from tv1 where b in (1);
select from v3;
create view v4 as select from tv1 where b in (2, 4, 5);
select from v4;
create view v5 as select from t1, t2 where b = d and d in (2, 5);
select from v5;
+-+-+-+-+-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
* create view tv1 as select from t1;
* select from tv1;
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* create view v1 as select from t1 where b in (1);
* select from v1;
a                b

abc              1
* create view v2 as select from t1 where b in (2, 4, 5);
* select from v2;
a                b

bcd              2
def              4
efg              5
* create view v3 as select from tv1 where b in (1);
* select from v3;
a                b

abc              1
* create view v4 as select from tv1 where b in (2, 4, 5);
* select from v4;
a                b

bcd              2
def              4
efg              5
* create view v5 as select from t1, t2 where b = d and d in (2, 5);
* select from v5;
a                b  c                d

bcd              2  BCD              2
efg              5  EFG              5
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test the in list qualification capability on views.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
