description: Sub-routines cannot use recursion.
For example this will not compile:

create or alter function factoriel(n int)
returns int
as
declare function subfactoriel(n int)
returns int
as
begin
if (n = 0) then
return 1;
else
return n * subfactoriel(n - 1); --this line cannot compile
end

begin
if (n < 0) then
return 0;
else
return subfactoriel(n);
end

As this subroutines' limitation is not mentioned in documentation (here: http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-psql-subroutines.html), I think it is a bug.

=>

Sub-routines cannot use recursion.
For example this will not compile:

create or alter function factoriel(n int)
returns int
as
declare function subfactoriel(n int)
returns int
as
begin
if (n = 0) then
return 1;
else
return n * subfactoriel(n - 1); --this line cannot compile
end

begin
if (n < 0) then
return 0;
else
return subfactoriel(n);
end

As this subroutines' limitation is not mentioned in documentation (here: http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-psql-subroutines.html ), I think it is a bug.

Component: Engine [ 10000 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

issuetype: Bug [ 1 ] => Improvement [ 4 ]

summary: Subroutine cannot call itself recursively => Allow subroutines to call others subroutines and itself recursively

summary: Allow subroutines to call others subroutines and itself recursively => Allow subroutines to call others subroutines and themself recursively

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]