You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:37:10 UTC
[jira] [Closed] (TRAFODION-883) LP Bug: 1409939 - showddl does not
display salt clause following 'create table...like...salt using...'.
[ https://issues.apache.org/jira/browse/TRAFODION-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-883.
------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> 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)