# 992 Changing the Unique Flag for an Index and Then Restructuring Can Cause Index Corruption

---

I'm including the table and you need and the following steps to reproduce the #8965 bug:

1) Open DBSys
2) Utilities->Restructure
3) Select the "Customer" table
4) Go into "Secondary Indexes" Tab, select "CODE" Index and change the "Unique" from "No" to "Yes"
5) Press "Save"
6) In the "Error" dialog that will show up click "All"
7) On the next dialog press "OK"
8) Open the table (Customer) and go into the last record (Press "Ctrl-End")
9) Start deleting records using CTRL-DEL

Around the 2nd - 3rd deletion an Error #8965 "Index page buffers corrupt" will be shown. Repairing the table after it worked but I don't know if it lost any data ... (it deleted some records).