Trafodion should prevent creating two logical identical indexes
Bug #1451628 reported by
ming.liu2@hp.com
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.
Changed in trafodion: | |
importance: | Undecided → Wishlist |
Changed in trafodion: | |
assignee: | nobody → Roberta Marton (roberta-marton) |
To post a comment you must log in.