cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
select from t1;
select from t1 where b > 2;
select from t1 where a match '*c*';
select from t1 where b range 2 to 4;
select from t1, t2 where b = d;
select from t1 where b > 2 and a match '*c*';
select from t1 where b > 2 or a match '*c*';
select from t1 where a = null;
insert into t1 values (null, 10);
select from t1 where a = null;
+-+-+-+-+-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 t1 where b > 2;
a                b

cde              3
def              4
efg              5
* select from t1 where a match '*c*';
a                b

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

bcd              2
cde              3
def              4
* select from t1, t2 where b = d;
a                b  c                d

abc              1  ABC              1
bcd              2  BCD              2
cde              3  CDE              3
def              4  DEF              4
efg              5  EFG              5
* select from t1 where b > 2 and a match '*c*';
a                b

cde              3
* select from t1 where b > 2 or a match '*c*';
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* select from t1 where a = null;
a                b

* insert into t1 values (null, 10);
* select from t1 where a = null;
a                b

                10
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test to make sure "simple select" still work.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
