Icon View Incident Report

Serious Serious
Reported By: Surjanto Kwe
Reported On: 5/6/2010
For: Version 2.03 Build 13
# 3207 Cannot Define Recursive Functions Directly and Recursive Functions Cause AV When Executed

I am evaluating EDB and trying to do recursive function, but I always got AV in doing it. I trick the SQL by not mentioning the function Rekursi at creation, then alter and add it

CREATE FUNCTION "Rekursi" (IN "Test" INTEGER)
RETURNS INTEGER
BEGIN
    DECLARE Result, i INTEGER DEFAULT 0;
    if test < 5 then

       SET i = test + 1;
       SET Result = Result + Rekursi(i);
    end if;
    RETURN Result;
END



Resolution Resolution
Fixed Problem on 5/15/2010 in version 2.03 build 14


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