[teiid-issues] [JBoss JIRA] (TEIID-2150) Allow procedures to be called with end defaultable inputs

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-2150:
-------------------------------------

             Summary: Allow procedures to be called with end defaultable inputs
                 Key: TEIID-2150
                 URL: https://issues.jboss.org/browse/TEIID-2150
             Project: Teiid
          Issue Type: Enhancement
          Components: Query Engine
    Affects Versions: 8.2
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.2


We should allow procedures to be called positionally and use default values for end parameters if they are not specified.

Condiser:

create foreign procedure proc (x integer, y string);

If you currently issue "call proc()", we'll assume named parameters and use "call proc(null, null)".

If you issue "call proc(1)", you'll get an exception.  The new behavior would be to use "call proc(1, null)".

Of course something like "call proc('a')" would still result in an exception.



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira