[jira] [Created] (TRAFODION-883) LP Bug: 1409939 - showddl does not display salt clause following 'create table...like...salt using...'.

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-883:
------------------------------------

             Summary: LP Bug: 1409939 - showddl does not display salt clause following 'create table...like...salt using...'.
                 Key: TRAFODION-883
                 URL: https://issues.apache.org/jira/browse/TRAFODION-883
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Julie Thai
            Assignee: Hans Zeller
             Fix For: 1.0 (pre-incubation)


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;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)