[jira] [Created] (TRAFODION-591) LP Bug: 1363132 - Showddl output for table with store by clause and index is misleading

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

Alice Chen created TRAFODION-591:
------------------------------------

             Summary: LP Bug: 1363132 - Showddl output for table with store by clause and index is misleading
                 Key: TRAFODION-591
                 URL: https://issues.apache.org/jira/browse/TRAFODION-591
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Suresh Subbiah
            Assignee: Suresh Subbiah
            Priority: Minor
             Fix For: 2.0-incubating


The following set of create table/index statements causes showddl to give misleading output.

create table tsys (a int not null, b int) store by (a) salt using 4 partitions ;
create index tsys_ix1 on tsys(b) ;
showddl tsys ;
CREATE TABLE TRAFODION.SEABASE.TSYS
  (
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  )
  STORE BY (A ASC)
  SALT USING 4 PARTITIONS
;

CREATE INDEX TSYS_IX1 ON TRAFODION.SEABASE.TSYS
  (
    B ASC
  , A ASC
  )
;

--- SQL operation complete.

>From showddl output it looks like the user explicitly included column A in the index, while the user actually did not. The actual index does not have an extra column in hbase so we are good.

Creating an index like
CREATE INDEX TSYS_IX2 ON TRAFODION.SEABASE.TSYS
  (
    B ASC
  , A ASC
  )
;
 causes showddl to show two column As in the output

>>showddl tsys ;

CREATE TABLE TRAFODION.SEABASE.TSYS
  (
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  )
  STORE BY (A ASC)
  SALT USING 4 PARTITIONS
;

CREATE INDEX TSYS_IX1 ON TRAFODION.SEABASE.TSYS
  (
    B ASC
  , A ASC
  )
;

CREATE INDEX TSYS_IX2 ON TRAFODION.SEABASE.TSYS
  (
    B ASC
  , A ASC
  , A ASC
  )
;



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