[
https://issues.jboss.org/browse/TEIID-1323?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1323.
-----------------------------------
Resolution: Partially Completed
Sources (such as SQL Server) and individual procedures (JDBC direct execution assumes ?
parameter sql that requires literal binding) expect only literal parameters. We cannot
generally push non-literals unless we add a capability and possibly extension metadata on
procedures - alternatively all procedure handling on sources that do support non-literal
arguments would need modified.
At this point it seems sufficient to just allow this at a translator language level and
mark the issue as partially completed. This can be revisited if critical for performance
or if it's the only way to address a particular case.
Add support for pushdown of non-literal procedure parameter
expressions.
------------------------------------------------------------------------
Key: TEIID-1323
URL:
https://issues.jboss.org/browse/TEIID-1323
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.2
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.5
Attachments: proc_params.patch
We are forcing all push-down procedure arguments to be literals (for simplicity), when
all expressions should be allowed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira