]
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}