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

Thu Jul 23 10:48:29 EDT 2009

    [ https://jira.jboss.org/jira/browse/TEIID-99?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12477297#action_12477297 ] 

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).

> Stored procedures should work in multisource connector binding scenarios
> ------------------------------------------------------------------------
>
>                 Key: TEIID-99
>                 URL: https://jira.jboss.org/jira/browse/TEIID-99
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.x
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 6.2.0
>
>
> Defect Tracker #24614: Stored procedures should work in multisource connector binding scenarios by adding another input parameter named SOURCE_NAME

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