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