Trafodion should prevent creating two logical identical indexes

Bug #1451628 reported by ming.liu2@hp.com
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
New
Wishlist
Roberta Marton

Bug Description

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.

Tags: sql-general
Changed in trafodion:
importance: Undecided → Wishlist
Changed in trafodion:
assignee: nobody → Roberta Marton (roberta-marton)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.