If you drop two different indexes within the same transaction, you get database corruption [CORE2397] #2816
Submitted by: @hvlad
Is related to QA234
Test case by Steve Summers :
create table test(id int, title varchar(50));
create index test1 on test computed by (id +1);
commit; // There is not an issue creating two computed indexes in the same transaction, so this commit is optional.
create index test2 on test computed by (id +2);
drop index test1;
// If you add a commit here, everything is fine.
drop index test2;
insert into test values(1,'test'); -- Error, file handle is invalid.
The text was updated successfully, but these errors were encountered: