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: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64