Den 2013-06-03 19:45 skrev Hannes Streicher såhär:

>
> Guten Tag Kjell Rilbe,
>
> what happens if you commit after alter table ?
>

Then it works, but I shouldn't be required to commit there, should I?
And if so, shouldn't the error occur on drop index rather than on commit?

> > 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.
>
> --
> Mit freundlichen Grüssen
> Hannes Streicher mailto:HStreicher@... <mailto:HStreicher%40gmx.de>
>

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