cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create view vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv as select from t1;
create view v2 (iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii, j) as select from t1;
select tab_name, attr_name, attr_dtname from sys_tables, sys_attrs
	where tab_number = attr_tabnum and tab_name !match 'sys_*'
		group by tab_name order by 1;
create view v1 as select from t1;
create view v2 (i, j) as select from t1;
create view v3 (x, y) as select from t1;
select tab_name, attr_name, attr_dtname from sys_tables, sys_attrs
	where tab_number = attr_tabnum and tab_name !match 'sys_*'
		group by tab_name order by 1;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* create view vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv as select from t1;

*** Error: invalid table name 'vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv'
* create view v2 (iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii, j) as select from t1;

*** Error: invalid attribute name 'iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii'
* select tab_name, attr_name, attr_dtname from sys_tables, sys_attrs
. 	where tab_number = attr_tabnum and tab_name !match 'sys_*'
. 		group by tab_name order by 1;
tab_name                          attr_name                         attr_dtname

t1                                a                                 character
t1                                b                                 integer
t1
t2                                c                                 character
t2                                d                                 integer
t2
tt                                aa                                integer
tt
ttt                               aaa                               integer
ttt
* create view v1 as select from t1;
* create view v2 (i, j) as select from t1;
* create view v3 (x, y) as select from t1;
* select tab_name, attr_name, attr_dtname from sys_tables, sys_attrs
. 	where tab_number = attr_tabnum and tab_name !match 'sys_*'
. 		group by tab_name order by 1;
tab_name                          attr_name                         attr_dtname

t1                                a                                 character
t1                                b                                 integer
t1
t2                                c                                 character
t2                                d                                 integer
t2
tt                                aa                                integer
tt
ttt                               aaa                               integer
ttt
v1                                a                                 character
v1                                b                                 integer
v1
v2                                i                                 character
v2                                j                                 integer
v2
v3                                x                                 character
v3                                y                                 integer
v3
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
More tests for views creation and droping.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* create view vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv as select from t1;

*** Error: ̵ʥơ֥̾ 'vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv' Ǥ
* create view v2 (iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii, j) as select from t1;

*** Error: ȥӥ塼̾ 'iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii' ̵Ǥ
* select tab_name, attr_name, attr_dtname from sys_tables, sys_attrs
. 	where tab_number = attr_tabnum and tab_name !match 'sys_*'
. 		group by tab_name order by 1;
tab_name                          attr_name                         attr_dtname

t1                                a                                 character
t1                                b                                 integer
t1
t2                                c                                 character
t2                                d                                 integer
t2
tt                                aa                                integer
tt
ttt                               aaa                               integer
ttt
* create view v1 as select from t1;
* create view v2 (i, j) as select from t1;
* create view v3 (x, y) as select from t1;
* select tab_name, attr_name, attr_dtname from sys_tables, sys_attrs
. 	where tab_number = attr_tabnum and tab_name !match 'sys_*'
. 		group by tab_name order by 1;
tab_name                          attr_name                         attr_dtname

t1                                a                                 character
t1                                b                                 integer
t1
t2                                c                                 character
t2                                d                                 integer
t2
tt                                aa                                integer
tt
ttt                               aaa                               integer
ttt
v1                                a                                 character
v1                                b                                 integer
v1
v2                                i                                 character
v2                                j                                 integer
v2
v3                                x                                 character
v3                                y                                 integer
v3
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
