Icon View Incident Report

Minor Minor
Reported By: Roman Korzh
Reported On: 8/31/2004
For: Version 4.10 Build 1
# 1829 Executing an INSERT INTO SELECT With the Same Table Causes Infinite Recursion

The simple query below esulted in an infinite loop with the database growing to eventually fill the entire disk drive and bring down the server.

INSERT INTO coders SELECT * FROM coders



Comments Comments and Workarounds
The workaround is to either not execute the above query (it's basically nonsense) or use navigational methods to do so.


Resolution Resolution
Fixed Problem on 9/2/2004 in version 4.11 build 1
Image