Submitted by: Pierre Ghislain (pghislain)

Duplicates CORE92

I wanted to create a table with the double of the existing rows.
Firebird work recursively and never end the query creating an enormous table with many... duplicates.
I had to shutdown Delphi and the Firebird server.
From 2 000 K the database file grew to 70 000 K.

The submited query is not recursive. The select clause 'should' be processed before the insert clause...

Best regard Pierre.

====== Test Details ======

See test core_3362_basic.fbt