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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0 (pre-incubation)
• Component/s: sql-cmu
• External issue URL: https://bugs.launchpad.net/bugs/1409939
• Assignee: Hans Zeller
• Reporter: Julie Thai
• Created: 22/Jul/15 18:18
• Updated: 31/Aug/15 05:36
• Resolved: 31/Aug/15 05:36

Description

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;