Hi,

> But if these are bugs, do you think FB team is fixing
> them, because one may need it sooner or later.

This is a very old bug - it's known, but not easy to fix.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

> > > 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
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>