flamerobin
flamerobin copied to clipboard
Deterministic clause of stored functions not reflected in generated DDL
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
Suggested Solution
I think RDB$DETERMINISTIC_FLAG field from RDB$FUNCTIONS system table needs to be considered while generating DDL.