Carlos,

I am sure it will be fixed but I am also sure if it was a simple one
it would be fixed by now. For the moment, the best way to do what you
are after is to copy the values of interest to a second table, then
run your query from that.

Something like

delete from T2
insert into T2 select field from T1
insert into T1 select field from T2
delete from T2




--- In firebird-support@yahoogroups.com, Carlos Ortiz Quiros
<carlosaortiz@y...> wrote:

> Thanks Marijn,
>
> But if these are bugs, do you think FB team is fixing
> them, because one may need it sooner or later.
>
> --- Martijn Tonies <m.tonies@u...> wrote:
>
> > Hi,
> >
> > > Can anybody tell me why this code makes to stall?
> > > Suppose you have a table like this
> > > CREATE TABLE T1(
> > > Field VARCHAR(50)
> > > );
> > >
> > > INSERT INTO T1 VALUES('FF');
> > >
> > > Here everything goes well, but when I try to
> > execute
> > > the following query, voila, the FB server stalls.
> > >
> > > INSERT INTO T1
> > > SELECT Field FROM T1
> > >
> > > Is this a bug or it cannot be done.
> >
> > This is a known bug -- the same applies for:
> >
> > delete from t1 where <something> in (select first 10
> > from t1)
> >
> > for example. Above will delete all records.
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird,
> > MySQL, Oracle & MS SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> >
> >
>
>
> Carlos Adolfo Ortiz Q
> carlosaortiz@y...
>
>
>
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
> http://mobile.yahoo.com/learn/mail