|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
Test case by Steve Summers :
create table test(id int, title varchar(50));
commit;
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);
commit;
drop index test1;
// If you add a commit here, everything is fine.
drop index test2;
commit;
insert into test values(1,'test'); -- Error, file handle is invalid.
|
|
Description
|
Test case by Steve Summers :
create table test(id int, title varchar(50));
commit;
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);
commit;
drop index test1;
// If you add a commit here, everything is fine.
drop index test2;
commit;
insert into test values(1,'test'); -- Error, file handle is invalid.
|
Show » |
| The cvs commits can not be displayed for repository Firebird at the moment since the log has not yet been parsed. The log will be parsed the next time the VcsService runs. If you have administrators privileges you can hasten the next time the service will run in the service section of the Administration pages.
|
|
Bug
Resolved
Major
If you drop two different indexes within the same transaction, you get database corruption
