example (but for all proc this happed)


SET TERM ^ ;
CREATE PROCEDURE GET_DATES (
    ADATE_FROM Date,
    ADATE_TO Date )
RETURNS (
    OUT_DATE Date )
AS
DECLARE VARIABLE D DATE;
BEGIN
  D = ADATE_FROM;

  WHILE (D<=ADATE_TO) DO
    BEGIN
      out_DATE = D;
      SUSPEND;
      D = D + 1;
    END
END^
SET TERM ; ^


now do select

SELECT p.OUT_DATE
FROM GET_DATES(CAST('2010-01-01' as date), CAST('2010-06-01' as date)) p

you get plan
PLAN (GET_DATES NATURAL)

but change this plan to this and do select

SELECT p.OUT_DATE
FROM GET_DATES(CAST('2010-01-01' as date), CAST('2010-06-01' as date)) p
PLAN (P GET_DATES NATURAL)

server crash
in windows log
" Abnormal Termination: "C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe": terminated abnormally (4294967295)268435456 ü."

in fb log
"
WCOMP1 (Client) Fri Jul 02 11:18:16 2010
"C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe": terminated abnormally (4294967295)"