cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
select from sys_clone;
select from t1;
select from t2;
select from v1;
select from v2;
select from v3;
create view v1 as select from t1;
create view v2 as select from t2;
select from v1;
select from v2;
drop view v1;
create view v3 as select from t1, t2 where b = d;
select from v3;
select from v2;
select from v1;
create view v1 as select from t1;
select from v1;
drop view v1;
drop view v2;
drop view v3;
select from sys_clone;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* select from sys_clone;

*** Error: table 'sys_clone' does not exist
* 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
* select from v1;

*** Error: table 'v1' does not exist
* select from v2;

*** Error: table 'v2' does not exist
* select from v3;

*** Error: table 'v3' does not exist
* create view v1 as select from t1;
* create view v2 as select from t2;
* select from v1;
a                b

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

ABC              1
BCD              2
CDE              3
DEF              4
EFG              5
* drop view v1;
* create view v3 as select from t1, t2 where b = d;
* select from v3;
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 v2;
c                d

ABC              1
BCD              2
CDE              3
DEF              4
EFG              5
* select from v1;

*** Error: table 'v1' does not exist
* create view v1 as select from t1;
* select from v1;
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* drop view v1;
* drop view v2;
* drop view v3;
* select from sys_clone;

*** Error: table 'sys_clone' does not exist
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test views creation and droping.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* select from sys_clone;

*** Error: ơ֥ 'sys_clone' ¸ߤޤ
* 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
* select from v1;

*** Error: ơ֥ 'v1' ¸ߤޤ
* select from v2;

*** Error: ơ֥ 'v2' ¸ߤޤ
* select from v3;

*** Error: ơ֥ 'v3' ¸ߤޤ
* create view v1 as select from t1;
* create view v2 as select from t2;
* select from v1;
a                b

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

ABC              1
BCD              2
CDE              3
DEF              4
EFG              5
* drop view v1;
* create view v3 as select from t1, t2 where b = d;
* select from v3;
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 v2;
c                d

ABC              1
BCD              2
CDE              3
DEF              4
EFG              5
* select from v1;

*** Error: ơ֥ 'v1' ¸ߤޤ
* create view v1 as select from t1;
* select from v1;
a                b

abc              1
bcd              2
cde              3
def              4
efg              5
* drop view v1;
* drop view v2;
* drop view v3;
* select from sys_clone;

*** Error: ơ֥ 'sys_clone' ¸ߤޤ
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
