Comment 4 for bug 1412983

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

Verified on the r1.0.0 rc2 build, both scenarios described in this report are now fixed:

>>create schema mytest;

--- SQL operation complete.
>>set schema mytest;

--- SQL operation complete.
>>
>>create table mytab1 (a int);

--- SQL operation complete.
>>create view myview1 as select a from mytab1;

--- SQL operation complete.
>>create table mytab2 like myview1;

--- SQL operation complete.
>>showddl mytab2;

CREATE TABLE TRAFODION.MYTEST.MYTAB2
  (
    A INT DEFAULT NULL
  )
;

--- SQL operation complete.
>>
>>drop schema mytest cascade;

--- SQL operation complete.

>>create schema sch999;

--- SQL operation complete.
>>set schema sch999;

--- SQL operation complete.
>>create table tab999(a int, b int);

--- SQL operation complete.
>>create view view999 as select a from tab999;

--- SQL operation complete.
>>create table tab888 like view999;

--- SQL operation complete.
>>showddl tab888;

CREATE TABLE TRAFODION.SCH999.TAB888
  (
    A INT DEFAULT NULL
  )
;

--- SQL operation complete.
>>drop schema sch999 cascade;

--- SQL operation complete.