[jira] [Created] (TRAFODION-1223) LP Bug: 1451628 - Trafodion should prevent creating two logical identical indexes

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

Alice Chen created TRAFODION-1223:
-------------------------------------

             Summary: LP Bug: 1451628 - Trafodion should prevent creating two logical identical indexes
                 Key: TRAFODION-1223
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1223
             Project: Apache Trafodion
          Issue Type: Wish
          Components: sql-general
            Reporter: Liu Ming
            Assignee: Roberta Marton
            Priority: Minor


Two indexes are logical identical when both of them are created against same table, on same column, and with same attributes.
It is ideal to prevent the creation of duplicated indexes which are logical identical.
This is an enhancement, should in Wishlist.

Here is how to reproduce it:
>>create table t1 (c1 int not null, c2 int, c3 int, c4 int, primary key(c1) );

--- SQL operation complete.
>>create index Inx1 on t1 (c2);

--- SQL operation complete.

>>create index Inx2  on t1 (c2);

--- SQL operation complete.
>>get indexes;

Indexes in Schema TRAFODION.SEABASE
===================================

INX1
INX2

--- SQL operation complete.
>>


INX2 should NOT be created.



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