Subject Error dropping index after col rename - (known) bug?
Author Kjell Rilbe

This seems buggy to me (Firebird WI-V2.5.2.26540 64 bit):

create table "Test" ("MyCol" int);
create index "IxTest" on "Test" ("MyCol");

alter table "Test" alter "MyCol" to "NewName";
drop index "IxTest";

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?


Kjell Rilbe
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64