Comment 3 for bug 1412891

Revision history for this message
Weishiun Tsai (wei-shiun-tsai) wrote :

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.