showddl does not display salt clause following 'create table...like...salt using...'.

[Julie Thai]

showddl does not display salt clause for table that was created via 'create table...like...salt using n partitions'.
Noted on 20141216 build.

>>create table mytbl( a int not null, b int, c int) primary key (a) salt using 8 partitions;
..

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

CREATE TABLE TRAFODION.JULSCH.MYTBL
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B INT DEFAULT NULL
  , C INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
  SALT USING 8 PARTITIONS
;

--- SQL operation complete.
>>create table myliketbl like mytbl salt using 12 partitions;

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

CREATE TABLE TRAFODION.JULSCH.MYLIKETBL
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B INT DEFAULT NULL
  , C INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
;

--- SQL operation complete.

to reproduce:
create table mytbl( a int not null, b int, c int) primary key (a) salt using 8 partitions;
showddl mytbl;
create table myliketbl like mytbl salt using 12 partitions;
showddl myliketbl;

[Julie Thai (julie-y-thai)]

Also, invoke does not display _SALT_ column.
>>invoke myliketbl;

-- Definition of Trafodion table TRAFODION.SEABASE.MYLIKETBL
-- Definition current Tue Jan 13 12:40:06 2015

  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B INT DEFAULT NULL
  , C INT DEFAULT NULL
  )
  PRIMARY KEY (A ASC)

--- SQL operation complete.

[Hans Zeller (hans-zeller)]

There are really two issues here. First, the condition to salt the target table in CREATE TABLE LIKE is too restrictive (requires with PARTITIONS clause). I am going to fix that. Second, we accept additional table attributes in CREATE TABLE LIKE but we don't actually process them - yet. I'll add a new error to indicate that. The output will look like the following:

>>create table myliketbl like mytbl salt using 12 partitions;

*** ERROR[3111] The LIKE clause and SALT clause cannot coexist in the same statement.

--- SQL operation failed with errors.
>>create table myliketbl like mytbl;

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

CREATE TABLE TRAFODION.SCH.MYLIKETBL
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B INT DEFAULT NULL
  , C INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
  SALT USING 8 PARTITIONS
;

--- SQL operation complete.
>>
>>create table myliketbl2 like mytbl without salt;

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

CREATE TABLE TRAFODION.SCH.MYLIKETBL2
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B INT DEFAULT NULL
  , C INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
;

--- SQL operation complete.
>>

[Hans Zeller (hans-zeller)]

Fix committed in https://review.trafodion.org/#/c/953/

[Paul Low (paul-low-x)]

Verified on R1.1 build