[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