flamerobin icon indicating copy to clipboard operation
flamerobin copied to clipboard

Deterministic clause of stored functions not reflected in generated DDL

Open ron90 opened this issue 3 years ago • 0 comments

Platform

Flamerobin: Version 0.9.3 OS: Windows 10 - (64 bit)

Problem

The optional Deterministic clause of stored functions is not reflected when DDL is generated.

Steps to reproduce

SET TERM^ ;

CREATE FUNCTION fn_CalcSum (a INT, b INT)
RETURNS INT DETERMINISTIC
AS
BEGIN
    RETURN a + b;
END^

SET TERM; ^

Generated DDL without Deterministic clause Function_DDL

Suggested Solution

I think RDB$DETERMINISTIC_FLAG field from RDB$FUNCTIONS system table needs to be considered while generating DDL.

ron90 avatar Jul 02 '22 11:07 ron90