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@...> 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@...



__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail