Issue Details (XML | Word | Printable)

Key: CORE-1772
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Pierre Ghislain
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

INSERT INTO myTABLE SELECT * FROM myTABLE

Created: 05/Mar/08 08:27 AM   Updated: 18/Sep/16 09:23 PM
Component/s: None
Affects Version/s: 2.0.3
Fix Version/s: None

Environment: Windows XP
Issue Links:
Duplicate
 

QA Status: Covered by another test(s)
Test Details: See test core_3362_basic.fbt


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 05/Mar/08 08:36 AM
Duplicates CORE-92.