Verified on the v0210 build installed on a workstation. This problem has been fixed:
>>create schema mytest;
--- SQL operation complete. >>set schema mytest;
--- SQL operation complete. >> >>create table mytable (a int);
--- SQL operation complete. >>create view "myview" (a) as select a from mytable;
--- SQL operation complete. >>select * from "myview";
--- 0 row(s) selected. >>showddl "myview";
CREATE VIEW TRAFODION.MYTEST."myview" (A) AS SELECT TRAFODION.MYTEST.MYTABLE.A FROM TRAFODION.MYTEST.MYTABLE ;
--- SQL operation complete. >>drop table mytable cascade;
--- SQL operation complete. >> >>drop view "myview";
*** ERROR[1389] Object TRAFODION.MYTEST."myview" does not exist in Trafodion.
--- SQL operation failed with errors. >>drop table mytable cascade;
*** ERROR[1389] Object TRAFODION.MYTEST.MYTABLE does not exist in Trafodion.
--- SQL operation failed with errors. >> >>drop schema mytest cascade;
--- SQL operation complete.
Verified on the v0210 build installed on a workstation. This problem has been fixed:
>>create schema mytest;
--- SQL operation complete.
>>set schema mytest;
--- SQL operation complete.
>>
>>create table mytable (a int);
--- SQL operation complete.
>>create view "myview" (a) as select a from mytable;
--- SQL operation complete.
>>select * from "myview";
--- 0 row(s) selected.
>>showddl "myview";
CREATE VIEW TRAFODION. MYTEST. "myview" (A) AS MYTEST. MYTABLE. A FROM TRAFODION. MYTEST. MYTABLE ;
SELECT TRAFODION.
--- SQL operation complete.
>>drop table mytable cascade;
--- SQL operation complete.
>>
>>drop view "myview";
*** ERROR[1389] Object TRAFODION. MYTEST. "myview" does not exist in Trafodion.
--- SQL operation failed with errors.
>>drop table mytable cascade;
*** ERROR[1389] Object TRAFODION. MYTEST. MYTABLE does not exist in Trafodion.
--- SQL operation failed with errors.
>>
>>drop schema mytest cascade;
--- SQL operation complete.