cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
select from tt;
create view vv as select from tt;
select from vv;
select from ttt;
create view vvv as select from ttt;
select from vvv;
create view v1 as select from t1;
select from v1;
create view v2 as select from t1 where b > 3;
select from v2;
create view v3 as select from t1 where a match '*c*';
select from v3;
create view v4 as select from t1 where b range 2 to 4;
select from v4;
create view v5 as select from t1 where a match '*d*';
select from v5;
create view v6 as select from t1 where b > 2;
select from v6;
create view v7 as select from t1 where a match '*d*' and b > 2;
select from v7;
create view v8 as select from t1 where a match '*d*' or b > 2;
select from v8;
insert into t1 values (null, 10);
create view v9 as select from t1 where a = null;
select from v9;
create view v10 as select from t1 where a != null;
select from v10;
create view v11 as select from t1, t2 where b = d;
select from v11;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* select from tt;
    aa

     1
     3
     5
* create view vv as select from tt;
* select from vv;
    aa

     1
     3
     5
* select from ttt;
   aaa

     3
* create view vvv as select from ttt;
* select from vvv;
   aaa

     3
* create view v1 as select from t1;
* select from v1;
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* create view v2 as select from t1 where b > 3;
* select from v2;
a                b

def              4
efg              5
* create view v3 as select from t1 where a match '*c*';
* select from v3;
a                b

abc              1
bcd              2
cde              3
* create view v4 as select from t1 where b range 2 to 4;
* select from v4;
a                b

bcd              2
cde              3
def              4
* create view v5 as select from t1 where a match '*d*';
* select from v5;
a                b

bcd              2
cde              3
def              4
* create view v6 as select from t1 where b > 2;
* select from v6;
a                b

cde              3
def              4
efg              5
* create view v7 as select from t1 where a match '*d*' and b > 2;
* select from v7;
a                b

cde              3
def              4
* create view v8 as select from t1 where a match '*d*' or b > 2;
* select from v8;
a                b

bcd              2
cde              3
def              4
efg              5
* insert into t1 values (null, 10);
* create view v9 as select from t1 where a = null;
* select from v9;
a                b

                10
* create view v10 as select from t1 where a != null;
* select from v10;
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* create view v11 as select from t1, t2 where b = d;
* select from v11;
a                b  c                d

abc              1  ABC              1
bcd              2  BCD              2
cde              3  CDE              3
def              4  DEF              4
efg              5  EFG              5
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test the "old" qualification capability on views.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
