| Key: |
CORE-1772
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Duplicate
|
| Priority: |
Major
|
| Assignee: |
Unassigned
|
| Reporter: |
Pierre Ghislain
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
| QA Status: |
Covered by another test(s)
|
| Test Details: |
See test core_3362_basic.fbt
|
|
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.
|
|
Description
|
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. |
Show » |
|
INSERT INTO myTABLE SELECT * FROM myTABLE
CORE-92.