Subject Re: [firebird-support] Should this work?
Author Ann W. Harrison
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.