Subject Re: Should this work?
Author thomas_kellerer
--- In, "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 :)