View Incident Report

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 *
from
projects p
inner join scenario_detail sd on cd.period = sd.period and p.scenario 
= 
sd.scenario_code
inner join category_detail cd on cd.project_code = p.project_code
where
cd.project_code = 1

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap