[
https://issues.apache.org/jira/browse/TRAFODION-591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-591.
------------------------------------
> 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: 1.0 (pre-incubation)
>
>
> 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)
