Hi,

I just noticed something strange and thought I might ask here if this
is expected behaviour.

Sometimes I do something like
insert into <table> (<field1>,<field2>, <field3>, ...) select * from <table>
in Oracle to quickly generate tables with lots of test data.

Now I tried the same in Firebird (2.5.0 Alpha 1 SuperClassic and 2.1.1
SuperServer and Classic)

SQL> create database '/var/db/firebird/foo.fdb' page_size 8192 default
character set UTF8;
SQL> create table foo (id integer not null);
SQL> insert into foo (id) values (1);
SQL> insert into foo (id) values (2);
SQL> insert into foo (id) values (3);
SQL> commit;
SQL> select * from foo;

ID
============
1
2
3

SQL> insert into foo (id) select id from foo;
At this point, Firebird hung, and the file /var/db/firebird/foo.fdb
kept growing rapidly. I had to kill the fbserver process.

I am not sure if this is works like expected, since it is easy to
bring a Firebird Server down that way.

Cheers,
Thomas