Skip to content

Deterministic clause of stored functions not reflected in generated DDL #265

Description

@ron90

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions