sgaflv wrote:

>Hello,
>I've experimented with Firebird and I wonder, if this could be a bug:
>
>create table temp_table ( a integer);
>insert into temp_table values(1);
>insert into temp_table values(2);
>insert into temp_table values(3);
>insert into temp_table select a from temp_table;
>
>After the last statement server hangs in endless loop and DB grows all
>the time.
>
>I have tested this on FireBird 1.5.2., and I wonder if something
>similar could happen in some complex inserts.
>
>

The new inserted rows will be inserted againg and again in a endless loop.

I think you should restrict the last insert statement in some form like

insert into temp_table select a from temp_table where a <= 3;

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 22/09/2005