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;
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.