--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> Thomas_kellerer wrote:
> >
> > Hello,
> >
> > to create quickly a table with a lot of rows, I usually do a:
> >
> > INSERT INTO the_table
> > SELECT * FROM the_table;
> >
>
> In Firebird, that will (eventually) create an infinite number of rows.
> The select doesn't stop with the rows that existed before the insert
> started, but continues storing one more new row for each row it stores
> until you run out of patience, time, or disk space. It's a bug of long
> standing - it becamea a bug in 1982 when the first SQL standard was
> published. Before that, it was just a quirk.
>
> Regards,

Thanks for the quick reply.
I did fear that this would be the answer :)

Cheers
Thomas