[teiid-issues] [JBoss JIRA] Commented: (TEIID-99) Stored procedures should work in multisource connector binding scenarios

[ https://jira.jboss.org/jira/browse/TEIID-99?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-99: ------------------------------------- For this to work seamlessly there will need be two valid forms of the procedure exec (params) exec (params, source_name) which will require some changes to the exec resolver to allow optional parameters specified at the end of the procedure to be omitted even if not using named parameter syntax. If the multisource value is included it must be set to a valid source, otherwise the function will not execute. Since we know the valid input set, procedure relational validation will also be modified to allow the procedure to execute even without the source_name parameter specified in criteria. The MultisourcePlanToProcessConverter will need to do special handling with DependendProcedureAccessNode (evaluating the input criteria and removing the source_name parameter) and AccessNodes containing procedures (testing if the source name parameter if set and if the value matches the current source). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira