Hi,
This seems buggy to me (Firebird WI-V2.5.2.26540 64 bit):
create table "Test" ("MyCol" int);
create index "IxTest" on "Test" ("MyCol");
[commit]
alter table "Test" alter "MyCol" to "NewName";
drop index "IxTest";
[commit]
In FlameRobin, this results in error message:
======================================
*** IBPP::SQLException ***
Context: Transaction::Commit
SQL Message : -607
This operation is not defined for system tables.
Engine Code : 335544351
Engine Message :
unsuccessful metadata update
cannot create index IxTest
======================================
After that, the index seems to be in use preventing me from doing
"anything", until I disconnect and reconnect.
If I drop the index before renaming the column, it works as expected.
Is this a bug and if so is it already known? If not, is it supposed to
NOT work, and if so, why? Or what am I missing?
Regards,
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: [email protected]
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
