Reported By: Roman Korzh Reported On: 8/31/2004 For: Version 4.10 Build 1
# 1829Executing 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 and WorkaroundsThe workaround is to either not execute the above query (it's basically nonsense) or use navigational methods to do so.
ResolutionFixed Problem on 9/2/2004 in version 4.11 build 1