[
https://issues.apache.org/jira/browse/TRAFODION-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-217.
----------------------------------
Resolution: Fixed
Assignee: (was: Hans Zeller)
Fix Version/s: 0.8 (pre-incubation)
> LP Bug: 1304563 - showddl of salted table, does not display salt clause.
> ------------------------------------------------------------------------
>
> Key: TRAFODION-217
> URL: https://issues.apache.org/jira/browse/TRAFODION-217
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Julie Thai
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> Create salted table with primary key. Showddl does not display 'salt' clause
> nor _SALT_ column and primary key. Store-by clause is being displayed, and
> probably should not be.
> To reproduce, in sqlci, issue:
> 1. CREATE TABLE TESTSCH.PARTSUPP
> (
> PS_PARTKEY INT NO DEFAULT NOT NULL
> , PS_SUPPKEY INT NO DEFAULT NOT NULL
> , PS_AVAILQTY INT NO DEFAULT NOT NULL
> , PS_SUPPLYCOST NUMERIC(12, 2) NO DEFAULT NOT NULL
> , PS_COMMENT VARCHAR(199) CHARACTER SET ISO88591 NO
> DEFAULT -- NOT NULL
> , PRIMARY KEY (PS_PARTKEY ASC, PS_SUPPKEY ASC)
> )
> SALT USING 4 PARTITIONS
> ;
> 2. showddl TESTSCH.PARTSUPP;
> MY_SQROOT=/home/trafodion/dlv38708
> who@host=trafodion@rhel-cdh1
> JAVA_HOME=/usr/lib/jvm/java
> linux=2.6.32-358.18.1.el6.x86_64
> redhat=6.4
> Release 0.7.0 (Build release [38708], branch 38708-project/datalake_64_1,
> date 25Mar14)
> in sqlci:
> >>showddl TRAFODION.TESTSCH.PARTSUPP;
> CREATE TABLE TRAFODION.TESTSCH.PARTSUPP
> (
> PS_PARTKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PS_SUPPKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PS_AVAILQTY INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PS_SUPPLYCOST NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , PS_COMMENT VARCHAR(199) CHARACTER SET ISO88591
> COLLATE DEFAULT NO DEFAULT
> )
> STORE BY (PS_PARTKEY ASC, PS_SUPPKEY ASC)
> ;
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
