Subject Re: [firebird-support] Bug in Firebird
Author Alexandre Benson Smith
sgaflv wrote:

>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
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

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