View Incident Report

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 and Workarounds

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

Resolution

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

More Support Options