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