Icon View Incident Report

Serious Serious
Reported By: Clive
Reported On: 7/10/2003
For: Version 3.24 Build 1
# 1377 Certain Recursive SQL JOIN Statements Can Cause a Stack Overflow

Problem joining multiple tables, the SQL below when executed on the attached database tables causes the application to crash with a Stack overflow.

select *
projects p
inner join scenario_detail sd on cd.period = sd.period and p.scenario 
inner join category_detail cd on cd.project_code = p.project_code
cd.project_code = 1

Resolution Resolution
Fixed Problem on 7/20/2003 in version 3.25 build 1