Icon View Incident Report

Serious Serious
Reported By: Richard Harding
Reported On: 6/28/2010
For: Version 2.03 Build 15
# 3242 Recursive Functions Can Incorrectly Cause Stack Overflow

I upgraded to v2.03b15 and tested out recursive functions with the following which works.

However, if the line SET I = N is removed and the subsequent references to I are replaced by the parameter N then EDBMgr terminates.

CREATE FUNCTION "TriangleNumber" (IN "N" INTEGER)
RETURNS INTEGER
BEGIN   
 DECLARE Result, I INTEGER;
 
 SET I = N;     -- Required
 CASE I
   WHEN 0 THEN
     SET Result = 0;
   WHEN 1 THEN
     SET result = 1;
   ELSE
     SET Result = I + TriangleNumber(I - 1);
 END CASE;
  
 RETURN Result;
END



Resolution Resolution
Fixed Problem on 7/2/2010 in version 2.03 build 17


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image