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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5380.
-----------------------------------
    Fix Version/s: 11.0
       Resolution: Done


Added an exception for defaults on function parameters.

> Disallow the default option for a function parameter
> ----------------------------------------------------
>
>                 Key: TEIID-5380
>                 URL: https://issues.jboss.org/browse/TEIID-5380
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>             Fix For: 11.0
>
>
> 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)