[teiid-issues] [JBoss JIRA] (TEIID-5380) Disallow the default option for a function parameter

Jan Stastny (JIRA) issues at jboss.org
Mon Jun 18 04:14:00 EDT 2018


Jan Stastny created TEIID-5380:
----------------------------------

             Summary: Disallow the default option for a function parameter
                 Key: TEIID-5380
                 URL: https://issues.jboss.org/browse/TEIID-5380
             Project: Teiid
          Issue Type: Bug
            Reporter: Jan Stastny
            Assignee: Steven Hawkins


Currently there's no support in Teiid for default values for parameters of a Function.

But [Function element in BNF for SQL Grammar|https://teiid.gitbooks.io/documents/content/reference/BNF_for_SQL_Grammar.html#createDDLProcedure] shares the definition with Procedure, which permits to deploy such a VDB, where there are DEFAULT values defined on a Function parameter.

So a VDB with following DDL shouldn't deploy successfully:
{code:sql}
CREATE VIRTUAL FUNCTION f1(e2 string NOT NULL DEFAULT 'default') RETURNS string AS
BEGIN
    RETURN e2;
END;
{code}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)


More information about the teiid-issues mailing list