[
https://issues.apache.org/jira/browse/TRAFODION-217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14698006#comment-14698006
]
Atanu Mishra commented on TRAFODION-217:
----------------------------------------
Hans Zeller (hans-zeller) wrote on 2014-04-22: #1
Fix checked into project/datalake_64_1 branch, rev. 39573.
Changed in trafodion:
status: In Progress → Fix Committed
Julie Thai (julie-y-thai) wrote on 2014-06-06: #2
Verified on RC2 (traf_20140606_0930):
[...]
--- SQL operation complete.
>>>>showddl 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
, PRIMARY KEY (PS_PARTKEY ASC, PS_SUPPKEY ASC)
)
SALT USING 4 PARTITIONS
;
--- SQL operation complete.
>>invoke TESTSCH.PARTSUPP;
-- Definition of Trafodion table TRAFODION.TESTSCH.PARTSUPP
-- Definition current Fri Jun 6 14:18:52 2014
(
"_SALT_" INT UNSIGNED NO DEFAULT NOT NULL NOT
DROPPABLE
, 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
)
PRIMARY KEY ("_SALT_" ASC, PS_PARTKEY ASC, PS_SUPPKEY ASC)
--- SQL operation complete.
Changed in trafodion:
status: Fix Committed → Fix Released
> 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
> Assignee: Hans Zeller
> 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)
