Hello,

to create quickly a table with a lot of rows, I usually do a:

INSERT INTO the_table
SELECT * FROM the_table;

Which seemed to work in the databases I have worked with so far. But
with my Firebird 1.5.2 (W2K) installation this hangs the server. CPU
is going up to 100% and the only way to stop it, is to kill the
process. I waited for several minutes but the statement did not
return. There were only two rows in the table, so I expected it to
finish pretty quickly.

Is this a bug, or simply not intended to work with FB?

Cheers
Thomas